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.
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
