Skip to main content
Docs
Build with Relevance AIToolsTool StepsGoogle Sheets Tool Steps

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

Drivestring

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

Spreadsheet ID (Template)stringrequired

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

Worksheet IDstringrequired

Enter the ID of the worksheet you want to copy.

Spreadsheet ID (Target)stringrequired

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.

Suggest edits Raise issue

Update Multiple Rows

The Update Multiple Rows tool step allows you to update multiple rows in your Google Sheet

Create Column

The Create Worksheet tool step allows you to create a new Google Sheet