# Create an integration for report data to pipe into Google Sheets

**URL:** <https://community.hubspot.com/t/create-an-integration-for-report-data-to-pipe-into-google-sheets/91886>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [October 16, 2023, 2:02pm UTC](https://community.hubspot.com/t/create-an-integration-for-report-data-to-pipe-into-google-sheets/91886 "2023-10-16T14:02:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hollyce](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hollyce/32/2764_2.png) [@Hollyce](https://community.hubspot.com/u/Hollyce)\
**Post date:** [October 16, 2023, 2:02pm UTC](https://community.hubspot.com/t/create-an-integration-for-report-data-to-pipe-into-google-sheets/91886/1 "2023-10-16T14:02:35Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Olivia\_Hatchi](https://avatars.discourse-cdn.com/v4/letter/o/74df32/32.png) [@Olivia\_Hatchi](https://community.hubspot.com/u/Olivia_Hatchi)\
**Post date:** [October 16, 2023, 5:33pm UTC](https://community.hubspot.com/t/create-an-integration-for-report-data-to-pipe-into-google-sheets/91886/2 "2023-10-16T17:33:19Z")

</div>

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](https://app-eu1.hubspot.com/ecosystem/26514287/marketplace/apps/marketing/data-management/google-sheets-228553)  
It can also be done through Zapier.  
Hope this helps!

| 

| 

| ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/9/09c1b07c1d834843ebffbadc49a62806c0cf71a8.jpeg) |
| |
| ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/6/46ceae2ded1389fcc677b417ab3fdccb0664a224.jpeg) |

 | | 
## Olivia Bagnall
Inbound Consultant | HubSpot Specialist | Community Champion

| |
| |
| |

| 

| ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/9/992ff01c4147f751a8a53f26652ceccd4d6469c6.png) |

 | [o.bagnall@baskey.eu](mailto:o.bagnall@baskey.eu) |
| 

| ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/2/520394ca2408f265ba1533bc5831a595c1d8670a.png) |

 | [www.baskey.eu](https://www.baskey.eu) |
| 

| ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/1/81c048d4ef50404ed012be779b4b68bf394d607e.png) |

 | Rheingasse 14, 50676 Köln |

| |

[Message me on LinkedIn](https://www.linkedin.com/in/olivia-bagnall-314ab98b/)

| |

[Create Your Own Free Signature](https://www.hubspot.com/email-signature-generator?utm_source=create-signature)

 |

 |

---

<div class="post-metadata">

**Author:** ![Hollyce](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hollyce/32/2764_2.png) [@Hollyce](https://community.hubspot.com/u/Hollyce)\
**Post date:** [October 16, 2023, 5:37pm UTC](https://community.hubspot.com/t/create-an-integration-for-report-data-to-pipe-into-google-sheets/91886/3 "2023-10-16T17:37:10Z")

</div>

[@Olivia\_Bagnall](https://community.hubspot.com/t5/user/viewprofilepage/user-id/359008) 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.

---

<div class="post-metadata">

**Author:** ![AHewitt90](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@AHewitt90](https://community.hubspot.com/u/AHewitt90)\
**Post date:** [January 28, 2025, 7:43am UTC](https://community.hubspot.com/t/create-an-integration-for-report-data-to-pipe-into-google-sheets/91886/4 "2025-01-28T07:43:41Z")

</div>

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.
