Skip to main content

Copy Google Sheets Rows to Zoho Sheets

With Document Studio, you can copy rows from Google Sheets to a new or existing Zoho Sheet automatically, whenever new rows are added to the Google Sheet. You can also use the add-on to copy rows in bulk from an existing Google Sheet to a Zoho Sheet.

For this example, we have a Google Sheet recording the sales data of a store, that we’ll be copying into a Zoho Sheet using Document Studio.

Copy Rows to Zoho Sheets

Create Workflow​

Install Document Studio and open your Google Sheet to launch the add-on. Create a new workflow, give a descriptive name, and click Continue to move to the conditions page.

On the Conditions pane, specify if you want your workflow to run only if the Google Sheet row satisfies certain conditions. For instance, if the source spreadsheet has sales data for all regions and you would like to copy data specific to North America in a Zoho sheet, you can put that condition here. By default, the workflow will run for all rows in the Google Sheet.

Click Continue to move to the tasks section, and choose Copy Row from the list of available tasks.

Copy Rows

Connect Google Sheets to Zoho Sheets​

Select Zoho Sheets from the list of available spreadsheet applications, and click on Link your Zoho Sheets account.

Once your Zoho account has been linked, copy the Spreadsheet URL from your Zoho Sheet, and paste it into the Spreadsheet URL field.

Next, specify the name of the worksheet where you want the rows to be copied. If you have created a worksheet previously, simply enter its name in this field. You can also choose to create a new worksheet by specifying a custom name for the sheet.

Connect to Zoho Sheets

The next section is Field Mapping where you define the source columns that should be mapped to the columns in the destination Zoho sheet.

Field Name: represents the heading of the column created in the worksheet Field Value: represents the dynamic values that will be stored in that column according to the actual cell values in the sheet.

For instance, if a column in the source sheet is titled β€œZip” and you would like to store it as β€œPostal Code”, the mapping would look like this:

Field NameField Value
Postal Code{{ Zip }}

You have a list of default fields available, including the columns in the existing sheet. You can edit the field names, delete an entire field, and add as many new fields as you want.

Click Done to save this task.

Activate Workflow​

Click on Continue to proceed to the triggers screen. If you want the workflow to be automatically triggered every hour, so that any new rows added in that duration are processed automatically, you can choose the option Run workflow every hour and then click on the Save button.

Or you can choose to run it immediately by simply clicking the Save and Run button.

Copy Rows to Zoho Sheets

The workflow will also appear in the workflow dashboard where you can edit, delete, or manually run the workflow.