Overview

The Google Sheets connector allows you to send & retrieve data from any of the Google Sheets available within your account.

Google sheet connector combine Google Sheets data with other data sources to measure ROI and business impact and choose from hundreds of different chart options to analyze data the way you want.

List of Operations

Update a cell

{
  "values": [
    [
      ""
    ]
  ]
}

Add a Row

Append a new row to the bottom of the table

{
  "values": [
    [
      "",
      ""
    ]
  ]
}

Add/Update Column

{
  "majorDimension": "COLUMNS",
  "values": [
    [
      "",
      ""
    ]
  ]
}

Update a Row

{
  "majorDimension": "COLUMNS",
  "values": [
    [
      "",
      ""
    ]
  ]
}

Delete Spreadsheet Row(s)

{
  "requests": [
    {
      "deleteDimension": {
        "range": {
          "sheetId": "<SHEED ID>",
          "dimension": "ROWS",
          "startIndex": 0,
          "endIndex": 10
        }
      }
    }
  ]
}

Delete Spreadsheet column(s)

{
  "requests": [
    {
      "deleteDimension": {
        "range": {
          "sheetId": "<SHEET ID>",
          "dimension": "COLUMNS",
          "startIndex": 0,
          "endIndex": 10
        }
      }
    }
  ]
}

Please find below a reference to REST API documentation
https://developers.google.com/sheets/api/reference/rest

Updated on: 20/07/2022