topic Re: Extract Form Submissions Automatically to Excel in APIs & Integrations

Extract Form Submissions Automatically to Excel

bcbotxo — Wed, 29 May 2019 11:33:34 GMT

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?

Re: Extract Form Submissions Automatically to Excel

Willson — Wed, 29 May 2019 13:42:43 GMT

Hi @bcbotxo

Great question!

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

https://developers.hubspot.com/docs/methods/analytics/get-analytics-data-by-object

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

Re: Extract Form Submissions Automatically to Excel

bcbotxo — Thu, 30 May 2019 07:09:04 GMT

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

Re: Extract Form Submissions Automatically to Excel

Willson — Thu, 30 May 2019 12:22:47 GMT

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