Skip to main content

​
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)

Yes, you can copy a worksheet to the same spreadsheet. This behaviour would be the same as duplicating a worksheet.
Yes, all cell values, formulas, and formatting in the original worksheet will be copied to the new one.
No, this tool only copies the worksheet contents (data and formatting). Scripts, macros, and protected ranges will not be copied.
⌘I