Loading...
Cross shared collection | Cenit Admin

Basic info

Title
Google Sheets API v4
Image
/file/setup~cross_shared_collection/5bb2765525d98559c80002e6/image/
Name
google_sheets_api_v4
Tags
Summary
Reads and writes Google Sheets.
Readme
These collection have been automatically generated by Cenit
Categories
IdTitleDescriptionUpdated at
cloudCloudOn-demand computing, storage and hostingDecember 01, 2016 17:06
1 Categories
Authors
Name
Cenit Team
1 Cross collection authors
Pull count
19
Id
5bb2765525d98559c80002e6
Created at
October 01, 2018 19:32
Updated at
October 01, 2018 19:47

Compute

Snippets
NamespaceNameTypeDescriptionUpdated at
Google Sheets API v4AddBandingRequest.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddBandingResponse.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddChartRequest.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddChartResponse.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddConditionalFormatRuleRequest.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddDimensionGroupRequest.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddDimensionGroupResponse.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddFilterViewRequest.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddFilterViewResponse.jsonJavaScript - October 01, 2018 20:43
Google Sheets API v4AddNamedRangeRequest.jsonJavaScript - October 01, 2018 20:43
199 Snippets (showing 10)

Connectors

Connections
NamespaceNameUrlKeyTokenAuthorizationUpdated at
Google Sheets API v4Connectionhttps://sheets.googleapis.com/September 18, 2018 18:03
1 Connections
Resources
NamespaceNamePathDescriptionOperationsUpdated at
Google Sheets API v4V4 Spreadsheets/v4/spreadsheets - Google Sheets API v4 | V4 Spreadsheets [Shared] | POST [Shared]October 01, 2018 19:46
Google Sheets API v4V4 Spreadsheets {spreadsheetid}/v4/spreadsheets/{{spreadsheetId}} - Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} [Shared] | GET [Shared]October 01, 2018 19:46
Google Sheets API v4V4 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 v4V4 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 v4V4 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 v4V4 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 v4V4 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 v4V4 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 v4V4 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 v4V4 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
ResourceMethodDescriptionParameters
Google Sheets API v4 | V4 Spreadsheets [Shared]postCreates a spreadsheet, returning the newly created spreadsheet.
Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} [Shared]getReturns 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]getReturns 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]postReturns 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]postCopies 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]getReturns 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]putSets 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]postAppends 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]postClears 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]postClears 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
NamespaceNameWebhooksConnectionsUpdated at
Google Sheets API v4ConnectionsGoogle 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
NamespaceNameSlugTypeStorage sizeUpdated at
Google Sheets API v4AddBandingRequest - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddBandingResponse - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddChartRequest - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddChartResponse - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddConditionalFormatRuleRequest - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddDimensionGroupRequest - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddDimensionGroupResponse - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddFilterViewRequest - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddFilterViewResponse - Json Data Type0 BytesOctober 01, 2018 19:46
Google Sheets API v4AddNamedRangeRequest - Json Data Type0 BytesOctober 01, 2018 19:46
199 Data Types (showing 10)

Security

Authorizations
NamespaceNameStatusTypeUpdated at
Google Sheets API v4Oauth 2 AuthorizationUnauthorizedOauth 2 Authorization -
1 Authorizations
OAuth Clients
ProviderNameIdentifierSecretRequest token parametersRequest token headersTemplate parametersUpdated at
Cenit | Google [Shared]CenitSaaSMarch 02, 2021 20:28
1 Remote OAuth Clients
OAuth Providers
NamespaceNameTypeAuthorization endpoint
CenitGoogleOauth 2 Providerhttps://accounts.google.com/o/oauth2/auth
1 Providers
OAuth 2.0 Scopes
ProviderNameDescriptionUpdated at
Cenit | Google [Shared]https://www.googleapis.com/auth/driveView and manage the files in your Google DriveMarch 02, 2021 20:28
Cenit | Google [Shared]https://www.googleapis.com/auth/drive.readonlyView the files in your Google DriveMarch 02, 2021 20:28
Cenit | Google [Shared]https://www.googleapis.com/auth/drive.fileView and manage Google Drive files and folders that you have opened or created with this appMarch 02, 2021 20:28
3 OAuth 2.0 Scopes

Config

Namespaces
NameSlugUpdated at
Cenitcenit -
Google Sheets API v4google_sheets_api_v4 -
2 Namespaces

Metadata