Tool
Get values in range
The Google Sheets Get Values in Range tool, powered by Pipedream, enables you to fetch all values or specific cell ranges from your Google Sheets with ease. Utilizing A1 notation, it offers precise data retrieval directly from your spreadsheets.
Features
- Supports retrieval of all values or specific ranges within Google Sheets using A1 notation.
- Allows selection of drive type including My Drive and Shared Drives.
- Enables specifying the exact spreadsheet and worksheet via IDs for targeted data extraction.
- Integrates seamlessly with Pipedream workflows for automated processes.
- Offers easy configuration through input parameters for customized data fetching.
Benefits
- Streamlines access to spreadsheet data for improved workflow automation.
- Reduces manual data extraction time, enhancing productivity.
- Facilitates integration with other tools and services via Pipedream.
- Supports complex data retrieval needs with precise range selection.
- Enables users to centralize data operations within their existing Google ecosystem.
Description
Get all values or values from a range of cells using A1 notation. See the documentation
Parameters
4 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID |
| worksheetIdrequired | string | Select a worksheet or provide a worksheet ID |
| range | string | The A1 notation of the values to retrieve. E.g., |