topic Simple Report Export to Google Sheets? in 💬 RevOps Discussions

Simple Report Export to Google Sheets?

DHarris_Keevo — Thu, 18 Mar 2021 16:05:42 GMT

I am trying to simply export the data from a report created to manage ticket resolution into google sheets. I've looked into Zapier as a middle-ware, but not sure where else to turn?

In detail, I want to export the data hourly or daily into a google sheets doc so that I can slice and dice the data in other ways.

Anyone know of how this can be done?

Re: Simple Report Export to Google Sheets?

danmoyle — Thu, 18 Mar 2021 16:23:45 GMT

Hey there @DHarris_Keevo. From what I have experienced, there are several solutions (you can read more in this thread) like setting up Zapier as you mentioned. Here's another article with more solutions. It looks like you have a few options at your disposal. Hope the resources help!

Dan / Impulse Creative

Re: Simple Report Export to Google Sheets?

JenBergren — Fri, 19 Mar 2021 18:00:52 GMT

Hello! I saw there is a new HubSpot/Sheets feature this month, which used to only be possible with Zapier: https://knowledge.hubspot.com/workflows/add-data-to-google-sheets-with-workflows

I'm not sure if this solves for your exact ticket report, but I hope it is helpful!

Jen Bergren

Sr. Operations Manager

Remotish -- A HubSpot RevOps Agency

Re: Simple Report Export to Google Sheets?

saps — Tue, 15 Jun 2021 06:43:10 GMT

Hi @DHarris_Keevo , sorry this is a late response. In case you haven't solved the problem already, check out Airboxr on the Hubspot Marketplace: https://app.hubspot.com/ecosystem/9210258/marketplace/apps/marketing/analytics-data/airboxr. It likely won't solve the first part of your problem (i.e., export a report created on Hubspot) but it will help you create reports on your Google Sheets and run them whenever you want.

Disclaimer: I'm one of the founders of the product. You can learn more about it here: https://www.airboxr.com/hubspot-integration.

Happy to answer any questions! 🙂

Re: Simple Report Export to Google Sheets?

BBush1 — Fri, 17 Sep 2021 15:16:40 GMT

YES!!! Absolutely trying to solve for this right now.... will look at solutions below.

Re: Simple Report Export to Google Sheets?

JiquanNgiam — Fri, 23 Aug 2024 03:24:00 GMT

Lutra AI should be able to build a workflow that goes either way -- HubSpot from/to Google Sheets, which runs on a regular basis for you.