Trigger HVAC upsell campaigns from weather data and handle bookings with GoHighLevel, WhatsApp, WeatherAPI and Gemini

Project Overview: Automated Climate-Driven HVAC Upsell & AI Concierge This project is specifically built for an HVAC business to automatically upsell to old customers when their locality has a heatwave or snow wave forecast in the upcoming five days. Prerequisites & Setup 1. GoHighLevel (GHL) Create Custom Fields: stopwhatsapp: Used when a user replies "STOP" to remove them from the marketing list. opptype: To track the campaign type (e.g., heatwave or snowwave). Create Two Pipelines: Pipeline A: HEATWAVE Pipeline B: SNOWWAVE Note: Both pipelines require 4 stages: New Lead, Contacted, Scheduled, and Closed. Grab the Calendar ID: Keep your GHL Calendar ID handy, as the workflow will need it to search for free slots and book appointments. 2. WhatsApp (Meta Business Suite) Create and approve two marketing templates for proactive outreach: A. Heatwave Template > Hello {{1}}, > With temperatures expected to rise soon, we wanted to share a few tips to keep your home comfortable and your AC running efficiently. > Maintenance Tips: > • Keep blinds closed during peak sun hours. > • Check your air filters; a clean filter prevents overworking. > • If you leave the house, raise the thermostat a few degrees rather than turning it off. > Need help? > If your system is struggling to keep up, we are here to assist. > Stay cool and safe! B. Snow Wave Template > Hello {{1}}, > With a cold front and freezing temperatures expected soon, we wanted to share a few tips to keep your home warm and your heating system running efficiently. > Winter Comfort Tips: > • Keep curtains and blinds open during the day to let sunlight naturally warm your home, then close them at night to trap the heat. > • Check your air filters; a clogged filter makes your heater work much harder in freezing weather. > • Ensure your outdoor vents and heat pump units are clear of snow or debris to maintain proper airflow. > Need help? > If your heating system is struggling to stay warm or making unusual noises, we are here to assist. > Stay warm and safe! 3. API Integrations Nominatim OpenStreetMap API: Review the documentation. This open-source tool will be used to extract exact cities from customer street addresses. WeatherAPI: Obtain a free API key. Add this to your workflow's generic credentials (Type: Query Auth > Name: key > Value: your-api-key). Gemini API: Obtain your API key to power the AI Service Concierge. --- Part 1: The Climate-Driven Lead Generation Engine (Proactive Outreach) This sub-workflow acts as a proactive scraper. It monitors your CRM contacts, cross-references their locations with live weather data, and triggers targeted upsell campaigns. 1. Schedule Trigger & Fetch Contacts Schedule Trigger: Kicks off the workflow every morning at 7:00 AM. Fetch Contacts (HighLevel): Pulls your entire list of previous customers and leads from GoHighLevel. 2. Geocoding & Data Cleaning If Node (City Set): Checks if the CRM contact already has a city populated. Nominatim API (Loop & Fetch): If a city is missing, the workflow runs the address through the Nominatim OpenStreetMap API to extract the exact city. Update Contact (HighLevel): Saves the extracted city back to the GHL contact profile to prevent redundant geocoding in the future. 3. Weather Data Aggregation Code Node (Group by City): A vital step to optimize API usage. Instead of making 1,000 separate calls for 1,000 contacts, custom JavaScript groups all contacts by their respective cities. HTTP Request (Fetch Forecast): Pings WeatherAPI.com to grab the 5-day forecast for each unique city. 4. Hazard Detection & Routing Code Node (Detect Weather Hazards): A script evaluates the 5-day forecast against dynamic, seasonal temperature thresholds (e.g., a "heatwave" threshold in May might be >85°F, but >95°F in August). It tags the grouped contacts with a campaign type (HEATWAVE or SNOWWAVE). If Node (Check Campaign Type): Routes the qualified leads into the