# Populate Google Sheets With HubSpot Data **URL:** \ **Category:** CRM\ **Created:** [October 17, 2017, 7:20pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594 "2017-10-17T19:20:27Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![sskurdah](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sskurdah/32/31184_2.png) [@sskurdah](https://community.hubspot.com/u/sskurdah)\ **Post date:** [October 17, 2017, 7:20pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/1 "2017-10-17T19:20:27Z")
Hi All - I’m looking for a way to populate Google Sheets wtih HubSpot data for reporting purposes. Ideally, as data is populated and edited within HubSpot, the Google Sheet would update as well. Is there currently any sort of integration or way to pull this info? Thanks! ---
**Author:** ![Phil\_Vallender](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/phil_vallender/32/48924_2.png) [@Phil\_Vallender](https://community.hubspot.com/u/Phil_Vallender)\ **Post date:** [October 18, 2017, 8:23am UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/2 "2017-10-18T08:23:41Z")
Hi @sskurdah You should be able to do this with Zapier - a zap can lookup and update, or create a row in a google sheet each time a new contact is created in HubSpot. Hope this helps. ---
**Author:** ![sskurdah](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sskurdah/32/31184_2.png) [@sskurdah](https://community.hubspot.com/u/sskurdah)\ **Post date:** [October 19, 2017, 3:55pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/3 "2017-10-19T15:55:44Z")
Hi Phil - Thanks for the response! If a property is updated, will the sheet update as well? Or will it only update when a contact is created? Thanks! ---
**Author:** ![Phil\_Vallender](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/phil_vallender/32/48924_2.png) [@Phil\_Vallender](https://community.hubspot.com/u/Phil_Vallender)\ **Post date:** [October 19, 2017, 5:11pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/4 "2017-10-19T17:11:49Z")
Hi @sskurdah That is possible but is tricky to set up. Zapier doesn’t support a trigger every time a contact is updated but can when a specific property is updated. If this works then you can have one zap when a new contact is created to create the row, and another to update it when the property updates. Not ideal but workable. Hope this helps. ---
**Author:** ![Vinicius](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vinicius/32/51304_2.png) [@Vinicius](https://community.hubspot.com/u/Vinicius)\ **Post date:** [January 24, 2018, 1:02am UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/5 "2018-01-24T01:02:21Z")
Hi, besides the Zapier Integration, is it possible to connect via Google Scripts to extract data direct to Sheets? Thanks! ---
**Author:** ![jkbaseer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jkbaseer/32/81360_2.png) [@jkbaseer](https://community.hubspot.com/u/jkbaseer)\ **Post date:** [August 30, 2018, 4:26pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/6 "2018-08-30T16:26:53Z")
Hello! [https://medium.com/@alexisbedoret/create-a-hubspot-custom-dashboard-with-google-spreadsheet-and-data-studio-27f9c08ade8d](https://medium.com/@alexisbedoret/create-a-hubspot-custom-dashboard-with-google-spreadsheet-and-data-studio-27f9c08ade8d) I have tried this. This does a google app script but it’s not working for me. see whether you could do it. ---
**Author:** ![Vinicius](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vinicius/32/51304_2.png) [@Vinicius](https://community.hubspot.com/u/Vinicius)\ **Post date:** [August 30, 2018, 5:34pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/7 "2018-08-30T17:34:36Z")
Thanks! i’ll try it. cheers ---
**Author:** ![meelad](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/meelad/32/9373_2.png) [@meelad](https://community.hubspot.com/u/meelad)\ **Post date:** [April 6, 2020, 6:10pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/8 "2020-04-06T18:10:20Z")
Hello, [here is a tutorial](https://www.benlcollins.com/apps-script/api-tutorial-for-beginners/) showing you how to use Google Apps Script to query the Hubspot API. I’ve also built an [API integrator for Google Sheets](https://apipheny.io/) that allows you to connect to almost any API, including the Hubspot API. ---
**Author:** ![thomasboyd](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thomasboyd/32/30191_2.png) [@thomasboyd](https://community.hubspot.com/u/thomasboyd)\ **Post date:** [December 10, 2019, 4:45am UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/9 "2019-12-10T04:45:24Z")
[Integration Fox](https://www.integrationfox.com/?utm_source=community.hubspot.com&utm_medium=forums&utm_campaign=Populate-Google-Sheets-With-HubSpot-Data) is a new tool that we use for this. It syncs your contacts, deals and companies into Google Sheets, which then can be linked up to DataStudio or something like that really easily. We sync the data into BigQuery so that we can use views for timezone manipulations and custom calculations, but this may be overkill for your needs. ---
**Author:** ![danielruby](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danielruby/32/97799_2.png) [@danielruby](https://community.hubspot.com/u/danielruby)\ **Post date:** [July 15, 2020, 7:50pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/10 "2020-07-15T19:50:33Z")
I know this is an old-ish thread, but [Demand Sage](https://www.demandsage.com) does that for free. Syncs all Contact, Company and Deal data to a Google Sheet and gives you a library of pre-built reports, a visual table builder and if you want to go fully nuts, the ability to run SQL queries across all your HS data within a Sheet. Data updates nightly, and it is indeed completely free to use (we’ll be adding premium features down the road, but the current incarnation will remain free forever). Daniel Ruby Head of Marketing [ ![28791iFFF34D1DDBF2D8A5.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/7/7565f99679919dc93da9106c67df641b77f53d1b.png) ](https://www.demandsage.com/) Better HubSpot Reporting In Sheets ---
**Author:** ![VincentPace](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vincentpace/32/91953_2.png) [@VincentPace](https://community.hubspot.com/u/VincentPace)\ **Post date:** [May 22, 2021, 5:55am UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/11 "2021-05-22T05:55:38Z")
@danielruby FYI, I’m getting 404s when I try to get set up on your website. ---
**Author:** ![RandOwens](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/randowens/32/38114_2.png) [@RandOwens](https://community.hubspot.com/u/RandOwens)\ **Post date:** [June 17, 2021, 9:03pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/12 "2021-06-17T21:03:25Z")
@VincentPace they closed up shop. Try [https://coefficient.io/](https://coefficient.io/) instead ---
**Author:** ![olga\_rusnak](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/olga_rusnak/32/46087_2.png) [@olga\_rusnak](https://community.hubspot.com/u/olga_rusnak)\ **Post date:** [January 20, 2021, 9:56pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/13 "2021-01-20T21:56:29Z")
hi @sskurdah In fact, it is very easy to do. Just install the add-on, fill out the required parameters and set up schedule for auto-refreshes. This is a detailed guide on how to import [HubSpot data to Google Sheets](https://blog.coupler.io/hubspot-data-to-google-sheets/). Below I attach a screenshot for you to see that’s it is indeed very easy to use. ![36774i97DE04CDCEF9451F.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/c/cc56619928f14bb334ebb6dcfd6d453141b8d833.png) ---
**Author:** ![RandOwens](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/randowens/32/38114_2.png) [@RandOwens](https://community.hubspot.com/u/RandOwens)\ **Post date:** [June 17, 2021, 8:58pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/14 "2021-06-17T20:58:00Z")
Hi sskurdah, You can do this easily with [Coefficient](https://coefficient.io/). They provide a UI to navigate all of your Hubspot objects and properties. You can select/deselect any fields you need so you don’t have to keep building new reports. You can also filter data to only work with the data you need. You can schedule the data to update hourly, daily or weekly, and also manually refresh anytime you need the latest data. Any formulas you build would be preserved as new data comes in. Any charts, graphs, pivot tables, etc will update on the schedule you need, so you can build a report once and use it operationally. Hope this helps! ---
**Author:** ![amitsarda](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amitsarda/32/30250_2.png) [@amitsarda](https://community.hubspot.com/u/amitsarda)\ **Post date:** [February 2, 2023, 1:58pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/15 "2023-02-02T13:58:06Z")
For anybody looking for a solution to this today, please check out [Coupler](https://www.coupler.io?referral_code=amitsarda)’s offering to help you back up your Hubspot data to Google Sheets, Google Drive, Big Query, etc. ---
**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\ **Post date:** [February 6, 2023, 9:02pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/16 "2023-02-06T21:02:02Z")
Hi @amitsarda, hope you are doing well! Thanks for sharing. Best, Diana ---
**Author:** ![bembus](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bembus/32/84959_2.png) [@bembus](https://community.hubspot.com/u/bembus)\ **Post date:** [November 6, 2023, 1:13pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/17 "2023-11-06T13:13:38Z")
You can use [Dokin](http://www.dokin.co) to populate your Google Sheets with live data from HubSpot and other systems like Google Analytics, Airtable, Google Ads, LinkedIn Ads etc. ---
**Author:** ![MGupta78](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@MGupta78](https://community.hubspot.com/u/MGupta78)\ **Post date:** [October 15, 2024, 10:28am UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/18 "2024-10-15T10:28:18Z")
Hey, you can do this with Superjoin ([Connect Hubspot to Google Sheets & Excel in One-Click | Superjoin](https://www.superjoin.ai/integrations/hubspot)). It’s made specifically for reporting on Gsheets. 1. We’ve bypassed the 10k limit on Hubspot APIs. You can pull upto 250k rows. 2. We’ve done all possible associations between objects 3. Preview data before importing to Sheets 4. Create calculated fields for ease of use 5. Workflows to tie Appscript with Imports Do try it out ---
**Author:** ![DSi81](https://avatars.discourse-cdn.com/v4/letter/d/a4c791/32.png) [@DSi81](https://community.hubspot.com/u/DSi81)\ **Post date:** [April 17, 2025, 8:48pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/19 "2025-04-17T20:48:23Z")
[**Byteline Sync**](https://www.byteline.io?utm_source=hubspot&utm_medium=forum&utm_campaign=community_ques) can populate Google Sheets with data from HubSpot. You can sync both existing records and keep the sync live for future updates. The sync runs continuously in the background, automatically updating your Google Sheets as changes occur in HubSpot. **Key Features:** - **Filters** – Define exactly which data should be synced. - **Field-Level Sync Direction** – Customize the sync direction for each field. - **2-Way Sync** – Enable bi-directional sync to keep both HubSpot and Google Sheets in sync. ---
**Author:** ![PNofer](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@PNofer](https://community.hubspot.com/u/PNofer)\ **Post date:** [August 2, 2025, 3:21pm UTC](https://community.hubspot.com/t/populate-google-sheets-with-hubspot-data/3594/20 "2025-08-02T15:21:08Z")
You can also do that using [Skyvia](https://skyvia.com/data-integration/integrate-hubspot-google-sheets). It can help automate the process, ensuring your Google Sheets are updated in near real-time with data from HubSpot.