Google Sheets Node

The Google Sheets Node integrates securely with Google Sheets using OAuth 2.0 via the Scalekit connection googlesheets-0. It enables your AI agent to create, read, and manage spreadsheets, sheets, cell values, dimensions, charts, and formatting on the connected user's Google Sheets account.

Parameters

Required Parameters

• action (string): The target Google Sheets tool action to run. Must be one of the enabled actions:
  • googlesheets_create_spreadsheet: Create a new spreadsheet with an optional title and sheets.
  • googlesheets_read_spreadsheet: Read spreadsheet metadata, sheets, and properties.
  • googlesheets_add_sheet: Add a new sheet (tab) to a spreadsheet.
  • googlesheets_rename_sheet: Rename an existing sheet (tab).
  • googlesheets_duplicate_sheet: Duplicate an existing sheet (tab).
  • googlesheets_delete_sheet: Delete a sheet (tab) from a spreadsheet.
  • googlesheets_copy_sheet_to: Copy a sheet to another spreadsheet.
  • googlesheets_get_values: Read cell values from a range in a sheet.
  • googlesheets_batch_get_values: Read cell values from multiple ranges in one request.
  • googlesheets_update_values: Overwrite cell values in a range.
  • googlesheets_batch_update_values: Overwrite cell values across multiple ranges in one request.
  • googlesheets_append_values: Append rows of values to the end of a sheet.
  • googlesheets_clear_values: Clear cell values in a range.
  • googlesheets_batch_clear_values: Clear cell values across multiple ranges in one request.
  • googlesheets_find_and_replace: Find and replace text or values in a sheet.
  • googlesheets_insert_dimension: Insert rows or columns into a sheet.
  • googlesheets_delete_dimension: Delete rows or columns from a sheet.
  • googlesheets_format_cells: Apply formatting (fonts, colors, alignment) to cells.
  • googlesheets_add_chart: Add a chart to a sheet.
  • googlesheets_add_conditional_format: Add conditional formatting rules to a range.
  • googlesheets_freeze_panes: Freeze rows and/or columns in a sheet.
  • googlesheets_merge_cells: Merge or unmerge cells in a range.

Optional Parameters

• params (object): A key-value dictionary containing action-specific inputs (e.g., {'spreadsheet_id': '1abc...', 'range': 'Sheet1!A1:C10', 'values': [['a', 'b'], ['c', 'd']]}).

Practical Use Cases

1. Data Collection Agent: Create spreadsheets, append incoming rows, and keep a live dataset updated automatically.
2. Reporting Automation: Read ranges across multiple sheets, format cells, add charts, and generate formatted reports.
3. Spreadsheet Maintenance: Rename, duplicate, merge, or delete sheets, and keep columns/rows and panes organized.