Retrieve options
The Retrieve Options tool by Google Sheets allows users to dynamically fetch available configuration options for component properties within a workflow. It ensures accurate and context-sensitive option retrieval by considering all previously configured property values.
Features
- Supports dynamic fetching of property options based on prior configurations.
- Maintains correct dependency order when retrieving component properties.
- Provides a reliable way to get up-to-date options for Google Sheets integration components.
- Acts as a modern, drop-in replacement for older configuration tools.
- Enables seamless automation by simplifying component configuration setups.
Benefits
- Reduces errors by ensuring options are contextually accurate and dependent values are respected.
- Improves workflow efficiency with quick and dynamic option retrieval.
- Enhances automation capabilities in Google Sheets-based workflows.
- Simplifies complex configurations by managing property dependencies automatically.
- Offers a user-friendly method to configure components without manual option lookup.
Description
You call this tool if you need to get the available options for a property of a component. The property description will tell you if you can use this tool and what the parameter values are.
IMPORTANT: Component properties are ordered by dependency — configure them top-to-bottom as they appear in the tool schema. When fetching options for a property, you MUST pass all previously configured property values in the "configuredProps" parameter (e.g. { "cloudId": "..." }). Downstream properties often depend on upstream values to resolve their options correctly.
Prefer "retrieve_options" as it is the newer version and a drop-in replacement for "configure_component"
Parameters
3 parameters
| Name | Type | Description |
|---|---|---|
| componentKeyrequired | string | — |
| propNamerequired | string | — |
| configuredProps | object | Previously configured property values for this component. Pass these so that dependent options can be resolved (e.g. pass { cloudId: "..." } when fetching options for projectId). |