> ## Documentation Index
> Fetch the complete documentation index at: https://docs.plura.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](#google-sheets-append-row)
* [Read Range](#google-sheets-read-range)
* [Update Range](#google-sheets-update-range)
* [Clear Range](#google-sheets-clear-range)
* [Get Spreadsheet](#google-sheets-get-spreadsheet)
* [Create Spreadsheet](#google-sheets-create-spreadsheet)
* [Add Sheet](#google-sheets-add-sheet)
* [Rename Sheet](#google-sheets-rename-sheet)
* [Delete Sheet](#google-sheets-delete-sheet)
* [Delete Spreadsheet](#google-sheets-delete-spreadsheet)
* [List Spreadsheets](#google-sheets-list-spreadsheets)

## Examples

<a id="google-sheets-append-row" />

#### Example 1: Google Sheets - Append Row

Append a row to a sheet

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

***

<a id="google-sheets-read-range" />

#### Example 2: Google Sheets - Read Range

Read a range from a sheet

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

***

<a id="google-sheets-update-range" />

#### Example 3: Google Sheets - Update Range

Update a range with a 2D matrix

```json theme={null}
{
  "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"
        ]
      ]
    }
  }
}
```

***

<a id="google-sheets-clear-range" />

#### Example 4: Google Sheets - Clear Range

Clear values in a range

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

***

<a id="google-sheets-get-spreadsheet" />

#### Example 5: Google Sheets - Get Spreadsheet

Get spreadsheet metadata and optionally grid data

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

***

<a id="google-sheets-create-spreadsheet" />

#### Example 6: Google Sheets - Create Spreadsheet

Create a new spreadsheet with optional initial sheets

```json theme={null}
{
  "automationType": "google_sheets",
  "nodeId": "sheets-create-001",
  "nodeParams": {
    "action": "create_spreadsheet",
    "params": {
      "title": "Plura Automation Sheet",
      "sheets": [
        {
          "title": "Summary"
        },
        {
          "title": "Data"
        }
      ]
    }
  }
}
```

***

<a id="google-sheets-add-sheet" />

#### Example 7: Google Sheets - Add Sheet

Add a sheet to an existing spreadsheet

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

***

<a id="google-sheets-rename-sheet" />

#### Example 8: Google Sheets - Rename Sheet

Rename a sheet in a spreadsheet

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

***

<a id="google-sheets-delete-sheet" />

#### Example 9: Google Sheets - Delete Sheet

Delete a sheet by id from a spreadsheet

```json theme={null}
{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-sheet-001",
  "nodeParams": {
    "action": "delete_sheet",
    "params": {
      "spreadsheetId": "1AbCDefGhIJkLmNoPqRstUvWxYz",
      "sheetId": 123456
    }
  }
}
```

***

<a id="google-sheets-delete-spreadsheet" />

#### Example 10: Google Sheets - Delete Spreadsheet

Delete a spreadsheet (uses Drive API)

```json theme={null}
{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-001",
  "nodeParams": {
    "action": "delete_spreadsheet",
    "params": {
      "fileId": "1AbCDefGhIJkLmNoPqRstUvWxYz"
    }
  }
}
```

***

<a id="google-sheets-list-spreadsheets" />

#### Example 11: Google Sheets - List Spreadsheets

List spreadsheets in Drive

```json theme={null}
{
  "automationType": "google_sheets",
  "nodeId": "sheets-list-001",
  "nodeParams": {
    "action": "list_spreadsheets",
    "params": {
      "listParentFolderId": "1a2b3cFolderId"
    }
  }
}
```

## Third-Party Documentation

* [https://developers.google.com/sheets/api](https://developers.google.com/sheets/api)