Copy Worksheet

The Copy Worksheet tool step allows you to copy a worksheet from one Google Sheet to another

Add the ‘Copy Worksheet’ Tool step to your Tool

You can add the ‘Copy Worksheet’ Tool step to your Tool by:

1. Creating a new Tool, then searching for the ‘Copy Worksheet’ Tool step
2. Click ‘Expand’ to see the full Tool step
3. Using the dropdown menu:
   • Select the account you would like to use.
   • Select the Drive you would like to use.
   • Select the Spreadsheet that the worksheet is in.
   • Select the worksheet you would like to copy.
   • Select the Spreadsheet you would like to copy the worksheet to.
4. Click ‘Run step’ to test out the Tool

Parameters

Drive · string

The Drive you want to use. By default, the tool uses “My Drive”.

Spreadsheet ID (Template) · string · required

Enter the ID of the spreadsheet where the original worksheet is located.

Worksheet ID · string · required

Enter the ID of the worksheet you want to copy.

Spreadsheet ID (Target) · string · required

Enter the ID of the spreadsheet where you want to copy the worksheet to.

Frequently asked questions (FAQs)

Can I copy a worksheet to the same spreadsheet?

Yes, you can copy a worksheet to the same spreadsheet. This behaviour would be the same as duplicating a worksheet.

Will the formatting be preserved?

Yes, all cell values, formulas, and formatting in the original worksheet will be copied to the new one.

Does this tool copy scripts, macros, or protected ranges?

No, this tool only copies the worksheet contents (data and formatting). Scripts, macros, and protected ranges will not be copied.