Daily Google Analytics PDF report by email

What it does

How to set it up

1. 1

   Connect the smtp credential

   This template uses smtp in: Enviar informe por email. Create or pick the credential and assign it in those nodes.

2. 2

   Create the Google service account

   In Google Cloud Console create (or pick) a project, enable Google Analytics Data API (and Search Console API if you will use Search Console), create a service account and download its JSON key.

3. 3

   Grant the service account access in Analytics

   In Google Analytics go to Admin > Property access management and add the service account email (...@...iam.gserviceaccount.com) with the Viewer role. Note the property ID (digits only, under Admin > Property details).

4. 4

   Store the key as a Basic Auth credential

   In Credentials create a Basic Auth one named exactly ga4-service-account (or whatever you set in the Configuración node). Username = the JSON client_email field; password = the JSON private_key field (paste it as is, with the \n). The key is never stored in the workflow.

5. 5

   Fill in the Configuración node

   Enter the property ID in property_id, your site name in nombre_sitio and, optionally, your Search Console property in search_console_site (for example sc-domain:yoursite.com; also add the service account as a user in Search Console).

6. 6

   Connect Api2Pdf and mail

   In the Generar PDF node paste your Api2Pdf API key (api2pdf.com) and in Enviar informe por email pick your SMTP credential and recipients.

7. 7

   Test and schedule

   Run the workflow once by hand: the email should arrive with the PDF attached. Then enable the schedule of the start node (every day at 8:00 by default).

8. 8

   Activate the workflow

   Workflows are installed inactive. Once everything is set, activate it.