/

Add sheet data

post

Store data in Google Sheets

Authorizations

bearerAuth & organizationCodeapiKeyAuth & organizationCode

AuthorizationstringRequired

Enter your Bearer token

organization_codestringRequired

Enter your organization code

Body

application/json

organizationIdnumberRequired

ID of the organization

Example: 123

spreadsheetIdstringRequired

ID of the spreadsheet

Example: spreadsheet123

sheetNamestringRequired

Name of the sheet

Example: Sheet1

primaryKeyColumnIndexnumberOptional

Index of the primary key column

Example: 1

endingColumnstringRequired

Ending column of the sheet

Example: Z

Responses

200Success

application/json

post

/api/sheets-integration/

HTTPcURLJavaScriptPython

POST /api/sheets-integration/ HTTP/1.1
Host: platform-api-development.azo.dev
Authorization: Bearer YOUR_SECRET_TOKEN
organization_code: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 155

{
  "organizationId": 123,
  "spreadsheetId": "spreadsheet123",
  "sheetName": "Sheet1",
  "primaryKeyColumnIndex": 1,
  "endingColumn": "Z",
  "dataToStore": [
    [
      "data1",
      "data2"
    ]
  ]
}

200Success

{
  "message": "Operation successful"
}