Google Sheets Component
Create, read, and modify Google Spreadsheets
Component key: google-sheetsDescription
Google Sheets is Google's spreadsheet service. This component allows you to create, read, and modify spreadsheets stored in a Google Drive Account.
Connections
Google Sheets OAuth 2.0
The Google Sheets component authenticates requests through Google's OAuth service. To create a Google Sheets developer account and authenticate using Google OAuth, follow directions here Now, you will have to configure OAuth 2.0 settings in Prismatic. Create a new Google Sheets connection.
- For Client ID and Client Secret enter the values that you got from the Google Cloud Platform auth settings.
- For Scopes choose from the list found on the Google docs
Actions
Add Worksheet
Add a new Worksheet to a Google Sheet Document | key: addSheet
Append Rows
Append new rows to a Worksheet | key: appendRows
Clear Worksheet
Clear all data in the a Worksheet | key: clearSheet
Create Spreadsheet
Create a new Google Sheet Document | key: createDocument
Get Rows
Get the cell values of rows in a Worksheet | key: getRows
Output Example Payload
{
"data": [
{
"Column 1": "a",
"Column 2": "b"
},
{
"Column 1": "c",
"Column 2": "d"
}
]
}
List Worksheets
List information about all Worksheets in a Google Sheet Document | key: listSheets
Raw Request
Send a raw HTTP request to Sheets API | key: rawRequest
Remove Worksheet
Remove a Worksheet from a Google Sheet Document | key: removeSheet
Set Header Row
Set the column headings in a Worksheet | key: setHeaderRow
Update Rows
Update call values of rows in a Worksheet | key: updateRows