The Google Spreadsheet™ add-on will merge the data from the Spreadsheet with the Google Doc™ template.
Listing updated:September 9, 2022
Works with:
909
Overview
The Google Spreadsheet™ add-on will merge the data from the spreadsheet with the Google Doc™ template. Use document mail merge for bulk letters, labels, envelopes and other bulk operations for personalizing documents. You can easily print the file after the data merge or push the personalized documents into a specific (customer/employee) folder. 

Steps in the configuration:
[1] On the Data sheet, create the relevant columns and data
[2] In the sidebar, select the document template
[3] Merge the Data and the document together
View the result in Google Drive™.

For the merge process you have the following options
 * Your file result:
 - Result in one document
 - Create a document for each data row

Your file format options:
 - Google Docs format
 - PDF (*.pdf) format

Your file location options:
 - Google Drive folder of the document template
 - Use column "Folder_ID" to determine the right Google Drive folder

File name options:
 - Use same name as the template
 - Use column "Filename" to set the File name

Note, with your Gmail.com account you only have 5 minutes, which can only merge a very few documents. Using a Google Workspace account will provide you more run time to do a document mail merge. 
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
123 Document mail merge will ask for the permissions shown below. Learn more
123 Document mail merge will need access to your Google account
This will allow 123 Document mail merge to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all of your Google Drive files
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Marc Delievret
February 2, 2022
Ne marche pas avec Google Sheets
Is this review helpful?
Yes
No
1-1 of 1
Search
Clear search
Close search
Google apps
Main menu