Export contact form Submission data

[Ry2]

I created a form which will create a contact record but on the form we have more fields. Those details are saved in the contact record form submission section which will show in activity. I am trying to export that data to google sheet but i didn't get any data. My question is how can I export that form submission data into google sheet? Regards, Sandeep

[Aakar · Accepted solution]

Hi @Ry2 

Here's a thread about it. Maybe you can use Zapier for this as well.

Thanks.

[karstenkoehler]

Hi @Ry2,

You can follow these steps to export form submissions: Navigate to Marketing > Lead Capture > Forms, hover over the form, then click Actions > Export submissions.

Once you've exported the csv or xlsx file, you can copy and paste the content into a Google Sheet.

Let me know if you get stuck at any point, happy to help. Cheers!

[LorraineMarsh]

Hi,
Thanks Karsten,

Just for public record, you need a Microsoft licence (I don't) if you want to copy and paste the date into the Google Sheet.

[Ry2]

Thank you for your response.
Can't we create a workflow to export the data directly to google sheet.

[Growth_Natives]

Hi @Ry2,

Yes, we can create a workflow to export form submission data directly in a Google Sheet. This is something that my HubSpot team asked to follow the steps mentioned below;


Step1.  HubSpot <> Google Sheet Integration:

• In your HubSpot account, navigate to Settings. → Integrations → Connected Apps → Click on “Visit App Marketplace” (Search for Google Sheet and install it .)

Step2. Create a Workflow (Let’s say for a particular form submission) :

• In a trigger select the form whose data you want to import in the google sheet.
• After setting the trigger criteria, you will click the + plus icon to add an action.
• In the actions panel, select Create Google Sheet row.

• In the Spreadsheet dropdown menu, select the spreadsheet you want to add data to.
• In the Sheet dropdown menu, select which sheet you want to add data to. The Sheet field refers to the tabs at the bottom of your spreadsheet.
• In the Header and Property dropdown menus, select which columns you'll be adding data to and which properties you'll send data from. You can add up to 10 per action. 

• Click Save.

I hope this answer is helpful.

Cheers!

Taran

[karstenkoehler · Accepted solution]

Hi @Ry2,

Yes, you can use HubSpot's Zapier integration to send contacts from HubSpot to a Google Sheet. There is a trigger for "New Form Submission" in HubSpot: https://zapier.com/apps/hubspot/integrations

Best regards!

[Aakar · Accepted solution]

Hi @Ry2 

Here's a thread about it. Maybe you can use Zapier for this as well.

Thanks.