# Export contact form Submission data **URL:** \ **Category:** CRM\ **Tags:** free\ **Created:** [July 3, 2021, 12:51pm UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240 "2021-07-03T12:51:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Ry2](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ry2/32/75413_2.png) [@Ry2](https://community.hubspot.com/u/Ry2)\ **Post date:** [July 3, 2021, 12:51pm UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240/1 "2021-07-03T12:51:21Z")
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 ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 3, 2021, 1:17pm UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240/2 "2021-07-03T13:17:33Z")
Hi @Ry2, You can follow these steps to [export form submissions](https://knowledge.hubspot.com/forms/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! ---
**Author:** ![Ry2](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ry2/32/75413_2.png) [@Ry2](https://community.hubspot.com/u/Ry2)\ **Post date:** [July 4, 2021, 5:54am UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240/3 "2021-07-04T05:54:43Z")
Thank you for your response. Can’t we create a workflow to export the data directly to google sheet. ---
**Author:** ![Aakar](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/aakar/32/107785_2.png) [@Aakar](https://community.hubspot.com/u/Aakar)\ **Post date:** [July 5, 2021, 4:04am UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240/4 "2021-07-05T04:04:37Z")
Hi @Ry2 Here’s a [thread](https://community.hubspot.com/t5/CRM/Populate-Google-Sheets-With-HubSpot-Data/td-p/34082) about it. Maybe you can use Zapier for this as well. Thanks. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 5, 2021, 4:13am UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240/5 "2021-07-05T04:13:54Z")
Hi @Ry2, Yes, you can use [HubSpot’s Zapier integration](https://knowledge.hubspot.com/integrations/how-to-use-zapier-and-hubspot) 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](https://zapier.com/apps/hubspot/integrations) Best regards! ---
**Author:** ![Growth\_Natives](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/growth_natives/32/102945_2.png) [@Growth\_Natives](https://community.hubspot.com/u/Growth_Natives)\ **Post date:** [July 7, 2021, 12:33pm UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240/6 "2021-07-07T12:33:11Z")
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](https://d2qpr2jzcazej7.cloudfront.net/original/2X/4/49b31484638c85bc3761f2a1fee3c920ab1ae249.png) 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](https://d2qpr2jzcazej7.cloudfront.net/original/2X/0/0e61d15cfe26530f40d01d0818a7a0c6d4d8a37f.png) - 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](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/e/ceefe6c12f7d034e9804274764afb04dd3e4da38.png) - Click **Save**. I hope this answer is helpful. Cheers! Taran ---
**Author:** ![LorraineMarsh](https://avatars.discourse-cdn.com/v4/letter/l/57b2e6/32.png) [@LorraineMarsh](https://community.hubspot.com/u/LorraineMarsh)\ **Post date:** [December 21, 2021, 12:39pm UTC](https://community.hubspot.com/t/export-contact-form-submission-data/40240/7 "2021-12-21T12:39:19Z")
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.