Hello!
I have a Hubspot sales pro account, and Im trying to have the submissions of a Hubspot form automatically export into an existing Google Spreadsheet. I used workflows for this purpose. I mapped a fw properties to the headers in the google sheet. However when I run the workflow and do a test submission, the exports shows up in one cell of the google sheet (it doesnt use the column mappings). Why is that and how do I fix it?
Hey there @SRatnayake
Thank you for sharing your question!
I wanted to share a couple of official resources and Community threads that provide helpful guidance for troubleshooting your issue:
https://community.hubspot.com/t5/CRM/Export-contact-form-Submission-data/m-p/454620
I also want to tag some experts from our Community to share ideas with us. Hey there @EmmaAtKiwi, @Tzuriel , and @HubSpotHannah. I hope you’re having a great week! Any additional thoughts here?
Thanks
Victor
Hey @SRatnayake
Without access to the workflow and Google Sheet, it’s difficult to diagnose precisely. However, I recommend confirming that you’re using “Add new Google Sheet rows” rather than “Update existing Google Sheet rows”, and ensuring your spreadsheet meets the integration requirements outlined here.
I’d also suggest testing from scratch with a brand-new workflow and a new spreadsheet (even with just a few columns) to rule out formatting or configuration issues. If the problem persists, reaching out to HubSpot Support for a deeper review would be the next best step.
Hope this helps!
| |||||||||
 If this helped, mark it as a solution for others in the community. |
Hey @SRatnayake , the “one cell” behavior is almost always a header matching issue. HubSpot’s Google Sheets action maps property values to columns by looking for exact header names in row 1 of your sheet, character by character
Any difference in spacing, capitalization, or special characters between what you configured in the workflow and what’s actually written in the sheet headers will cause data to land in the wrong place or bundle togethr
This gets worse with existing spreadsheets because any merged cells, extra formatting, or content above row 1 can confuse the integration. the sheet really expects clean, plain text headers starting at A1 with nothing else going on around them.
If the fresh sheet test works but your existing one doesn’t, that’s your answer. You can then go back and fix the headers in the original sheet to match the workflow field labels exactly, and it should start mapping correctly.
For more complex HubSpot data routing to databases or other systems something like Stacksync handles that, but for this use case the native workflow should work once the headers are aligned
Hope this helps!
