Automating Google MailMerge of Reports

Alex T.

Hi all, I need to run a monthly report and perform a mail merge of that data into a google doc/pdf. Any pointers on how to perform the scheduled recurrence?

Thanks!

Genevieve P.

Hi Alex,

The easiest thing to do would be to use the "Send as Attachment" feature in a Report where you can schedule a weekly or monthly email of the Report as a PDF file. You could also have this attach as an Excel document to bring into Google Docs if needed.

You can read more about this in our Help Center (click here).

Cheers!

Genevieve

Alex T.

Hi Genevieve, thanks for the response. I need the report to feed a google mail merge, which generates a new list of PDFs. Those are the pdfs I need to have sent. Does that make sense?

Best,

A

Andrée Starå

Hi @Alex T.,

Have you looked at the integration with Google Docs?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Alex T.

Yes, this is the question. How do I automate the generation of the mail merge functionality with google docs.

Jorge Montoya

I am currently researching how to achieve that as well.

I have a sales tracker and each time I get a new lead in the form of request for information, I want to automate sending a brochure personalized to this potential customer. I believe the only way to do it is via mail merge with a set template.

as an alternative, I can create my pdf - not personilized and post it in a link that can be sent back as an automatic response to the client.

Jm

Andrée Starå

@Alex T.

Here's an excellent resource.

https://help.smartsheet.com/articles/1850128-smartsheet-merge-add-on-for-google-docs

Let me know if you have any questions!

Andrée Starå

Hi @Jorge Montoya,

Have a look at Smartsheet Merge for Google Docs

https://help.smartsheet.com/articles/1850128-smartsheet-merge-add-on-for-google-docs

Would that work?

There are other 3rd party options as well.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!