Skip to content

[BUG] Google Sheets Wrong Component Metadata #17527

Open
@ghardin1314

Description

@ghardin1314

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions