PipedreamHQ / PipedreamHQ/pipedream
[BUG] Google Sheets Wrong Component Metadata
- Dominant language
- JavaScript
- Stars
- 11.7k
- Forks
- 5.8k
- Avg merge
- 3d 10h
- Merged PRs (30d)
- 102
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
```json
"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.
Contributor guide
Assessment
This issue has not been assessed yet.