Is there a way I can automatically export reports into google sheets?

We have Sales Enterprise and I am looking for a way to export on a bi-weekly basis a report to goole sheets. Is there a workflow or a third party tool I can use to do these exports?

Best,

Efi

Hey, @Efigiann :waving_hand: Welcome to the community! I didn’t see a native option for this in the documentation aside from a manual export of unstructured data. Which is not the automated solution you are after. I know @h-recker works with a company that offers a sync solution for HubSpot and google Sheets. And we’ll definitely leave this open for other community members to offer their suggestions, apps, or workarounds. — Jaycee

Hi @Efigiann - this is exactly what Coefficient offers. Coefficient is a certified app on the HubSpot marketplace that offers a 2-way sync between HubSpot and Google Sheets or Excel. We have both a free trial and a Free plan.
HubSpot’s API doesn’t currently allow you to export reports as they are. But, you could pull the data you need with Coefficient to support the report and keep the data on a refresh schedule. You can then build the visualizations for your dashboard in Google Sheets or leverage Coefficient’s Sheets Assistant to build them for you.
You could refresh the data hourly, daily, or weekly to keep it refreshed as often as you need! The solution is no-code so very simple to use.
If you have any question at all, I’d be super happy to help.

Thank you @h-recker :raising_hands: — Jaycee