How to Mail Merge with Google Drive in Design & Print Online
- In the Customize screen, on the left side toolbar, click Import Data and select Start Import/Merge.
- Select Google Drive and then click Connect to Google Drive.
- Log into your Google account, if you are not already. Select your Google account and click Continue.
- If this is your first time connecting your Google account, on the next window, click Select All and Continue.
- Select the spreadsheet from your Google Drive that you want to merge and click Select.
- Your data will merge over, bringing you to the Choose Fields step. Here, you can select or deselect any rows or columns that you do not want to merge, then click Next.
- Arrange your fields by dragging and dropping the Imported Data Fields to Arrange Fields, or double-click each field name from the left side.
- Click Next and then Finish.
- Your data is now merged onto your template!
How to Download Your Google Spreadsheet in Google Drive
If you encounter issues merging data from Google Drive into Design & Print Online, you can download a copy of the spreadsheet and upload it as a .csv file. Here's how:
- In Google Drive, open your Google Spreadsheet and select File in the upper left-hand corner of the screen.
- Hover over Download As.
- Select either Microsoft Excel (.xlsx) or Comma-separated values (.csv).
- Follow the Import Data Mail Merge steps using your .csv or .xlsx file.