Claude + n8n: Turn Call/Chat Transcripts into Sales Records

Turn Call/Chat Transcripts into Sales Records—Automatically

This n8n workflow ingests call, chat, or email transcripts, uses Anthropic Claude to extract structured sales data, logs everything to Google Sheets, and immediately alerts your team via Gmail when a conversation is highly urgent.

What this workflow does

• Receives transcripts through an n8n form submission or a POST request to a webhook endpoint.
• Normalizes the payload into a consistent structure including source, channel, timestamp, and the transcript text.
• Uses Anthropic Claude to extract strict JSON fields such as summary, contact, company, needs, intent, budget, timeline, objections, urgency, next action, and a follow-up message.
• Parses Claude output to create a human-readable record; if parsing fails, it falls back to a manual-review record.
• Appends results to Google Sheets in a tab named “Conversations” for ongoing sales tracking.
• Sends email alerts via Gmail when urgency is high, including the readable summary and the follow-up message to your configured recipient.
• Returns structured JSON to webhook callers and/or displays results to form users.

Use cases

• Route high-intent calls to reps after sales calls or demos, with automatic next-step messaging.
• Capture chat or email lead details into a single Google Sheets pipeline.
• Monitor urgency in inbound conversations and trigger immediate Gmail follow-ups.

Technical details

• Anthropic/Claude for JSON extraction of sales fields.
• Google Sheets integration to append records into the Conversations tab.
• Gmail node for urgent alerts.
• n8n nodes used include: if, set, code, form, gmail, and webhook.