The easiest way to merge Google Sheets data with a Google Docs template

Merge Data
Template
Selected Sheet: Selected CSV File Selected Airtable Data data rows  
Fields:
 
Automatic Row Grouping Premium
To get started, please provide the data you wish to merge into the template document. You can either:
  • Choose a Google Sheets file: after you've selected the file you will be able to select a specific tab to use as the data source.
  • Choose an Airtable table or view: you will need to log in and connect your Airtable account. (Paid feature)
  • Upload an Excel (.xlsx) file.
  • Upload a CSV (Comma Separated Values) file.

Help

See a sample merge data file

Any properly-formatted Google Spreadsheet can be used as the merge data source. When you select a spreadsheet file we will check the number of sheets within the spreadsheet: if there is more than one sheet we will prompt you to pick the specific sheet to use for the merge, otherwise we will automatically use the only available sheet. We will then scan the file and extract the first row of the selected sheet: the values in this row will be used as the merge data variables that can be merged into the template.