Gmail to Google Sheets CRM Updates with Gemini & Slack (n8n)

Auto-build CRM updates from Gmail sales emails—then notify Slack and populate Google Sheets

This n8n workflow monitors unread Gmail messages labeled sales, uses Google Gemini to extract structured deal updates (plus a suggested reply), updates your Google Sheets CRM, drafts a follow-up in the same thread, and sends Slack alerts for high-risk or closed_won deals.

What this workflow does

• Triggers every minute when a new unread Gmail email arrives with the label sales.
• Analyzes the email with Google Gemini (PaLM API) to extract a JSON CRM update, including: company, contact, stage, sentiment, objections, next action, due date, and risk—plus a short draft reply.
• Normalizes and structures data into a single deal record keyed by the sender’s email, using a task-style next action.
• Writes to Google Sheets:
  • Appends or updates a Deals row in your selected spreadsheet.
  • Appends the next action to a Tasks worksheet.
• Creates a Gmail draft reply to the client in the same email thread.
• Posts a Slack alert to your chosen channel if the deal risk is high or the stage is closed_won, then marks the original email as read.

Use cases

• SaaS sales teams who want automatic CRM updates from inbound/outbound Gmail conversations.
• Operators who track deal stages, next actions, due dates, and risk without manual entry.
• Teams that need instant Slack escalation for risky deals and closed wins.

Technical details

• n8n trigger: Gmail Trigger (label: sales, unread).
• AI extraction: Google Gemini (PaLM) to return structured JSON fields + draft reply.
• Processing: code + switch (for routing logic like high-risk/closed_won).
• Storage: Google Sheets updates to Deals and Tasks tabs/worksheets.
• Notifications: Slack node to post alerts to your selected channel.
• Gmail actions: create draft reply and mark the message as read.