I've created a Google Form. When somebody fills it out and submits, I would like to run some Python code using the submission answers. My current system is having a Google Sheet tied to the Google Form, which constantly updates with new answers. Then, I have an infinite loop running in Python on my PC that grabs the sheet contents in a database and checks if they have change. If they have, run code with the new entry. This process requires me to have an infinite loop running constantly on my PC, which isn't great. Anyone got any suggestions? Continue reading...
