Python Google Spreadsheet Updates

Asked 1 weeks ago, Updated 1 weeks ago, 1 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

© 2022 pinfo. All rights reserved.