Description
Describe the bug
When getting the component metadata for any google sheets component, the configurable_props
returned are the following (using google_sheets-get-values-in-range
) as an example
"configurable_props": [
{
"app": "google_sheets",
"name": "googleSheets",
"type": "app"
},
{
"name": "drive",
"type": "string",
"label": "Drive",
"default": "My Drive",
"optional": true,
"description": "Defaults to `My Drive`. To select a [Shared Drive](https://support.google.com/a/users/answer/9310351) instead, select it from this list.",
"remoteOptions": true
},
{
"name": "sheetId",
"type": "string",
"label": "Spreadsheet ID",
"description": "Select a spreadsheet or provide a spreadsheet ID",
"remoteOptions": true
},
{
"name": "worksheetId",
"type": "string",
"label": "Worksheet ID",
"description": "Select a worksheet or provide a worksheet ID",
"remoteOptions": true
},
{
"name": "range",
"type": "string",
"label": "Range",
"optional": true,
"description": "The A1 notation of the values to retrieve. E.g., `A1:E5`"
}
]
Which shows a parameter called sheetId
. When I actually go to execute this component and use these parameters, I get Error fetching worksheet with ID
undefined - Missing required parameters: spreadsheetId
This happens across multiple different google sheet components
Expected behavior
Consistent parameter names between metadata and actual execution parameters expected.
Screenshots
If applicable, add screenshots to help explain your problem. Note that the screenshots will be displayed publicly.
Additional context
Add any other context about the problem here.