Kontaktformular-Leads der Website mit OpenAI, Twilio, Gmail und Google Sheets filtern

## Website lead filter for home-service businesses A trade website's contact form gets customers, sales pitches and bots, and all three ring the owner's phone the same way. This sorts them before anyone is told. ### How it works 1. Your form POSTs to the webhook (any form tool, JSON or form-encoded), or you use the built-in form with its hidden honeypot. 2. Plain checks run first in code: the honeypot, fill time, links in the message, throwaway email domains, and whether the same email or phone wrote in this week. 3. Twilio Lookup checks the phone: real or not, mobile, landline or VoIP, and the carrier. 4. OpenAI reads the message against the Services tab in your spreadsheet (what you do, what you do not, where) and sorts it: customer, vendor pitch, job seeker, spam or unclear, with urgency and a suggested reply. 5. Customers go on the Leads tab and reach you by email (and text if you add Twilio) with a suggested reply. Doubtful ones come marked to check. Pitches and spam are filed quietly. 6. Monday at 7am: the week's counts, sources and customers still waiting on a reply. ### Setup 1. Add OpenAI, Google Sheets, Gmail and Twilio credentials (Twilio is used for Lookup, and for texts if you add your mobile). 2. Run Create my spreadsheet once. Paste the ID and your email into Your settings and rewrite the Services tab. 3. Point your website form at the Form posts here URL, or link to the built-in form. Publish. ### Try it first Submit the built-in form as a customer with a real phone, then again as "We can get you on page one of Google", then with the honeypot filled. Check which tab each landed on.