Copy Calendly bookings into Google Sheets automatically

Short answer: Use a free Google Apps Script that copies your Calendly bookings into a Google Sheet every hour, with who booked, when and where, and marks the ones that get cancelled. It runs in your own Google account; nothing is sent to us. Setup takes 3 steps: Add your key; Paste the script; Run it.

How to set it up

1. Add your key. In the Apps Script editor, open Project Settings and add the Script property CALENDLY_TOKEN. In Calendly, go to Integrations, then API and webhooks, and create a personal access token. Keys stay in the script, never in the sheet.
2. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Calendly menu appears.
3. Run it. Choose Calendly, then Copy bookings. The Bookings tab fills in with each booking's start time, event type, status, the name and email of the person who booked and the location. Choose Copy bookings every hour to keep it up to date.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• It covers bookings starting from 30 days ago onwards, including future ones.
• When someone cancels, the next run changes the status to canceled instead of adding a new row.
• It reads the first invitee of each event; group events list one person.

Questions

What does this script do?

It is a free Google Apps Script that copies your Calendly bookings into a Google Sheet every hour, with who booked, when and where, and marks the ones that get cancelled.

How do I set it up?

In 3 steps: 1. Add your key; 2. Paste the script; 3. Run it. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.