With Sheetgo, you can connect your Calendly account directly to Google Sheets to automatically import event scheduling data. This integration allows you to gather all your meeting insights — such as attendee names, event types, and scheduled times — into a single spreadsheet. Automating this process saves hours of manual data entry, helping teams track appointments, analyze meeting volume, and generate performance reports in real-time.
Prerequisites
- A Calendly account with admin or owner access
- A Calendly Personal Access Token
- Your Calendly User URI (unique user identifier)
- Calendly API Documentation : https://developer.calendly.com/api-docs
- Ensure your Sheetgo account uses the same email associated with your Calendly account
Step 1: Identify the Required API Endpoint
Visit the official Calendly API documentation (linked in the Prerequisites) to find the correct endpoint for your needs. Calendly’s base URL is `https://api.calendly.com`. To retrieve a list of scheduled events, use the /scheduled_events endpoint. You will also need to include your `uri` as a query parameter in the request. For example: `https://api.calendly.com/scheduled_events?user={uri}`. This endpoint returns all the scheduled events linked to your account, including event details, invitee information, and timestamps.
Step 2: Generate API Credentials
To connect Calendly with Sheetgo, you first need to generate a Personal Access Token that authenticates your requests. Begin by logging into your Calendly account and navigating to the Integrations tab. you must retrieve your User URI, which uniquely identifies your Calendly account in the API. To do this, send a GET request to `https://api.calendly.com/users/me`, including your Bearer token in the request header. The API response will include several user details, among which you should locate the uri field. This uri value represents your unique user URI and will be required when constructing the main API endpoint URL for pulling your scheduled events into Google Sheets.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Open Sheetgo and create a new workflow. Choose HTTP Request as your source and enter the suitable API request URL. In the Headers (JSON) section, input the following structure:
{
"Authorization": "Bearer YOUR_API_TOKEN",
"Content-Type": "application/json",
"@pagination": {
"type": "cursor",
"cursor_param": "next_page_token",
"next_cursor_key": "pagination.next_page_token"
}
}Calendly’s API uses cursor-based pagination, so this setup ensures that Sheetgo retrieves all available events, automatically fetching the next set of results using the `next_page_token` key.
Step 5: Choose the Destination Spreadsheet
Select the Google Sheet where you want Calendly data to be imported. You can either pick an existing spreadsheet or create a new one. Each time the connection runs, the event data will populate this sheet, allowing you to filter, analyze, and visualize meeting trends directly in Google Sheets.
Step 6: Execute the Sheetgo Connection
Click Run to execute your Calendly integration. Sheetgo will fetch scheduled event data from your Calendly account and populate your selected Google Sheet. Once tested successfully, enable automatic refreshes at your preferred interval (daily, hourly, etc.) so that your Calendly events remain updated continuously.