1

I have a google sheet that 5 times a day append a new value to the sheet. I need to run a local python script everytime a value is included, how can I do it?

aitor
  • 37
  • 6

1 Answers1

5

Are you familiar with the Google Sheet API yet?

https://developers.google.com/sheets/api/quickstart/python

That should get your started. As for automatizing running the script every time the sheet is overwritten, check the metadata section to give you an idea of how to sync the data. Then, choose your favorite way to run your script periodically in the background of your system.

JustLearning
  • 1,435
  • 1
  • 1
  • 9