Read rows
Google Sheets Read Rows is a powerful AI tool that allows users to seamlessly extract data from Google Sheets worksheets. It returns structured data as objects keyed by column headers or as raw arrays, enabling flexible data access for various applications.
Features
- Reads rows from any specified Google Sheets worksheet using the spreadsheet ID and sheet name.
- Supports returning data as structured objects (with keys as column headers) or as raw arrays.
- Allows specifying a range in A1 notation to read subsets of data efficiently.
- Provides functionality to search for rows by value with a dedicated Find Rows feature.
- Integrates easily into Pipedream workflows for automated data processing and extraction.
Benefits
- Simplifies data retrieval from Google Sheets without manual export or copy-pasting.
- Enhances automation by feeding spreadsheet data directly into workflows or applications.
- Improves flexibility by allowing targeted data extraction through range specifications.
- Saves time with fast access to updated spreadsheet data for reporting and analysis.
- Supports dynamic applications by enabling programmatic interaction with live spreadsheet data.
Description
Read rows from a Google Sheets worksheet. Returns data as objects (keys = column headers from row 1) by default, or as raw arrays. Use Get Spreadsheet Info first to discover worksheet names. Optionally specify a range in A1 notation (e.g., A2:D10) to read a subset. For searching rows by value, use Find Rows instead.
Parameters
4 parameters
| Name | Type | Description |
|---|---|---|
| spreadsheetIdrequired | string | The spreadsheet ID from the Google Sheets URL. |
| sheetNamerequired | string | The worksheet (tab) name. Use Get Spreadsheet Info to discover worksheet names. |
| range | string | Optional A1 notation range within the sheet (e.g., |
| hasHeaders | boolean | Whether row 1 contains column headers. If true, returns rows as objects with header keys. Default: |