topic Re: Form Submission capture to data warehouse in Data Hub

Form Submission capture to data warehouse

sanchid — Mon, 05 Feb 2024 05:28:59 GMT

Hi All,

We all know that form submissions data can be captured as fields in Hubspot. However if a different form or the same form is submitted again, these values can be overridden. To track this better, Hubspot allows us to see all data points of the form during the submission activity. Is there a way we can record this back to any of the tables in a data warehouse, so that it helps us analyse this better?

Re: Form Submission capture to data warehouse

karstenkoehler — Mon, 05 Feb 2024 05:30:45 GMT

Hi @sanchid,

Yes, the HubSpot CRM API would be one way to do that: https://developers.hubspot.com/docs/api/crm/understanding-the-crm

Best regards!

Re: Form Submission capture to data warehouse

Celmer93 — Mon, 05 Feb 2024 16:54:36 GMT

Sanchid,

There's a pre-built integration to SQL server that you should evaluate as well as the manual API route that Karsten mentioned.

https://datawarehouse.io/product/hubspot-ms-sql-integration/ This handles both the extraction and storage - and the form submission data tables are included.

Re: Form Submission capture to data warehouse

Jonas_De_Mets — Mon, 05 Feb 2024 19:42:50 GMT

Hi @sanchid,

What data warehouse do you use? I've extracted HubSpot data to Redshift, BigQuery, and Snowflake using Fivetran or a similar tool. These platforms have clear data models that can inspire your setup:https://docs.google.com/presentation/d/17hG7vce4KMDLvHjYKhrmCeGpjaxVu8dLBWfhBeev7NI/edit#slide=id.gec9082f27e_0_0

Hope this helps!

Best regards,
Jonas De Mets
HubSpot Revenue Operations & Co-Founder @ Koalify

Did my answer help? Please "mark as a solution" to help the community.

Re: Form Submission capture to data warehouse

sanchid — Tue, 06 Feb 2024 07:07:31 GMT

So each form can bring in multiple contact/conversion level information like UTM params while submission. However these values can be overriden if a new form is submitted. In order to track the history, I'd like to capture the form level submission data also to my data warehouse in Bigquery.

Re: Form Submission capture to data warehouse

TomM2 — Tue, 06 Feb 2024 11:34:13 GMT

Hey @sanchid just to add to what everyone else posted, you can use the get submissions endpoint here to get the raw data for each submission. This will show you the values submit on the form submission, not the existing values for the CRM record.

Re: Form Submission capture to data warehouse

Jonas_De_Mets — Tue, 06 Feb 2024 12:11:52 GMT

@sanchid correct! You should be able to retrieve this data in a table that contains all form submissions.

Hope this helps!

Best regards,
Jonas De Mets
HubSpot Revenue Operations & Co-Founder @ Koalify

Did my answer help? Please "mark as a solution" to help the community

Re: Form Submission capture to data warehouse

sanchid — Thu, 08 Feb 2024 05:13:28 GMT

But from the screenshot or your deck, I'm not able to see which table actually captures the field information during the form submission. I guess not even a JSON field is available to capture all form level data.

Re: Form Submission capture to data warehouse

sanchid — Thu, 08 Feb 2024 05:14:12 GMT

Thanks Tom, let me try this once.

Re: Form Submission capture to data warehouse

Jonas_De_Mets — Thu, 08 Feb 2024 20:44:25 GMT

@sanchid you are right, the table does not contain the details of the form submission. I double checked in our BigQuery database (see printscreen below). Pretty sure we could do this in the past with Fivetran though. I believe it might be related to the switch to the new HubsSpot API.

You would need the legacy API endpoint to capture the details of form submissions as @TomM2 refered to: https://legacydocs.hubspot.com/docs/methods/forms/get-submissions-for-a-form

If you prefer to use an ETL solution, Airbyte should be able to capture this data according to their documentation for HubSpot.

Hope this helps!

Best regards,
Jonas De Mets
HubSpot Revenue Operations & Co-Founder @ Koalify

Did my answer help? Please "mark as a solution" to help the community.

Re: Form Submission capture to data warehouse

johnelmer — Thu, 07 Nov 2024 16:11:03 GMT

@sanchid @Jonas_De_Mets @TomM2 You might consider using an app in the HubSpot App Marketplace called Database Sync for HubSpot. This app syncs forms data (and over 100 other data tables) from HubSpot to Azure, Bigquery, MySQL, PostgreSQL, Redshift, and SQL cloud databases. The cost is only $49 a month for daily sync refreshes, and faster rates are available.

Re: Form Submission capture to data warehouse

RubenBurdin — Wed, 22 Oct 2025 20:06:29 GMT

Hi @sanchid ,

Good question, form submission data in HubSpot can be tricky since each new submission overwrites property values on the contact record. The only permanent record is the form submission object, accessible through the “Get form submissions” endpoint (https://developers.hubspot.com/docs/api-reference/marketing-forms-v3/guide ) This includes every submission event, even when properties are overwritten.

If your goal is to store these events historically in BigQuery, the cleanest approach is to set up an ETL or sync layer that captures these raw submission payloads and writes them to your warehouse.

Airbyte and Fivetran both support HubSpot form endpoints, but for deeper control, you can poll the endpoint periodically and push JSON payloads into your BigQuery form_submissions table, preserving timestamps and field-level metadata. You can then join those with contact or deal tables for full attribution analysis.

If you ever need those events to flow bidirectionally say, enriching HubSpot with warehouse-calculated metrics like LTV or campaign performance a managed two-way sync avoids the API pagination, schema drift, and token rotation issues described in Stacksync’s architecture guide. If consistency between HubSpot and your data warehouse is the gap, Stacksync keeps them mirrored in real time without the need for manual ETL scripts.