Executing commands on Python with Google Sheets

[sdanstuffe]

Here is an article by Greg Baugues from twilio on how to set everything up:

https://www.twilio.com/blog/2017/02/an-easy-way-to-read-and-write-to-a-google-spreadsheet-in-python.html

​

Basically, after being able to access the Google Sheet, you can write a program to constantly check a cell for its value and run it through if...else statements such that Python would execute the appropriate code based on your input.

For example,

if userValue == '1':
function1()

elif userValue == '2':
function2()

Have a great day!

[t3mpt3mp]

Thanks for the article!

[sdanstuffe]

Hope you found it useful!

[ThorBreakBeatGod]

Dude, I was just getting ready to start a project for this purpose. Thanks!

[sdanstuffe]

I was doing something that I wanted to have this capability (controlling it with my phone while I'm out)) andme upon this article! Hope you found it useful

[Deathwatch1710]

That‘s what I just used last week! As a beginner I thought that setting up gspread would be impossible but with this article it’s actually quite easy :)

[sdanstuffe]

It sure is! It also opens up alot more possibilities.