AI Automation
923 Ergebnisse — ausschließlich quellenverknüpfte n8n-Referenzen
Generate personalized cold email drafts from Google Sheets with Groq and Tavily
Quick overview This scheduled workflow reads leads from Google Sheets, researches each company with Tavily Search, uses Groq (Llama 3.3 70B) to generate a short personalized cold email, and saves the result as a Gmail draft while updating the lead status back in the sheet. How it works Runs on an hourly schedule trigger. Reads lead rows from Google Sheets and keeps only rows that have an email address and are not marked with status "sent". Processes leads one at a time and uses the Tavily Search API to fetch a brief company overview based on the lead’s company name. Sends the lead details plus the Tavily research summary to Groq (Llama 3.3 70B) to generate a JSON-formatted email subject, body, and personalization hook. Parses and validates the AI output to ensure a subject and body are present, and routes failures to an error log. Creates a Gmail draft with the generated subject and body, updates the corresponding row in Google Sheets with the new status and generated fields, and waits briefly before continuing to the next lead. Setup Create and connect a Google Sheets OAuth2 credential, then select the target spreadsheet and sheet in both the Google Sheets read and update steps. C
Manage KlickTipp contact tags with GPT-5-mini via chat input
Quick overview This workflow uses an n8n chat trigger, OpenAI (gpt-5-mini), and KlickTipp community nodes to interpret chat instructions and create, apply, or remove tags for an existing KlickTipp contact, returning a structured JSON result. How it works Receives a chat message containing a contact email address and explicit tag add/remove instructions. Uses OpenAI (gpt-5-mini) to extract the email plus the requested tags to apply and/or remove, enforcing strict rules to avoid inventing tags. Looks up the contact in KlickTipp by email and reads the contact’s currently assigned tag IDs. Retrieves the full tag list from KlickTipp and creates any missing tags that were explicitly requested for applying. Applies the resolved tag IDs to the contact in KlickTipp when an explicit apply action is present and the contact does not already have them. Removes specific tag IDs (or all currently assigned tag IDs when requested) from the contact in KlickTipp when an explicit remove action is present. Returns a structured JSON response summarizing what was requested, which tags were created, and which tag IDs were applied or removed. Setup Add KlickTipp credentials for the community KlickTipp node
Enrich KlickTipp contact fields using OpenAI GPT-5.5 and context
Quick Overview This workflow receives an email and a context block, uses OpenAI to extract and validate enrichment details against the existing KlickTipp subscriber record, and then updates approved mapped data fields in KlickTipp. How it works Receives an incoming request from another workflow containing a contact email address and a free-text context block. Fetches the existing subscriber record from KlickTipp using the provided email. Uses OpenAI to extract enrichment attributes from the context, compare them to the current KlickTipp values, and decide final values using a confidence threshold for overwriting non-empty fields. Updates the KlickTipp subscriber with the final approved values for the mapped fields (for example name, company, address, phone numbers, website, birthday, and social profile URLs). Setup Add KlickTipp credentials and ensure the target subscriber fields (including any custom fields for LinkedIn, Instagram, Facebook, and job title) exist in your KlickTipp account. Add an OpenAI API key credential and select the model you want to use in the OpenAI chat model configuration. Ensure the incoming payload sent to this workflow includes at least email and context
Generate personalized email salutations for KlickTipp contacts with OpenAI
Quick Overview This workflow triggers when a contact is tagged in KlickTipp, uses OpenAI to generate an HTML-ready email salutation with a quality score, and updates the KlickTipp subscriber record with the salutation only when it meets a defined confidence threshold. How it works Triggers when a contact is tagged in KlickTipp and receives the contact’s profile fields (name, email, company, and address data). Sends the contact details to OpenAI to generate a JSON response containing an HTML-ready salutation plus language, style, and a salutation quality score. Parses and validates the OpenAI response against a structured JSON schema. Checks whether the generated salutation quality score is greater than 80. Updates the contact in KlickTipp by writing the generated salutation into a configured custom field when the score passes the threshold. Setup Add KlickTipp credentials and ensure the KlickTipp trigger for “contact tagged” is enabled for your account. Add an OpenAI API key for the chat model used to generate the salutation. In KlickTipp, create/identify the tag that should trigger this automation and configure it to call the n8n webhook URL from the trigger. Create a KlickTipp cu
Nurture leads from Google Sheets with Gmail, SMS, and OpenRouter AI
Quick overview Automatically nurture leads with AI-personalized email follow-ups (plus optional SMS) across 3 stages triggered hourly, respecting business hours, and fully tracked in Google Sheets. How it works Runs every hour, filtered to a business-hours window (default 9am–6pm, timezone configurable). Reads all leads from Google Sheets and filters those due for follow-up skipping replies, unsubscribes, and completed leads. Routes by stage Stage 1 (Welcome), Stage 2 (Check-in), or Stage 3 (Final nudge). AI writes the email an LLM (via OpenRouter) generates a personalized subject + body using the lead's name, source, and service of interest. Sends via Gmail, and optionally an SMS via Seven/Twilio (Day 1 and Day 4, with consent and dedupe checks). Updates Google Sheets advances the lead's stage, sets the next follow-up timestamp, and marks SMS sent. Setup Import all 4 workflows they share one Google Sheet. Paste your Sheet ID/tab name into each 🔧 CONFIG node (same Sheet ID throughout). Connect Google Sheets, Gmail, and OpenRouter credentials. Edit the 3 LLM prompt nodes to replace "YOUR NAME/company" with your actual brand name. (Optional) Connect Seven/Twilio for SMS, and adjust
Classify Salesforce deal complexity and notify sales with Groq and Slack
Quick overview This workflow monitors new Salesforce opportunities, enriches them with related contacts and products, uses Groq-hosted LLM analysis to classify deal complexity, then updates Salesforce with a processed flag, creates a follow-up task, and posts the outcome to a Slack channel. How it works Triggers when a new Opportunity is created in Salesforce. Retrieves Opportunity details and checks whether the opportunity has already been marked as processed. If it is already processed, posts a “no new opportunities” message to a Slack channel. If it is unprocessed, fetches related Salesforce Contacts for the Opportunity’s Account and OpportunityLineItem records for the Opportunity. Calculates simple deal metrics (stakeholder count, product count, and total product value) and sends them with Opportunity fields to a Groq LLM to classify complexity as Low/Medium/High with reasons and suggested actions. Parses the LLM’s JSON response, marks the Opportunity as Processed__c = true in Salesforce, creates a Salesforce Task containing the classification details, and sends a success notification to Slack. Setup Add Salesforce OAuth2 credentials and ensure your Opportunity object includes
WScore customer health and churn risk with Salesforce, Gemini, and Gmail
Quick Overview This workflow runs every minute to pull accounts from Salesforce, enrich each customer with order, payment, support, and marketing data via HTTP APIs, analyze the combined profile with Google Gemini, then update the Salesforce account and send Gmail alerts for high-risk customers and execution outcomes. How it works Runs every minute on a schedule and retrieves up to five Salesforce Account records. Processes accounts in batches and initializes a retry counter to control fault-tolerant data fetching. Fetches customer order data via an HTTP API, retrying up to three times with a wait delay and falling back to a backup HTTP endpoint if needed. Fetches payments, support tickets, and marketing engagement for the same customer via HTTP API requests and normalizes everything into a single customer profile. Sends the unified customer profile to Google Gemini to generate a JSON assessment with health score, churn risk, customer type, a summary, and a recommended action. Parses the AI output and emails a high-risk alert via Gmail when the churn risk equals HIGH. Routes by customer type, updates the Salesforce Account description with the AI summary, then logs the result and e
Send prioritized forex risk alerts from ForexLive RSS with OpenAI and Slack
Quick Overview This workflow polls the ForexLive RSS feed every five minutes, filters for forex-relevant headlines, uses OpenAI to generate structured risk analysis, deduplicates items in an n8n Data Table, and sends high-priority alerts to a Slack channel. How it works Polls the ForexLive RSS feed on a */5 * * * * schedule and ingests newly published items. Normalizes each RSS item into consistent fields (title, description, link, and date) and checks the text for predefined forex and macroeconomic keywords. For relevant items, sends the title and description to OpenAI (GPT-4.1-mini) to return a strict JSON risk assessment including summary, impacted currency pairs, risk level, confidence score, and recommended action. Parses the OpenAI JSON response, merges it back with the original news data, and computes a final risk score, priority level, and a normalized deduplication key. Checks an n8n Data Table for the dedupe key and only continues when the item has not been seen before. Stores the processed item in the n8n Data Table and posts a formatted Slack message when the computed priority is HIGH. Setup Add OpenAI credentials and ensure the OpenAI node is set to a model you have ac
Generate Salesforce opportunity next steps with Gemini and Slack
Quick Overview This workflow runs daily at 10:00 AM to find open Salesforce Opportunities with no Next Step, generates a recommended next action with Google Gemini, posts it to Slack, and updates the Opportunity’s Next Step field back in Salesforce. How it works Runs every day at 10:00 AM on a schedule trigger. Fetches all Salesforce Opportunities, reverses the list, and processes them in batches of 10. Retrieves key fields, filters to opportunities that are not Closed Won/Lost, have a close date on/after today, and have a blank Next Step. Builds a per-opportunity prompt containing the main deal details for an AI sales assistant. Processes opportunities one at a time and uses Google Gemini to generate a 1–2 sentence next-step recommendation. Posts the AI-generated recommendation to a specified Slack channel and updates the Opportunity’s Next Step field in Salesforce. Setup Connect Salesforce OAuth2 credentials with permission to read Opportunities and update the Opportunity Next Step field. Add Google Gemini (Google PaLM) API credentials for the Gemini chat model used by the agent. Add Slack credentials and select the channel where recommendations should be posted. Confirm your Sal
Schedule and manage pet clinic visits with WhatsApp, Gemini, and HighLevel
Quick overview Youtube Video: https://youtu.be/81QSPEr5Yio?si=4EeaBFVofW0dK2Z_ This workflow handles pet clinic appointment conversations over WhatsApp, using Google Gemini for replies, Redis for chat memory, and GoHighLevel (LeadConnector) to look up or create contacts, save visit notes, and book, cancel, or reschedule calendar appointments. How it works Triggers when a new WhatsApp message is received. Validates the sender and ignores unsupported message types. Searches GoHighLevel for an existing contact that matches the sender’s WhatsApp phone number. Uses Google Gemini with Redis chat history and the contact context to chat with the owner, capture the pet’s issue, and save it as notes in GoHighLevel. Fetches available GoHighLevel calendar free slots for the requested weekday date range and presents times to the user. Creates or updates the GoHighLevel contact if required, then books the selected appointment, or fetches upcoming appointments to cancel or reschedule when explicitly confirmed. Sends the assistant’s formatted response back to the owner via WhatsApp. Setup Connect WhatsApp Cloud API credentials for both the WhatsApp Trigger and WhatsApp send action, and set your Wh
Run a hotel WhatsApp concierge using Google Gemini and Google Sheets
Quick overview Youtube Video: https://youtu.be/q2vPN9eub1o?si=lSo4c0kQMNQd_Aad This workflow acts as a WhatsApp hotel concierge that looks up guest profiles, reservations, and open service requests in Google Sheets, consults a Google Docs amenities guide, and uses Google Gemini with Redis memory to reply and optionally create or update reservations and service requests. How it works Triggers when a WhatsApp message is received and continues only if the incoming message contains text. Looks up the guest by WhatsApp number in a Google Sheets “Guest Details” spreadsheet and checks whether Do Not Disturb (DND) is enabled. If the guest is not in DND, fetches the guest’s reservations and any incomplete service requests from Google Sheets. Determines whether the guest is new, currently checked in (based on today’s date between check-in and check-out), and whether any requests are pending, then packages this context for the assistant. Uses Google Gemini with Redis chat memory to generate a WhatsApp-ready reply, calling a Google Docs amenities document when answering policy/pricing/amenity questions. When appropriate, the assistant writes back to Google Sheets to create or update guest prof
Send multi-carrier shipping quotes via WhatsApp with Gemini and ShipEngine
Quick overview Youtube Video: https://youtu.be/jIGBUW_1Sx0?si=BNXzk95soO0Nefan This workflow responds to incoming WhatsApp messages, validates the sender in HighLevel, uses Google Gemini with Redis memory to collect shipment details, fetches multi-carrier rates from ShipEngine, applies a commission markup, logs the quote to Google Sheets, and sends the best options back via WhatsApp. How it works Triggers when a new WhatsApp message is received. Looks up the sender’s phone number in HighLevel and stops outreach if the contact is marked Do Not Disturb. Uses a Google Gemini-powered agent with Redis chat memory to collect and confirm shipment details, creating the contact in HighLevel if needed or marking them DND if they opt out. If shipment data collection is complete, requests shipping rates from the ShipEngine Rates API for the configured carriers. Calculates a commission markup, filters for valid rates, and selects the cheapest and fastest options to format a quote message. Appends the quote text and metadata to a Google Sheets spreadsheet and sends the quote back to the customer via WhatsApp. Setup Connect WhatsApp Business credentials for both the WhatsApp trigger and send acti
BAnswer HR policy and benefits questions with BambooHR, OpenAI and Supabase
Quick Overview This workflow ingests company policy PDFs from BambooHR into a Supabase vector database and provides an employee chat interface that answers policy and benefits questions using OpenAI, with an additional employee/department lookup powered by BambooHR employee data. How it works Starts a manual run to fetch files from BambooHR and keep only PDFs in the “Company Files” category. Downloads each selected PDF, splits it into chunks, generates OpenAI embeddings, and inserts the content into a Supabase vector table for retrieval. Exposes a chat trigger where employees submit questions to an HR assistant. Uses OpenAI with conversation memory and retrieves relevant policy content from the Supabase vector store to ground responses. When a question requires a contact person, looks up employee details in BambooHR by exact name or finds the most senior person in a requested department using an OpenAI-assisted department extraction and ranking step. Returns the final answer to the chat, including policy-based guidance and any retrieved employee contact details. Setup Add BambooHR credentials and ensure your policies/benefits PDFs are available in the BambooHR file category named “
Score and advance job applicants with Airtable, Google Workspace and GPT-4o
Quick Overview This workflow collects job applications via an n8n form, stores CVs in Google Drive, logs applicants in Airtable, and uses OpenAI to score CV-to-role fit. Shortlisted candidates receive an AI-generated questionnaire, a personalized Gmail outreach, an auto-booked Google Calendar phone screen, and saved screening questions. How it works Receives a job application through an n8n form submission, including applicant details and a PDF CV upload. Uploads the CV to Google Drive, builds a normalized applicant record (name, email, phone, experience, CV link), and creates an applicant entry in Airtable. Downloads the stored CV from Google Drive, extracts text from the PDF, and uses an OpenAI-powered agent to score the CV against the job description pulled from Airtable. Updates the applicant’s Airtable record as either “Interviewing” (score ≥ 0.7) or “No hire” (score < 0.7), including the numeric score and short reasoning. For shortlisted candidates, generates five interview questions with OpenAI, presents them in a follow-up n8n form, and saves the candidate’s responses back to Airtable. Uses OpenAI plus Airtable job/candidate context to draft a personalized outreach email, s
WAnswer HR and IT policy questions on Telegram with OpenAI and Postgres PGVector
Quick overview This workflow builds a searchable HR policy knowledge base from a PDF and runs a Telegram helpdesk bot that answers employee questions from that content, handling both text messages and voice notes via OpenAI transcription and retrieval from a Postgres PGVector vector store. How it works Manually runs once to download an HR policy PDF over HTTP and extract its text. Splits the extracted policy text into chunks, generates OpenAI embeddings, and inserts the vectors into a Postgres PGVector store. Triggers on new Telegram messages sent to your bot. Routes incoming Telegram updates by type, sending text directly to the assistant, transcribing voice messages with OpenAI, or replying that other formats are unsupported. Uses an OpenAI chat model with Postgres-backed chat memory and a PGVector retrieval tool to answer questions grounded in the stored policy content. Sends the final answer back to the user in Telegram. Setup Add an OpenAI API key for embeddings, chat completions, and audio transcription. Set up a Postgres database with the PGVector extension enabled and add the Postgres credentials for both the vector store and chat memory. Create a Telegram bot with BotFathe
Review Jira ticket quality with OpenRouter GPT and coaching comments
Quick overview This workflow triggers on new Jira Cloud issues (Story, Bug, or Task), uses OpenRouter (OpenAI model) to score ticket quality across five criteria, and posts an automated coaching comment back to Jira only when the ticket falls below a configurable threshold. How it works Triggers when a new Jira issue is created that matches the selected issue types (Story, Bug, Task). Sets a configurable quality score threshold used to decide whether the ticket needs feedback. Sends the ticket’s type, title, description, and reporter details to an OpenRouter-hosted OpenAI chat model to generate a structured quality evaluation JSON. Parses and validates the model response as JSON and extracts the normalized score, missing criteria, and coaching comment. Checks whether the normalized score is below the configured threshold. If the score is below threshold, adds a formatted coaching comment to the Jira issue; otherwise, it takes no action. Setup Add Jira Software Cloud credentials in n8n and ensure the Jira Trigger can receive issue-created events for your Jira Cloud site. Add an OpenRouter API credential for the OpenRouter chat model used to evaluate ticket quality. Set the SCORE_THR
Generate English–Polish vocabulary quizzes with Google Sheets and Groq
Quick overview Tool useful for any language exams. It is a chat-based workflow that uses Google Sheets in Structure English|your language that using free Groq model (Llama 3.3) generate lists of 10 words that you need to provide answer based on your while model helps How it works Receives a chat message as the trigger input. Checks whether the message contains the word “generate” to decide if it should create a new quiz set or continue the current session. When “generate” is included, reads vocabulary rows (English and your language columns) from a specified Google Sheets range. Randomly shuffles the rows, selects 10 pairs, and formats them as a clean list of {english, your-language} objects. Sends the user message and the selected word pairs to a Groq Llama 3.3 chat model that runs the quiz conversation. Uses a buffer memory window to keep recent chat context so the agent can track which words are answered and which still need guesses. Setup Connect Google Sheets OAuth credentials and set the correct spreadsheet URL, sheet name, and range that contains “English word” and “your language words” columns. Add Groq API credentials and confirm the selected model (llama-3.3-70b-versatile
Create social posts from RSS feeds with OpenAI, Unsplash, and Buffer
Quick overview This workflow polls an RSS feed for new articles, uses OpenAI to generate platform-specific copy for X, LinkedIn, and Instagram, pulls a related random image from the Unsplash API, and creates queued posts in Buffer for each social channel. How it works Runs every hour and reads the latest items from the configured RSS feed. Sends each article title and snippet to OpenAI to generate three ready-to-post messages for X, LinkedIn, and Instagram. Requests a random related image from the Unsplash API using the article title as the search query. Creates an image post in Buffer for X using the generated Twitter text and the Unsplash image URL. Creates an image post in Buffer for LinkedIn using the generated LinkedIn text and the Unsplash image URL. Creates an image post in Buffer for Instagram using the generated Instagram caption and the Unsplash image URL. Setup Add an OpenAI API credential in n8n (or replace the included OpenAI credential) for the OpenAI node. Create a Buffer account, connect your X/Twitter, LinkedIn, and Instagram profiles, and add your Buffer API credential in n8n. Create an Unsplash developer app and replace the client_id value in the HTTP Request URL
Score LinkedIn leads in Google Sheets with Bright Data and Claude
Quick overview This workflow watches a Google Sheets leads sheet, enriches each new lead with LinkedIn person and company data from Bright Data, then uses Anthropic Claude to generate a 0–100 lead score and reason and updates the sheet status to HOT or DONE. How it works Triggers when a new row is added to a Google Sheets worksheet. Reads the leads from the sheet and iterates through the rows that match the configured Status filter. For each lead, uses Bright Data to fetch structured data from the lead’s LinkedIn person profile, then waits briefly to respect rate limits. Uses Bright Data to fetch structured data from the lead’s current company LinkedIn page, then waits briefly to respect rate limits. Sends the person and company details to Anthropic Claude to return a JSON score (0–100) and a one-sentence reason. Parses the JSON response, flags leads with scores ≥ 70 as HOT 🔥 and others as DONE, and writes the enriched fields (title, company, size, location, connections, score, reason) back to Google Sheets. Setup Connect Google Sheets OAuth credentials (Trigger and Google Sheets) and replace YOUR_GOOGLE_SHEET_ID with your spreadsheet ID. Add a Bright Data API credential and ensur
Monitor n8n security advisories from GitHub, NVD, JPCERT and JVN with Claude and Slack
Quick overview This workflow runs hourly to monitor n8n-related security information from GitHub Advisories, NVD (NIST) CVE data, GitHub n8n security release notes, and JPCERT/JVN RSS feeds, then summarizes new findings with Anthropic Claude and posts an alert to Slack. How it works Runs every hour on a schedule. Fetches the latest items from the GitHub Advisory API, the NVD CVE API, the n8n GitHub Releases Atom feed, and the JPCERT and JVN RSS feeds. Parses the XML feeds, normalizes all sources into a single list of n8n-related security items, and removes duplicates and previously notified items using stored IDs. Checks whether any new items were found and stops if there are none. Sends the new items to Anthropic Claude to generate a concise Japanese summary including importance, affected product, and urgency. Formats a Slack Block Kit message and posts the alert to the configured Slack channel. Saves the notified item IDs to workflow static data to prevent repeat notifications in future runs. Setup Create an NVD API key and add it as an HTTP Header Auth credential named (or mapped to) NVD_API_Key with header name apiKey. Add an Anthropic API credential for the Claude model used i
Create blog drafts, images, and LinkedIn posts with Tavily, Gemini, and OpenAI
Quick overview This workflow receives a blog request via webhook, researches the topic with Tavily, generates a long-form HTML article using Google Gemini, creates two images via the kie.ai API, stores assets in Google Drive, updates a Google Sheets tracker, and notifies a Slack user with links. How it works Receives a POST webhook request containing a Google Sheets row payload with an “AI Blog Title” and related metadata. Searches the web for supporting sources using Tavily and passes the research plus the title to Google Gemini to generate the full article as HTML. Converts the generated content to HTML, creates a temporary HTML file in Google Drive, downloads it to set the correct text/html MIME type, re-uploads it as the final Drive file, and deletes the temporary file. Sends the finished article to OpenAI to generate a short LinkedIn post, then updates the matching row in Google Sheets with a Done flag, the article folder/link value, and the LinkedIn post text. Creates a cover image and an in-article infographic by submitting two text-to-image jobs to the kie.ai API, polling until each job succeeds, downloading each resulting image, and uploading both images to Google Drive. W
Send weekly curated news newsletters with Bright Data, Claude, and Gmail
Quick overview This workflow runs every Monday to scrape Google News with Bright Data, fetch and clean the full text of the top five unique stories, generate an HTML newsletter with Anthropic Claude, and send it via Gmail. How it works Runs every Monday on a scheduled trigger. Uses Bright Data to scrape a Google News search results page for the configured topic. Filters out YouTube results, deduplicates by title, and keeps the top five stories. Loops through the five stories and uses Bright Data to scrape each article’s full content as Markdown. Cleans and truncates each article’s text to remove navigation, ads, images, and link clutter. Aggregates the five cleaned articles and sends them to Anthropic Claude to generate a single clean HTML newsletter. Sends the generated HTML newsletter to the configured recipient using Gmail. Setup Add a Bright Data credential and ensure your Web Unlocker zone (for example, n8n_unlocker) is available in your Bright Data account. Add an Anthropic API credential and select the Claude model you want to use. Add a Gmail OAuth2 credential and set the recipient email address, subject, and any desired email options. Update the Google News search URL (the
Analyze Instagram profiles with Apify, Google Gemini, and Supabase
Quick overview This workflow receives an Instagram username via webhook, checks Supabase for a recent cached analysis, and if needed scrapes recent posts with Apify and generates niche, content, and engagement insights using Google Gemini before storing and returning the report. How it works Receives a POST webhook request containing an Instagram username. Queries the Supabase reports table for matching records updated within the last 24 hours and returns the cached analysis_report if found. If no fresh cache exists, runs the Apify Instagram Scraper actor to fetch the latest 5 posts for the requested profile. Cleans and bundles the scraped post data into a compact JSON payload for analysis. Sends the payload to Google Gemini to generate three sub-reports: niche/frequency, content strategy, and engagement/actions. Combines the three Gemini outputs into a single analysis_report object along with the scraped data. Upserts the report into Supabase (update if the username exists, otherwise insert) and returns the fresh analysis_report in the webhook response. Setup Create or select a Supabase project, add Supabase credentials in n8n, and ensure a reports table exists with at least usern
Qualify open house leads and send AI follow-ups with Google Sheets and Gmail
Quick overview When a visitor signs in at your open house, this workflow instantly scores their buying intent using Gemini AI, sends a personalized follow-up email via Gmail, logs every visitor to Google Sheets, and alerts the agent for hot leads only. How it works A visitor signs in via your Google Form at the open house. Their details — name, email, phone, budget, timeline, and buying intent — are captured automatically. AI (Gemini) scores them as Hot, Warm, or Cold based on their responses and drafts a personalized follow-up email in the same step. A tailored thank-you and next-step email sends immediately via Gmail. Every visitor is logged to Google Sheets with their score, reasoning, and message sent. If a lead scores Hot, the agent receives an instant notification email — and optionally a Slack alert — so they can prioritize personal outreach right away. Setup Connect credentials for Google Sheets (trigger and append), Google Gemini (PaLM API), and Gmail (to send visitor follow-ups and agent notifications). Set the Google Sheets Trigger document and sheet to your sign-in responses sheet, and map the expected column headers (Full Name, Email Address, Phone Number, property, bu