Google Sheets

Description: Manage operations in Google Sheets. Authentication:

Available Actions: Examples:

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: