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