Copy Worksheet

Copy a worksheet from one spreadsheet to another.

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
Spreadsheet	List of spreadsheets in your Google Sheets account Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option.	Dropdown	TRUE
Spreadsheet ID	Unique identifier for your selected spreadsheet	String	FALSE
Worksheets	List of worksheet tabs in your selected spreadsheet	Dropdown	TRUE

Field Definition Type Required

Field	Definition	Type	Required
ID	ID of the spreadsheet where you want to copy the selected worksheet. For example, the spreadsheet ID in the URL `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` is `abc1234567`.	String	FALSE

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

For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is abc1234567.

String

FALSE

Field	Definition	Type
Name	Name of the new worksheet (typically `Copy of <original name>`)	String
ID	New worksheet's unique ID	String