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,
Certificate Template - docs.google.co...
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.

[@hnazgul]

Very helpful - thank you! We'll be using this feature to manage service hours for a high school student council.

[@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.

[@hanifharun512]

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

[@drp2792]

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

[@vOgg21]

I have a problem with mine. Some people received their certificates blank, with only the name or a placeholder like written on them. Most of them use mobile devices, but those who use a PC browser received their certificates with the proper template.

[@AndrewSheves]

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

[@Chrisdgallego]

Hi! 3 years aftes this viedo was published (I'm sorry my English please).
Do or did you tried to fill a form from a phone or similar device to check if it sends the email? I hope my comment have sense. Thanks

[@AmanullahMHaniffa]

I am facing two issues with AutoCrat:
When someone edits their Google Form response after submitting, they don't automatically receive the updated PDF, even though they received the original one.
AutoCrat is generating multiple PDF files for each response."
Would you like some suggestions to address these issues?

[@tedbragg74]

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?

[@ymm424]

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

[@drclifplewis237]

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!

[@user-ih8ei6jn5l]

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

[@cherrytee24]

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

[@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

[@epd_connectplanning8454]

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?

[@muzhameerputra]

This is revolutionary

[@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🤗

[@JenJonson]

I don't think so since the pictures from the form don't live on the spreadsheet -- they are sent to a unique folder on Drive. Data must be on the spreadsheet to be merge-able

[@ElizabethEversmanIR]

Is there a time delay in the emails being sent? I am having trouble with the email being sent. PDF is showing in my drive but not in my email. Thoughts?

[@anilkumar-2114]

May I know how many mails it will sent

[@findthetruth3021]

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.

[@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??

[@JenJonson]

The templates require a ton of trial & error testing. I start with the MS Word one from Avery's website & convert to Google Docs. Then I just start merging, printing, changing margins, font, & column width over & over & over & over until finally it prints correctly.

[@Baobab365]

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!

[@careerssns127]

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

[@trevortakahashi1699]

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?

[@judithdoepel5058]

Fabulous tutorial! Thank you.

[@bharathib5793]

While using autocrat, i am not able to connect to my drive to look up the word template if i use my chrome or mozilla browsers. however it works on opera. any idea why?

[@racharladhanraj2508]

Is there any premium version for autocrat

[@questtech2698]

So far I know Autocrats allows 1 header row, but how many columns of data can I merge? I can only merge 4 columns, am I doing it right?

[@JenJonson]

I'm not aware of a specific column limit. I've merged using well over 4 though

[@questtech2698]

@@JenJonson thank you for the reply. I'm pretty new to Autocrat. After days of debugging I manage to go beyond 20 columns of dataset :)

[@analizatorres6292]

Hello! This video was very useful. Now, I have a question. I am trying to have my DOC update every time I update the spreadsheet. My students get participation "bitcoin" in class. I keep their tallies on a Google Sheet. I would like to update the spreadsheet, and for it to automatically give them their new total on the SAME document that I will share with them automatically at the beginning of the school year.

[@thejubileemajestics]

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

[@tiriajulius9881]

Autocrat only sends 100 emails per day with personal files attached. How can this be changed?

[@mariaheidimanzano1706]

This video saved me... Thank you! :)

[@tobidurosinmi-etti2427]

Thank you Jen!

[@AgentCathy]

This is an excellent video. Thank you!

[@JenJonson]

You're very welcome!

[@gloriaokall5310]

VERY VERY HELPFUL

[@informergurumarathi]

Thank you So much madam

[@davidsookharry8555]

how many mail merges can be done using autocrat?

[@burnoutminion]

Why autocrat is taking so long to load and takes like forever to save at the end?

[@southbridgeforestHOA]

THANKS!

[@skrtzen]

THANK U SO MUCH! 💗

[@jencarrero]

awesome thank you!!!!

[@dimitarnonchev1921]

First update AutoCrat to version 3. If not it doesn't look and work that way!

[@ivanborzenko6226]

AMAZING LIFE SAVER!

[@aaronalphonso3993]

Awesome. Thank you

[@anthonyandres2833]

How to merge google slide and pdf?

[@JenJonson]

Step 4 - choose output Type as PDF or Docs (can be a Slide if you chose that as your template in Step 2

[@anthonyandres2833]

@@JenJonson thank you. I mean. How can i merge the google slide at the same time and the pdf saved in my google drive. ? I cant figure it out the formula in the google sheet. Is that impossible?

[@JenJonson]

I would just create 2 separate "jobs" (run it twice). I don't think you can export to PDF and Slides at the same time. But if you merge your slides as one full slide deck you can also just File > Download as PDF to save the slides as a PDF

[@clara_____]

THANK YOU! YOU MADE IT VERY EASY ʕ•́ᴥ•̀ʔっ♡

[@CEOITBOXSupport]

mam yeh image ka thumbnail send krdo

[@m_joronalnickjohnl.6570]

thank u