# Sync Google Calendar events to Google Sheets on schedule
This automation template eliminates manual data transfer between Google Calendar and Google Sheets. It runs every minute, checks for new or updated calendar events, and synchronizes them into a spreadsheet—updating existing rows or appending new ones. Ideal for professionals who rely on structured spreadsheets to track meetings, tasks, or client calls.
## Who it´s for
- Managers tracking meetings in Google Sheets
- Administrators syncing calendars with task databases
- Freelancers logging time based on calendar entries
## What the automation does
- Triggered by a cron schedule (every minute)
- Fetches events from Google Calendar within a defined time window
- Checks if an event already exists in Google Sheets using a unique ID
- Updates the corresponding row if found
- Appends a new row if the event is not present
- Prevents duplicate entries while ensuring real-time sync
## What´s included
- Ready-to-use n8n workflow
- Predefined trigger and handler logic
- Integrations with Google Calendar API and Google Sheets API
- Basic setup and adaptation guide
## Requirements for setup
- Google account with access to Google Calendar
- Google account with access to Google Sheets
- OAuth2 credentials for connecting services in n8n
- Running n8n instance (cloud or self-hosted)
## Benefits and outcomes
- Eliminates manual entry errors
- Saves time on maintaining parallel records
- Ensures real-time data consistency
- Simplifies reporting based on calendar activity
- Maintains a single source of truth for planning and analytics
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet