Hello and welcome to the Community ​@vp472! 

I’m really sorry to hear you’ve had such a frustrating time with this. I’d be happy to help out!  

It looks like the New Form Submission trigger for HubSpot requires a specific form to be selected so you wouldn’t be able to trigger a single Zap from all forms. There’s an existing feature request for the ability to trigger on all forms which has come up in the Community before:

So I’ve gone ahead and added your vote to that feature request. While I can’t make any promises around when/if it will be added we’ll definitely send you an email notification once it is!

In the meantime, you’d need to have a different Zap set up for each of those different HubSpot forms so that you can map the necessary fields from each form into the spreadsheet. Alternatively, Troy suggested a potential workaround in that other Community topic of either triggering from a different trigger (like the New Contact trigger) or use HubSpot’s native workflows.

With the issue of the missing fields, I did some checking in our Help Center and it looks like not all fields are currently supported. I’d recommend checking out Trigger for New Form Entry Doesn't Have All My Fields for more details—there’s a workaround mentioned there that may help to get the necessary fields appearing. 

Can you give that a try and let us know how you get on? 

Hi there, Thanks for the reply. I also want to point out that there seems to be a bug in Zappier. I have correctly matched all the records from Hubspot to google sheet columns, however only a few columns are moved to google sheets as a new contact is created. I checked and the information is not missing, its just not transferred to google. 

Please let me know if you find a bug or glitch in the system. 

Thanks

​@vp472 

Just out of interest is the missing data coming as line items or as a list. I’m wondering if there is an issue with the data format and that’s why google sheets isn’t picking it up.

Thanks for letting us know ​@vp472! Hmm, that is strange. I had a look but couldn’t see any existing bugs reported that match this. It could be, as Badger mentioned, that there’s some line items being passed into a field that doesn’t accept them. Or it could be that the field that was selected in the Zap isn’t the same one that contains the corresponding data when the Zaps live. 

I’ve seen that sort of thing happening in cases where a test record from a different form was used to set up the Zap, or a different form was selected after selecting the fields from the trigger and then when the Zap ran, the form fields didn’t exactly match what had been selected. Do you think that might be what’s happening here? 

To help us rule out a mismatch between the form fields selected in the Zap and those that are seen when the Zap runs live can you please send over screenshots of the selected HubSpot fields in the Zap’s Google Sheets action, as well as screenshots of a recent Zap run showing the Data In/Data Out for the HubSpot trigger and Google Sheets action? Make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing - you can use a tool like Zappy for that.

Thanks very much for your assistance on this. Looking forward to hearing from you! 

As you can see the first picture is the field of Round applying. While this is visible in the particular contact, in Zappier I have matched this correctly however it returns as “No Data”. 

So, This is where I get the data in Hubspot from - CRM → Contacts. Contacts is where all the new contacts with their names, emails, number etc is stored. 

Now in Zappier I have connected it to hubspot to trigger a zap when → A new contact is created or updated. 

And it is all then pushed to google sheets. All the columns are perfectly matched to google sheets, and some fields like names, email and number is properly transferred to sheets however a chunk of other details are not. 

And I have no idea what more I can do here since half of the things work and the other half dont. 

APologies for spamming but this a one last picture that could help. So For the final step, I retrieve these properties that I want in the configure in Zappier. So In my first test zap, 2-3 of these properties did transfer to google sheets. And then in my second test Zap again one property did transfer but was totally different one. So I guess, theres something wrong on the other end since I did the exact same thing both times however im getting different results 

Thanks for sharing all those helpful details here ​@vp472. 

It looks like you’re able to select those additional properties fields in the Google Sheets action but the test record that’s currently selected hasn’t got any values for them. If you change the currently selected test record in the HubSpot trigger, that might help to get the values appearing.

Alternatively, if you turn the Zap on and run a quick test by updating a contact in HubSpot do the additional properties come over from HubSpot then, or are they still blank as well? 

Hey Sam, Thanks for the help. Heres another picture unfortunately of the datain/dataout - 

This picture contains a few of many fields 

Data in - 

Data Out does NOT have any of these values in them, despite the fact that the contact has all fields present. 

I honestly dont know what more I can do. 

1. Lists wont work since Zappier Hubspot does not currently support active lists automation. 
2. Regarding multiple form submission, that is still not available as of 10th December 2024. 
3. Creating 6 Zaps for 6 different form submissions to store everything in the google sheet is also out of option since Zappier does not have any functionality of updating the fields for the same contact ( I tried it out multiple times even made a custom function which dint work). 

Thanks 

Thanks for sharing that screenshot ​@vp472. It looks like the naming of the selected fields doesn’t match what’s available when the Zap runs live. If you’re able to see the desired values in the Data Out section of the HubSpot trigger then, in the Google Sheets action you can manually select the differently named fields by using a process we refer to as custom pill mapping. You can learn more about that here:

But if the Data Out section of the HubSpot trigger doesn’t contain the desired values that are present on the contact in HubSpot, then it could potentially be a bug. It looks like you previously reached out to our Support team about the issues in adding HubSpot contacts over to Google Sheets back on the 3rd December but they don’t appear to have had a reply from you. If you can’t see their reply in your email inbox, I’d recommend searching your spam/junk folder or searching your inbox for any emails from zapier.com in case it’s been misplaced. If you continue the conversation with them over email they’ll be able to take a closer look into your account to confirm whether it is a bug that you’re running into. If it is a bug then they’ll get a bug report created on your behalf so that HubSpot’s developers can investigate further.

Creating 6 Zaps for 6 different form submissions to store everything in the google sheet is also out of option since Zappier does not have any functionality of updating the fields for the same contact ( I tried it out multiple times even made a custom function which dint work). 

There is a Create or Update Contact action as well as an Update Contact available for HubSpot but it doesn’t look like they give access to all the fields. There is another feature request for the ability to access additional fields with those actions so I’ve added your vote for that too. As with the other feature request I can’t make any promises as to when it would be added but we’ll drop you an email as soon as it is. In the meantime, if you’d like to revisit using a Custom action and need any help in getting it set up I’d be happy to lend a hand—just send over a screenshot showing it’s current set up and any errors you’re getting and we’ll go from there! 

Please do keep us updated on how you get on with the Support team in the meantime.