Step 2: Configure the Calendly Invite Trigger

This trigger handles Calendly invitee creation and feeds attendee data into the same enrichment flow.

1. Add and open Calendly Invite Trigger.
2. Set Events to invitee.created.
3. Credential Required: Connect your calendlyApi credentials.

Step 3: Connect Google Sheets

These nodes store intake data and enrichment results in your Google Sheet.

1. Open Record Intake Row and set Document to [YOUR_ID] and Sheet to Sheet1.
2. Confirm Operation is appendOrUpdate and mapping includes fields like Email, Name , and Created At.
3. Open Update Enriched Sheet and set Document to [YOUR_ID] and Sheet to Sheet1.
4. Ensure Update Enriched Sheet uses the expressions such as {{ $('Apollo Data Fetch').first().json.companyName }} and {{ $('Record Intake Row').first().json['Created At'] }} in its column mapping.
5. Open Log Missing Info and confirm Status is Info Not Available and Created At is {{ $('Record Intake Row').first().json['Created At'] }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials to Record Intake Row, Update Enriched Sheet, and Log Missing Info.

Step 4: Set Up Parsing and Intake Processing

These nodes normalize data from both calendar sources and build the intake record used for enrichment.

1. In Parse Cal Payload, map fields like Name to {{ $json.responses.name.value }} and Created at to {{ $json.createdAt.toDateTime() }}.
2. In Parse Calendly Payload, map fields like Name to {{ $json.payload.name }} and Created at to {{ $json.created_at.toDateTime() }}.
3. Confirm both Parse Cal Payload and Parse Calendly Payload connect into Record Intake Row.
4. Set Build Search Query to Mode raw and JSON Output to =={ "query": [ { "keyword": ["{{ $json['Name '] }}"], "business": ["{{ $json.Company }}"] } ] }.

Step 5: Configure the Enrichment Request and Validation

This section builds the Apollo search URL, fetches data, and routes results based on availability.

1. Review Assemble Search URL to ensure it reads from Build Search Query and outputs finalURL.
2. In Apollo Data Fetch, set URL to https://api.apify.com/v2/acts/supreme_coder~apollo-scraper/run-sync-get-dataset-items?token=[CONFIGURE_YOUR_API_KEY].
3. Set Method to POST and JSON Body to { "count": 25, "excludeGuessedEmails": false, "excludeNoEmails": false, "getEmails": true, "searchUrl": "{{ $json.finalURL }}" }.
4. In Validate Data Presence, set the condition to {{ $('Apollo Data Fetch').all().toJsonString() }} notEmpty.
5. Confirm Validate Data Presence outputs to both Update Enriched Sheet and Log Missing Info in parallel.

Step 6: Test and Activate Your Workflow

Validate that both trigger paths enrich data and write to the correct sheet.

1. Click Execute Workflow and fire a test booking from Cal and/or Calendly.
2. Verify that Record Intake Row appends or updates a row with Email, Name , and Created At.
3. Check Update Enriched Sheet for enrichment fields like Company, Phone, and Socials when data is returned.
4. If Apollo returns no data, confirm Log Missing Info writes Status as Info Not Available.
5. When successful, toggle the workflow to Active for production use.