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.
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.
Component settings
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 - ...
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.
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.
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
Was this helpful?