{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/1a9c7504fbee447da813e4c9f4ccda51\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/1a9c7504fbee447da813e4c9f4ccda51-968e5eca552b8c32.gif","duration":267.112,"title":"Automated Follow Ups with Zapier Alerts","description":"This Loom explains a Zapier system that manages dormant sales leads and stops follow ups once a human receives a reply. It uses rules in a Google Sheet to exclude edge cases such as duplicate emails, missing emails, opted out leads, closed deals, leads with recent activity, and rows with fewer than three attempts, leaving 31 eligible leads out of 44 fictional dormant leads. Zap 1 runs every Monday to clean eligible emails, generate an AI message, send via Gmail, and log status, while Zap 2 also runs in the morning to sequence follow ups via touch two and touch three or sunset after 180 days. Zap 3 matches replies to sheet rows, marks leads as replied to stop the sequence, classifies responses with AI, and uses Slack error handling to capture Gmail send failures."}