How To Export Your Calendly Appointments To Google Sheets

Option 1: Using Calendly’s CSV Export + Google Sheets

1. Log into your Calendly account.
2. Go to “Scheduled Events”.
3. Use the filters to choose the time range or event type you want.
4. Click “Export” → “CSV”.
5. Open Google Sheets, then go to File → Import → Upload and select the CSV.

Your appointments will now be in a Google Sheet.

Option 2: Automating with Zapier (Calendly → Google Sheets)

1. Sign into Zapier (or Make.com if you prefer).
2. Create a new Zap:
   • Trigger: Calendly → “Invitee Created” or “Invitee Canceled”.
   • Action: Google Sheets → “Create Spreadsheet Row”.
3. Connect your Calendly and Google accounts.
4. Map the event data (name, email, event type, date/time, location) into columns.

Each new Calendly appointment will automatically flow into Google Sheets.

Option 3: Using Google Sheets API + Calendly API

1. For more control (developer approach):
2. Enable the Google Sheets API in your Google Cloud project.
3. Get a Calendly Personal Access Token.
4. Write a script (Node.js, Python, etc.) that:
   • Calls the Calendly API /scheduled_events endpoint.
   • Parses the JSON response. Pushes rows into a Google Sheet using the Sheets API. (This method gives you flexibility, like syncing only certain event types or updating rows.)