/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo

POST

Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.

Request

Path Params

Body Params application/json

Examples

Responses

🟢200Successful response

application/json

Body

Request Example

Shell

JavaScript

Java

Swift

curl --location --request POST 'https://sheets.googleapis.com//v4/spreadsheets//sheets/:copyTo' \
--header 'Content-Type: application/json' \
--data-raw '{
    "destinationSpreadsheetId": "string"
}'

Response Example

{
    "dataSourceSheetProperties": {
        "columns": [
            {
                "formula": "string",
                "reference": {
                    "name": "string"
                }
            }
        ],
        "dataExecutionStatus": {},
        "dataSourceId": "string"
    },
    "gridProperties": {
        "columnCount": 0,
        "columnGroupControlAfter": true,
        "frozenColumnCount": 0,
        "frozenRowCount": 0,
        "hideGridlines": true,
        "rowCount": 0,
        "rowGroupControlAfter": true
    },
    "hidden": true,
    "index": 0,
    "rightToLeft": true,
    "sheetId": 0,
    "sheetType": "SHEET_TYPE_UNSPECIFIED",
    "tabColor": {},
    "tabColorStyle": {
        "rgbColor": {},
        "themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
    },
    "title": "string"
}

Modified at 2023-08-15 07:09:28

/v4/spreadsheets/{spreadsheetId}/developerMetadata:search

/v4/spreadsheets/{spreadsheetId}/values/{range}