Home Service Quotes & Promos

Home Service Quotes & Promos: Overview Core Functionality This n8n workflow automates two primary business processes for a home service company called "Lawn & Order": 1. New Customer Quoting: When a potential customer fills out a form (captured in Airtable), the workflow automatically fetches their property size from Zillow, calculates custom quotes for all available services, updates the customer's record, and sends them a personalized email with the pricing. 2. Promotional Marketing: A sophisticated AI Agent, acting as a marketing manager, autonomously generates two unique monthly promotional offers. It stores these offers in a database and then triggers a separate process to email the relevant promotions to targeted customer segments. This dual-process automation streamlines the entire customer journey from initial inquiry to ongoing marketing engagement, saving significant administrative time, ensuring consistent pricing, and enabling dynamic, AI-driven marketing campaigns. Technologies Used - Airtable: Acts as the central database (CRM) for storing customer information, service requests, calculated quotes, and AI-generated promotional content. - Zillow (via RapidAPI): Used to programmatically retrieve property data (specifically lot size) based on a customer's address, which is crucial for accurate quoting. - OpenAI: Powers the AI Agent, using a chat model (like GPT-3.5 Turbo) to generate creative and structured marketing copy for promotional emails. - Gmail: Used as the email service to send automated quote information to new leads and targeted promotional offers to existing customers. - n8n (Core): Coordinates the entire process, connecting the services, handling data transformation, executing conditional logic, and managing the AI agent's tasks. How the AI is Integrated The workflow uses an AI Agent to automate the creative and strategic aspects of marketing. This is a significant step beyond simple data processing: - Persona-Driven Content Creation: The AI Agent is given a specific persona—the "head of marketing for Lawn & Order"—and a clear set of instructions.