GSheets Operator > Google Sheets Operator > Copy Sheet To

Copy Sheet To

Copy a sheet tab from your a source spreadsheet to a target spreadsheet as a new sheet tab titled "Copy of {source sheet title}".
It's recommended to refresh your spreadsheet ref after doing this.

Inputs

In
Exec

In Token
Google Sheets Web Token Object Reference

A validated UGoogleSheetsWebToken object. Used to authenticate the Sheets operation.

Operation Params
Google Sheets Operation Params Structure

Generic request operation parameters

Call on Complete
Delegate (by ref)

This delegate will be called when the operation completes and tell you whether or not it was successful and return the response as a string.

In Source Spreadsheet Id
String

This is the spreadsheet ID number or key of the spreadsheet which contains the source sheet tab. Get it from your spreadsheet URL by calling GetSpreadsheetIdFromUrl.

In Target Spreadsheet Id
String

This is the spreadsheet ID number or key of the spreadsheet to which the source sheet tab will be copied. Get it from your spreadsheet URL by calling GetSpreadsheetIdFromUrl.

In Source Sheet Id
Integer

This is the sheet ID number or GID. Get it from your sheet URL by calling GetSheetIdFromUrl or from a UGoogleSheetsObjectSpreadsheet calling GetSheetIdFromSheetIndex().

Outputs

Out
Exec