Use Autocrat to Mail Merge from Google Sheets to Docs, Slides, or PDF Files

Mail merge certificates, letters, forms and more from Google Sheets to Google Docs, Slides,, or PDFs with Autocrat. You can even set Autocrat to email merged documents directly to users for you automatically,

You can also merge to Google Slides, which is more flexible in format arrangement than a Google Doc. If you change the Page Setup in Slides to 11 x 8.5", it'll print on a standard piece of paper.

[hanifharun]

The most easiest tutorial i found in the tube regarding the mail merge in google sheet. Thank!

[drp]

Wow! This is terrific. You explained it extremely well. I'm definitely going to use this! Thank you.

[leahheerema]

This is so great, Jen! I was going to make one but found yours to send to a colleague. Very clear and concise! I noticed at the 2:30 min mark (also at 4 min), you mention having type the field name in. Did you know that you can actually click on the vertical blue bar on the left to reveal the list of column names? When you click on a name, it is automatically saved to your clipboard so you'll just paste it into the File Name field.

[AndrewSheves]

Fantastic explainer Jen! Super clear and useful, thank you.

[Baobab]

Thank you so much very helpful video!
If you get the following error, here's how I fixed it:
Autocrat says Exception: Invalid argument: timeZone. Should be of type: String when I try to merge
Solution:
Change TimeZone(File -> Spreadsheet setting) to others and change back
Delete all data in any columns that AutoCrat created in the Spreadsheet file
Run again, It works well for me!

[bwsustainability]

This is incredibly helpful! Thank you so much.

[onlytourist]

Thanks allot for making such an easy and wonder full video about the useful tool

[careerssns]

Thank you much for sharing this beautiful video. It helps me to lot for generating ecertificates attached through mail

[cherrytee]

This is amazing! Thank yoz so much for sharing. It is just what I am looking for! ❤❤❤

[tedbragg]

I have one concern/fear using this method — if Autocrat were to suddenly disappear/withdraw their apps/banned/etc, Id be up a creek without a paddle. Do you have alternative, more secure (or offline) suggestions?

[AgentCathy]

This is an excellent video. Thank you!

[ymm]

Thank you for your work here. Question: Can I collect all the data from my students at the start of the school year and then selectively merge a particular student to create a certificate? I guess what I'm confused about is...does autocrate email EVERYONE in the spreadsheet? Thanks again

[drclifplewis]

Hi Jen. Thanks so much for this great tutorial. Could you perhaps assist with incorporating a chart into this merge process? I.e. the spreadsheet has data that needs to populate a chart that goes into the final pdf. Thanks!

[thejubileemajestics]

Great tutorial. I couldn't get the email feature to work. Everything ran. No errors. But the emails didn't go out.

[nuuurrrmoon]

Thanks for this tutorial. It helps a lot. And i do have a question, can we mail merge a picture upload from the google form? Thanks again🤗

[epd_connectplanning]

Hi Jen. Thanks for sharing this info, super helpful! I have everything set up in a test version and it seems to be working well. I have added a column to my test Google sheet to run the merge with the Not Null feature so I don't have to run 900 past entries that were created manually. I just want to start running data as of May 1st. That works great too and is doing what I need it to do. I am nervous however that manually adding a column (in my live/official version) in the sheet will mess everything up. I am not very experienced with Google Drive and definitely new to AutoCrat. I guess the question is, can I add a column to the sheet without it affecting the data pulling from the form?

[jmogford]

the video was wonderful when I was using your exact label template but had to get smaller labels (Avery 1569) and made a complete mess trying to change the template. Where are your videos on how you're getting all these templates that you so easily inputting and pulling info from??

[findthetruth]

It is really awesome. Thanks a bunch. I would like to ask you a question. How can import data from Microsoft box into Google sheets automatically when there an update in the excel sheet. Thanks in advance.

[trevortakahashi]

This is a great tutorial video! Thanks for posting. I have a .png image in my template doc, but when I run the mail merge the outputted docs have broken image links which show up as a white rectangle with a question mark inside. Any thoughts on how to resolve?

[iheijnl]

Thanks for the video. Question- when I try to locate my template in the drive, it doesn’t appear. How could I fix this?