n8n Workflow: Track Demo Bookings with Google Calendar to Meta Conversions API Integration

This n8n workflow is designed to automate the process of tracking demo bookings made via Google Calendar and sending these events to the Meta Conversions API for enhanced ad campaign optimization. It acts as a bridge, ensuring that every confirmed demo booking directly contributes to your Meta ad performance metrics.

What it does

This workflow simplifies the process of sending Google Calendar events as conversion events to Meta, specifically for demo bookings.

1. Monitors Google Calendar for Events: The workflow starts by listening for new or updated events in a specified Google Calendar.
2. Filters for "Demo Booked" Events: It then checks if the event's summary (title) contains the phrase "Demo Booked". Only events matching this criterion proceed.
3. Prepares Data for Meta Conversions API: For qualifying events, it extracts relevant information such as the event ID, start time, and a unique user identifier (e.g., email hash).
4. Generates User Email Hash: It hashes the attendee's email address using SHA256, a requirement for sending PII (Personally Identifiable Information) to Meta Conversions API securely.
5. Sends Conversion Event to Meta: Finally, it constructs and sends an HTTP POST request to the Meta Conversions API, reporting a "Schedule" event with the prepared data, including the hashed email, event time, and a unique event ID.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Calendar Account: An active Google Calendar account where demo bookings are scheduled.
• Google Calendar Credential in n8n: OAuth 2.0 credentials configured in n8n to access your Google Calendar.
• Meta Conversions API Access: Access to the Meta Conversions API, including:
  • A Facebook Pixel ID (or Meta Pixel ID).
  • A Meta Access Token (generated from your Facebook Business Manager).
• Basic understanding of n8n: Familiarity with configuring nodes and credentials.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON content or upload the file.
2. Configure Google Calendar Trigger:
   • Locate the "Google Calendar Trigger" node.
   • Credentials: Select or create your Google Calendar OAuth2 credentials.
   • Calendar ID: Specify the Google Calendar ID you want to monitor for demo bookings.
   • Watch Events: Ensure it's set to watch for "New or Updated" events.
3. Configure the "If" Node:
   • The "If" node is pre-configured to check for "Demo Booked" in the event summary. You can adjust this condition if your booking titles differ (e.g., {{ $json.summary.includes("My Demo") }}).
4. Configure the "Edit Fields" Node:
   • This node extracts and renames data. Ensure the expressions correctly map to your Google Calendar event data if your event structure varies significantly.
5. Configure the "Crypto" Node:
   • This node hashes the email address. Ensure the input for hashing correctly points to the attendee's email address from the Google Calendar event data (e.g., {{ $json.attendees[0].email }}).
6. Configure the "HTTP Request" Node (Meta Conversions API):
   • Method: POST
   • URL: https://graph.facebook.com/v18.0/<YOUR_PIXEL_ID>/events?access_token=<YOUR_ACCESS_TOKEN>
     • Replace <YOUR_PIXEL_ID> with your actual Facebook Pixel ID.
     • Replace <YOUR_ACCESS_TOKEN> with your Meta Conversions API access token.
   • Body Parameters:
     • Ensure the JSON body correctly maps the hashed email, event time, and event ID to the Meta Conversions API requirements for a "Schedule" event.
7. Activate the Workflow:
   • Once all credentials and configurations are set, click the "Activate" toggle in the top right corner of the n8n editor to start the workflow.

Now, whenever a new or updated event containing "Demo Booked" in its summary is detected in your specified Google Calendar, this workflow will automatically send a "Schedule" conversion event to your Meta Conversions API.