Merging Google Docs

This page explains how to merge multiple documents using the Merge Docs Pro.

Creating the Input Sheet Header

Launch the Add on using the Extensions -> Merge Docs Pro -> Merge Google Docs.

The following sidebar will be displayed.

Click on the Add Column Headers to Get Started button. It will add the necessary headers and the data validation in the Google Sheets. This will help you creating the input for Merging multiple docs.

• Once the headers are added, the sheet will look like the Sample Sheet (opens in a new tab) below:

• With columns, File Name, File Type, File URL/Gemini Prompt, Merge, Status, Comments, Processed on.

Adding Documents to Merge

1. Click on the Select Google Docs or Drive Files to Merge button to open the Google File Picker and choose the files you want to merge from Google Drive.

   • The file picker will display all available Google Docs, Word documents, plain text files, Markdown, HTML, and Rich Text files in your drive.
   • Select the desired documents and click OK to add them to the Google Sheet, with file types automatically assigned. You can manually review and confirm these assignments if needed.

2. To upload files from your local storage, click on the Upload Local Files to Merge option. This allows you to select and upload the Word or other text file formats for merging.

By default, the Merge flag will be set to Yes. You can modify this setting as needed; for instance, if you wish to exclude a file from merging, change the Merge flag to No.

Using Gemini Prompts

Merge Docs Pro integrates with Gemini. You can utilize the Gemini free tier and generate an API key from Google AI Studio (opens in a new tab) and configure it in Merge Docs Pro using the Settings window.

Gemini can be used create contents of the for a full book or missing/unavailable documents.

To add Gemini content:

1. Add a new row in the desired position

2. Select the input type as Gemini Prompt and enter the prompt.

During the merge process, the content will be generated using the Gemini and merged into the output accordingly.

Customizing the Merge Process

After adding the documents to the sheet, you'll be ready to merge the files.

Before starting the merge, you can customize the Merge process as you need using the following options:

Automatically Adding Summary

Select the Summarize each merge option to enable automatic summaries before merging each document.

Selecting Merge Destination

a. Create a new Google Doc: Select this option if you want all documents merged into a new Google Doc.

b. Use an existing Doc as a template: Select this option if you want to create a new Google Doc based on an existing Doc, copying its headers, footers, document access settings, language, and merging the contents into that Doc. This is helpful if you want the merged output to have a default header and footer and be shared with the same people consistently.

c. Merge into Existing Doc: Select this option if you want to append all content into an existing Google Doc.

Customizing the Output Options

• Add page break before each merge: Enable this option to add a page break before each merged content. Each document will start on a new page in the final output.
• Save merged Docs as Word: Enable this option to automatically export the merged document as a Word.
• Save merged Docs as PDF: Enable this option to automatically export the merged document as a PDF.
• Save merged Docs as ePUB: Enable this option to automatically export the merged document as an ePUB.
• Auto download output files: Enable this option to download the PDF/ePUB files automatically.

Merging Docs

After selecting the desired configuration, click the Merge Docs button.

The selected documents will be merged, and the output will be created accordingly. If you have enabled the auto download Option, the output files will be downloaded automatically.