Skip to main content

Google Sheets Component

Google Sheets

Create, read, and modify Google Spreadsheets

Component key: google-sheets

Description​

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