This topic was automatically generated from Slack. You can find the original thread here.
Hi
I keep getting this error which has only stared showing recently on part of the workflow in “add single row” to Google Sheets. Anyone have any ideas? @U03CXTHK4RF?
TypeError
Cannot read properties of undefined (reading ‘label’)
DETAILS
at Object.run (file:///tmp/pdg/dist/code/cb…904f55ad84/code/google_sheets/actions/add-single-row/add-single-row.mjs:80:44)
at null.executeComponent (/var/task/launch_worker.js:288:53)
at MessagePort.messageHandler (/var/task/launch_worker.js:788:28) (modificato)
It seems like you’re encountering a TypeError related to the add-single-row action in your Google Sheets workflow. The error message indicates that the code is trying to read the label property of an undefined object. This usually happens when the expected data structure is not as anticipated. Here are a few steps you can take to troubleshoot and resolve this issue: 1. Check the Input Data: Ensure that all the required fields for the add-single-row action are correctly populated. This includes the Spreadsheet ID, Worksheet ID, and the data you want to add as a new row. 2. Verify Headers: If your Google Sheet has headers, make sure the Does the first row of the sheet have headers? option is correctly set. If headers are present, Pipedream will use them to map the data correctly. 3. Test with Sample Data: Try running the action with a simple set of sample data to see if the issue persists. This can help isolate whether the problem is with the data being passed to the action. 4. Review the Workflow Configuration: Make sure that all previous steps in the workflow are correctly configured and producing the expected outputs. Any issues in earlier steps can propagate and cause errors in subsequent steps. 5. Check for Recent Changes: Since you mentioned that the error started showing recently, consider any recent changes you made to the workflow or the Google Sheet that might have introduced the issue. If you continue to experience issues, you can also reach out to Pipedream support for further assistance. Visit Support - Pipedream for more support options. ### Example Configuration for Adding a Single Row Here’s a quick guide on how to configure the Add Single Row action in Pipedream: 1. Search for the Google Sheets app from the step menu. 2. Select the Add Single Row action. 3. Connect your Google Sheets account. 4. Select a Spreadsheet or pass a string from a previous step. 5. Select a Worksheet Id or pass a string from a previous step. 6. Select a Does the first row of the sheet have headers? or pass a boolean from a previous step. 7. At the bottom of the step, click Test to run the action and test the configuration. For more detailed instructions, you can refer to the [Add Single Row
Hi
I keep getting this error which has only starete showing recently on part of the workflow in “add single row” to Google Sheets. Anyone have any ideas? I made no changes so that can’t be the reason
TypeError
Cannot read properties of undefined (reading ‘label’)
DETAILS
at Object.run (file:///tmp/pdg/dist/code/cb…904f55ad84/code/google_sheets/actions/add-single-row/add-single-row.mjs:80:44)
at null.executeComponent (/var/task/launch_worker.js:288:53)
at MessagePort.messageHandler (/var/task/launch_worker.js:788:28) (modificato)
It sounds like you’re encountering a TypeError related to the label property in the “Add Single Row” action for Google Sheets. This error typically indicates that the code is trying to access a property on an object that is undefined. Given that you haven’t made any changes to your workflow, it’s possible that the structure of the data being passed to the Google Sheets action has changed, or there might be an issue with the Google Sheets API response. Here are a few steps you can take to troubleshoot and resolve this issue: 1. Check the Data Being Passed: Ensure that the data being passed to the Google Sheets action is in the expected format. Verify that all required fields are present and correctly labeled. 2. Reconfigure the Action: Sometimes, reconfiguring the action can resolve issues. Try deleting the “Add Single Row” action and adding it again, following these steps: - Search for the Google Sheets app from the step menu. - Select the “Add Single Row” action. - Connect your Google Sheets account. - Select a Spreadsheet or pass a string from a previous step. - Select a Worksheet Id or pass a string from a previous step. - Select whether the first row of the sheet has headers or pass a boolean from a previous step. - At the bottom of the step, click Test to run the action and test the configuration. 3. Inspect the Workflow Execution: Use the Pipedream Inspector to check the data being passed between steps. Look for any discrepancies or missing data that might be causing the issue. 4. Community and Support: If the issue persists, consider reaching out to the Pipedream community or support for further assistance. You can visit Support - Pipedream for more support options. If you need more specific help, please provide additional details about the data being passed to the Google Sheets action or any recent changes in your Google Sheets structure. This will help in diagnosing the issue more accurately.