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
Data Sources
Select Column
Select a Column from a Worksheet | key: selectColumn | type: picklist
{
"result": [
{
"key": "Column 1",
"label": "Column 1"
},
{
"key": "Column 2",
"label": "Column 2"
}
]
}
Select Columns
Select Columns from a Worksheet | key: selectColumns | type: objectSelection
{
"result": [
{
"object": {
"key": "id",
"label": "id"
}
},
{
"object": {
"key": "equipmentId",
"label": "equipmentId"
}
}
]
}
Select Worksheet
Select a Worksheet | key: selectWorksheet | type: picklist
{
"result": [
{
"key": "1",
"label": "Sheet1"
}
]
}
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
List Columns
Get the headers of a Worksheet | key: listColumns
{
"data": ["Column 1", "Column 2"]
}
List Rows
List the cell values of rows in a Worksheet | key: getRows
{
"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
{
"data": [
{
"spreadsheetId": "1K__zH9e2bd",
"title": "Sheet1",
"worksheetId": "od6"
}
]
}
Raw Request
Send raw HTTP request to Google Sheets | 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