# Data from Hubspot dashboard into a google spreadsheet **URL:** \ **Category:** Dashboards & Reporting\ **Created:** [November 14, 2019, 10:12am UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201 "2019-11-14T10:12:38Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Angelamr](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/angelamr/32/98612_2.png) [@Angelamr](https://community.hubspot.com/u/Angelamr)\ **Post date:** [November 14, 2019, 10:12am UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201/1 "2019-11-14T10:12:38Z")
Hi there, I need to export the monthly forecast amount from a report, into a google spreadsheet. I’ve tried with Zapier but it’s not possible. Do you know any way or tool to do it? Thank you in advance, Regards, Angela ---
**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\ **Post date:** [November 14, 2019, 11:04am UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201/2 "2019-11-14T11:04:31Z")
You’ll want to export each report to .xls or .xlsx separately, and doing so will yield mixed results depending on the specific report. Those exported workbooks typically include multiple sheets! (important) - see [Export your content and data](https://knowledge.hubspot.com/account/export-your-content-and-data#custom-reports) ( **Custom Reports section** ) - see image ![hubspot-dashboard-action-export.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/a/ea913b8baac9914c835d6f885d3f6c2bd43fcff5.png) Export HubSpot Reports ---
**Author:** ![Angelamr](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/angelamr/32/98612_2.png) [@Angelamr](https://community.hubspot.com/u/Angelamr)\ **Post date:** [November 14, 2019, 12:13pm UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201/3 "2019-11-14T12:13:22Z")
I would like to export the data automatically: E. g. If the forecast for May 2020 is 30K I would like to export that number automatically to a google excel sheet, and in case the number changes, which probably will happen, have it also automated on the google sheet. It would be possible? Thanks ---
**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\ **Post date:** [November 14, 2019, 12:18pm UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201/4 "2019-11-14T12:18:24Z")
Dunno of a way to make that happen automatically. Check back here. Maybe others have ideas. cc: @Josh, [@jennysowyrda](https://community.hubspot.com/t5/user/viewprofilepage/user-id/3685) ---
**Author:** ![Josh](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/josh/32/17115_2.png) [@Josh](https://community.hubspot.com/u/Josh)\ **Post date:** [November 14, 2019, 1:14pm UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201/5 "2019-11-14T13:14:58Z")
Hi @Angelamr, I would suggest trying [Automate.io](http://Automate.io). You can pull data from deals automatically into a Google Sheet. I have been testing this for a client and it is working well. You can pull any property that’s stored in the deal to the spreadsheet including probability and forecast. I hope that helps. Thanks for the ping @MFrankJohnson! Josh ---
**Author:** ![Angelamr](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/angelamr/32/98612_2.png) [@Angelamr](https://community.hubspot.com/u/Angelamr)\ **Post date:** [November 14, 2019, 2:17pm UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201/6 "2019-11-14T14:17:10Z")
Hi Josh, Thanks for your reply, in my case forecast, is not a property, as it is a number that is continuously changing. How can I create a property for the forecast amount? Thanks ---
**Author:** ![Josh](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/josh/32/17115_2.png) [@Josh](https://community.hubspot.com/u/Josh)\ **Post date:** [November 14, 2019, 2:25pm UTC](https://community.hubspot.com/t/data-from-hubspot-dashboard-into-a-google-spreadsheet/17201/7 "2019-11-14T14:25:32Z")
Hi @Angelamr, There will be an option to pull projected deal amount, which is based on the deal stage probability and the deal value. Alternatively, if you are tracking probability separately, you can import into the spreadsheet using a formula such as =(DEAL AMOUNT\*CUSTOM DEAL PROBABILITY). When the spreadsheet populates, the formula will function as a formula. If you need assistance, I’d be happy to do a screen share with you. Josh