Copy Spreadsheet

Copy a complete spreadsheet, including all worksheets and data, to a new spreadsheet with a new name.

Options

Field Definition Type Required
Use Spreadsheet ID? Option to specify a Google Sheets spreadsheet by ID.

If you select No, select a spreadsheet from the Spreadsheet dropdown and ignore the Spreadsheet ID field.

If you select Yes, the list of spreadsheets from your account in the Spreadsheet dropdown will be depopulated; select -- Enter Spreadsheet ID -- from the Spreadsheet dropdown and enter an ID in the Spreadsheet ID field.

The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0, the spreadsheet ID is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps.

Dropdown

TRUE

Sheet to Copy Select a sheet to copy from a list of spreadsheets in your Google Sheets account.

Dropdown

TRUE

Spreadsheet ID Unique identifier for your selected spreadsheet.

Text

FALSE

Input

Field Definition Type Required
Name Name for the new spreadsheet to which the sheet content will be copied.

Text

FALSE

Output

Field Definition Type
ID Unique identifier of the new spreadsheet.

Text

URL URL of the new spreadsheet.

Text

Related topics

Google Sheets connector

Workflow elements

Google Sheets API documentation