GoogleSheets

FREE
By zakutynsky
Updated 9 months ago
Tools
0.1/10
Popularity Score
58996ms
Latency
-
Success Rate

GoogleSheets API Documentation

Read, write, and format data in Sheets.

View API Details
POSTappendSheetValues
POSTbatchClear
POSTbatchUpdate
POSTclearValues
POSTcopySheets
POSTcreateSpreadsheet
POSTgetAccessToken
POSTgetBatchValues
POSTgetRangeValues
POSTgetSingleSpreadsheet
POSTupdateRangeValues
POSTupdateSpreadsheet
POSTappendSheetValues

Appends values to a spreadsheet. The input range is used to search for existing data and find a table within that range. Values will be appended to the next row of the table, starting with the first column of the table.

Header Parameters
X-RapidAPI-HostSTRING
REQUIRED
X-RapidAPI-KeySTRING
REQUIRED
Required Parameters
accessTokenCREDENTIALS
REQUIREDOAuth 2.0 token for the current user.
responseValueRenderOptionSELECT
REQUIREDDetermines how values in the response should be rendered. Must be: FORMATTED_VALUE,UNFORMATTED_VALUE,FORMULA
insertDataOptionSELECT
REQUIREDHow the input data should be inserted. Must be: OVERWRITE,INSERT_ROWS
rangeSTRING
REQUIREDThe A1 notation of a range to search for a logical table of data. Values will be appended after the last row of the table.
valueRangeJSON
REQUIREDValueRange structure.
responseDateTimeRenderOptionSELECT
REQUIREDDetermines how dates, times, and durations in the response should be rendered. Must be: SERIAL_NUMBER,FORMATTED_STRING
valueInputOptionSELECT
REQUIREDHow the input data should be interpreted. Must be: INPUT_VALUE_OPTION_UNSPECIFIED,RAW,USER_ENTERED
includeValuesInResponseSELECT
REQUIREDDetermines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values.
spreadsheetIdSTRING
REQUIREDThe ID of the spreadsheet to update.
Code Snippet
Install SDK
Response ExampleSchema

Install SDK for (Node.js)Unirest

OAuth2 Authentication
Client ID
Client Secret
OAuth2 Authentication