Integrate Calendly with Google Sheets

Embed a Calendly form on a Google Apps Script web app page. Pass user information.

This solution embeds a Calendly form on a Google Apps Script web app page. Calendly can be pre-filled with data if the user is a returning customer. When the user completes the registration, a Calendly webhook calls the webapp, which updates a Google Sheet with the registration data.

Screen visitors for ease of use

A Google Apps Script web app contains a custom form, enabling users to schedule calls.

To ease registration, the web app enables users to submit their email address for lookup, if they used the registration before.

calendly-form-sheet-screener
calendly-form-sheet-calendly

Pre-filled form

The web app looks up the visitor's email address in the Google Sheet. If it finds an entry, it auto-populates the Calendly form with the data.

This way, users don't need to manually re-type data that Calendly collects.

Auto-detect Calendly registrations

When the user schedules the call, Calendly notifies the web app about the event.

The page can then react to the event and close the Calendly form.

calendly-form-sheet-thankyou
calendly-form-sheet-sheet

Automatically update Google Sheet

A Calendly web hook is configured so that when a new registration occurs, it sends the data to an end point of the Google Apps Script web app. The web app appends the registration data in a Google Sheet.

When users cancel registrations, the web app finds the right row in the sheet and updates the event status to "Canceled".

BUY THIS PRODUCT

PLEASE NOTE THAT THIS SOLUTION REQUIRES A PAID CALENDLY SUBSCRIPTION. IT DOES NOT WORK WITH THE FREE CALENDLY ACCOUNT. ALSO NOTE THAT THIS SOLUTION REQUIRES PROGRAMMING SKILLS TO MODIFY ITS SCRIPT FOR YOUR OWN NEEDS. FINALLY, THIS SOLUTION INVLOVES A 25-STEP PROCESS TO SET UP EVERYTHING. YOU CAN VIEW THE SETUP INSTRUCTIONS HERE.

$45

The price is a one-time fee for the purchase of a script.

  • Spreadsheet-bound Google Apps Script
  • Unlimited script use
  • Fully customizable
  • Implementation instructions
  • Free email support for 30 days
pay with stripe

More information

What do I receive after I complete the purchase? +
You will receive a link to copy the Google Sheet that contains the script, and add it to your Google Drive.
What is required to operate this solution? +
You need to be comfortable coding in Google Apps Script and in operating the Apps Script IDE. You will need to perform the following tasks to use this solution:
  1. Sign up for a Calendly account
  2. Create a Calendly token and store it as a "calendly_token" script property in the Apps Script IDE
  3. Copy your Calendly URL and store it as a "calendly_url" script property in the Apps Script IDE
  4. Deploy the script as a webapp, executes as: me, available to anyone
  5. Copy the webapp deployment URL and store it as a "webapp_url" script property in the Apps Script IDE
  6. Manually run createWebhook() in Calendly.gs. This will register the webapp as a webhook with Calendly
  7. Open the webapp deployment URL in a web browser to access the registration flow
What if I need technical support? +
Please use the contact form to submit your issue. You will receive a response within 24 hours Mon-Fri 9am-5pm PT. Please note that support does not include any customizations or new features.
What is your refund policy? +
At this time there is no refund, unless you experience a technical problem that I am unable to resolve.
What are the requirements for using this script? +
You need to have a Gmail account or a Google Workspace account.
What if I need to customize this script? +
You have two options here: You can either customize the script on your own, or hire me to customize it for you. Please use the contact form to describe your customization needs. I'll provide you with the amount of hours you'll need to prepay, and the hourly rate.