How can I transfer information from HubSpot to Google Sheets for reporting?

Question

Hello,I have some small problems to set up a ZAP, I am open to all ideas.

I would like to feed a report on Google sheet, so only numbers...From Hubspot, and every week get me the numbers (for example : new incoming contacts, those who have gone through some phases of the pipeline…)

I started my zap with a "Schedule by Zapier" running "every week" Then I log in to Hubspot, then I use "Get Deal in Hubspot", I then block in the configuration to turn them into numbers... and select the correct phase of the pipeline.

Thanks !

icon

Best answer by christina.d 27 July 2022, 01:25

View original

christina.d · Accepted Answer

Hey there,@Brunoleclerc! Thanks for clarifying that. This should be doable as Danvers mentioned!A rough outline might be:Set up a Zap for each number that you want to add to the report.Zap that triggers from New DealsZap that triggers when a deal enters stage xZap that triggers when a deal enters stage y, etc.For each step use the Increment Value action forStorage by Zapier, you can set this up so that each time the Zap is triggered, it increases the number at a particular storage key by 1 (ie.each time the Zap runs because a new deal is added, the number increases).Set up aZap that triggers once a week and fetches all of the values from Storage and adds them to your Google Sheet. If you want to reset the counters (so you always start at 0) you can add an action to remove the value/s from storage.Let us know if this helps!

Danvers · Answer

Hi @Brunoleclerc!Can I check I’ve understood what you’d like here? You want to create a report in Google Sheets that tells you how many new contacts, contacts at different stages there are, is that right? Are you thinking something like a sheet with columns for the different values and the rows would be the week, so each week a new row is added with the informationfrom the previous week? Is that right? First of all, have you checked that Hubspot doesn’t have a dashboard that you can use? Or is there a specific reason that you need it in Google Sheets?I can think of a way to tell you how many deals moveintoa stage each week, but that wouldn’t tell you how many deals were in a stage, because it doesn’t account for deals that might level other stages. Would that work for you? Let me know and I can describe how you would do that :) If not, do any other users have an idea of how to use Zapier to get a list of all deals in all stages and turn that into a number that can be added to a sheet?

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded