Sometimes pivot tables in the HubSpot report builders are not laid out as clearly as they could be. I have also had a client desire to add color and other design elements to a report. It would be awesome to have an integration for piping HubSpot report data into Google Sheets where it could be better visually formatted.
Status: Idea Submitted
Hi @Hollyce 
Maybe you missed it but there is an integration with Google Sheets on the Marketplace that allows you to pipe HubSpot data into sheets using workflows? HubSpot Marketplace
It can also be done through Zapier.
Hope this helps!
|
@Olivia_Bagnall Yes, I looked at this but it is only for piping in information about objects such as contacts, deals, and custom objects. In this case I want the analytics from a marketing email to end up in a Google Sheet. The custom report builder lets be draw these stats into it, but does not combine and display them in a way my client desires.
I could also make use of this. We have a lot of analytical information that the reports in hubspot show on the dasboards. We want to get this informaiton out of hubspot into google sheets so that we can do further analysis on this as well as updating the rest of the company in management meetings.
As we have a lot of staff, doing this manually would become very time consuming, to the point where currently we ask each member of the team to export their own stats and put them into a google form at the end of the day.
Having the calculated values that are used in reports available as a date set that could be sent to google sheets would be a life saver.