Python Google Spreadsheet Updates

Hello, I understand that the results of the response from the Google questionnaire are saved in the Google spreadsheet. I know the gspread that extracts the stored values.

If you answer the questionnaire and google spreadsheet, If new data is added I want to run a function on Python Is there any way?

gspread python

2022-09-20 11:27

1 Answers

After periodically reading the sheet value in gspread, if it is different from the previous value, I think you can run the function. Monitoring the change in the value in the live state seems to be too resource-intensive or impossible. Even if Google API has such a feature, it is impossible to run Python in a spreadsheet

2022-09-20 11:27

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656