HubSpot Social Analytics to Google Sheets

[KLitzenberger]

If you go into Marketing > Social >  Analyze you have a bunch of valuable data. Is there a way to connect this data to Google Sheets? I tried creating a workflow to do this but I wasn't able to find the correct trigger to do this. Is this possible? If so How?

[AHeni]

Hi i think you can do it using the hubspot api, or the better suggestion will be to connect your hubspot to Google analytics and then to a third party platform, where you'd be able to get all your data there and in real time.
We use this one  https://ecosystem.hubspot.com/marketplace/apps/marketing/analytics-data/windsor-ai-all-marketing-dat... as a marketing attribution software, and we visualize our data in Google data studio

[kvlschaefer]

Thanks for sharing, @AHeni! 

[karstenkoehler · Accepted solution]

Hi @KLitzenberger,

It's not possible to export this data, unfortunately. Some of these reports can be saved but even when saved, the usual option to export report data is not available.

The only thing that can be exported are social posts data: https://knowledge.hubspot.com/social/export-social-post-data

Best regards!