The CalendarApp service in Apps Script gives you full control over Google Calendar — creating events, inviting attendees, setting reminders, reading upcoming meetings, and syncing your spreadsheet data to a calendar automatically.

In this series, we follow the Acme Corp sales team. They schedule follow-up calls when deals move to In Progress, send calendar invites to customers when contracts are signed, and automate recurring team standups — all driven from their Sales Tracker spreadsheet.

All examples use a Sales Tracker Google Sheet with the following columns:

• Create Calendar Events
• Read and List Calendar Events
• Update and Delete Calendar Events
• Invite Attendees to Events
• Create Recurring Events
• Sync Sheet Data to Calendar