Automatically send a PDF of the looker dashboard to the email entered in the Google Sheets

[Goudhaatje]

Hi,

Can someone help with the following problems? I'm happy to pay the one that is known with the solution and can build the outcome.

Here it goes.

1. Someone fills in a row in Google Sheets and a unique ID and email is on this row.

2. Automatically a dashboard is made in Looker Studio.

3. A PDF of this dashboard with only the data of this person eg. the answers on that row in the google sheet should be send to this person.

If someone knows the answer and can help me with this. Please book in some time in my calendly.com/bjorndinslage or send me an email to (PII Removed by Staff) and we get connected.

Best regards,

Björn

Ps. I already came quite far by sending an automatic email with the link to the looker report via Google app script. But without sending the PDF.

[GavinW]

I think this would be extremely challenging in Looker Studio as it doesn't really have APIs that would help you automate something like this the way Looker original flavour does.