Skip to main content

Google Sheets

Integrate with Google Sheets for cloud-based spreadsheet automation and data management.

Overview​

The Google Sheets package provides comprehensive spreadsheet manipulation capabilities for Google Sheets. Use it when you need to read, write, or manage data in Google Sheets from your automation workflows.

Key Features​

  • Read/Write Data - Get and set cell values and ranges
  • Sheet Management - Add, delete, rename sheets
  • Row/Column Operations - Insert, delete rows and columns
  • Formatting - Apply cell formatting
  • Search - Find and replace content

Available Nodes​

  • Create Spreadsheet - Create a new Google Sheets document
  • Open Spreadsheet - Open an existing spreadsheet
  • Get Cell Value / Set Cell Value - Read/write individual cells
  • Get Range / Set Range - Read/write cell ranges
  • Get Row / Get Column - Read entire rows or columns
  • Append - Add data to the end of sheet
  • Append Range - Add range of data
  • Insert Row / Insert Column - Add new rows or columns
  • Delete Row / Delete Column - Remove rows or columns
  • Add Sheet / Delete Sheet / Rename Sheet - Manage sheets
  • Get Sheets - List all sheets in workbook
  • Switch Sheet - Change active sheet
  • Clear Range - Clear cell contents
  • Find Replace - Search and replace text
  • Format Range - Apply formatting
  • Merge - Merge cells
  • Trigger - Set up change triggers

When to Use This Package​

  • Data Collection: Store automation results in sheets
  • Report Generation: Create reports accessible via browser
  • Collaborative Data: Share data with team members
  • Database Alternative: Use Sheets as a simple database
  • Integration Hub: Central data store for integrations

Authentication​

Supports two authentication methods:

  • OAuth2 - For personal Sheets access
  • Service Account - For server-side automation

Typical Workflow​

  1. Create or Open Spreadsheet
  2. Get Range to read existing data
  3. Process data in your automation
  4. Set Range or Append to write results
  5. Share the spreadsheet as needed