CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-calendar-api
Dan
Dan

Reputation: 5313

How do I automatically update a Google spreadsheet when a Google calendar is changed?

I have a script on a Google spreadsheet that reads a Google calendar and populates its cells.

How can I make it so that the spreadsheet is automatically updated when I make a change on the calendar instead of me manually having to open the spreadsheet and run the script?

Upvotes: 0

Views: 169

Answers (1)

Serge insas
Serge insas

Reputation: 46794

You can't, there is no event that Google Apps Script can catch when something is changed in a calendar.

What I do is setting a timer trigger that checks data in sheet against calendar and do something when a change is detected.

I do so every 30' and check only on a few coming weeks because it is sufficient for my use case but if you need an extended time period to be checked very often then beware the quota limits !(max processing time = 1h/day)

Upvotes: 1

Related Questions