Form data sent to google sheet via a workflow has wrong data

[NContrinoEM]

We created a Hubspot Form for RMA requests. The form itself has automation so an email is sent to Fulfillment with the data. We also set up a workflow so that the form data is put into a google sheet row, so that it is easier for Fulfillment to track. We noticed that random or perhaps previous data is sent to the google sheet when fields in the form are left blank. The email sent directly from the form does not have this issue. Does anyone know what is going on and how to fix it?

[zachh · Accepted solution]

Hi @NContrinoEM 

Are all the fields on the form mandatory? I ran into a similar issue and that was one problem.

Say for example it used these properties:

• First Name *
• Last Name *
• Email *
• Request Type (dropdown) *
• Form Request (multi-line text)

We made the Form Request field optional since the rep would reach out for more details anyway. So when John Smith submits the form:

1. Those properties are updated on his contact record
2. Then the form submission triggers the workflow
3. Finally, those properties are pushed into Google Sheets.

Then, later, John submits another form, but doesn't fill out the Form Request, so when the form updates his contact record, the Form Request property still has all the data from his first submission. And when it goes to pull those properties from Google Sheets, it's still using partially old data.

We ended up clearing the optional properties at the end of our workflow so that it would be fresh every time, since we can still see the same info in the form data. But in theory making all fields mandatory would ensure it's updating every time.

- Zach

[Phil_Vallender]

Hi @NContrinoEM 

That sounds like a bug with the Google Sheets connector to me. Since, assuming you are using this, you have a Pro level Hub and support, I recommend screenshotting a form submission and the associated erroneous data in Google Sheets and send this to support to investigate. 

Hope this helps.