Skip to main content
Description: Manage operations in Google Sheets. Authentication:
  • See integration-specific authentication requirements
Available Actions: Examples:
Action: unknown
Example 1: Google Sheets - Append Row Append a row to a sheet
{
  "automationType": "google_sheets",
  "nodeId": "sheets-append-001"
}
Example 2: Google Sheets - Read Range Read a range from a sheet
{
  "automationType": "google_sheets",
  "nodeId": "sheets-read-001"
}
Example 3: Google Sheets - Update Range Update a range with a 2D matrix
{
  "automationType": "google_sheets",
  "nodeId": "sheets-update-001"
}
Example 4: Google Sheets - Clear Range Clear values in a range
{
  "automationType": "google_sheets",
  "nodeId": "sheets-clear-001"
}
Example 5: Google Sheets - Get Spreadsheet Get spreadsheet metadata and optionally grid data
{
  "automationType": "google_sheets",
  "nodeId": "sheets-get-001"
}
Example 6: Google Sheets - Create Spreadsheet Create a new spreadsheet with optional initial sheets
{
  "automationType": "google_sheets",
  "nodeId": "sheets-create-001"
}
Example 7: Google Sheets - Add Sheet Add a sheet to an existing spreadsheet
{
  "automationType": "google_sheets",
  "nodeId": "sheets-add-sheet-001"
}
Example 8: Google Sheets - Rename Sheet Rename a sheet in a spreadsheet
{
  "automationType": "google_sheets",
  "nodeId": "sheets-rename-sheet-001"
}
Example 9: Google Sheets - Delete Sheet Delete a sheet by id from a spreadsheet
{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-sheet-001"
}
Example 10: Google Sheets - Delete Spreadsheet Delete a spreadsheet (uses Drive API)
{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-001"
}
Example 11: Drive - List Folders List folders in Google Drive
{
  "automationType": "google_sheets",
  "nodeId": "sheets-list-folders-001"
}
Example 12: Drive - Create Folder Create a folder in Google Drive
{
  "automationType": "google_sheets",
  "nodeId": "sheets-create-folder-001"
}
Example 13: Drive - Delete Folder Delete a folder in Google Drive
{
  "automationType": "google_sheets",
  "nodeId": "sheets-delete-folder-001"
}
Example 14: Google Sheets - List Spreadsheets List spreadsheets in Drive
{
  "automationType": "google_sheets",
  "nodeId": "sheets-list-001"
}
Third-Party Documentation: