Integration

Google Sheets

Read or write approved Google Sheets data from a phone workflow.

Description

AIM AI can be configured to use selected spreadsheets and ranges for structured call data. Files, tabs, columns, validation rules, and write permissions are confirmed before implementation.

Authentication

A connected Google account using OAuth 2.0 is required.
Exact spreadsheets, ranges, and approved actions are confirmed during workflow scoping.

Supported Actions (11)

These are the operations this integration can perform after the required credentials and permissions are approved.

Append Row
Read Range
Update Range
Clear Range
Get Spreadsheet
Create Spreadsheet
Add Sheet
Rename Sheet
Delete Sheet
Delete Spreadsheet
List Spreadsheets

Examples

Use these representative payloads as a technical starting point, then replace the sample values with the approved workflow data.

Google Sheets - Append Row

Representative workflow configuration for Google Sheets - Append Row.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-append-001",
  "nodeParams": {
    "action": "append_row",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "range": "Sheet1!A1",
      "values": [
        "Alice",
        "Completed",
        "2025-01-20"
      ]
    }
  }
}

Google Sheets - Read Range

Representative workflow configuration for Google Sheets - Read Range.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-read-001",
  "nodeParams": {
    "action": "read_range",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "range": "Sheet1!A1:C10"
    }
  }
}

Google Sheets - Clear Range

Representative workflow configuration for Google Sheets - Clear Range.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-clear-001",
  "nodeParams": {
    "action": "clear_range",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "range": "Sheet1!A2:C10"
    }
  }
}

Google Sheets - Get Spreadsheet

Representative workflow configuration for Google Sheets - Get Spreadsheet.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-get-001",
  "nodeParams": {
    "action": "get_spreadsheet",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "includeGridData": false
    }
  }
}

Google Sheets - Add Sheet

Representative workflow configuration for Google Sheets - Add Sheet.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-add-sheet-001",
  "nodeParams": {
    "action": "add_sheet",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "newSheetTitle": "NewData"
    }
  }
}

Google Sheets - Rename Sheet

Representative workflow configuration for Google Sheets - Rename Sheet.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-rename-sheet-001",
  "nodeParams": {
    "action": "rename_sheet",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "sheetId": 123456,
      "newSheetTitle": "RenamedSheet"
    }
  }
}

Google Sheets - Delete Spreadsheet

Representative workflow configuration for Google Sheets - Delete Spreadsheet.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-001",
  "nodeParams": {
    "action": "delete_spreadsheet",
    "params": {
      "fileId": "1AbCDefGhIJkLmNoPqRstUvWxYz"
    }
  }
}

Google Sheets - List Spreadsheets

Representative workflow configuration for Google Sheets - List Spreadsheets.

JSON

{
  "automationType": "google_sheets",
  "nodeId": "sheets-list-001",
  "nodeParams": {
    "action": "list_spreadsheets",
    "params": {
      "listParentFolderId": "1a2b3cFolderId"
    }
  }
}