Export contact form Submission data

Smart CRM & Sales Hub CRM
1

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

2

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!

3

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

4

Hi @Ry2

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

Thanks.

5

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: HubSpot Integrations | Connect Your Apps with Zapier

Best regards!

6

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 .)

Growth_Natives_6-1625660905195.png
Growth_Natives_6-1625660905195.png1111×330 25.5 KB

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.

Growth_Natives_7-1625660905199.png
Growth_Natives_7-1625660905199.png881×546 40.3 KB

  • 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.

Growth_Natives_8-1625660905203.png
Growth_Natives_8-1625660905203.png910×612 41 KB

  • Click Save.

I hope this answer is helpful.
Cheers!

Taran

7

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.