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
Thank you!