Automate Cal.com meeting attendee management with Google Sheets, Beehiiv & Telegram

# Automate Cal.com Meeting Attendee Management with Google Sheets, Beehiiv & Telegram

This n8n workflow automates the process of managing attendees for Cal.com meetings by integrating with Google Sheets, a hypothetical Beehiiv integration (implied by directory name but not present in JSON), and Telegram. It streamlines the post-meeting actions, ensuring attendees are recorded and notified.

## What it does

This workflow is triggered by events in Cal.com and performs the following actions:

1.  **Listens for Cal.com Events**: The workflow starts when a specific event occurs in Cal.com (e.g., a new booking, a booking cancellation).
2.  **Processes Attendee Data**: It extracts relevant attendee information from the Cal.com event.
3.  **Splits Out Attendees**: If a Cal.com event contains multiple attendees (e.g., a group meeting), this step separates them into individual items for further processing.
4.  **Edits Fields (Set)**: This node likely transforms or renames data fields to prepare them for Google Sheets, ensuring consistency and correct mapping.
5.  **Records to Google Sheets**: The processed attendee information is then added as a new row to a specified Google Sheet, serving as a centralized record.
6.  **Sends HTTP Request**: This step suggests an interaction with an external API, possibly for a Beehiiv integration (as hinted by the directory name) or another service, to update subscriber lists, send follow-up emails, or perform other actions.
7.  **Sends Telegram Notification**: Finally, a notification is sent to a Telegram chat, likely informing an administrator or team about the new attendee record or other relevant updates.

## Prerequisites/Requirements

To use this workflow, you will need:

*   **n8n Instance**: A running instance of n8n.
*   **Cal.com Account**: Configured with webhooks to trigger n8n on relevant events.
*   **Google Sheets Account**: With a spreadsheet prepared to store attendee data.
*   **Telegram Account**: A Telegram bot and chat ID for sending notifications.
*   **API Endpoint/Service**: For the HTTP Request node, if it's connecting to an external service like Beehiiv, you'll need the API endpoint and any necessary authentication.

## Setup/Usage

1.  **Import the Workflow**: Download the provided JSON and import it into your n8n instance.
2.  **Configure Credentials**:
    *   **Cal.com Trigger**: Set up a webhook in your Cal.com account to point to the webhook URL provided by the "Cal.com Trigger" node.
    *   **Google Sheets**: Configure your Google Sheets credential, ensuring it has write access to your target spreadsheet.
    *   **Telegram**: Set up your Telegram Bot API token and specify the chat ID where notifications should be sent.
    *   **HTTP Request**: Configure the API endpoint, headers, and body for your specific external service (e.g., Beehiiv).
3.  **Customize Nodes**:
    *   **Google Sheets**: Specify the Spreadsheet ID and Sheet Name where attendee data should be added.
    *   **Edit Fields (Set)**: Adjust the fields being set or transformed to match your Google Sheet columns and any other data requirements.
    *   **HTTP Request**: Modify the URL, method, headers, and body to correctly interact with your desired external API.
    *   **Telegram**: Customize the message content to include relevant attendee details.
4.  **Activate the Workflow**: Once configured, activate the workflow to start automating your Cal.com attendee management.