Google Sheets

Read, write, and manage Google Sheets spreadsheets and their tabs

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.

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

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

• https://developers.google.com/sheets/api