This topic was automatically generated from Slack. You can find the original thread here.
I made a form on my website which points to a Pipedream Webhook.
When storing the data from my form in Google Sheets only COLUMNS A-H are stored. My other fields are coming up blank.
It sounds like there might be an issue with how the data from your form is being mapped to the columns in your Google Sheets. Here are a few steps you can take to troubleshoot and resolve this issue: 1. Check the Form Data: Ensure that your form is correctly sending all the fields to the Pipedream webhook. You can inspect the incoming event data in Pipedream by checking the event payload in the workflow’s trigger step. 2. Verify the Google Sheets Configuration: Make sure that your Google Sheets action in the Pipedream workflow is configured to map all the fields from your form to the correct columns in your Google Sheet. You should see a form in the Google Sheets step where you can map each field from your form to a column in the sheet. 3. Headers in Google Sheets: Ensure that your Google Sheet has headers for all the columns you want to populate. Pipedream uses these headers to map the data correctly. 4. Inspect the Workflow Execution: After sending a test form submission, inspect the workflow execution in Pipedream to see if all fields are being processed correctly. This can help identify if the issue is with the data being sent or with the configuration of the Google Sheets action. 5. Test with Sample Data: You can manually trigger the workflow with sample data to see if the issue persists. This can help isolate whether the problem is with the form submission or the workflow configuration. If you’ve checked these and the issue persists, you might want to revisit the configuration of your Google Sheets action to ensure all fields are correctly mapped. If you need further assistance, you can visit Pipedream Support for more help.
I did all of the steps to check the workflow.
On step 5, I hardcoded the values in the fields and they did not appear in the form. I have REFRESHED the form several times and all of the columns do appear.
I’m sorry to hear you’re having trouble with your workflow. It sounds like you’ve already tried some troubleshooting steps. Here are a few additional suggestions: 1. Check for Errors: Look at the logs for any error messages that might indicate what’s going wrong. This can provide clues about why the values aren’t appearing as expected. 2. Inspect the Code: Double-check the code in your workflow to ensure that the values are being set correctly. Make sure there are no typos or logical errors that could prevent the values from appearing. 3. Review the Data Flow: Ensure that the data is being passed correctly between steps. You might want to add logging statements to verify that the data is as expected at each step. 4. Community Support: If you’re still having issues, consider reaching out to the Pipedream community for help. You can visit Pipedream Support for more options. If you continue to experience issues, please provide more details about the specific steps you’re taking, and any error messages you’re seeing, so I can assist you further.
As I stated in the original comment, it appears as if only columns A - K are being updated. Column L and M despite being hardcoded into the fields are not appearing.
{"spreadsheetId":"1_lA0xcuejt8t-ZGTbqaF9efJp8p-5Or6nBA00VVSS1I","updatedRange":"SUBMISSIONS!A3:K3","updatedRows":1,"updatedColumns":11,"updatedCells":11}
It seems like you’re experiencing an issue where only columns A to K are being updated in your Google Sheets, while columns L and M are not being updated despite being included in your fields. This could be due to a few reasons: 1. Check Field Mapping: Ensure that the fields for columns L and M are correctly mapped in your Pipedream workflow. Double-check the configuration to ensure that the data intended for these columns is being passed correctly. 2. Data Range: Verify that the data range specified in your update request includes columns L and M. The range should be something like A3:M3 instead of A3:K3. 3. API Request: If you’re using an API request to update the Google Sheet, ensure that the payload includes values for columns L and M. Double-check the JSON structure to confirm that these columns are not being omitted. 4. Permissions: Ensure that your Google Sheets API credentials have the necessary permissions to update all columns in the spreadsheet. 5. Debugging: Add logging or debugging steps in your workflow to verify the data being sent to Google Sheets. This can help identify if the issue is with the data being passed or with the Google Sheets API. If you’ve checked these areas and the issue persists, you might want to reach out to Pipedream support for further assistance. You can visit Support - Pipedream for more support options.
I think the module for GOOGLE SHEETS / ADD SINGLE ROW is not fully operational.
Essentially, I had a spreadsheet that spans from A - M. However, the data is only storing from A - K.
I have actually hardcoded values into J and K and they will not store in the spreadsheet.
Hi , I couldn’t reproduce your issue in a test spreadsheet. Could you file a support ticket and share your workflow there so I can take a look?
I submitted a ticket and included a video. I hope this helps.
any word on this?
Hi , not yet unfortunately, appreciate your patience!