Extract Form Submissions Automatically to Excel

Developer Support APIs & Integrations
1

Hello everyone,

I have multiple forms on Hubspot and I am trying to get the number of form submissions each month and automatically store this into an excel file. Where my data updates at the end of each month. Basically, I need an API to extract the data. Could somebody please help me with this?

2

Hi @bcbotxo

Great question!
I believe the Get analytics data for specific objects endpoint may be of use here, see here:

This endpoint allows you to request specific data in relation to an object. For form data, you can use the following request:

https://api.hubapi.com/analytics/v2/reports/forms/total?hapikey=xxxx&start=20180101&end=20190531

You’ll want to ensure you’re customising the time constraints set by the use of &start=xx and &end=xx.

Once this call is made, you’ll receive a response along the lines of the following:

{
 "offset": 5,
 "total": 5,
 "totals": {
 "submissions": 21,
 "formViews": 56,
 "installs": 8,
 "visibles": 38,
 "interactions": 6,
 "submissionsPerFormView": 0.375
 } //Further breakdowns will be provided but have been removed from this snippet.

You can then extract and use the above data as you’d like.

Thanks,

Matt

3

Hey Matt,

Thank you for your reply. I am trying to do this in python, however I am not that familiar. Could you please guide me on how I would do this.

Cheers,

Sam

4

Hi Sam (@bcbotxo),

Unfortuntely I would not be the best resource to do a full walkthrough here, but I am more than happy to look into specific questions and any roadblocks you encounter.

Thanks,

Matt