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
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 pinfo. All rights reserved.