Calendly Invitee Enrichment

Task

Pull all Calendly meetings from the past week, extract every invitee, enrich them with company and contact data, and log the results to a Google Sheet for CRM follow-up.

Input

The user provides a time range (default: last 7 days) and optionally a Google Sheets spreadsheet ID.

Context

Research Strategy

1. Use @Calendly/Get Current UserName it "Calendly/Get Current User" and call it with @Calendly/Get Current User to get the user URI
2. Use @Calendly/List EventsName it "Calendly/List Events" and call it with @Calendly/List Events for the past 7 days with status "active"
3. For each event, use @Calendly/List Event InviteesName it "Calendly/List Event Invitees" and call it with @Calendly/List Event Invitees to get attendee info
4. For each invitee, use @Apollo/Enrich PersonName it "Apollo/Enrich Person" and call it with @Apollo/Enrich Person with their email
5. Compile a row per invitee with: name, email, company, title, company size, industry, meeting date, event type, and any booking form answers
6. If a Google Sheet ID is provided, use @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row to log each row

What to Capture

• Full name and email from Calendly invitee data
• Company name, size, and industry from Apollo
• Job title and seniority level
• Any custom question answers from the booking form
• Meeting type and date for context
• LinkedIn URL if available

Output

Summary: Total meetings, total unique invitees, breakdown by event type.

Enriched Invitee List: For each invitee:

• Name, email, title, company
• Company size and industry
• Booking form responses
• Meeting date and event type

If a Google Sheet was provided, confirm rows were appended with a link to the sheet.