Before a sales call, Claude AI pulls prospect info and recent context from Google Sheets, generates a comprehensive prep briefing with talking points, and posts it to Slack so your team walks into every call prepared.
1. Create a Google Sheet with columns: Prospect Name, Company, Deal Value, Meeting Date, Meeting Time, Rep Email, Notes, LinkedIn URL. Populate it with upcoming meetings.
2. In your automation platform, create a workflow with a scheduled trigger that runs every morning (e.g., 7 AM). Add a Google Sheets node to fetch rows where Meeting Date equals today.
3. For each row, add an HTTP Request node to call the Claude API (POST https://api.anthropic.com/v1/messages). Set headers: x-api-key to your Anthropic API key, anthropic-version to 2023-06-01, content-type to application/json.
4. Set the model to "claude-sonnet-4-20250514" and max_tokens to 1024. Craft a prompt asking Claude to generate a deal intelligence briefing including: company overview, potential pain points based on their industry, suggested talking points, objection handling tips, and recommended next steps. Pass all available prospect data.
5. Add a Slack node to post the briefing to a dedicated channel (e.g., #deal-prep). Format it with the prospect name, meeting time, deal value, and the AI-generated briefing.
6. Add a Gmail node to email the briefing to the assigned sales rep so they have it in their inbox before the call.
7. Test by adding a row with today's date. Verify the briefing appears in Slack and the rep's inbox.
8. Iterate on the prompt to match your sales methodology (MEDDIC, BANT, Challenger, etc.) for more targeted briefings.
Troubleshooting
**No rows returned from Google Sheets:** Ensure the date format in your sheet matches what the filter expects (e.g., YYYY-MM-DD). Check that the sheet name and column headers match exactly. Time zone mismatches can cause today's meetings to be missed.
**Claude briefing is too generic:** Add more context to the prompt. Include the deal stage, previous interaction notes, and industry. Specify your sales methodology in the prompt so Claude frames the briefing accordingly.
**Slack message is too long:** Slack blocks have a 3000-character limit. If Claude generates a very detailed briefing, split it into multiple messages or use a thread. Consider asking Claude to keep the briefing under 500 words.
**Gmail send fails for some reps:** Verify each rep's email is valid. If using Google Workspace, ensure the sending account has permission to send on behalf of the organization. Check daily sending limits if processing many meetings.