Description
Summary UT THE PROJECT** Storme Media is a B2B SaaS video follow-up service. We join client demo calls via an AI notetaker (Fathom), extract key information from the transcript, and produce 5 personalized AI videos delivered automatically over 21 days after every demo. I need an experienced Make.com specialist to build the complete automation backbone that connects every tool in our production workflow. This is a one-time build project with the possibility of ongoing maintenance work. --- **OUR TECH STACK** - Fathom (meeting transcription) — sends transcript via email after every demo - email— receives Fathom transcripts - Claude API (Anthropic) — extracts structured data from transcripts - HeyGen API — programmatic video generation - Google Sheets — Production Queue tracking database - Google Calendar — scheduling video due dates - Loom API — video delivery and view analytics - Notion — Company Intelligence Brief storage - Slack — contractor notifications - Google Drive — file storage --- **WHAT I NEED BUILT — 5 MAKE.COM SCENARIOS** **Scenario 1: Transcript to Production Queue** Trigger: Fathom transcript email arrives in Gmail Actions: - Extract the email body text - Send transcript text to Claude API with a structured prompt - Claude extracts: prospect first name, prospect company, AE name, demo date, top pain point (in prospect's exact words), main objection raised, key features shown, next step agreed - Populate a new row in Google Sheets Production Queue with all extracted fields - Set all 5 video status columns to Not Started automatically **Scenario 2: Production Queue to Contractor Notification** Trigger: New row added to Google Sheets Production Queue Actions: - Send a Slack message to the contractor channel with: client name, prospect name, AE name, demo date, a direct link to the relevant Notion Company Intelligence Brief page, and the Google Sheet row number - Send a Gmail notification to my email with the same summary **Scenario 3: Production Queue to Calendar Events** Trigger: New row added to Google Sheets Production Queue (same trigger as Scenario 2) Actions: - Create 5 Google Calendar events automatically based on the demo date in the new row - Video 1 due: 2 hours after demo date and time - Video 2 due: 3 days after demo date - Video 3 due: 7 days after demo date - Video 4 due: 14 days after demo date - Video 5 due: 21 days after demo date - Each event title: [Client Name] — [Prospect Name] — Video [X] Due **Scenario 4: HeyGen API Video Generation** Trigger: Specific column in Google Sheet updated to Approved Actions: - Pull the relevant row data from Google Sheets - Pull the matching Company Intelligence Brief content from Notion via Notion API - Send all variables to HeyGen API to generate the correct video template with personalized content - Receive the HeyGen video URL when generation is complete - Update the Google Sheet row with the HeyGen video URL - Notify contractor via Slack that video is ready for CapCut editing **Scenario 5: Loom Analytics to Monthly Report** Trigger: First Monday of every month at 9am Actions: - Pull view data from Loom API for all videos in each client folder - Pull total views, average watch completion, and individual video performance per client - Populate a Google Sheet Report tab with the monthly data per client - Send a summary email to chad at stomemedia.ai with the report data --- **CLAUDE API PROMPT STRUCTURE** For Scenario 1 you will need to build the Claude API call. Here is the extraction prompt structure to use: System prompt: You are a data extraction assistant. Extract the following fields from this B2B SaaS demo transcript and return them as a JSON object only. No other text. Fields to extract: - prospect_first_name - prospect_company - ae_name - demo_date - top_pain_point (exact words the prospect used) - main_objection (exact words the prospect used) - features_shown (comma separated list) - next_step (what was agreed at end of call) Return format: Valid JSON only. No markdown. No explanation. --- **REQUIREMENTS** - Minimum 2 years Make.com experience - Proven experience with API connections in Make.com (not just native integrations) - Experience with Claude API or OpenAI API in Make.com workflows - Experience with HeyGen API preferred - Experience with Loom API preferred - Google Sheets, Google Calendar, Slack, Gmail, Notion integrations all required - Must document every scenario clearly with screenshots so I can maintain it - Must test all scenarios with dummy data before marking complete - Must provide a handover call to walk me through what was built --- **DELIVERABLES** 1. All 5 Make.com scenarios built, tested, and activated 2. Google Sheets Production Queue template with correct column structure 3. Google Calendar event templates configured 4. Claude API prompt tested and returning clean JSON 5. HeyGen API connected and generating test video 6. Loom API connected and returning view data 7. Full documentation: screenshots of every scenario, what each module does, how to update variables 8. 30-minute handover Zoom call walkthrough --- **BUDGET** $300 to $600 USD fixed price for the complete build depending on experience and scope. Open to milestone payments: 50% on start, 50% on completion and handover. --- **TIMELINE** 7 days from project start to full delivery. If you need longer please state this in your application. --- **TO APPLY** Please include: 1. Your Job Success Score (must be 90% or above) 2. Two or three examples of Make.com workflows you have built that involved external API connections 3. Confirmation that you have worked with Claude API or OpenAI API in Make.com 4. Confirmation that you have experience with HeyGen API or similar AI video tool APIs 5. Your timeline estimate for this specific project 6. Any questions about the workflow before you quote Do not send a generic proposal. I will not respond to applications that do not address the specific scenarios listed above.