# Python and Google Sheets Integration (Zapier free alternative) **URL:** \ **Category:** Ask for Help\ **Created:** [May 22, 2020, 9:30pm UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606 "2020-05-22T21:30:22Z")\ **Posts on this page:** 10\ **Page:** 2
**Author:** ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)\ **Post date:** [May 27, 2020, 4:36pm UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/21 "2020-05-27T16:36:11Z")
Then is there any option to send sms ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 27, 2020, 4:36pm UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/22 "2020-05-27T16:36:14Z")
+1 > [@Gabriel\_Sobral](#): > > Be careful with solutions that offers free WhatsApp notifications API! it’s probably a scam, as it violates WhatsApp guidelines. ---
**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\ **Post date:** [June 11, 2020, 12:20pm UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/23 "2020-06-11T12:20:02Z")
> [@Gabriel\_Sobral](#): > > Willpower (I guarantee you that is worth it.) I’m sooo stuck in setting up the basics,… `Once you’ve installed Homebrew, insert the Homebrew directory at the top of your PATH environment variable. You can do this by adding the following line at the bottom of your ~/.profile file` Where is this file? Does it matter if I use terminal or Visual Studio Code ? ---
**Author:** ![Gliderrr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gliderrr/32/5215_2.png) [@Gliderrr](https://community.glideapps.com/u/Gliderrr)\ **Post date:** [June 11, 2020, 1:21pm UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/24 "2020-06-11T13:21:33Z")
Awesome! This is supercharging Glide 🦾 ---
**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\ **Post date:** [June 11, 2020, 5:12pm UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/25 "2020-06-11T17:12:33Z")
> [@Gabriel\_Sobral](#): > > And then, there’s not much to explain about the code added, it just sends e-mails. > ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/238acbd486d19721fa74cf8988e4807793cd45a7.png) > > So, if you do everything right, you’ll be sending e-mails for free in just a click. When I get to here,… yay I made it,… smptlib is unknown and recipient isn’t defined. Any suggestions how to solve that? ---
**Author:** ![Gabriel\_Sobral](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gabriel_sobral/32/6513_2.png) [@Gabriel\_Sobral](https://community.glideapps.com/u/Gabriel_Sobral)\ **Post date:** [June 11, 2020, 7:05pm UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/26 "2020-06-11T19:05:16Z")
Hey @Naos_Wilbrink! Glad you could install Python using homebrew! About the smtplib, I forgot to import it on my code, as well as define the `recipient` variable. It’s just a matter of replacing `recipient` with `email_login` and importing `smtplib` on the imports section. ---
**Author:** ![alex-borenshtein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex-borenshtein/32/8078_2.png) [@alex-borenshtein](https://community.glideapps.com/u/alex-borenshtein)\ **Post date:** [June 12, 2020, 8:59am UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/27 "2020-06-12T08:59:39Z")
@ [Gabriel\_Sobral](https://community.glideapps.com/u/Gabriel_Sobral) Thanks for the tutorial. Do you know the performance differences between those 2 implementations ? 1. POST to google script webapp (doPost) that will do some search and insert a row to google sheet. 2. Insert a row (and do some search) via google sheet api in python. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 12, 2020, 9:04am UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/28 "2020-06-12T09:04:40Z")
Hi Alex, can you point me to a documentation of the doPost method for scripts? I would love to take some time to read about it. Currently I’m implementing Python to update one of my app’s database every 15 minutes, just want to have alternatives if it’s viable. ---
**Author:** ![alex-borenshtein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex-borenshtein/32/8078_2.png) [@alex-borenshtein](https://community.glideapps.com/u/alex-borenshtein)\ **Post date:** [June 12, 2020, 9:27am UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/29 "2020-06-12T09:27:27Z")
Hi, I think that google documentation is good enough if you already familiar with google app script: [Google Web Apps documentation](https://developers.google.com/apps-script/guides/web) If not ,i think the best channel to learn from is (that’s what i did) : [Google Apps Script Web App Tutorial](https://www.youtube.com/watch?v=RRQvySxaCW0&list=PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l) Anyway, if you have specific question just ask. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 12, 2020, 9:30am UTC](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606/30 "2020-06-12T09:30:02Z")
Thanks, I will have a read through it. I think I’m familiar enough with scripts, I will see if it’s a viable alternative. [Previous page](https://community.glideapps.com/t/python-and-google-sheets-integration-zapier-free-alternative/9606.md?page=1)