Bibliothek / Lead-Generierung & Anreicherung
Lead-Generierung & Anreicherung
Antworten auf Portalanfragen mit OpenAI, Gmail und Google Sheets entwerfen
Überwacht ein Gmail-Label auf Anfragen von Immobilienportalen, nutzt OpenAI, um Interessentendaten zu extrahieren und eine Antwort zu entwerfen, protokolliert den Lead in Google Sheets und speichert die Antwort als Gmail-Entwurf zur Prüfung.
Was sie bewirkt
## Portal enquiry → AI draft reply → lead log (Gmail + OpenAI) Free template by Burnt & Toast Kits, for UK estate and letting agents. What it does: watches a Gmail label for Rightmove, Zoopla, OnTheMarket or website enquiries, asks OpenAI to pull out the lead details and write a short personal first reply with qualifying questions, logs the lead to Google Sheets and saves the reply as a Gmail draft for you to check and send. It never sends anything by itself. Setup (10 minutes) 1. In Gmail, add a filter that labels portal enquiry emails portal-leads. 2. Add credentials: Gmail (trigger + draft node), OpenAI (AI node), Google Sheets (log node). 3. Fill in Settings (agency name, booking link, signature, privacy notice URL). 4. Make a Google Sheet with a tab called Leads and paste its URL into the log node. Columns: received_at, message_id, source, market, property, applicant_name, applicant_email, applicant_phone, enquiry_summary, position, finance, timeline, move_in_date, viewing_requested, lead_temperature, temperature_reason, needs_human, needs_human_reason, sensitive_info_flag, reply_status, delete_after, agent_notes. 5. Send yourself a test enquiry, then activate. The AI only uses facts in the enquiry email, never invents property details and ignores instructions inside the email. Full version (auto-send after checks, hot-lead alerts, Claude and Outlook versions, lettings rules, setup guide and test enquiries): https://kits.burntandtoast.com/estate-agents/kits/instant-lead-responder
Die Schritte
- Portal enquiry (Gmail)
- Settings
- AI instructions
- Prepare enquiry
- AI: draft reply (OpenAI)
- Check AI output
- Log lead (Google Sheets)
- Draft for review?
- Save draft for review
Ähnliche Automatisierungen
Lead-Generierung & AnreicherungOutreach-E-Mails mit Gemini, Gmail und Google Sheets planen12 SchritteLead-Generierung & AnreicherungBewerte eingehende Leads mit einem Score, erstelle dann HubSpot-Kontakte und sende Gmail-Follow-ups8 SchritteLead-Generierung & AnreicherungFormular-Leads in Google Sheets speichern, Slack benachrichtigen und per Gmail automatisch antworten7 SchritteLead-Generierung & AnreicherungLeads aus dem Website-Formular in Google Sheets speichern und Gmail-Autoreplies senden7 Schritte