# Google My Business to Sheets Integration

**URL:** <https://community.glideapps.com/t/google-my-business-to-sheets-integration/1689>\
**Category:** Ask for Help\
**Created:** [November 5, 2019, 12:41pm UTC](https://community.glideapps.com/t/google-my-business-to-sheets-integration/1689 "2019-11-05T12:41:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hansel\_Pahmer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hansel_pahmer/32/1320_2.png) [@Hansel\_Pahmer](https://community.glideapps.com/u/Hansel_Pahmer)\
**Post date:** [November 5, 2019, 12:41pm UTC](https://community.glideapps.com/t/google-my-business-to-sheets-integration/1689/1 "2019-11-05T12:41:42Z")

</div>

Does anybody know how to pull data from Google My Business or Foursquare to a Google Sheet? That way the input data in the app will remain up to date. Cheers!

---

<div class="post-metadata">

**Author:** ![Xann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xann/32/39474_2.png) [@Xann](https://community.glideapps.com/u/Xann)\
**Post date:** [November 5, 2019, 4:06pm UTC](https://community.glideapps.com/t/google-my-business-to-sheets-integration/1689/2 "2019-11-05T16:06:59Z")

</div>

You could probably find a Zapier! If you didn’t know, [Zapier](http://zapier.com/) automates tasks for you, and I think it works for free! When I searched Zapier for automation between Google My Business & Sheets, it came up with two results: [1](https://zapier.com/app/editor/template/52846?selected_apis=GoogleMyBusinessCLIAPI%401.0.0%2CGoogleSheetsV2API&referrer=member-home-recommended-zaps-zt) & [2](https://zapier.com/app/editor/template/55711?selected_apis=GoogleMyBusinessCLIAPI%401.0.0%2CGoogleSheetsV2API&referrer=member-home-recommended-zaps-zt).  
Sorry if these don’t work out for you because they both take only reviews from Google My Business( Maybe you could make your own Zapier).  
Also, I searched and it does not have any automations between Foursquare and google sheets.

---

<div class="post-metadata">

**Author:** ![Hansel\_Pahmer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hansel_pahmer/32/1320_2.png) [@Hansel\_Pahmer](https://community.glideapps.com/u/Hansel_Pahmer)\
**Post date:** [November 5, 2019, 5:40pm UTC](https://community.glideapps.com/t/google-my-business-to-sheets-integration/1689/3 "2019-11-05T17:40:59Z")

</div>

Hey thanks so much for getting back. Yea I looked into Zappier and several other integration platforms but they only do it with your own business account, while I want to do this for all business visible in Google My Business.

I also tried screen scraping by importing with XML but didn’t manage to make it work.

Thanks though.

---

<div class="post-metadata">

**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\
**Post date:** [November 5, 2019, 9:10pm UTC](https://community.glideapps.com/t/google-my-business-to-sheets-integration/1689/4 "2019-11-05T21:10:04Z")

</div>

Check out Integromat before you give up.

---

<div class="post-metadata">

**Author:** ![Xann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xann/32/39474_2.png) [@Xann](https://community.glideapps.com/u/Xann)\
**Post date:** [November 5, 2019, 11:40pm UTC](https://community.glideapps.com/t/google-my-business-to-sheets-integration/1689/5 "2019-11-05T23:40:03Z")

</div>

You are welcome! 😃