Skip to main content

​
Overview

Read, write, and manage Google Sheets spreadsheets and their tabs. Call actions with automationType, action, and params from any workflow node that supports automations.

​
Authentication

  • OAuth 2.0 — connect your Google account via the Plura OAuth flow. The same connection covers both Google Sheets and Google Drive operations (unified under automationType: "google_sheets").

​
Available Actions

Click any action to jump to its example payload.

​
Examples

​
Example 1: Google Sheets - Append Row

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

​
Example 2: Google Sheets - Read Range

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

​
Example 3: Google Sheets - Update Range

Update a range with a 2D matrix 
{
  "automationType": "google_sheets",
  "nodeId": "sheets-update-001",
  "nodeParams": {
    "action": "update_range",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "range": "Sheet1!A2:C2",
      "valueInputOption": "USER_ENTERED",
      "matrix": [
        [
          "Bob",
          "In Progress",
          "2025-01-22"
        ]
      ]
    }
  }
}

​
Example 4: Google Sheets - Clear Range

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

​
Example 5: Google Sheets - Get Spreadsheet

Get spreadsheet metadata and optionally grid data 
{
  "automationType": "google_sheets",
  "nodeId": "sheets-get-001",
  "nodeParams": {
    "action": "get_spreadsheet",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "includeGridData": false
    }
  }
}

​
Example 6: Google Sheets - Create Spreadsheet

Create a new spreadsheet with optional initial sheets 
{
  "automationType": "google_sheets",
  "nodeId": "sheets-create-001",
  "nodeParams": {
    "action": "create_spreadsheet",
    "params": {
      "title": "Plura Automation Sheet",
      "sheets": [
        {
          "title": "Summary"
        },
        {
          "title": "Data"
        }
      ]
    }
  }
}

​
Example 7: Google Sheets - Add Sheet

Add a sheet to an existing spreadsheet 
{
  "automationType": "google_sheets",
  "nodeId": "sheets-add-sheet-001",
  "nodeParams": {
    "action": "add_sheet",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "newSheetTitle": "NewData"
    }
  }
}

​
Example 8: Google Sheets - Rename Sheet

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

​
Example 9: Google Sheets - Delete Sheet

Delete a sheet by id from a spreadsheet 
{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-sheet-001",
  "nodeParams": {
    "action": "delete_sheet",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "sheetId": 123456
    }
  }
}

​
Example 10: Google Sheets - Delete Spreadsheet

Delete a spreadsheet (uses Drive API) 
{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-001",
  "nodeParams": {
    "action": "delete_spreadsheet",
    "params": {
      "fileId": "1AbCDefGhIJkLmNoPqRstUvWxYz"
    }
  }
}

​
Example 11: Google Sheets - List Spreadsheets

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

​
Third-Party Documentation