DMARC-to-Google-sheet

In Gmail: Save attachments that are DMARC-reports and insert values from them in Google sheet. The reports are in XML-format.

Preparations in Google Drive

1. Create a folder and call it DMARC
2. Create a sub-folder of DMARC and call it DMARC-reports, note the folder id
3. Create a sub-folder of DMARC-reports and call it DMARC-archive, note the folder id
4. Create a copy of Google sheet dmarc-report and put it in the DMARC-folder, note the file id. https://docs.google.com/spreadsheets/d/10crRusmMwmcTuiUMn0jwFRHSotbXXrNTRTPcx4hJI4U/copy

Create the script

Go to https://script.google.com/home Click New project

Give the project a name (change the Untitled project) Copy the code from the GAS-file and paste it there.

Trigger the script

Go to Triggers and Add Trigger

Change it settings so the script is trigged for instance once a day.