Save Merged Files to a Specific Google Drive Folder

How to change the default save location for merged files to a folder of my choice on Google Drive?

By default, files are saved on My Drive. This article describes how to save your merged files in a specific folder on Google Drive, enabling better organization of merged files produced from different Google Docs, Slides and Sheets templates. Merged files may include letters generated during mail merges, and files sent as PDF email attachments based on Google Docs templates.

From Google Docs

Step 1: Cick Options

In Google Docs, click on Options in the Mail Merge sidebar to open the Options dialog box.

Step 2: Click My Drive

Click on My Drive under Save Merged Files To.

Step 3: Select Google Drive folder

Select a Google Drive folder in which to save your merged files (e.g., My Merge Files), and then click on Select.

Step 4: Click Save

Click on Save to apply the changes.

Note that My Drive under Save Merged Files To in the Options dialog box changes to your preferred save location (e.g., My Merge Files).

You also have the option to save your merged documents as PDF files by selecting Yes from the Save to PDF drop-down menu.

Step 5: Select Letters & click Merge

Select Letters from the Merge To list and then click on Merge.

Step 6: View files on Google Drive

Click the link provided to view your files on Google Drive.

From Google Slides

Step 1: Click Options

In Google Slides, click on Options in the Mail Merge sidebar to open the Options dialog box.

Step 2: Click My Drive

Click on My Drive under Save Merged Files To.

Step 3: Select Google Drive folder

Select a Google Drive folder in which to save your merged files (e.g., My Merge Files), and then click on Select.

Step 4: Click Save

Click on Save to apply the changes.

Note that My Drive under Save Merged Files To in the Options dialog box changes to your preferred save location (e.g., My Merge Files).

You also have the option to save your merged documents as PDF files by selecting Yes from the Save to PDF drop-down menu.

Step 5: Select Presentations & click Merge

Select Presentations from the Merge To list, and then click on Merge.

Step 6: View files on Google Drive

Click the link provided to view your files on Google Drive.

From Google Sheets

Step 1: Click 'My Drive'

In Google Sheets, click the default location My Drive to open the Google Drive Folder dialog box.

Step 2: Choose a Google Drive folder

Choose a folder from your Google Drive or Shared Drives and click Select. The name of the folder will appear in the main dialog box. Click the Save button to save changes.