How it works
Automating Google Calendar and Google Sheets takes no code: a ready-made scenario does the routine for you.
- Starts when: Schedule Trigger
- Then: Get many workflows
- Then: Code: parsing
- Then: Code: save current values
- Then: Sheets:Lookup-ExistOnCalendar
- Then: Code manual merge
- Then: Code: detect changes
- Check: Switch
- If yes: Remove Duplicates
- Then: Code: RRULE
- Then: Create an event
- Then: Code: post-create
- Then: Sheets:OnCalendar=YES
- If no: Code: split eventIds for delete
- Then: Delete old event
- Then: Delete an event
- Then: Get many events2
- Starts when: Webhook
You can launch this Google Calendar + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.