How to Create Worksheets using Gemini™ in Merge Docs Pro

This page explains how to create worksheets using Gemini™ in 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.

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

Creating Worksheets

To create worksheets, begin by adding all the prompts for each worksheet unit into your Google Sheet. For reference on how to format and structure your prompts, refer to the Sample Sheet (opens in a new tab).

Creating Worksheets for a Single Output File

1. Add Prompts for Each Worksheet Unit: Begin by entering all the prompts for each worksheet unit into the appropriate columns of your Google Sheet.

2. Generate the Output File: Once all prompts are entered, you can create a single output file. This file will include worksheets on different topics or units combined into one document. This document can be shared or printed for students.

Creating Unique Worksheets for Each Student

1. Duplicate Prompts for Each Worksheet: To generate a unique worksheet for each student, duplicate the same prompt as many times as needed for the number of different worksheets. This ensures each student receives a worksheet with individual content.

2. Add Page Breaks for Separation: When setting up your merge options, choose to add a page break between each worksheet. This configuration will ensure that each worksheet appears on a separate page in the final output file, making it easy to print and distribute to students.

The output file will include multiple worksheets combined into one document. The document can then be shared or printed as needed.