search
HomePricingIntegrations

Google Sheet

The Google Sheet node allows you to seamlessly read from and write data to Google Sheets. It supports various actions such as appending rows, updating cells, retrieving data, and more.

hashtag
Description

What it does: This node allows you to connect and interact with Google Sheets, enabling you to read, write, update, and manage spreadsheet data dynamically within a workflow.

When to use it? : Use this node when you need to integrate Google Sheets as a data source or destination, such as logging workflow outputs, retrieving configuration data, or automating spreadsheet operations.

hashtag
Component settings

Parameter Name
Description

Credentials

Connect your Google account to authorize access to Google Sheets. Required to perform any actions.

Action

Select the operation you want to perform on the spreadsheet. Available actions include: - Create a new Google sheet - Create Sheet from JSON - Lookup Spreadsheet Row - Get Sheet Names - Get Spreadsheet Info - Batch Get - Batch update - Clear Values

Another fields

Based on the action, another field will display on the node: - Spreadsheet ID - Ranges - Title - Sheet Name - Sheet JSON - Query - Value - ...

hashtag
Operations

hashtag
Document-level Operations

Operations related to the entire Google Sheet file:

  • Create a new Google Sheet: Create a new Google Sheet document.

  • Get Spreadsheet Info: Retrieve general information about the spreadsheet, including the list of sheets and metadata.

hashtag
Sheet-level Operations

Operations related to individual sheets within a spreadsheet:

  • Create Sheet from JSON: Create a new sheet and populate it with data from a JSON string.

  • Get Sheet Names: Retrieve the names of all sheets in the spreadsheet.

  • Clear Values: Clear data within a sheet, either entirely or from a specified range.

hashtag
Data-level Operations

Operations related to rows, cells, or data content:

  • Lookup Spreadsheet Row: Search for a row based on a specific column value.

  • Batch Get: Retrieve data from multiple ranges or sheets at once.

  • Batch Update: Update multiple cells or data ranges in bulk.

Last updated