Skip to content
ClickRuntime

Connect Google Calendar to Google Sheets

A sheet is a simple way to plan and record time, and the calendar is where that time actually gets blocked. Create events in bulk from a sheet, and log meetings, bookings and hours from your calendar into rows for timesheets and reports.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Calendar and Google Sheets

Sheet-to-calendar scheduling and calendar-to-sheet logging for bookings, timesheets and plans. These are ready-made starting points. Anything else you can describe works too.
WeeklyAI

Turn your week's calendar into a timesheet by client

Every Friday your calendar events are sorted by client or project and written to your timesheet sheet with the hours for each.

See how it works
Every 15 minutes

Invite new sheet registrants to your calendar event

Each new email in your registrations sheet is added as a guest to your event and gets a calendar invite.

See how it works
Every hour

Put unpaid bills from a sheet into your calendar on their due dates

Every unpaid bill in your sheet shows up in your calendar on its due date with a reminder, and the event updates if the amount changes.

See how it works
The moment it happens

Set up new clients in Sheets and book their kickoff call

When a new client form comes in, they are added to your clients sheet with an onboarding checklist, and a kickoff call is booked next week.

See how it works
Every 2 weeksAI

Schedule backlog refinement meetings from your sheet

Before each sprint, the top backlog items are picked from your sheet and refinement meetings are put in the team's calendars.

See how it works
Every 15 minutes

Keep a Google Sheet of every work calendar event

Your sheet always lists every event on your work calendar with its title, time, guests and status, and updates when events change.

See how it works
Every 30 minutesAI

Update your leads sheet and get a follow-up draft after each client meeting

When a client meeting ends, the lead's row in your sheet is marked as met and you get an email with a suggested follow-up.

See how it works
The moment it happens

Book appointment requests into your calendar and a sheet

Booking requests are checked against your calendar, booked when you are free and logged in your appointments sheet.

See how it works
Every 10 minutes

Fill cancelled appointments from your waitlist sheet

When an appointment is cancelled, you get an email naming the next person on your waitlist to offer the slot to.

See how it works
Daily

Put birthdays, anniversaries and probation dates on the calendar

Birthdays, work anniversaries and probation end dates from your employee sheet appear as calendar events ahead of time.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Calendar and Google Sheets, plus any other app. Describe it and your assistant builds it.

See how to build your own

More ideas

Every 15 minutes

Create calendar events from rows in a sheet

Every row you add to your Events sheet becomes a Google Calendar event, and the event ID is written back so it is never created twice.

See how it works
DailyAI

Schedule study sessions around your calendar until the exam

Your syllabus topics are turned into study sessions placed in your free time, all finished before the exam date.

See how it works
Every 30 minutes

Log interviews from your calendar to a hiring sheet with reminders

Every calendar event titled Interview is logged in your hiring sheet, and you get an email reminder the day before each one.

See how it works
Daily

Get warned about likely no-shows for tomorrow

Each morning you get a list of tomorrow's appointments with clients who have missed before, so you can confirm them.

See how it works

Build your own

Build any Google Calendar and Google Sheets automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Calendar and Google Sheets in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Every night, add yesterday's Google Calendar events that have a client name in brackets to my Hours sheet, rounding each to the nearest 15 minutes.

Check my Shifts sheet every 30 minutes and create, move or delete Google Calendar events so the calendar always matches the sheet.

Use cases

Why people connect Google Calendar and Google Sheets

How the two apps work together

  • On a schedule, ClickRuntime reads Google Calendar events and writes them as rows in a sheet.
  • It can also read rows every few minutes and create or update events in a calendar.
  • Event IDs are kept in the sheet or in state, so changes update the same row or event.

  • Consultant tracks billable hours

    Calendar events tagged with a client name can be logged as rows with date, duration and client. The sheet gives a ready billing summary each month.

  • Team lead plans shifts from a sheet

    A shift sheet with Name, Date, Start and End columns can create Google Calendar events for each person. Changes in the sheet update the events.

  • Manager reviews meeting load

    Weekly logging of every meeting with attendees and duration shows where team time goes. A pivot table does the rest.

  • Event planner publishes a schedule

    A sheet listing sessions, rooms and times can become a shared calendar that attendees subscribe to.

More apps

Google Calendar, Google Sheets and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Weekly meeting hours report to Slack

Every Friday, log this week's calendar meetings to my Time sheet and post total meeting hours per person to #team in Slack.

Sheet schedule to calendar with email notice

When I add a session to my Schedule sheet, create the calendar event and email the speaker the details from Gmail.

Billable hours to QuickBooks invoices

At month end, total each client's hours from my calendar log sheet and create a draft invoice in QuickBooks.

Setup

Connect Google Calendar and Google Sheets once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Calendar

Calendar / Scheduling

  1. At console.cloud.google.com, create a project and enable the Google Calendar API.
  2. Set up the OAuth consent screen: Internal on Google Workspace, or External on a personal account. Add the scope https://www.googleapis.com/auth/calendar.events (or calendar).
  3. Create an OAuth client of type Web application with the redirect URI https://clickruntime.com/oauth/callback.
  4. In the ClickRuntime dashboard, open Connections, choose Google Calendar and enter the client ID and secret, then connect.
  5. Prefer a service account? Create one with a JSON key, share the calendar with its email with Make changes to events, and save the key as a secret on Connections & secrets.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

FAQ

Questions about connecting Google Calendar and Google Sheets

Will it create the same event twice?
No. It writes the event link back to the row once the event is created, and skips rows that already have one.
What date format should my sheet use?
Any format Google Sheets recognises as a date and time. Separate start and end columns work best.
Can it log events from more than one calendar?
Yes. Name the calendars and it adds a column showing which one each event came from.
What happens if I move an event in the calendar?
Logging automations update the matching row on the next check, so the sheet reflects the new time.
Is it two-way?
It can work in either direction or both, depending on what you ask for. Many people log calendar to sheet, or create events from the sheet.
Can it skip personal or declined events?
Yes. The script can filter by calendar, title keyword, attendee or response status.
How often does it sync?
Scheduled checks can run as often as every 5 minutes, or once a day for logs.

Related pages

Keep exploring

Tell your assistant what Google Calendar and Google Sheets should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude