**Introduction** Small teams often struggle to generate qualified leads without spending hours sifting through noisy data. By applying a straightforward AI workflow, a three‑person consultancy was able to transform scattered customer interactions into booked appointments – all within half an hour of daily work. Below is the step‑by‑step process they followed, complete with practical tips you can adopt immediately. **1. Capture Every Touchpoint** - **Forms & Chats**: Use a simple form on the website that feeds directly into a spreadsheet. - **Email Replies**: Set up an automatic rule in Gmail or Outlook to flag messages containing words like "interested," "quote," or "demo." - **Social Signals**: Add a Chrome extension that logs LinkedIn or Twitter engagements. *Tip*: Keep the source columns distinct (e.g., `form_source`, `email_flag`, `social_interaction`) so the AI later knows which channels perform best. **2. Clean & Consolidate the Data** - Remove duplicate rows. - Fill missing names with "Unknown" to avoid empty records. - Convert dates to a uniform format (YYYY‑MM‑DD). *Tool suggestion*: Google Sheets built‑in data validation and the `REMOVE DUPLICATES` function handle most of this for free. **3. Build a Lead‑Scoring Prompt** Create a short prompt for a language model that evaluates each record and returns a score (0‑1000). Example: ``` You are a sales assistant. Given the following contact info and interaction history, assign a lead score from 0 (unlikely) to 1000 (highly likely to buy). Consider: recent engagement, budget indicators, and decision‑maker status. Contact: {name}, {email} Interactions: {interactions} Score: ``` Run this through an AI chat interface or a low‑code platform like Zapier + OpenAI. Store the returned score in a new column. **4. Set Thresholds & Auto‑Assign** - Define a minimum score for a "hot" lead (e.g., ≥ 600). - Use Zapier or Microsoft Power Automate to move rows meeting the threshold into a dedicated "Follow‑up" folder and trigger an email template. **5. Integrate with Calendar** - Connect the follow‑up email system to a calendar API. - When the prospect clicks "Schedule a Call,” the system automatically books a slot in the team’s shared calendar, respecting time‑zone differences. **6. Review & Refine Weekly** - Spend 15 minutes each Monday reviewing which AI‑scored leads turned into meetings. - Adjust the scoring prompt based on conversion patterns – for instance, add weight to LinkedIn engagements if they correlate with bookings. **Results** - **Time saved**: 4 hours per week previously spent manually filtering leads. - **Appointments booked**: an average of 12 new client meetings per week. - **Revenue impact**: 18% increase in billable hours within the first month. **Key Takeaways** - Start small: a single spreadsheet + a simple AI prompt is enough to see immediate gains. - Keep the workflow visible – a one‑page checklist helps team members follow the same steps. - Iterate based on real data; the AI model improves as you feed it more examples. By automating the repetitive parts of lead qualification, small teams can focus on relationship‑building and close deals faster – all with less than half an hour of daily setup. **Image Prompt**: A cozy home office scene showing a laptop open to an AI dashboard with glowing green scores, a calendar app displaying scheduled appointments, and a coffee mug on a wooden desk, illustrating data‑driven lead generation.