Python Google Spreadsheet Updates

Asked 2 years ago, Updated 2 years ago, 78 views

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


© 2024 OneMinuteCode. All rights reserved.