Google Sheets Reader
This document outlines the functionality and characteristics of the Google Sheets Reader node, which enables automated data extraction from Google Sheets.
Node Inputs
The Google Sheets Reader node accepts the following inputs:
Sheet Selection (Choose one method)
- Select Sheet: Choose a Google Sheet directly from your Drive
- Use Link: Option to use a direct Google Sheets URL
- Link: The URL of your Google Sheet (required if using link method)
Configuration Options
- Sheet Name: Specific worksheet within the Google Sheets file
- Row Range: Specify exact rows to read (e.g., “2-5, 8, 11-13”)
- Search Column: Column to use for filtering data
- Search Value: Value to filter rows by
- Number of Rows: Limit the number of rows returned
Node Output
The Google Sheets Reader node produces:
- Sheet Data: Structured data from the Google Sheet based on your column headers. Each column header is exposed as a list of text output containing all records from that column.
Node Functionality
The Google Sheets Reader node provides automated access to Google Sheets data with advanced filtering and sorting capabilities.
Key features include:
- Flexible row range selection
- Search and filter functionality
- Customizable data retrieval options
- Secure authentication with Gumloop
When To Use
The Google Sheets Reader node is particularly valuable in scenarios requiring automated data extraction from Google Sheets. Common use cases include:
- Data Analysis: Extract data for reports and analytics
- Content Management: Pull content stored in spreadsheets
- Inventory Tracking: Monitor stock levels and changes
- Project Management: Track task status and updates
Some specific examples:
- Reading daily sales data
- Extracting customer information
- Monitoring inventory levels
- Pulling content for websites
Important Considerations:
- Requires Authentication with Google - Set up in the Credentials page
- Sheet must have headers in the first row (ie. the data you want to extract)
- Row Range cannot include row 1 (headers)
- You must have access to the Google Sheet
In summary, the Google Sheets Reader node provides powerful data extraction capabilities from Google Sheets, with flexible configuration options for precise data retrieval and filtering.