Calendly meeting prep briefs by email
Emails a prep brief before each Calendly meeting. This n8n template checks Gmail every minute and continues only for Calendly notifications of a new event. OpenAI extracts the invitee email and meeting time, and the workflow calculates when to send the brief. It looks up the lead in a Notion database, researches the building address with SerpApi, matches it against STR registration data in Google Sheets and searches Gmail history across two accounts. OpenAI then summarises the relationship or writes a research brief, which is formatted as an HTML email and sent through Gmail at the set time. It suits a team that books calls with leads through Calendly.
Steps
- Trigger: Gmail check every minuteGmail
Only Calendly new-event emails continue. - Extract booking detailsOpenAI
Invitee email and meeting time; send time calculated. - Look up and researchNotion
Notion lead lookup; SerpApi research; OpenAI extracts building details. - Match STR dataGoogle Sheets
Matched to the building address. - Search email historyGmail
Across two Gmail accounts. - Summarize historyOpenAI
If history exists, an HTML brief is created. - Output: Research brief and sendGmail
Otherwise a SerpApi-based brief; waits, then emails it.
Limits
- Built around building addresses and STR registration data.
- Needs a SerpApi key on top of the Google, Notion and OpenAI accounts.
What it does well
- Falls back to a web-research brief when there is no email history.
Before you import
Setup: Gmail OAuth2, OpenAI, Notion and Google Sheets OAuth2 credentials, and the SerpApi key placeholders replaced with your own key.
Similar templates
Competitor watch report with GPT-4o
Also for scheduling and ops, 7 steps.
Daily Shopify order summary in Slack
Also for scheduling and ops, 5 steps.
Gmail summaries in Notion with audio
Also for scheduling and ops, 10 steps.
Gmail and OpenAI: 29 templates compared
Same two apps, different steps.
Google Sheets and OpenAI: 24 templates compared
Same two apps, different steps.
Gmail and Google Sheets: 22 templates compared
Same two apps, different steps.
Gmail and Notion: 5 templates compared
Same two apps, different steps.
Notion and OpenAI: 4 templates compared
Same two apps, different steps.
Google Sheets and Notion: 3 templates compared
Same two apps, different steps.
Notify a team
Other templates that do this task.