Basic info
- Title
- Google Sheets API v4
- Image
- /file/setup~cross_shared_collection/5bb2765525d98559c80002e6/image/
- Name
- google_sheets_api_v4
- Summary
- Reads and writes Google Sheets.
- Readme
- These collection have been automatically generated by Cenit
- Categories
-
Id Title Description Updated at cloud Cloud On-demand computing, storage and hosting December 01, 2016 17:06 1 Categories -
Name Email Cenit Team support@cenit.io 1 Cross collection authors - Pull count
- 28
- Id
- 5bb2765525d98559c80002e6
- Created at
- October 01, 2018 19:32
- Updated at
- October 01, 2018 19:47
Compute
- Snippets
-
Namespace Name Type Description Updated at Google Sheets API v4 AddBandingRequest.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddBandingResponse.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddChartRequest.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddChartResponse.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddConditionalFormatRuleRequest.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddDimensionGroupRequest.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddDimensionGroupResponse.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddFilterViewRequest.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddFilterViewResponse.json JavaScript - October 01, 2018 20:43 Google Sheets API v4 AddNamedRangeRequest.json JavaScript - October 01, 2018 20:43 199 Snippets (showing 10)
Connectors
- Connections
-
Namespace Name Url Key Token Authorization Updated at Google Sheets API v4 Connection https://sheets.googleapis.com/ September 18, 2018 18:03 1 Connections - Resources
-
Namespace Name Path Description Operations Updated at Google Sheets API v4 V4 Spreadsheets /v4/spreadsheets - Google Sheets API v4 | V4 Spreadsheets [Shared] | POST [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} /v4/spreadsheets/{{spreadsheetId}} - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} [Shared] | GET [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Developermetadata {metadataid} /v4/spreadsheets/{{spreadsheetId}}/developerMetadata/{{metadataId}} - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Developermetadata {metadataid} [Shared] | GET [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Developermetadata:search /v4/spreadsheets/{{spreadsheetId}}/developerMetadata:search - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Developermetadata:search [Shared] | POST [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Sheets {sheetid}:copyto /v4/spreadsheets/{{spreadsheetId}}/sheets/{{sheetId}}:copyTo - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Sheets {sheetid}:copyto [Shared] | POST [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Values {range} /v4/spreadsheets/{{spreadsheetId}}/values/{{range}} - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range} [Shared] | GET [Shared] and Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range} [Shared] | PUT [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Values {range}:append /v4/spreadsheets/{{spreadsheetId}}/values/{{range}}:append - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range}:append [Shared] | POST [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Values {range}:clear /v4/spreadsheets/{{spreadsheetId}}/values/{{range}}:clear - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range}:clear [Shared] | POST [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Values:batchclear /v4/spreadsheets/{{spreadsheetId}}/values:batchClear - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values:batchclear [Shared] | POST [Shared] October 01, 2018 19:46 Google Sheets API v4 V4 Spreadsheets {spreadsheetid} Values:batchclearbydatafilter /v4/spreadsheets/{{spreadsheetId}}/values:batchClearByDataFilter - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values:batchclearbydatafilter [Shared] | POST [Shared] October 01, 2018 19:46 16 Resources (showing 10) - Operations
-
Resource Method Description Parameters Google Sheets API v4 | V4 Spreadsheets [Shared] post Creates a spreadsheet, returning the newly created spreadsheet. Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} [Shared] get Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids will not be returned. You can include grid data one of two ways: * Specify a field mask listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true. If a field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, it is recommended to retrieve only the specific fields of the spreadsheet that you want. To retrieve only subsets of the spreadsheet, use the ranges URL parameter. Multiple ranges can be specified. Limiting the range will return only the portions of the spreadsheet that intersect the requested ranges. Ranges are specified using A1 notation. Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Developermetadata {metadataid} [Shared] get Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metadata's unique metadataId. Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Developermetadata:search [Shared] post Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetadataLookup object, this will return all DeveloperMetadata entries selected by it. If the DataFilter represents a location in a spreadsheet, this will return all developer metadata associated with locations intersecting that region. Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Sheets {sheetid}:copyto [Shared] post Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet. Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range} [Shared] get Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range. dateTimeRenderOption: , majorDimension: , and valueRenderOption: Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range} [Shared] put Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption. includeValuesInResponse: , responseDateTimeRenderOption: , and responseValueRenderOption: and Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range}:append [Shared] post 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. See the [guide](/sheets/api/guides/values#appending_values) and [sample code](/sheets/api/samples/writing#append_values) for specific details of how tables are detected and data is appended. The caller must specify the spreadsheet ID, range, and a valueInputOption. The `valueInputOption` only controls how the input data will be added to the sheet (column-wise or row-wise), it does not influence what cell the data starts being written to. Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range}:clear [Shared] post Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept. Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values:batchclear [Shared] post Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept. 17 Operations (showing 10) - Connection Roles
-
Namespace Name Webhooks Connections Updated at Google Sheets API v4 Connections Google Sheets API v4 | V4 Spreadsheets [Shared] | POST [Shared], Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} [Shared] | GET [Shared], and Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Developermetadata {metadataid} [Shared] | GET [Shared] and Google Sheets API v4 | Connection [Shared] - 1 Connection Roles
Data
- Data Types
-
Namespace Name Slug Type Storage size Updated at Google Sheets API v4 AddBandingRequest - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddBandingResponse - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddChartRequest - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddChartResponse - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddConditionalFormatRuleRequest - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddDimensionGroupRequest - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddDimensionGroupResponse - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddFilterViewRequest - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddFilterViewResponse - Json Data Type 0 Bytes October 01, 2018 19:46 Google Sheets API v4 AddNamedRangeRequest - Json Data Type 0 Bytes October 01, 2018 19:46 199 Data Types (showing 10)
Security
-
Namespace Name Status Type Metadata Updated at Google Sheets API v4 Oauth 2 Authorization Unauthorized Oauth 2 Authorization - 1 Authorizations - OAuth Clients
-
Provider Name Identifier Secret Request token parameters Request token headers Template parameters Updated at Cenit | Google [Shared] CenitSaaS January 06, 2022 22:15 1 Remote OAuth Clients - OAuth Providers
-
Namespace Name Type Authorization endpoint Cenit Google Oauth 2 Provider https://accounts.google.com/o/oauth2/auth 1 Providers - OAuth 2.0 Scopes
-
Provider Name Description Updated at Cenit | Google [Shared] https://www.googleapis.com/auth/drive View and manage the files in your Google Drive July 21, 2022 10:44 Cenit | Google [Shared] https://www.googleapis.com/auth/drive.readonly View the files in your Google Drive July 21, 2022 10:44 Cenit | Google [Shared] https://www.googleapis.com/auth/drive.file View and manage Google Drive files and folders that you have opened or created with this app July 21, 2022 10:44 3 OAuth 2.0 Scopes
Config
- Namespaces
-
Name Slug Updated at Cenit cenit - Google Sheets API v4 google_sheets_api_v4 - 2 Namespaces