Quick overview
This workflow checks Google Calendar every 15 minutes for meetings starting in about an hour, looks up external attendees in Clientify CRM, uses OpenAI to generate a one-page meeting briefing grouped by account, and emails the briefing to the meeting organizer via Gmail.
How it works
- Runs every 15 minutes and fetches Google Calendar events that start between 60 and 75 minutes from now.
- Extracts external attendees from each event, skipping internal domains, resource/room attendees, declined guests, and meetings with more than the configured maximum guest count.
- Searches Clientify contacts by each attendee’s email and keeps only those found in the CRM while tracking attendees that are not in Clientify.
- For each known contact, reads the contact timeline and tasks from Clientify and searches the related Clientify company record to build a compact profile.
- Groups all found attendees for the same meeting by company/account so each meeting produces one account-based context bundle.
- Sends the meeting and CRM context to OpenAI to write a plain-text, one-page briefing with account history, open items, goals, questions, and risks.
- Emails the generated briefing to the meeting organizer using Gmail.
Setup
- Install the community node
n8n-nodes-clientify and create/select a Clientify API credential for the Clientify nodes.
- Add a Google Calendar credential, select the calendar to monitor, and ensure it contains the meetings you want to brief.
- Update
ownDomains and maxGuests in the attendee extraction code so internal attendees are excluded and large meetings are skipped.
- Add an OpenAI credential for the Chat Model and a Gmail credential for sending the briefing email.