←Back/Product/Zapier/Gemini
IntermediateProduct

Create an Automated AI Meeting Prep Assistant with Zapier

Prepare for customer interviews automatically by triggering on the right calendar events, gathering product and CRM context before the meeting, and placing a concise source-linked brief directly in the notes page.

Create an Automated AI Meeting Prep Assistant with Zapier

Source episode · 20:00

How I AI: Reid Robinson's Zapier Workflows for CRM Automation, Meeting Prep, and Feedback Loops

with Claire Vo

Reid triggers research for upcoming meetings, looks up company usage and sales history, converts the returned HTML into a file Gemini can summarize, and appends the brief to the customer’s Coda page.

Read the full episodeWatch on YouTubeListen on SpotifyListen on Apple

Before you start

What you need

  • A calendar with identifiable customer meetings
  • Customer email addresses
  • Authorized product usage and CRM lookup tools
  • Coda meeting pages and Gemini access

What you’ll make

A pre-meeting brief in the correct Coda page with usage context, prior interactions, open questions, and source links.

Tools used

Step by step

The workflow

Follow the sequence once, then adapt the prompts, checks, and handoffs to your own setup.

4 steps

Step01

Trigger Research from a Calendar Event

Create a Zap triggered by a new or updated calendar event. Filter for the customer meeting type and schedule the research far enough ahead to finish before the call.

Step02

Fetch and Convert Customer Data

Use the external attendee email to retrieve the authorized account, product usage, and prior interaction data. Convert returned HTML or PDF material into a file and retain source URLs and timestamps.

Step03

Summarize Data with Gemini

Send the collected file to Gemini with a fixed brief structure. Require factual context, explicit dates, source references, and separate suggested questions.

Example prompt
Prepare a concise brief for this customer interview. Use only the attached account and interaction data. Include company and attendee, dated product usage signals, previous conversations, open commitments, risks or unknowns, and three suggested discussion questions. Cite the source or date for each factual section and label suggestions as suggestions.

Use a model like Google Gemini that is specifically optimized for handling file-based inputs (like PDFs, audio, or converted HTML) for more reliable and efficient processing.

Step04

Deliver the Brief to Your Notes

Find the Coda page for the exact meeting and append or replace a named “AI meeting brief” section. Record the generation time and source links, and alert the owner if identity resolution or research failed.

What good looks like

  • Only intended customer meetings trigger the workflow.
  • The lookup resolves the correct company and contact.
  • The brief distinguishes observed data from suggested discussion topics.
  • The Coda page is updated before the meeting without duplicating content.

Build your next product with ChatPRD

Turn an idea into a PRD, user stories, and a plan.

Try ChatPRD free

After the steps

Runbook notes

How to recover when the loop fails and where human judgment helps.

Recover

If it goes sideways

The Zap runs for internal or unrelated meetings
Filter on meeting type, title, attendees, or a dedicated calendar and require at least one external participant.
The attendee email maps to the wrong account
Use CRM identifiers and company domain, surface ambiguous matches, and do not merge data across accounts.
The brief uses stale or unsupported facts
Include data timestamps and source links, and label model-generated discussion suggestions separately.
Slow research finishes after the meeting starts
Trigger far enough in advance, cache slow lookups, and post a clear incomplete status instead of silently failing.

Keep building

Related workflows

Create an Automated Workout Tracker with a Simple Claude Voice Note
beginnerPersonalClaude

Create an Automated Workout Tracker with a Simple Claude Voice Note

Log your workouts effortlessly without ever opening a spreadsheet. This workflow uses the Claude mobile app to parse a simple voice note and automatically update your workout tracking spreadsheet in the background.

Open
How to Rebuild Your Gmail Inbox Inside Claude to Manage Email
advancedOperationsClaude

How to Rebuild Your Gmail Inbox Inside Claude to Manage Email

Create a custom email management interface within Claude to read, triage, and draft replies without opening the Gmail tab. This workflow helps you reclaim focus and compound your learnings by training your AI on every interaction.

Open
Automate Client Proposals and Onboarding with a Claude 'Pipeline Operator'
intermediateSalesClaude

Automate Client Proposals and Onboarding with a Claude 'Pipeline Operator'

Build a fully automated system in Claude to generate personalized, interactive HTML proposals and client onboarding materials, saving hours on administrative work and creating a high-touch experience.

Open

Start shipping
better products.

Join 100,000+ product managers who use ChatPRD to write better docs, align teams faster, and build products users love.

Start building freeRequest a demo
Free to start
No credit card
SOC 2 certified
Enterprise ready