Customer support WhatsApp bot with Google Docs knowledge base and Gemini AI
Document-Aware WhatsApp AI Bot for Customer Support Google Docs-Powered WhatsApp Support Agent 24/7 WhatsApp AI Assistant with Live Knowledge from Google Docs 📝Description Template Smart WhatsApp AI Assistant Using Google Docs Help customers instantly on WhatsApp using a smart AI assistant that reads your company’s internal knowledge from a Google Doc in real time. Built for clubs, restaurants, agencies, or any business where clients ask questions based on a policy, FAQ, or services document. ⚙️ How it works Users send free-form questions to your WhatsApp Business number (e.g. “What are the gym rules?” or “Are you open today?”) The bot automatically reads your company’s internal Google Doc (policy, schedule, etc.) It merges the document content with today’s date and the user’s question to craft a custom AI prompt The AI (Gemini or ChatGPT) then replies back on WhatsApp using natural, helpful language All conversations are logged to Google Sheets for reporting or audit > 💡Bonus: The AI even understands dates inside the document and compares them to today’s date — e.g. if your document says “Closed May 25 for 30 days,” it will say “We're currently closed until June 24. 🧰 Set up steps Connect your WhatsApp Cloud API account (Meta) Add your Google account and grant access to the Doc containing your company info Choose your AI model (ChatGPT/OpenAI or Gemini) Paste your document ID into the Google Docs node Connect your WhatsApp webhook to Meta (only takes 5 minutes) Done — start receiving and answering customer questions! > 📄 Works best with free-tier OpenAI/Gemini, Google Docs, and Meta's Cloud API (no phone required). Everything is modular, extensible, and low-code. 🔄 Customization Tips Change the Google Doc anytime to update answers — no retraining needed Add your logo and business name in the AI agent’s “System Prompt” Add fallback routes like “Escalate to human” if the bot can't help Clone for multiple brands by duplicating the workflow and swapping in new docs 🤝 Need Help Setting It Up? If you'd like help connecting your WhatsApp Business API, setting up Google Docs access, or customizing this AI assistant for your business or clients… 📩 I offer setup, branding, and customization services: WhatsApp Cloud API setup & verification Google OAuth & Doc structure guidance AI model configuration (OpenAI / Gemini) Branding & prompt tone customization Logging, reporting, and escalation logic Just send a message via: Email: tharwat.elsayed2000@gmail.com WhatsApp: +20 106 180 3236
By Tharwat MohamedScrape any web page into structured JSON data with ScrapeNinja and AI
Disclaimer: This template only works on self-hosted for now, as it uses a community node. Use Case Web scrapers often break due to web page layout changes. This workflow attempts to mitigate this problem by auto-generating web scraping data extractor code via LLM. How It Works This workflow leverages ScrapeNinja n8n community node to: scrape webpage HTML, feed it into LLM (Google Gemini) and ask to write a JS extractor function code, then it executes the written JS extractor against scraped HTML to extract useful data from webpage (the code is safely executed in a sandbox) Installation To install ScrapeNinja n8n node, in your self-hosted instance, go to Settings -> Community nodes, enter "n8n-nodes-scrapeninja", and install. Make sure you are using at least v0.3.0. See this in action: https://www.linkedin.com/feed/update/urn:li:activity:7289659870935490560/
By AnthonyCopy viral reels with Gemini AI
Video Guide I prepared a detailed guide that shows the whole process of building an AI tool to analyze Instagram Reels using n8n. [](https://youtu.be/SQPPM0KLsrM) Youtube Link Who is this for? This workflow is ideal for social media analysts, digital marketers, and content creators who want to leverage data-driven insights from their Instagram Reels. It's particularly useful for those looking to automate the analysis of video performance to inform strategy and content creation. What problem does this workflow solve? Analyzing video performance on Instagram can be tedious and time-consuming, requiring multiple steps and data extraction. This workflow automates the process of fetching, analyzing, and recording insights from Instagram Reels, making it simpler for users to track engagement metrics without manual intervention. What this workflow does This workflow integrates several services to analyze Instagram Reels, allowing users to: Automatically fetch recent Reels from specified creators. Analyze the most-watched videos for insights. Store and manage data in Airtable for easy access and reporting. Initial Trigger: The process begins with a manual trigger that can later be modified for scheduled automation. Data Retrieval: It connects to Airtable to fetch a list of creators and their respective Instagram Reels. Video Analysis: It handles the fetching, downloading, and uploading of videos for analysis using an external service, simplifying performance tracking through a structured query process. Record Management: It saves relevant metrics and insights into Airtable, ensuring that users can access and organize their video analytics effectively. Setup Create accounts: Set up Airtable, Edify, n8n, and Gemini accounts. Prepare triggers and modules: Replace credentials in each node accordingly. Configure data flow: Ensure modules are set to fetch and analyze the correct data fields as outlined in the guide. Test the workflow: Run the scenario manually to confirm that data is fetched and analyzed correctly.
By Mark ShcherbakovCheck for bargain flights and get notified using Amadeus and Gmail
What this template does This workflow uses the Amadeus API, every day to check for bargain flights for an itinerary and price target of your choice. It then automatically emails you once it found a match. Setup Create an api account on https://developers.amadeus.com/ In Amadeus Flight Search, connect to Oauth2 API: -- Grant Type - Client Credentials -- Access Token URL - https://test.api.amadeus.com/v1/security/oauth2/token -- Client ID/Secret - from your account Set your details in Gmail Set your desired Origin/Destination airports in FromTo Set the dates ahead you wish to search in Get Dates (default is 7 days and 14 days) Set the price target in Under Price How to test it After completing the setup steps above, just hit 'Test workflow'!
By Jay HartleyBulk emails with personalized attachment
A workflow to send personalized emails with respective attachment. The workflow needs a pre-formatted CSV with file names and email IDs.
By BhavabhuthiAI-powered cold call machine with LinkedIn, OpenAI & Sales Navigator
🔧 AI-Powered Cold Call Machine 🎯 Purpose The AI-Powered Cold Call Machine is a fully automated workflow designed to generate qualified leads from LinkedIn, evaluate them using AI-based scoring, identify key decision-makers, and generate personalized cold call scripts. All results are saved to a Google Sheet-based CRM. --- ⚙️ How It Works Initialization Triggered either manually or via schedule. Pulls configuration from a Google Sheet’s Settings tab (e.g., target product, keywords, company size, API key). Company Search on LinkedIn Uses the Ghost Genius API to search for companies based on cleaned, relevant keywords extracted by OpenAI. Handles pagination, up to 1000 companies per batch. Company Filtering Each company goes through: Data enrichment via Ghost Genius (website, size, followers, etc.). Filtering: Must have a LinkedIn page with a website. Must have 200+ followers. Deduplication: checks if the company already exists in the CRM. AI-Based Company Scoring A specialized AI model scores each company from 0 to 10 based on: Industry fit. Size/location alignment. Potential pain points that match your offering. If the company is new and relevant (score ≥ 7), it is saved in the Companies sheet. Decision Maker Identification Uses Sales Navigator API (via Ghost Genius) to find employees with targeted job titles. For each matching profile: Enriches contact data (title, bio, etc.). Retrieves phone number (if available). Generates a 20-second personalized cold call script using OpenAI, based on company and profile data. Saves all information in the Leads tab of the CRM. If no decision maker is found, the company status is marked accordingly. --- 📈 Outcome A fully enriched, qualified lead database. Custom cold call scripts ready to be used by SDRs or founders. Zero manual work – from search to lead generation, everything is automated. --- 💡 Use Case Perfect for SDRs, founders, or growth marketers looking to scale cold outreach without sacrificing personalization or running into LinkedIn scraping limits. ---
By MatthieuExecute multiple command lines based on text file inputs
This workflow takes a text file as input. It pulls the information from the text file and used it as a parameter to execute a command for each text line. This workflow references a file /home/n8n/filelist.txt in the Read Binary File node which will need to be changed to work properly. You can also edit the Execute Command node to modify what happens for each of these lines of text. Note: This workflow requires the Execute Command node which is only available on the on-premise version of n8n.
By jasonPost new Google Calendar events to Telegram
This n8n workflow automatically sends a Telegram message whenever a new event is added to Google Calendar. It extracts key event details such as event name, description, event creator, start date, end date, and location and forwards them to a specified Telegram chat. This ensures you stay updated on all newly scheduled events directly from Telegram. Prerequisites Before setting up the workflow, ensure the following: Google Account with Google Calendar Access: The Google Calendar API must be enabled. Telegram Bot: Create a bot using BotFather on Telegram. Telegram Chat ID: Retrieve the Chat ID (personal chat or group). Use OAuth2 for Google Calendar and a Bot Token for Telegram. Steps Step 1: Google Calendar Trigger Node (Event Created Event) Click "Add Node" and search for Google Calendar. Select "Google Calendar Trigger" and add it to the workflow. Authenticate with your Google Account. Select "Event Created" as the trigger type. Choose the specific calendar to monitor. Click "Execute Node" to test the connection. Click "Save". Step 2: Telegram Node (Send Message Action) Click "Add Node" and search for Telegram. Select "Send Message" as the action. Authenticate using your Telegram Bot Token. Set the Chat ID (personal or group chat). Format the message using details from Google Calendar Trigger and set the message in text. Click "Execute Node" to test. Click "Save". Step 3: Connect & Test the Workflow Link Google Calendar Trigger → Telegram Send Message. Execute the workflow manually. Create a test event in Google Calendar. Check Telegram to see if the event details appear. n8n Workflow Created by WeblineIndia This workflow is built by the AI development team at WeblineIndia. We help businesses automate processes, reduce repetitive work, and scale faster. Need something custom? You can hire AI developers to build workflows tailored to your needs.
By WeblineIndiaCreate new Clickup tasks from Slack commands
Create new Clickup Tasks from Slack commands This workflow aims to make it easy to create new tasks on Clickup from normal Slack messages using simple slack command. For example We can have a slack command as /newTask Set task to update new contacts on CRM and assign them to the sales team This will have an new task on Clickup with the same title and description on Clickup For most teams, getting tasks from Slack to Clickup involves manually entering the new tasks into Clickup. What if we could do this with a simple slash command? Step 1 The first step is to Create an endpoint URL for your slack command by creating an events API from the link [below] https://api.slack.com/apps/) STEP 2 Next step is defining the endpoint for your URL Create a new webhook endpoint from your n8n with a POST and paste the endpoint URL to your event API. This will send all slash commands associated with the Slash to the desired endpoint Step 3 Log on to slack API (https://api.slack.com/) and create an application. This is the one we use to run all automation and commands from Slack. Once your app is ready, navigate to the Slash Commands and create a new command This will include the command, the webhook URL and a description of what the slash command is all about Now that this is saved you can do a test by sending a demo task to your endpoint Once you have tested the webhook slash command is working with the webhook, create a new Clickup API that can be used to create new tasks in ClickUp This workflow creates a new task with the start dates on Clikup that can be assigned to the respective team members More details about the document setup can be found on this document below Happy Productivity
By Zacharia KimothoAutomated LinkedIn job hunter: get your best daily job matches by email
Overview This n8n template automates the tedious process of searching for jobs on LinkedIn. By integrating with tools for web scraping and leveraging AI (Google Gemini) for intelligent matching, this workflow delivers a curated list of the top 5 most relevant job opportunities published within past 24h directly to your inbox daily, based on your unique resume and preferences.The cost is only 0.1 USD per day and there is no subscription needed. Who is this for? This template is ideal for: Active job seekers wanting to save time and effort. Professionals looking to discreetly monitor relevant new opportunities. Individuals seeking a highly personalized job feed tailored to their resume and preferences. Anyone overwhelmed by manual job searching on LinkedIn. What is Included: n8n Workflow Template: The complete workflow file (.json) ready to import into your n8n instance. Video Guidance: A step-by-step video walkthrough showing you exactly how to set up and configure the workflow. What problem is this workflow solving? Finding the right job on LinkedIn can be overwhelming and time-consuming. Sifting through hundreds of listings, tailoring searches, and checking daily takes significant effort. This workflow solves the problem of manual, repetitive job searching by automating the discovery and filtering process, ensuring you see the most relevant opportunities without the daily grind and reducing the risk of missing out on your ideal role. What this workflow does: This workflow automates the following steps: Scheduled Job Fetching: Runs automatically (default: daily at 8 AM) to find the latest jobs. Resume Processing: Downloads your resume (PDF) from Google Drive and extracts the text content. Targeted LinkedIn Scraping: Uses Apify to scrape recent job listings from LinkedIn based on your custom search URL. AI-Powered Matching: Employs an AI agent (Google Gemini) to analyze scraped jobs against your resume text and specified preferences. Top 5 Ranking & Selection: Identifies and ranks the opportunities, selecting the 5 best matches for you. Personalized Email Reporting: Generates and sends a detailed HTML email containing the top 5 jobs, including company name, job title, industry, a personalized reason for the match, and a direct application link. Setup: Follow these steps to configure the workflow: Core Connections: Connect your Google Drive and Gmail accounts to n8n via the Credentials section. Ensure your n8n environment has access/credentials configured for the AI model used by the AI Agent node (e.g., Google Gemini). Apify Integration: Sign up for an Apify account (apify.com) and obtain your API key. Action: In the Input node, paste your Apify API Key into the Value field for the ApifyAPIKey assignment. Resume Setup: Upload your current resume in PDF format to your Google Drive. Action: Find the File ID of the uploaded resume in Google Drive (part of the shareable link). Paste this File ID into the File ID parameter within the DownloadResume (Google Drive) node. LinkedIn Search Definition: Go to LinkedIn Jobs (www.linkedin.com/jobs/search/) using an incognito/private browser window to ensure you get a public URL. Apply all your desired filters (keywords, location, date posted, job type, industry, etc.). Copy the complete URL from your browser's address bar. Action: In the ScrapeLinkedin (HTTP Request) node, navigate to the Body > JSON parameter. Replace the example URL within the urls array [ "YOURLINKEDINSEARCHURLHERE" ] with the URL you just copied. Make sure the URL is enclosed in double quotes. Personalization Inputs: Action: Go to the Input node: In the Preference assignment, replace the example text in the Value field with your detailed job preferences (e.g., "Seeking remote Data Scientist roles in SaaS companies with less than 1000 employees, strong preference for Python/ML focus"). In the EmailAddressToReceiveJobRecommendations assignment, enter the email address where you want to receive the daily job list in the Value field. Email Sender Configuration: Action: In the Email the top job recommendations (Gmail) node, ensure the correct Gmail credential (the account you want to send emails from) is selected. How to customize this workflow: Run Schedule: Modify the settings in the Schedule Trigger node to change the time or frequency (e.g., twice daily, weekly). Job Search Criteria: Update the LinkedIn search URL in the ScrapeLinkedin node whenever you want to target different roles, industries, or locations. Matching Preferences: Refine the text in the Preference field within the Input node to guide the AI's matching process more accurately. AI Behavior: Advanced users can adjust the system prompt within the AI Agent: Find Best-matched jobs node to change how the AI analyzes or presents information (ensure the output structure still matches the Structured Output Parser and email node expectations). Number of Jobs Scraped: Change the count value (e.g., from 100) in the JSON Body of the ScrapeLinkedin node. Note that higher numbers may increase Apify costs/usage. Number of Jobs Emailed: To change the number of recommendations (e.g., top 3 or top 10), you'll need to: Modify the AI prompt in the AI Agent: Find Best-matched jobs node to request the desired number. Adjust the Structured Output Parser node's example/schema if needed. Update the HTML code in the Email the top job recommendations node to correctly loop through and display the new number of jobs. Email Appearance: Edit the HTML within the Message field of the Email the top job recommendations node to customize the email's style, colours, or layout. Category: Job Search, Automation, AI, Productivity, Career Management
By TianyiAutomate SAP Business Partner analysis with OpenAI GPT-4o & Gmail reporting
Who is this for? This workflow is intended for micro businesses, SAP users, companies, users or owners who need system simplicity in SAP. In micro businesses, SAP users or individuals, there must be the task of manually inputting a lot of data or here in partner businesses in SAP, the reality is that it is very time consuming and tiring, especially since we have to arrange it first or click one by one and send it. This is also a form of community service in n8n and n8n companies, as well as dedication to small businesses using SAP, SAP users, companies or owners who use SAP so that reality is no longer tiring and is able to answer existing reality problems automatically. How it works? Easy explanation: The First Manual Trigger Node is used when clicking to start the program running. It's like starting by clicking the button first. After that the HTTP Request will be sent to the next node, here containing SAP. After that, each function will program and process it into clean data. Then after that it will be sent to Gmail via the Gmail node. The AI Agent will carry out the task of reporting, analyzing and sending it via Gmail, here using model Open AI. You can immediately see the data thoroughly, because the data has been processed. If you want to process it again, just direct the AI system to process it again. And all duties and responsibilities have been completed Very practical and easy, plus its automatic nature. I'm sure you can understand it wisely. Set up instructions Complete what is in the nodes as stated in the notes column. Because the other nodes have been set up neatly, what you have to set up is, first, you have to connect the Gmail and Open AI "Credential Accounts" only. After that, enter the email address you want to send or receive in the Gmail node parameters. Well, it's very simple. Everything is organized wisely, so you just follow the notes or setup instructions provided, or you can add other things according to your specific purpose and congratulations you are ready to use it. Requirements As a reminder: It must be arranged in nodes, what your business description looks like, also according to the conditions of your small business, so that the AI Agent matches your business knowledge base. Must have (if not, make sure you are registered) in each "Credential Account" by following the guide on how to do it n8n the guide is very complete. Don't forget to save, and make sure the workflow is active and don't forget about "Account Credentials". How to customize this workflow to your needs You can directly organize your business knowledge base in these nodes, so that according to your business in its field and what services it sells or has or here is your business partner, you can then carry out tasks and answer them.
By Ghufran RidhawiAutomated email assistant for suppliers using OpenAI and Google Sheets
Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. How It Works The user makes a request (e.g., “Send an email to my fruit supplier asking for a quote on 1 crate of mangoes.”). Workflow: The AI agent searches for the supplier in a Google Sheets database. It automatically drafts the email using OpenAI (with the tone and style you define). It sends the email using your Gmail account connected through n8n. This assistant uses: Google Sheets to manage your suppliers (name and email). OpenAI to generate clear, natural messages. MCP (client-server logic) to handle request processing. Gmail as the sending channel for automated emails. Setup Instructions Create a Google Sheets document with the supplier name and email, like this: |Supplier name|Email| |-|-| |Proveedor de frutas Alvarez|fruteriaalvarez@alvarez.com| Connect your Google Sheets and Gmail accounts within n8n. Add your OpenAI API key. Test the automation by chatting with the integrated assistant. It will generate and send the email automatically to the indicated supplier. Requirements OpenAI API key to generate email content. Gmail account connected via OAuth2. Google Sheets document with your supplier database. n8n instance (cloud or self-hosted). Customization Adjust the OpenAI prompt to make the email tone more formal, casual, or technical. Add custom fields to your supplier sheet (location, notes, special conditions). Replace Google Sheets with a real database like Supabase or PostgreSQL for greater scalability.
By Omar Hdez