Enhance customer chat by buffering messages with Twilio and Redis
This n8n workflow demonstrates a simple approach to improve chat UX by staggering an AI Agent's reply for users who send in a sequence of partial messages and in short bursts. How it works Twilio webhook receives user's messages which are recorded in a message stack powered by Redis. The execution is immediately paused for 5 seconds and then another check is done against the message stack for the latest message. The purpose of this check lets use know if the user is sending more messages or if they are waiting for a reply. The execution is aborted if the latest message on the stack differs from the incoming message and continues if they are the same. For the latter, the agent receives the buffered messages up to that point and is able to respond to them in a single reply. Requirements A Twilio account and SMS-enabled phone number to receive messages. Redis instance for the messages stack. OpenAI account for the language model. Customising the workflow This workflow should work for other common messaging platforms such as Whatsapp and Telegram. 5 seconds too long or too short? Adjust the wait threshold to suit your customers.
By JimleukAnalyze 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
By Fabian PerezTrack website traffic & backlinks with Ahref API and Google Sheets
π Automated Website Traffic Tracker with Google Sheets Logging Track website traffic and backlinks effortlessly using the Website Traffic Checker - Ahref API. This n8n workflow automates data retrieval and logging into Google Sheets, making it perfect for SEO professionals and digital marketers. --- 𧩠What This Workflow Does (Summary) Accepts a domain via a simple web form. Sends the domain to Website Traffic Checker - Ahref API. If successful: Extracts backlink and traffic data. Appends the results to two separate Google Sheets. If failed: Sends an email alert with domain and status code. --- π§ Node-by-Node Explanation | Node | Purpose | | ---------------------------------- | ---------------------------------------------------------------------------------------------------------------- | | π’ Form Trigger | Starts the workflow when a domain is submitted via form. | | π© Set Domain Value | Stores the submitted domain into a variable. | | π HTTP Request | Calls Website Traffic Checker - Ahref API. | | β IF Node | Checks if the API responded with statusCode = 200. | | β Email Node (Fail) | Sends an alert email if API fails. | | π¦ Code (Backlink Info) | Extracts backlink data from API response. | | π Google Sheet: Backlink Info | Appends backlink data to a sheet. | | π¦ Code (Traffic Info) | Extracts traffic data from API response. | | π Google Sheet: Traffic Data | Appends traffic metrics to another sheet. | --- π Google Sheet Columns Backlink Info Sheet | Column | Description | | ------------------ | --------------------------- | | website | Domain submitted | | ascore | Authority score | | referring domain | Number of referring domains | | total backlinks | Total backlinks | --- Traffic Data Sheet | Column | Description | |----------------------|---------------------------------------------| | accuracy | Accuracy level of the traffic data | | bounce_rate | Bounce rate percentage | | desktop_share | Percentage of traffic from desktop devices | | direct | Direct traffic sources | | display_ad | Display ad traffic sources | | display_date | Date when traffic data was captured | | mail | Traffic from email campaigns | | mobile_share | Percentage of traffic from mobile devices | | pagespervisit | Average number of pages per visit | | paid | Paid traffic sources | | prevbouncerate | Bounce rate in the previous period | | prev_direct | Previous period's direct traffic | | prevdisplayad | Previous period's display ad traffic | | prev_mail | Previous period's email traffic | | prevpagesper_visit | Previous period's pages per visit | | prev_referral | Previous period's referral traffic | | prevsearchorganic | Previous organic search traffic | | prevsearchpaid | Previous paid search traffic | | prevsocialorganic | Previous organic social traffic | | prevsocialpaid | Previous paid social traffic | | prevtimeon_site | Previous time spent on site | | prev_users | Number of users in the previous period | | prev_visits | Visits in the previous period | | rank | Global rank of the website | | referral | Referral traffic | | search | Total search traffic | | search_organic | Organic search traffic | | search_paid | Paid search traffic | | social | Total social traffic | | social_organic | Organic social traffic | | social_paid | Paid social traffic | | target | Targeted country or demographic | | timeonsite | Average time spent on site | | unknown_channel | Traffic from unknown sources | | users | Number of unique users | | visits | Total number of visits | --- π How to Configure π Get API Key Go to Website Traffic Checker - Ahref API on RapidAPI. Sign in or create a free RapidAPI account. Subscribe to the API plan. Copy your x-rapidapi-key from the Endpoints tab. π Add Key in n8n Go to your HTTP Request node. Under Headers, set: x-rapidapi-host = website-traffic-checker-ahref.p.rapidapi.com x-rapidapi-key = your API key* --- π How to Setup Google Sheets in n8n Connect a Google account via Google Sheets credentials in n8n. Use the full Google Sheet URL in the documentId field. Set correct Sheet name or GID (e.g., "Traffic Data"). Use Auto Map or Custom Map to define columns. > Make sure your Google Sheet has edit access and headers already created. --- π§ Use Case & Benefits π€ Ideal For: SEO analysts Digital marketers Agencies managing multiple clients Web analytics consultants β Benefits: Fully automated data collection. No manual copy-paste from tools. Real-time insights delivered to Google Sheets. Easy monitoring of backlinks and traffic trends.
By Sk developer View fantasy football roster details with Sleeper API and Telegram chatbot
Sleeper NFL Team Chatbot Starter A Telegram chatbot built to look up your fantasy football team in the Sleeper app and return your roster details, player names, positions, and team info. This starter workflow is perfect for users who want a simple, conversational way to view their Sleeper team in-season or pre-draft. --- What It Does When a user types their Sleeper username into Telegram, this workflow: Extracts the username from Telegram Pulls their Sleeper User ID Retrieves their Leagues and selects the first one (by default) Pulls the full league Rosters Finds the matching roster owned by that user Uses player_ids to look up full player info from a connected database (e.g. Airtable or Google Sheets) Returns a clean list of player names, positions, and teams via Telegram --- Requirements To get this running, youβll need: A Telegram bot (set up through BotFather) A Sleeper Fantasy Football account A synced player database that matches player_id to full player details (we recommend using the companion template: Sleeper NFL Players Daily Sync) --- Setup Instructions Import the workflow into your n8n instance Add the required credentials: Telegram (API Key from BotFather) Airtable (or replace with another database method like Google Sheets or HTTP request to a hosted JSON file) Trigger the workflow by sending your exact Sleeper username to the bot Your full team roster will return as a formatted message > If the user is in multiple Sleeper leagues, the current logic returns the first league found. --- Example Output You have 19 players on your roster: Cam Akers (RB - NO), Jared Goff (QB - DET), ... --- Customization Notes Replace Telegram Trigger with any other input method (webhook, form input, etc.) Replace Airtable node with Google Sheets, SQL DB, or even a local file if preferred You can hardcode a Sleeper username if you're using this for a single user --- Related Templates Sleeper NFL Players Daily Sync (syncs player_id to player name, position, team) -Create Player Sync first then either integrate it to this template or reate a subworkflow from it & use most recent data set. --- Difficulty Rating & Comment (from the author) 3 out of 10 if this ain't you're first rodeo, respectfully. Just a little bit more work on adding the Players Sync as your data table & knowing how to GET from Sleeper. If you use Sleeper for fantasy football, lets go win some games! ---
By Patrick JenningsAutomated appointment approval system with GPT-4 Mini, JotForm, and Telegram
AI Powered All Purpose Appointment System via JotForm What This Workflow Does This template automates the entire appointment request lifecycle using AI. When someone submits an appointment request through JotForm, the system automatically sends details for approval, generates personalized confirmation or rejection emails using OpenAI, and maintains recordsβall without manual intervention. π Get JotForm here Whether you're running a clinic, consulting business, training center, or any service-based operation, this workflow eliminates repetitive email writing and ensures consistent, professional communication. It's fully customizable to work with any appointment form structure. Who's It For Service providers (consultants, trainers, coaches) Healthcare professionals Educational institutions Salon and wellness businesses Event coordinators Any business handling appointment requests at scale How It Works Form Submission β Appointment request arrives via JotForm Data Extraction β System pulls name, email, phone, date, time, and visit type Approval Request β Details are sent to Telegram for review and approval AI Email Generation β OpenAI creates personalized confirmation or rejection email based on approval status Smart Routing β If approved: records in Google Sheets and sends confirmation. If rejected: removes from system and sends reschedule notice Automated Follow-up β Requester receives professional email instantly Getting Started (Quick Setup) Step 1: Choose Your JotForm Select any existing appointment form or create a new one in JotForm The workflow works with any form structure Step 2: Map Your Form Fields Identify the field names in your JotForm (name, email, phone, appointment date, time, etc.) Update the "Parse: Extract Appointment Details" node with your exact field names This ensures the workflow reads data correctly from your specific form Step 3: Follow Full Setup Steps Connect JotForm β Copy the Form ID and API Key Configure Google Sheets β Create a sheet for appointment records and copy the spreadsheet ID Setup Telegram β Create a bot via BotFather for approval notifications Add OpenAI Credentials β Generate an API key at platform.openai.com Authorize Gmail β Enable Gmail API in Google Cloud Console Why This Is Customizable The workflow is built to be flexible from the start. Whether your form collects appointment type, service category, special requests, or any other field, you can easily map those fields into the flow. Just identify what data your form collects and tell the workflow where to find it. Requirements JotForm account with an appointment form Google Sheets for record keeping Telegram account and bot (for approvals) OpenAI API key (paid account recommended) Gmail account for sending emails n8n instance (self-hosted or cloud) How to Customize Change Approval Channel β Replace Telegram with Slack, Discord, or email by swapping the notification node Modify Email Templates β Edit the AI prompt in "Generate: Appointment Response Email" to match your tone and branding Add More Fields β Update the Set node to capture additional information from your JotForm like appointment type, service category, or special requests Adjust Routing Logic β Modify the conditional node to add approval stages or auto-confirm certain appointment types Connect CRM β Add steps to automatically create contacts in HubSpot, Pipedrive, or Salesforce Enable Reminders β Use Gmail or SMS nodes to send appointment reminders 24 hours before scheduled time Extend Data Collection β Map any custom fields from your JotForm by updating the extraction node to include them
By Roshan Ramani