PipedreamHQ / PipedreamHQ/pipedream

[BUG] Google Sheets Wrong Component Metadata

Open
#17,527 1 comment 0 reactions 0 assignees View on GitHub
bug question triaged
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.