This topic was automatically generated from Slack. You can find the original thread here.
getting an error “type missing for prop sheetName” while using the google sheets find row action
It looks like you’re encountering an error related to a missing type definition for the sheetName prop in your Google Sheets Find Row action. This error typically occurs when the sheetName prop is not properly defined in your component. To resolve this issue, you need to ensure that the sheetName prop is defined with the correct type. Here is an example of how you can define the sheetName prop in your Pipedream component: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, sheetName: { type: "string", label: "Sheet Name", description: "The name of the sheet to search for rows", }, }, async run({ steps, $ }) { // Your code to find a row in the Google Sheet const sheetName = this.sheetName; const response = await axios($, { url: `https://sheets.googleapis.com/v4/spreadsheets/${this.google.$auth.spreadsheet_id}/values/${sheetName}`, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, }); return response; }, }); In this example: - The sheetName prop is defined with the type string. - The label and description properties provide additional information for the user in the Pipedream UI. Make sure to replace the URL in the axios request with the appropriate endpoint for your use case. If you continue to experience issues, please provide more details about your component code, and I’ll be happy to help further.
Hey , could you share the screenshot of your setup if possible?
Maybe related to this error: [BUG] Resource not found with dynamically created google spreadsheet · Issue #12301 · PipedreamHQ/pipedream · GitHub