Articles on: Connectors

Google Sheets - Partner Connector

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

Was this article helpful?

Share your feedback

Cancel

Thank you!