Fabian Perez
Workflows by Fabian Perez
Automated lead follow-up with Follow Up Boss, Gmail, Twilio & WhatsApp messaging
This workflow automates your entire lead follow-up process across email, SMS, and WhatsApp. It starts on a schedule and pulls your latest leads from FollowUpBoss (FUB), checking when the workflow last ran. Each new contact is automatically validated — phone numbers and emails are cleaned, filtered, and checked for duplicates before sending any message. Once validated, the system intelligently decides how to reach each lead: 💬 Email + SMS if all data looks good 📧 Email only if phone is invalid 📱 SMS/WhatsApp only if email is missing Each message is personalized using data from the lead record, and everything is tracked back in your database for future reporting. This template helps agents, marketing teams, and CRM users run consistent follow-ups without missing a single contact. Whether you manage 10 or 10 000 leads, this flow scales effortlessly. Tools used: FollowUpBoss, Gmail, Twilio/WhatsApp, n8n (Tip: Replace your API keys and Gmail credentials before running.)
Analyze real estate investment potential: Zillow properties to Google Sheets with GPT-4o
This workflow automates the process of scraping, analyzing, and storing real estate data from Zillow using Apify, OpenAI, and Google Sheets. It begins by running an Apify Actor that extracts live property details such as price, location, and key features. The data is then cleaned and processed before being analyzed by an AI model that assigns an investment potential score (1–10). To maintain reliable results, the AI only scores properties that include all required fields — for example, listings missing price or description data are automatically skipped. This ensures that only complete and accurate information is evaluated. Finally, all valid results are appended or updated in a Google Sheet, creating a central, always-up-to-date property database for future analysis. Ideal for real estate investors, analysts, and data-driven agencies, this template provides a fully automated loop for property collection, evaluation, and reporting — all in one flow. Tools used: Apify, OpenAI, Google Sheets, n8n