Send tailored pre-meeting briefs from Google Calendar and Gmail with OpenAI
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (cron */30 * * * *) (plus 1 other trigger). Along the way it connects Google Calendar, Google Sheets, Gmail and OpenAI Chat Model.
How it runs
Trigger: On a schedule (cron */30 * * * *) (plus 1 other trigger).
- Brief Config (Edit Fields (Set)): sets 6 fields: CalendarId, SendBriefTo, InternalDomains…
- Get Upcoming Meetings (Google Calendar): get many
- Load Brief Log (Google Sheets): uses Google Sheets
- Select And Classify (Code): runs custom JavaScript code
- Loop Meetings (Loop Over Items (Split in Batches)): loops over the items in batches
- Route By Meeting Type (Switch): routes items into 4 branches
- Search Candidate History (Gmail): get many
- Build Recurring Delta (Code): runs custom JavaScript code
- Build Internal Note (Code): runs custom JavaScript code
- Search Contact History (Gmail): get many
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Calendar
n8n-nodes-base.googleCalendar - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Quick overview This workflow runs every 30 minutes (or manually) to find upcoming external Google Calendar meetings, pulls recent Gmail history with the primary external attendee, uses OpenAI to generate a concise meeting brief, emails it to you, and logs the…