Telegram and Google Sheets integration

Who’s it for This template is designed for anyone who wants to use Telegram as a personal AI assistant hub. If you often juggle tasks, emails, calendars, and expenses across multiple tools, this workflow consolidates everything into one seamless AI-powered agent. What it does Jarvis listens to your Telegram messages (text or audio) and processes them with OpenAI. Based on your request, it can:

Who Is This For? 🚘This workflow is designed for auto service / car repair businesses looking to streamline their social media marketing with Ai tools and automation via n8n. Whether you’re a small garage owner, a car repair shop, an automotive specialist or automechanic - this tool helps you maintain an active online presence without spending hours creating content. 💪🏼 Though this template is set up for Auto Service daily content uploads, but the underlying logic is universal. You can easily adapt it for any niche by editing prompts, adding nodes, and creating or uploading a variety of content to any platform. You can use any LLM and generative AI of your choice. Personally, I prefer the smooth and effective results from ChatGPT 4.1 combined with GPT Image 1. But you can generate videos instead of images for your posts as well 😉 What Problem Is This Workflow Solving? 🤦‍♂️ Many auto service businesses struggle with consistently posting engaging content due to time constraints or lack of marketing expertise. 💎This workflow solves that by automating the content creation and posting process, ensuring your social media channels stay fresh and active, ultimately attracting more customers. What This Workflow Does: Generates daily social media posts tailored specifically to the auto service niche using AI. Allows easy customization of post and image prompts. Integrates research links through the Tavily Internet Search tool for relevant content. Supports starting posts based on reference article links via Google Sheets. Automatically publishes posts to your connected social media platforms. Enables scheduled or trigger-based posting for maximum flexibility. How It Works? Easy, actually ☺️ AI creates daily social media content made just for Auto Service. You can simply edit prompts for both posts and images, set up news or articles research links via the Tavily Internet Search tool. You can also start the workflow with a reference article link through Google Sheets. 🎯 Consistently posting relevant and actual niche content helps attract new customers, all while leveraging AI and n8n tools to keep the process seamless and cost-effective. Set Up Steps: I kept it quick and simple for you ✨ If you’re happy with the current LLM and image model configurations, just connect your OpenAI API credentials to enable AI content generation. Link your social media accounts (Facebook, Telegram, X, etc.) for autoposting. Optionally connect Google Sheets if you want to trigger posts based on sheet updates with reference links. Customize prompts as needed to match your brand voice, style and marketing tasks. Choose between: 1) Scheduled automatic generation and posting at the same time as socials algorythms like it. 2) Google Sheets trigger with reference. 3) Manual start. How to Customize This Workflow to Your Needs? Switch AI models and edit prompts to better reflect your specific services or promotions. Add or modify research links in Tavily to keep your posts timely and relevant. Adjust posting schedules to match peak engagement times for your audience. Expand or reduce the number of social platforms integrated depending on your marketing strategy. Use Google Sheets to batch upload ideas or curate specific content topics. After adjusting a few settings, activate the workflow and let it run. 🤖 The system will then automatically publish your content across your selected social platforms — saving you time and effort. 📌 You’ll find more detailed tips and additional ai models for customizing ai generation process inside the workflow via sticky notes. 💬 Need help? For additional guidance, feel free to message me — here’s my profile in the n8n community for direct contact 👈 click!

💥 Automate Scrape Google Maps Business Leads (Email, Phone, Website) using Apify 🧠 AI-Powered Business Prospecting Workflow (Google Maps + Email Enrichment) Who is this for? This workflow is designed for entrepreneurs, sales teams, marketers, and agencies who want to automate lead discovery and build qualified business contact lists — without manual searching or copying data. It’s perfect for anyone seeking an AI-driven prospecting assistant that saves time, centralizes business data, and stays fully compliant with GDPR. What problem is this workflow solving? Manually searching for potential clients, copying their details, and qualifying them takes hours — and often leads to messy spreadsheets. This workflow automates the process by: Gathering publicly available business information from Google Maps Enriching that data with AI-powered summaries and contact insights Compiling it into a clean, ready-to-use Google Sheet database This means you can focus on closing deals, not collecting data. What this workflow does This automation identifies, analyzes, and organizes business opportunities in just a few steps: Telegram Trigger → Send a message specifying your business type, number of leads, and Google Maps URL. Apify Integration → Fetches business information from Google Maps (public data). Duplicate Removal → Ensures clean, non-redundant results. AI Summarization (GPT-4) → Generates concise business summaries for better understanding. Email Extraction (GPT-4) → Finds and extracts professional contact emails from company websites. Google Sheets Integration → Automatically stores results (name, category, location, phone, email, etc.) in a structured sheet. Telegram Notification → Confirms when all businesses are processed. All data is handled ethically and transparently — only from public sources and without any unsolicited contact. Setup Telegram Setup Create a Telegram bot via BotFather Copy the API token and paste it into the Telegram Trigger node credentials. Apify Setup Create an account on Apify Get your API token and connect it to the “Run Google Maps Scraper” node. Google Sheets Setup Connect your Google account under the “Google Maps Database” node. Specify the target spreadsheet and worksheet name. OpenAI Setup Add your OpenAI API key to the AI nodes (“Company Summary Info” and “Extract Business Email”). Test Send a Telegram message like: restaurants, 5, https://www.google.com/maps/search/restaurants+in+Paris How to customize this workflow to your needs Change search region or business type** by modifying the Telegram input message format. Adjust the number of leads** via the maxCrawledPlacesPerSearch parameter in Apify. Add filters or enrichments** (e.g., websites with social links, review counts, or opening hours). Customize AI summaries** by tweaking the prompt inside the “Company Summary Info” node. Integrate CRM tools** like HubSpot or Pipedrive by adding a connector after the Google Sheets node. ⚙️ Expected Outcome ✅ A clean, enriched, and ready-to-use Google Sheet of businesses with: Name, category, address, and city Phone number and website AI-generated business summary Extracted professional email (if available) ✅ Telegram confirmation once all businesses are processed ✅ Fully automated, scalable, and GDPR-compliant prospecting workflow 💡 This workflow provides a transparent, ethical way to streamline your B2B lead research while staying compliant with privacy and anti-spam regulations. 🎥 Watch This Tutorial 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n

📥 Invoice Intake & Notification Workflow This automated n8n workflow monitors a Google Drive folder for newly uploaded invoice PDFs, extracts essential information (like client name, invoice number, amount, due date), logs the data into a Google Sheet for recordkeeping, and sends a formatted Telegram message to notify the billing team. For step-by-step video build of workflows like this: https://www.youtube.com/@automatewithmarc ✅ What This Workflow Does 🕵️ Watches a Google Drive folder for new invoice files 📄 Extracts data from PDF invoices using AI (LangChain Information Extractor) 📊 Appends extracted data into a structured Google Sheet 💬 Notifies the billing team via Telegram with invoice details 🤖 Optionally uses Claude Sonnet AI model to format human-friendly summaries ⚙️ How It Works – Step-by-Step Trigger: Workflow starts when a new PDF invoice is added to a specific Google Drive folder. Download & Parse: The file is downloaded and its content extracted. Data Extraction: AI-powered extractor pulls invoice details (invoice number, client, date, amount, etc.). Log to Google Sheets: All extracted data is appended to a predefined Google Sheet. AI Notification Formatting: An Anthropic Claude model formats a clear invoice notification message. Telegram Alert: The formatted summary is sent to a Telegram channel or group to alert the billing team. 🧠 AI & Tools Used Google Drive Trigger & File Download PDF Text Extraction Node LangChain Information Extractor Google Sheets Node (Append Data) Anthropic Claude (Telegram Message Formatter) Telegram Node (Send Notification) 🛠️ Setup Instructions Google Drive: Set up OAuth2 credentials and specify the folder ID to watch. Google Sheets: Link the workflow to your invoice tracking sheet. Telegram: Set up your Telegram bot and obtain the chat ID. Anthropic & OpenAI: Add your Claude/OpenAI credentials if formatting is enabled. 💡 Use Cases Automated bookkeeping and invoice tracking Real-time billing alerts for accounting teams AI-powered invoice ingestion and summary

++HOW IT WORKS:++ This workflow automates the processing of invoices sent via Telegram. It extracts the data using LlamaIndex OCR, logs it in Google Sheets, and optionally pushes the structured data to SAP Business One 🔹 1. Receive Invoice via Telegram:** A user sends a PDF of an invoice through Telegram A Telegram Trigger node listens for incoming messages and captures the file and metadata The document is downloaded and prepared for OCR 🔹 2. OCR with LlamaIndex: The file is uploaded to the LlamaIndex OCR API. The workflow polls the API until the processing status returns SUCCESS Once ready, the parsed content is fetched in Markdown format 🔹 3. Data Extraction via LLM (editable): The Markdown content is sent to a language model (LLM) using LangChain A Structured Output Parser transforms the result into a clean, structured editable JSON 🔹 4. Save to Google Sheets: The structured JSON is split into: Header (main invoice metadata) Detail (individual line items) Each part is stored in a dedicated tab within a connected Google Sheets file 🔹 5. Ask for SAP Confirmation: The bot replies to the user via Telegram: "Do you want to send the data to SAP?" If the user clicks "Yes", the next automation path is triggered. 🔹 6. Push Data to SAP B1: A connection is made to SAP Business One's Service Layer API Header and detail data are fetched from Google Sheets The invoice structure is rebuilt as required by SAP (DocumentLines, CardCode, etc.) A POST request creates the Purchase Invoice in SAP A confirmation message with the created DocEntry is sent back to the user on Telegram ++SET UP STEPS:++ Follow these steps to properly configure the workflow before execution: 1️⃣ Create Required Credentials: Go to Credentials > + New Credential and create the following: Telegram API (set your bot token get it from BotFather) Google Sheets OpenAI 2️⃣ Set Up Environment Variables (Optional but Recommended): LLAMAINDEX_API_KEY SAP_USER SAP_PASSWORD SAP_COMPANY_DB SAP_URL 3️⃣ Prepare Google Sheets: Ensure your Google Spreadsheet has the following: ➤ Sheet 1: Header ➤ Sheet 2: Details Contains columns for invoice lines

Convert YouTube videos to viral Shorts with Klap and auto-post with Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes and requires a self-hosted n8n instance. Who is this for? This workflow is perfect for content creators, YouTubers, marketing teams and entrepreneurs who want to effortlessly convert long YouTube videos into short, viral-ready clips and publish them automatically on TikTok, Instagram, YouTube Shorts and other platforms. What problem is this workflow solving? Manually creating short, engaging clips from YouTube videos takes hours: Selecting highlights Adding subtitles and effects Downloading and editing Posting individually on each platform This workflow eliminates all of that: AI-powered Shorts generation with Klap Smart scheduling based on your posting calendar Full automation of uploads to multiple platforms What this workflow does From a simple YouTube link sent via Telegram, the workflow: Extracts the YouTube URL and number of Shorts requested Sends the video to Klap for AI-powered Shorts generation Checks when the Shorts are ready Schedules publication times based on your custom settings Uploads the Shorts to Blotato Auto-posts on TikTok, YouTube Shorts, Instagram and more Sends a confirmation recap to Telegram Setup Connect your Telegram bot to the trigger node Add your Klap API key for video processing Link your Google Sheets with your scheduling preferences Add your Blotato API key and social platform IDs Adjust the number of Shorts generated if needed Modify the scheduling logic or time windows in the Google Sheets How to customize this workflow to your needs Change AI video settings in the Klap API request Adjust time windows and frequency in the scheduling nodes Limit the workflow to specific platforms (e.g., TikTok only) Add a manual approval step before publishing Modify the Telegram recap message content 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

Description Track and query your expenses effortlessly through Telegram using voice or text messages. This AI-powered workflow transcribes voice input via AssemblyAI, processes transactions with a GPT-4.1 mini agent, stores data in Google Sheets with comprehensive timestamp metadata, and responds with both voice and text confirmations. Key Features: Multi-modal input:** Send expenses via voice messages or text Intelligent processing:** AI agent automatically categorizes transactions, calculates running balance, and handles multiple expenses in a single message Conversational queries:** Ask questions like "What did I spend on food last week?" Voice responses:** Get spoken confirmations using OpenAI TTS Smart alerts:** Automatic Gmail notifications for low balance thresholds Cost tracking:** Monitors and logs all API usage costs (LLM + TTS) in USD and INR Perfect for: Personal finance management with minimal effort Small business expense tracking with audit trails Shared household or team budgets API cost monitoring for developers Each transaction includes detailed metadata (timestamps, categories, run IDs, source text) enabling powerful time-based analytics and queries. Requirements: Telegram bot, Google Sheets OAuth, OpenAI API key, AssemblyAI API key, Gmail OAuth (optional) Support: Join n8n Discord or Community Forum README file available at https://drive.google.com/file/d/1mh9FRm7zemdazNpjyEq9uhHSc_9go7PN/view?usp=sharing

Monitor Indian (NSE/BSE) and US stock markets with intelligent price alerts, cooldown periods, and multi-channel notifications (Email + Telegram). Automatically tracks price movements and sends alerts when stocks cross predefined upper/lower limits. Perfect for day traders, investors, and portfolio managers who need instant notifications for price breakouts and breakdowns. How It Works Market Hours Trigger - Runs every 2 minutes during market hours Read Stock Watchlist - Fetches your stock list from Google Sheets Parse Watchlist Data - Processes stock symbols and alert parameters Fetch Live Stock Price - Gets real-time prices from Twelve Data API Smart Alert Logic - Intelligent price checking with cooldown periods Check Alert Conditions - Validates if alerts should be triggered Send Email Alert - Sends detailed email notifications Send Telegram Alert - Instant mobile notifications Update Alert History - Records alert timestamps in Google Sheets Alert Status Check - Monitors workflow success/failure Success/Error Notifications - Admin notifications for monitoring Key Features: Smart Cooldown**: Prevents alert spam Multi-Market**: Supports Indian & US stocks Dual Alerts**: Email + Telegram notifications Auto-Update**: Tracks last alert times Error Handling**: Built-in failure notifications Setup Requirements: Google Sheets Setup: Create a Google Sheet with these columns (in exact order): A**: symbol (e.g., TCS, AAPL, RELIANCE.BSE) B**: upper_limit (e.g., 4000) C**: lower_limit (e.g., 3600) D**: direction (both/above/below) E**: cooldown_minutes (e.g., 15) F**: last_alert_price (auto-updated) G**: last_alert_time (auto-updated) API Keys & IDs to Replace: YOUR_GOOGLE_SHEET_ID_HERE - Replace with your Google Sheet ID YOUR_TWELVE_DATA_API_KEY - Get free API key from twelvedata.com YOUR_TELEGRAM_CHAT_ID - Your Telegram chat ID (optional) [email protected] - Your sender email [email protected] - Alert recipient email Stock Symbol Format: US Stocks**: Use simple symbols like AAPL, TSLA, MSFT Indian Stocks**: Use .BSE or .NSE suffix like TCS.NSE, RELIANCE.BSE Credentials Setup in n8n: Google Sheets**: Service Account credentials Email**: SMTP credentials Telegram**: Bot token (optional) Example Google Sheet Data: symbol upper_limit lower_limit direction cooldown_minutes TCS.NSE 4000 3600 both 15 AAPL 180 160 both 10 RELIANCE.BSE 2800 2600 above 20 Output Example: Alert: TCS crossed the upper limit. Current Price: ₹4100, Upper Limit: ₹4000.

Automated B2B Lead Generation from Google Maps to Google Sheets using BrowserAct This n8n template automates local lead generation by scraping Google Maps for businesses, saving them to Google Sheets, and notifying you in real-time via Telegram. This workflow is perfect for sales teams, marketing agencies, and local B2B services looking to build targeted lead lists automatically. Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. How it works The workflow is triggered manually. You can set the Location, Bussines_Category, and number of leads (Extracted_Data) in the first BrowserAct node. A BrowserAct node ("Run a workflow task") initiates the scraping job on Google Maps using your specified criteria. A second BrowserAct node ("Get details of a workflow task") pauses the workflow and waits for the scraping task to be 100% complete. A Code node takes the raw JSON string output from the scraper and correctly parses it, splitting the data into individual items (one for each business). A Google Sheets node appends or updates each lead into your spreadsheet, matching on the "Name" column to prevent duplicate entries. Finally, a Telegram node sends a message with the new lead's details to your specified chat, providing instant notification. Requirements BrowserAct** API account for web scraping BrowserAct* "Google Maps Local Lead Finder*" Template BrowserAct** n8n Community Node -> (n8n Nodes BrowserAct) Google Sheets** credentials for saving leads Telegram** credentials for sending notifications Need Help? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates How to Use the BrowserAct N8N Community Node Workflow Guidance and Showcase AUTOMATE Local Lead Generation: Google Maps to Sheets & Telegram with n8n

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🧠 Perplexity-Powered Daily AI News Digest (via Telegram) This ready-to-deploy n8n workflow automates the entire process of collecting, filtering, formatting, and distributing daily AI industry news summaries directly to your Telegram group or channel. Powered by Perplexity and OpenAI, it fetches only high-signal AI updates from trusted sources (e.g. OpenAI, DeepMind, HuggingFace, MIT Tech Review), filters out duplicates based on a Google Sheet archive, and delivers beautifully formatted news directly to your team — every morning at 10AM. For more such build and step-by-step tutorials, check out: https://www.youtube.com/@Automatewithmarc 🚀 Key Features: Perplexity AI Integration: Automatically fetches the most relevant AI developments from the last 24 hours. AI Formatter Agent: Cleans the raw feed, removes duplicates, adds summaries, and ensures human-friendly formatting. Google Sheets Log: Tracks previously reported news items to avoid repetition. Telegram Delivery: Sends a polished daily digest straight to your chat, ready for immediate team consumption. Customizable Scheduling: Preconfigured for daily use, but can be modified to fit your team's preferred cadence. 💼 Ideal For: Anyone who wants to stay ahead of fast-moving AI trends with zero manual effort 🛠️ Tech Stack: Perplexity AI OpenAI (GPT-4 or equivalent) Google Sheets Telegram API ✅ Setup Notes: You’ll need to connect your own OpenAI, Perplexity, Google Sheets, and Telegram credentials. Replace the Google Sheet ID and Telegram channel settings with your own.

Automated AI Content Publisher This n8n workflow is your all-in-one solution for automated content creation and publishing. It intelligently crafts unique articles in Thai, generates captivating AI images, and seamlessly publishes them to your website while notifying you via Telegram. Say goodbye to manual content pipelines and hello to effortless, AI-driven publishing. How It Works This workflow kicks off when new news data hits your designated Google Sheet, then it springs into action: Smart Image Selection: An AI analyzes your news content to decide if a general photorealistic image or a more artistic, risoprint-style AI image is the best fit. Article Generation: Another AI drafts a high-quality, long-form article in flawless Thai, adapting its format (listicle or analytical) to perfectly suit the topic. SEO & Marketing Boost: A specialized AI then optimizes your content by generating concise titles, engaging excerpts, and relevant tags in both Thai and English. It also creates the perfect prompts for image generation. AI Image Creation: Leveraging Google Gemini, the workflow generates stunning visuals, producing either photorealistic or artistic risoprint-style images based on the AI's prompts. Seamless Publishing: Your newly created article, complete with its AI-generated image and all metadata, is automatically posted to your website. Instant Notifications: You'll get a quick ping on Telegram with a summary of the new post, so you're always in the loop. Setup To get this workflow up and running, you'll need to configure a few things: Google Sheet: Link your Google Sheet and specify the sheet name and the column containing your news description. Ollama: Set up your Ollama API credentials to connect the workflow to your local or remote Ollama instance. Google Gemini API: Provide your Google Gemini API key to enable AI image generation. Website API: Create a credential for your website, including its posting URL, an API Key for authentication, and your desired user_id and username for posts. You can also add optional fields like bgColor, LinkAff, postType, and embeddedContent here. Telegram: Set up your Telegram API credential with your bot token and the chatId where you want to receive notifications.

Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes and must be run on a self-hosted instance of n8n. Who is this for? This template is perfect for social media managers, content creators, AI enthusiasts, and automation pros who want to generate short-form videos (Reels) from a simple Telegram message, then publish them across multiple platforms—all without video editing or manual uploads. What problem is this workflow solving? Creating content is only half the job. The real bottleneck comes in: Rendering the video, Adding voice or music, Writing captions and titles, Publishing to multiple platforms. This workflow automates all of that using AI. It saves hours every week and guarantees consistent output. What this workflow does This end-to-end automation handles everything from AI video generation to social publishing: Starts with a Telegram message (text or image prompt) Generates video using Kling or Blotato, based on the input Creates music with Piapi and merges it with the video Generates text overlays and captions with GPT-4 Builds a stylized video using JSON2Video Logs results to Google Sheets Sends final output back to Telegram Auto-posts the video to 9 platforms via Blotato (Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Twitter/X, Pinterest, Bluesky) Setup Connect your Telegram bot to the trigger node. Add your OpenAI API key for all GPT nodes. Set up Kling and Piapi API access (for video and music generation). Connect your Cloudinary account to upload images. Link a Google Sheet with columns: Title, Caption, URL. Set your Blotato API key and fill in the platform-specific account IDs. How to customize this workflow to your needs Change prompt formatting** to control GPT responses and video tone. Edit text styling** in JSON2Video to match your brand. Add a Telegram approval step** before publishing, if needed. Disable platforms** you don’t use by deleting their HTTP Request nodes. Use a Google Sheet filter** to only process new rows or drafts. 📄 Documentation: Notion Guide

Overview This n8n templates helps you to authomatically search Linkeding jobs. It uses AI (Gemini or OpenAPI) to match your resume with each job description and write a sample cover letter for each job and update the job google sheet. You can receive daily matched linkedin job alerts by telegram. Prerequisites AI API Key from one model like: Google Gemini OpenAI Telegram Bot Token - Create via @BotFather Google Sheets - OAuth2 credentials Google Drive - OAuth2 credentials Setup Upload your resume Upload your CV in PDF format in google drive and configure google drive node to read your resume from list of google drive files. You need to configure Google Drive OAuth2 and grant access to your drive before that. You can find useful infomration about how to configure Googel OAuth2 API key in n8n documents. Create Google sheet You need to create a google sheet document consist of two sheets, one sheet for define job filter criteria and second sheet to store job search result. You can download this Google Sheet Template and copy in your personal space. Then you can add your job filter in Google sheet. You can search job by keywords, location, remote type, job type and easy apply. You need to configure Google Sheet OAuth2 and grant access to your drive before that. Conifgure Telegram Bot You need to create a new Telegram Bot in @BotFather and insert API Key in Telegram node and you need to TELEGRAM_CHAT_ID to your telegram ID.

🤖 Interactive Academic Chatbot (Telegram + MongoDB) Overview 📋 This project is a template for building a complete academic virtual assistant using n8n. It connects to Telegram, answers frequently asked questions by querying MongoDB, keeps the community informed about key dates (via web scraping), and collects user feedback for continuous improvement. How It Works Architecture and Workflow ⚙️ n8n: Orchestration of 3 workflows (chatbot, scraping worker, announcer). Telegram: Frontend for user interaction and sending announcements. MongoDB: Centralized database for FAQs, academic calendar, and feedback logs. Web Scraping: HTTP Request and HTML Extract nodes to read the university's web calendar. Cron: For automatic periodic executions (daily and weekly). Core Processes 🧠 Real-time reception of user queries via Telegram. Querying MongoDB collections for FAQ answers and calendar dates. Daily scraping of the university website to keep the calendar updated. Instant logging of user feedback (👍/👎) in MongoDB. Proactive sending of weekly announcements to the Telegram channel. Key Benefits ✅ Complete automation of student communication 24/7. An always-accurate academic calendar database without manual intervention. A built-in continuous improvement system through user feedback. Proactive communication of important events to the entire community. Use Cases 💼 Automation of student support in universities, colleges, and institutions. A virtual assistant for any organization needing to manage FAQs and a dynamic calendar. An automated announcements channel to keep a community informed. Requirements 👨‍💻 n8n instance (self-hosted or cloud). Credentials for a Telegram Bot (obtained from @BotFather). Credentials for a MongoDB database (Connection URI). URL of the academic calendar to be scraped. Authors 👥 Doménica Amores Nicole Guevara Adrián Villamar Mentor: Jaren Pazmiño Applicants to the CIAP Polytechnic Artificial Intelligence Club

Social Media Spark (SMS) — Automated Viral Content Engine Automate your entire content workflow: discover viral ideas, generate posts in your tone, repurpose for X, and auto-publish — reducing 90% of manual effort. 🚀 What it Does Scrapes competitors or niche profiles on LinkedIn to find high-performing posts. Classifies and saves evergreen content ideas for later use. Generates fresh posts in your own voice with matching images. Repurposes content for X (Twitter) in a platform-optimized style. Automatically publishes content to LinkedIn and X on your schedule. Allows on-demand commands via Telegram for research or instant content generation. 🧩 Why Use It Save time:** no more manual scraping, idea collection, or formatting. Stay consistent:** maintain a daily content pipeline. Multi-platform leverage:** create once, adapt for LinkedIn and X. Creative control:** mix automation with optional human review. Scalable:** extend to more platforms, analytics, and workflows as you grow. 🔧 Prerequisites & Setup Before importing or activating the workflow, prepare these: AI Provider (OpenAI / Gemini / OpenRouter)** For classifying posts, generating new content, repurposing for X. Google Sheets** Central database for competitors, ideas, generated posts, and posting status. Google Drive** Stores generated images. Apify & Browseract** Scrapes LinkedIn profiles, posts, and performs research tasks. LinkedIn API** Needed for automated LinkedIn publishing. X (Twitter) API** Requires OAuth 1.0a for image uploads and OAuth 2.0 for text posting. Telegram Bot** Enables on-demand commands and notifications. Set your Telegram User ID in the trigger node. > 🔎 In each sub-workflow, look for nodes marked “Configure Me!” to replace example prompts, search keywords, sheet IDs, etc. ⚙️ How It Works (Simplified Flow) Scrape & Classify: Collect high-engagement posts → keep evergreen ones. Generate Content: Rewrite ideas into new posts in your voice → create images. Repurpose for X: Adapt LinkedIn posts for short-form, high-impact tweets. Auto-Publish: Post daily on LinkedIn and X. Control via Telegram: Manually trigger scraping, research, or post generation. 💡 Best Practices & Tips Keep all API keys private — never share them in public repos or screenshots. Adjust cron schedules (e.g., scraping on weekends, posting on weekdays) to fit your content rhythm. Add Human-in-the-Loop review steps for brand-sensitive content. Extend to other platforms (Instagram, TikTok, YouTube Shorts) as needed. Experiment with prompt variations for different tones or creative styles. Add analytics logging (likes, comments, clicks) to measure content performance. 🙋‍♂️ Who is This For Solo creators & founders** who want to post consistently but don’t have time for daily ideation. Small marketing teams** that need to keep up with trends without spending hours on research. Consultants & thought leaders** who want to amplify their personal brand on LinkedIn and X. Startups & bootstrapped businesses** that need a lean but reliable content engine. Content strategists** who want a data-driven, repeatable pipeline for finding and using what works. Or anyone who wants to boost social presence by 300% 💡 Why SMS Stands Out Authentic voice:** Uses your own tone and style (defined in prompts and examples), so posts feel personal — not generic AI fluff. Data-driven:** Pulls from real, viral posts in your niche to inspire fresh content. Quality over quantity:** Focuses only on proven viral ideas instead of churning random posts. Consistent growth:** Keeps your posting regular, so you stay visible and relevant. Efficient workflow:** Minimizes manual work while letting you step in when needed (e.g., for approvals or special campaigns). > ⚡ SMS combines real market data with your unique voice — so you post smarter, not just more often.

How it works: This project creates a personal AI knowledge assistant that operates through Telegram. The assistant can extract summaries from YouTube videos or online articles, store them in Google Sheets for later reference, and retrieve stored summaries when requested by the user. Step-by-step: Google Sheets Trigger:* The workflow starts by detecting a new YouTube or article URL added to a dedicated sheet (Sheet2*). It checks whether the link is already processed. Link Type Detection:** The system identifies if the URL is from YouTube or a standard article. Data Retrieval:** If it’s YouTube: Uses Apify to fetch the transcript. If it’s an article: Uses an HTTP Request node to fetch the webpage content. AI Summarization:* The transcript or article content is passed to Google Gemini* for refined summarization. Google Sheets Storage:* The summary and title are appended to another sheet (Sheet1*) for long-term storage, along with a “Stored” status update in Sheet2. Telegram Assistant:** A Telegram Trigger listens for messages from the user. The assistant searches stored summaries in Google Sheets. If a match is found, it returns the result to the user on Telegram; otherwise, it politely apologizes.

✅ What problem does this workflow solve? Automatically monitor multiple websites every 5 minutes, log downtime, notify your team instantly via multiple channels, and track uptime/downtime in a Google Sheet—without relying on expensive monitoring tools. ⚙️ What does this workflow do? Triggers every 5 minutes to monitor website health. Fetches a list of website URLs from a Google Sheet. Checks the status of each website one by one. Sends instant alerts if a website is down (Email, Slack, Telegram, Voice Call). Logs downtime events in Google Sheets. Tracks when websites are back up and updates the log. Sends recovery notifications when a site is live again (Email, Slack, Telegram). 🔧 Setup 📄 Google Sheets Setup Sheet 1: List of website URLs to monitor. Sheet 2: Log to store uptime/downtime records. Sample Format: https://docs.google.com/spreadsheets/d/1_VVpkIvpYQigw5q0KmPXUAC2aV2rk1nRQLQZ7YK2KwY/edit?usp=sharing ✉️ Gmail, Slack & Telegram Setup Connect Gmail, Slack, and Telegram to n8n. Configure each service with proper credentials or OAuth. 📞 Vapi (Voice Call) Setup Create a Vapi account. Generate an API key. Configure API Parameters (vapi_api_key, assistant_id, number, phone_number_id) on VAPI Node. Insert the First Message specified in the Workflow. 🧠 How it Works ⏱ 1. Scheduled Monitoring A Schedule Trigger runs the workflow every 5 minutes. It reads the list of URLs from the Google Sheet and loops through each one. 🌍 2. Website Health Check Each website is pinged to check if it’s online. 🔴 3. If Website is Down: It verifies if a downtime record already exists. If not, it: Adds a new row in the Google Sheet with the timestamp. Sends notifications via: 📧 Email 💬 Slack 📲 Telegram 📞 Voice Call via Vapi 🟢 4. If Website is Back Up: It fetches the matching downtime record. Updates the sheet with: ✅ Uptime timestamp ⏱ Total downtime duration Sends recovery notifications via: 📧 Email 💬 Slack 📲 Telegram (No phone call is made for uptime.) 👤 Who can use it? This is perfect for: 🚀 Startups 👨‍💻 Freelance Developers 🛠 SaaS Product Owners 🖥 IT/DevOps Teams If you're looking to replace tools like UptimeRobot, Pingdom, or StatusCake, this no-code solution gives you full control, customization, and cost-efficiency.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Deliver seamless, AI-driven customer support on Telegram and WhatsApp—powered by GPT-4 Turbo and n8n. 🌟 Key Features Unified Messaging:** Receive and normalize messages from both Telegram (via Bot Trigger) and WhatsApp (via Webhook). Contextual AI Responses:** Build customer context from Google Sheets, then craft personalized replies with GPT-4 Turbo. Smart Routing:** Automatically detect platform and send replies with platform-appropriate formatting (HTML for Telegram, plain for WhatsApp). Intent Detection & Escalation:** Flag orders, appointments or complex queries and trigger Slack notifications for human handoff. Comprehensive Logging:** Append every interaction to a “conversations” sheet and upsert customer profiles in a “customers” sheet. 📋 Prerequisites n8n instance (self-hosted or n8n Cloud) Credentials: OpenAI API key Telegram Bot Token WhatsApp Business API credentials (WHATSAPP_PHONE_ID) Google Sheets service-account credentials Slack Incoming Webhook URL Google Sheets Setup: customers sheet with columns: user_id, user_name, previousOrders, lastInteraction, preferences, conversationHistory conversations sheet with columns: user_id, user_name, platform, message, ai_response, timestamp, needs_escalation, is_order, is_appointment 🚀 Setup & Usage Import the provided JSON into your n8n editor. Configure each node’s credentials in n8n’s Credentials panel. Set the following Workflow Variables: GOOGLE_SHEET_ID WHATSAPP_PHONE_ID Activate the Telegram Bot Trigger and WhatsApp Webhook nodes. Test by messaging your bot on Telegram and WhatsApp. 🔍 How It Works Trigger: Listens for new Telegram updates or WhatsApp webhook calls. Normalize Message: Standardizes payload into { user_id, user_name, message_text, platform, chat_id, timestamp }. Get Customer Data: Reads from “customers” sheet to fetch past history and order count. Build AI Context: Merges incoming message with customer info and history. AI Assistant: Sends context to GPT-4 Turbo (temperature 0.8, maxTokens 800). Process Response: Cleans formatting, identifies intents (order, appointment), and sets escalation flags. Platform Router: Routes reply to the appropriate “Send Telegram” or “Send WhatsApp” node. Log Conversation: Appends each message and response to the “conversations” sheet. Update Customer: Increments previousOrders, updates last interaction timestamp, and saves a snippet of the latest message. Escalation: If flagged, posts a formatted alert to your Slack channel for immediate attention. Empower your business with 24/7 AI-powered support—save time, increase conversions, and ensure no customer inquiry goes unanswered.

Generate visual resumes from Telegram inputs using Google Gemini This workflow transforms text-based resume data into visually stunning images by leveraging Google Gemini's reasoning and vision capabilities. It autonomously analyzes the candidate's profile, selects an appropriate design template based on their industry, and renders a high-quality resume image directly in Telegram. Target Audience Job seekers, career coaches, resume writers, and recruitment agencies looking to automate design generation. How it works Classify Input: The workflow starts with a Telegram trigger. A Google Gemini agent analyzes the incoming message to determine if it is a casual chat or a resume generation request. Fetch Context: If it is a resume request, a BrowserAct node triggers a workflow (using the "AI Resume Replicant" template) to fetch necessary external context or data. Ingest Designs (Optional): If a reference image is provided, CloudConvert standardizes the file, and Google Gemini Vision reverse-engineers the layout and style, saving the "Visual DNA" to Google Sheets. Draft Blueprint: The "Resume Writer" AI agent selects a stored design template that matches the candidate's industry (e.g., "Corporate" for Finance, "Creative" for Design) and maps the text content to the layout. Generate Prompt: A "Visualizer" AI agent converts the structured blueprint into a highly detailed natural language prompt for image generation. Render & Deliver: Google Gemini generates the final resume image, which is then sent back to the user via Telegram. How to set up Configure Credentials: Connect your Telegram, Google Gemini, Google Sheets, CloudConvert, and BrowserAct accounts in n8n. Prepare BrowserAct: Ensure the AI Resume Replicant template is saved in your BrowserAct account. Setup Google Sheet: Create a new Google Sheet with the required header (listed below). Connect Sheet: Open the Google Sheets nodes (Clear, Get, Append) and select your new spreadsheet. Configure Telegram: Ensure your Telegram Bot is connected to the Trigger and Message nodes. Google Sheet Headers To use this workflow, create a Google Sheet with the following header: Resume Details Requirements BrowserAct* account (Template: AI Resume Replicant*). Google Gemini** account. Telegram** account (Bot Token). CloudConvert** account. Google Sheets** account. How to customize the workflow Refine Design Logic: Modify the system prompt in the "Resume Writer" agent to change how the AI matches industries to design styles (e.g., force specific colors for specific roles). Change Output Format: Replace the Telegram response node with a Google Drive node to save the generated images as PDF or PNG files instead of sending them. Switch Image Model: Update the "Generate an image" node to use a different image generation model if preferred (e.g., OpenAI DALL-E). Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video I Built a Resume Bot that CLONES Any Template! 🤖 (BrowserAct + n8n + Gemini Tutorial)

This workflow helps you monitor domain expiration dates and send automated reminders via Telegram when a domain is about to expire or has already expired, using WHOIS data and AI-powered information extracting. It helps prevent service downtime, lost traffic, and missed renewals for individuals and teams managing multiple domains. Common use cases: Track and remind on agency-managed client domains Monitor personal or business domain portfolios Send automated expiry alerts for IT and DevOps teams How it works Runs daily at 08:00 AM Reads domain data from Google Sheets Fetches WHOIS information from whois.com for each domain Extracts the data (expired date, domain owner, status domain) using AI Sends a Telegram reminder if the domain expires within 90 days Records the notification date to avoid duplicate alerts Setup steps Add your Google Sheets ID and ensure the required columns exist Connect your Google Sheets credentials Connect your Telegram credentials Configure your LLM provider (Ollama or other) Activate the workflow Need Help? Contact me on LinkedIn!

Decodo-powered review aggregation to Google Sheets with Gemini analysis and Telegram alerts Who’s it for This template is designed for e-commerce owners, marketplace sellers, product teams, and CX/reputation managers who need an automated way to monitor product reviews. It’s ideal for anyone tracking Amazon listings or other URLs and wants AI-powered sentiment, summaries, and alerts without manual scraping. What it does This workflow automatically retrieves product URLs from Google Sheets, scrapes reviews using Decodo (community node), formats the extracted data, and analyzes it using Gemini AI. It produces both sentiment classification and a concise review summary. Results are saved to a Google Sheets log, and the workflow sends a Telegram alert whenever new reviews are processed. The entire pipeline runs on a schedule, ensuring continuous and fully automated monitoring. How it works A scheduled trigger starts the workflow. Google Sheets provides the list of product URLs. Each URL is processed through Decodo to extract user reviews. A Code node formats the raw review data. Gemini performs sentiment analysis and summarization. Results are appended to a Google Sheets review log. A Telegram message delivers a real-time summary and sentiment snapshot. Sign up for Decodo — get better pricing here Requirements Decodo API credentials (self-hosted community node) Google Sheets API Key Gemini AI credentials Telegram Bot + Chat ID n8n self-hosted (required for Decodo community node) How to set up Add your Decodo credentials to the Decodo node. Update both Google Sheets nodes with your document ID and sheet names. Insert your Gemini API key. Provide your Telegram Bot token and Chat ID. Adjust the schedule interval to your preference. Run the workflow once to validate mappings and output fields. How to customize Modify the Code node to change how reviews are formatted. Extend Gemini prompts for deeper analysis (keywords, categories, toxicity). Add filters to trigger alerts only on negative sentiment. Append additional metadata (timestamps, product IDs) to the Sheets log. Add email, Slack, or other communication channels. Disclaimer (Community Node) This workflow uses a community node (Decodo) and therefore works only on self-hosted n8n instances. Be sure to install and trust the package before using it.

💥 Automate YouTube thumbnail creation from video links (with templated.io) Who is this for? This workflow is designed for content creators, YouTubers, and automation enthusiasts who want to automatically generate stunning YouTube thumbnails and streamline their publishing workflow — all within n8n. If you regularly post videos and spend hours designing thumbnails manually, this automation is built for you. What problem is this workflow solving? Creating thumbnails is time-consuming — yet crucial for video performance. This workflow completely automates that process: No more manual design. No more downloading screenshots. No more repetitive uploads. In less than 2 minutes, you can refresh your entire YouTube thumbnail library and make your channel look brand new. What this workflow does Once activated, this workflow can: ✅ Receive YouTube video links via Telegram ✅ Extract metadata (title, description, channel info) via YouTube API ✅ Generate a custom thumbnail automatically using Templated.io ✅ Upload the new thumbnail to Google Drive ✅ Log data in Google Sheets ✅ Send email and Telegram notifications when ready ✅ Create and publish AI-generated social posts on LinkedIn, Facebook, and Twitter via Blotato Bonus: You can re-create dozens of YouTube covers in minutes — saving up to 5 hours per week and around $500/month in manual design effort. Setup 1️⃣ Get a YouTube Data API v3 key from Google Cloud Console 2️⃣ Create a Templated.io account and get your API key + template ID 3️⃣ Set up a Telegram bot using @BotFather 4️⃣ Create a Google Drive folder and copy the folder ID 5️⃣ Create a Google Sheet with columns: Date, Video ID, Video URL, Title, Thumbnail Link, Status 6️⃣ Get your Blotato API key from the dashboard 7️⃣ Connect your social media accounts to Blotato 8️⃣ Fill all credentials in the Workflow Configuration node 9️⃣ Test by sending a YouTube URL to your Telegram bot How to customize this workflow Replace the Templated.io template ID with your own custom thumbnail layout Modify the OpenAI node prompts to change text tone or style Add or remove social platforms in the Blotato section Adjust the wait time (default: 5 minutes) based on template complexity Localize or translate the generated captions as needed Expected Outcome With one Telegram message, you’ll receive: A professional custom thumbnail An instant email + Telegram notification A Google Drive link with your ready-to-use design And your social networks will be automatically updated — no manual uploads. Credits Thumbnail generation powered by Templated.io Social publishing powered by Blotato Automation orchestrated via n8n 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n 🎥 Watch This Tutorial 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n

LinkedIn URL → Scrape → Match → Screen → Decide, all automated This workflow automatically processes candidate LinkedIn profiles shared via Telegram, intelligently matches them to job descriptions, performs AI-powered screening analysis, and sends actionable summaries to your team in Telegram. Good to know Handles LinkedIn profile scraping via Apify API (extracts full profile data including experience, education, skills) Built-in spam prevention: limits users to 3 LinkedIn profile submissions Two-stage JD matching: prioritizes role mentioned in candidate's Telegram message, falls back to LinkedIn profile analysis if needed Uses Google Gemini API for AI screening (generous free tier and rate limits, typically enough to avoid paying for API requests - check latest pricing at Google AI Pricing and rate limits documentation) Automatic polling mechanism checks Apify extraction status up to 10 times (15-second intervals) Complete audit trail logged in Google Sheets with unique submission IDs Who's it for Hiring teams and recruiters who want to streamline first-round screening for candidates who share LinkedIn profiles directly. Perfect for companies accepting applications via messaging platforms (Telegram, WhatsApp, etc.), especially useful fortech-savvy audiences and remote/global hiring. How it works Telegram bot receives message containing LinkedIn profile URL from candidate Validates URL format and checks spam prevention (max 3 submissions per Telegram username) Sends confirmation message to candidate and notifies internal talent team via Telegram group Extracts clean LinkedIn URL and initiates Apify scraping job Polls Apify API up to 10 times (15-second intervals) until profile extraction completes AI agent matches candidate to best-fit job description by analyzing Telegram message context first (if candidate mentioned a role), or LinkedIn profile content as fallback (selects up to 3 potential JD matches) If multiple JDs matched, second AI agent selects the single best fit based on detailed profile analysis AI recruiter agent analyzes LinkedIn profile against selected JD and generates structured screening report (strengths, weaknesses, risk/reward factors, overall fit score 0-10 with justification) Logs complete analysis to Google Sheets tracker with unique submission ID Sends formatted summary to Telegram group with candidate details, matched JD, and overall fit score Requirements Telegram Bot Token (Create bot via @BotFather) Apify account with API token (Sign up for free tier) Google Drive account (OAuth2) Google Sheets account (OAuth2) Google Gemini API key (Get free key here) Google Drive folder for Job Descriptions (as PDFs or Google Docs) Telegram group for internal talent team notifications How to set up Create Telegram bot and internal Telegram chat group with new bot: Message @BotFather on Telegram Send /newbot and follow instructions to create your bot Save the API token provided Create Telegram group chat and invite your new bot + invite the @GetIDs bot Note down the group chat ID (How to get group chat ID) Setup Apify: Sign up at Apify Get your API token from Settings Note: Free tier includes sufficient scraping credits for testing and production ($0.01 per successful LinkedIn profile enriched, a free monthly limit of $5.00) - LinkedIn profile scraper "actor" details Create Google Sheet: Create new sheet named "LinkedIn Profile AI Candidate Screening" Add columns: Submission ID, Date, LinkedIn Profile URL, First Name, Last Name, Email (if known), Telegram Username, Strengths, Weaknesses, Risk Factor, Reward Factor, JD Match, Overall Fit, Justification Copy the spreadsheet ID from URL Setup Google Drive folder: Create folder named "Job Descriptions" Upload your JD files (PDFs or Google Docs) with clear, descriptive filenames Copy the folder ID from URL Configure workflow nodes: In "Receive Telegram Msg to Recruiter Bot" node: Add Telegram API credentials In "Extract LinkedIn Profile Information" node: Replace YOUR_APIFY_API_TOKEN with your Apify token In "Check LinkedIn Profile Extraction Status" node: Replace YOUR_APIFY_API_TOKEN with your Apify token In "Get Fully Extracted LinkedIn Profile Data" node: Replace YOUR_APIFY_API_TOKEN with your Apify token In "Access JD Files" node: Update folder ID to your "Job Descriptions" folder In "Get All Rows Matching Telegram Username" node: Select your Google Sheet In "Add Candidate Analysis in GSheet" node: Select your Google Sheet and verify column mappings In "Send Msg to Internal Talent Group" node: Update chat ID to your Telegram group chat ID In "Send Review Completed Msg to Talent Group" node: Update chat ID and Google Sheet URL Add your company description: In "JD Matching Agent" system message: Replace company description with your details In "Detailed JD Matching Agent" system message: Replace company description with your details In "Recruiter Scoring Agent" system message: Update company description Test the workflow: Send a LinkedIn profile URL to your bot from Telegram Monitor execution to ensure all nodes run successfully Check Google Sheets for logged results Activate workflow Customizing this workflow Change spam limits: Edit "Spam Check: Sent <4 LinkedIn Profiles?" node to adjust maximum submissions (currently 3) Adjust polling attempts: Edit "Checked 10x for LinkedIn Profile Data?" node to change maximum polling attempts (currently 10) or modify wait time in "Wait for LinkedIn Profile" node (currently 15 seconds) Change JD matching logic: Edit "JD Matching Agent" node prompt to adjust how LinkedIn profiles are matched to roles (e.g., weight current role vs. overall experience) Modify screening criteria: Edit "Recruiter Scoring Agent" node system message to focus on specific qualities (culture fit, leadership potential, technical depth, industry experience, etc.) Add more messaging platforms: Add nodes to support WhatsApp, Discord, or other messaging platforms using similar URL-based triggers Customize Telegram messages: Edit notification nodes to change formatting, add emojis, or include additional candidate data Auto-proceed logic: Add IF node after screening to auto-proceed candidates with fit score above threshold (e.g., 8+/10) and trigger different notification paths Add candidate responses: Connect nodes to automatically message candidates back via Telegram (confirmation, rejection, interview invite) Add interview scheduling: For approved candidates, send Telegram message with Cal.com or Calendly link so they can book their interview Enrich with additional data: Add nodes to cross-reference candidate data with other sources (GitHub, Twitter/X, company websites) Multi-language support: Add translation nodes to support candidates submitting profiles in different languages Add human approval step: Create buttons in Telegram group messages for instant Approve/Reject decisions that update Google Sheets Pro tip: Add your Telegram bot to your company's careers page with instructions like: "Want fast-track screening? Share your LinkedIn profile with our AI recruiter: @YourBotName" Troubleshooting Telegram bot not responding: Ensure bot token is correct in "Receive Telegram Msg to Recruiter Bot" node, and users have sent /start to your bot at least once "LinkedIn profile URL invalid" error: Check that candidates are sending full URLs in format https://www.linkedin.com/in/username (not shortened links or text without URL) Apify extraction failing: Verify Apify API token is correctly set in all three HTTP Request nodes ("Extract LinkedIn Profile Information", "Check LinkedIn Profile Extraction Status", "Get Fully Extracted LinkedIn Profile Data") LinkedIn extraction timeout: Increase polling attempts in "Checked 10x for LinkedIn Profile Data?" node (currently 10) or increase wait time in "Wait for LinkedIn Profile" node (currently 15 seconds) Spam check blocking valid users: Check "Get All Rows Matching Telegram Username" node is pointing to correct Google Sheet, and adjust limit in "Spam Check: Sent <4 LinkedIn Profiles?" node if needed JD matching returns no results: Check "Access JD Files" node folder ID points to your Job Descriptions folder, and JD files are named clearly (e.g., "Marketing Director JD.pdf") JD matching is not relevant for my company: Update the "Company Description" in the System Messages in all three AI agent nodes ("JD Matching Agent", "Detailed JD Matching Agent", "Recruiter Scoring Agent") "Can't find matching JD": Ensure candidate's Telegram message mentions role name OR their LinkedIn profile clearly indicates relevant experience for available JDs Google Sheets errors: Verify sheet name is "LinkedIn Profile AI Candidate Screening" and column headers exactly match workflow expectations (Submission ID, Date, LinkedIn Profile URL, First Name, Last Name, etc.) Telegram group notifications not appearing: Verify chat ID is correct in "Send Msg to Internal Talent Group" and "Send Review Completed Msg to Talent Group" nodes (use negative number for group chats, e.g., -4954246611) Missing candidate data in Google Sheets: LinkedIn profile may be incomplete - verify Apify successfully extracted data by checking "Get Fully Extracted LinkedIn Profile Data" node output Loop counter not working: Check "Restore Loop Counter" code node references correct node names ("Checked 10x for LinkedIn Profile Data?" and "Initialize Loop Counter to Poll for Completion") 401/403 API errors: Re-authorize all OAuth2 credentials (Google Drive, Google Sheets) and verify Apify and Telegram API tokens are valid AI analysis quality issues: Edit system prompts in "JD Matching Agent", "Detailed JD Matching Agent", and "Recruiter Scoring Agent" nodes to refine screening criteria and provide more context about your hiring needs Gemini API rate limit errors: Check your usage at Google AI Studio and consider upgrading to paid tier if exceeding free tier limits (see rate limits documentation) Sample Outputs Google Sheets - LinkedIn AI Candidate Screening - sample Telegram messages between AI recruiter bot and job applicant Telegram messages from AI recruiter bot in internal group chat

Automated Social Media Video Posting 👥 Who's it for This workflow is perfect for content creators, social media managers, and businesses who want to schedule and automatically post videos 📹 to multiple platforms (Instagram, LinkedIn, TikTok) without manual effort. Save hours every week! ⏰ 🤖 What it does It automatically reads scheduled posts from Google Sheets, checks if it's the right time to post, downloads videos from Google Drive, uploads them to multiple social media platforms simultaneously, updates the posting status, and sends you a Telegram notification with the results. Complete hands-free social media management! 🚀 ⚙️ How it works ⏰ Schedule Trigger – Runs twice daily at 9 AM and 9 PM 📊 Google Sheets (Read) – Fetches posts with status "Listo para postear" (Ready to post) ⚙️ Code Node – Converts trigger time to readable Spanish format (e.g., "16 de Octubre a las 9 am") 🔍 If Condition – Checks if current time matches the scheduled post time in the sheet 📝 Format Drive Content – Extracts and organizes post data (Title, Copy, Video URL) 🆔 Social Media Account IDs – Prepares account identifiers (can be customized for specific accounts) 🎬 Upload a video – Posts video simultaneously to Instagram, LinkedIn, and TikTok using UploadPost API 📊 Google Sheets (Update) – Changes post status to "Posteado" (Posted) to avoid duplicates 📱 Telegram Notification – Sends detailed success report with URLs for each platform 📋 Requirements Google Sheets** with your content calendar Google Drive** to store your videos UploadPost API account** (supports Instagram, LinkedIn, TikTok): Click aquí 👉 UploadPost Telegram Bot** for notifications n8n instance** with required node packages Google Sheets Structure Your spreadsheet should have these columns: Title – Post title Copy – Post caption/description Video Link – Google Drive download URL Status – Post status ("Listo para postear" or "Posteado") Fecha.Hora – Scheduled time (format: "16 de Octubre a las 9 am") row_number – Auto-generated row identifier 🛠️ How to set up Create your Google Sheets calendar: Set up columns as specified above Use status "Listo para postear" for scheduled posts Format dates as "DD de Mes a las HH am/pm" (Spanish format) Upload videos to Google Drive: Get shareable download links (format: https://drive.google.com/uc?export=download&id=FILE_ID) Ensure videos meet platform requirements (duration, format, size) Configure UploadPost API: Create account and get API credentials Connect your Instagram, LinkedIn, and TikTok accounts Add credentials to the "Upload a video" node Set up Google Sheets credentials: Connect OAuth2 for both read and update operations Update documentId with your spreadsheet ID Verify sheet name matches (default: "Video") Configure Telegram notifications: Create a Telegram bot via @BotFather Get your chat ID Add credentials to "Send a text message" node Customize posting times: Modify Schedule Trigger hours (default: 9 AM and 9 PM) Times are in Santiago, Chile timezone (America/Santiago) Test the workflow: Create a test entry with current time Run manually to verify all connections work Check Telegram for success notification Activate the workflow ✅ 🎨 How to customize Change posting schedule:** Modify triggerAtHour values in Schedule Trigger (add more times if needed) Add more platforms:** Extend the platform array in "Upload a video" node (supports YouTube, Facebook, Twitter) Customize notification format:** Edit the Telegram message template to include/exclude information Change timezone:** Modify the timeZone parameter in the Code node (default: "America/Santiago") Filter by platform:** Add a filter node before upload to post only to specific platforms on certain days Add approval workflow:** Insert an approval step before posting using Telegram or Slack Multiple accounts per platform:** Modify "Social Media Account IDs" node to specify different account IDs Error handling:** Add error notification paths to alert you if uploads fail Batch posting:** Remove returnFirstMatch option to post multiple videos at once 💡 Pro Tips Time format must match exactly** between Schedule Trigger and Google Sheets for the workflow to trigger Videos should be optimized for each platform before upload (aspect ratio, length, file size) Test with a private account first before going live Keep video files under 100MB for best performance across platforms Use the row_number column to track and update specific posts The workflow runs twice daily, so schedule posts accordingly (9 AM or 9 PM slots) ⚠️ Important Notes Posts marked as "Posteado" won't be processed again (prevents duplicates) Video must be publicly accessible from the Google Drive link UploadPost API has rate limits depending on your plan Telegram notifications show success status and post URLs for each platform The Code node converts times to Spanish format - modify if you need different language/format

Stay ahead in your trading game with this powerful n8n automation workflow. Designed for real-time efficiency, this setup continuously scans your Gmail inbox for trading alerts from TradingView and ensures you never miss a signal. Every minute, this workflow will: 📩 Check Gmail for new messages using a trigger. 🔍 Identify emails coming specifically from TradingView. 📊 Extract key trading signals like BUY or SELL along with the company name. 🕒 Capture the exact date and time of the alert. 📄 Log all extracted signals neatly into a Google Sheet for easy tracking and analysis. 📲 Instantly notify you on Telegram with a custom message so you can act fast. Perfect for traders who want an automated assistant to handle alerts, record them for analysis, and provide timely updates — all without lifting a finger.

Be first. Be relevant. Get hired. This ready-to-import n8n workflow automates your entire Freelancer.com job search: it scans new listings, filters the best ones with AI, writes proposal drafts, and sends them to Telegram instantly — all while logging every opportunity into Google Sheets. 💡 Why Freelancers Love It ⚡ Instant Alerts: Get notified within minutes of new high-quality jobs. 🧠 AI-Powered Scoring: Filters scams, vague clients, and low-value gigs automatically. ✍️ Smart Proposal Drafts: GPT-4.1 crafts 150–200 word personalized proposals for you. 📱 Telegram Integration: See job details + AI proposal in one alert message. 📊 Auto Tracking: Logs every lead in Google Sheets with scores, notes, and timestamps. Spend less time searching — and more time winning projects. 🧩 What’s Included ✅ n8n Workflow (.json) — ready to import and launch ✅ Setup Guide (Markdown) — complete 5-step configuration walkthrough 🧰 Requirements Free n8n Cloud account (or self-hosted instance) OpenAI API key** (GPT-4.1 or GPT-4-mini) Telegram bot** + Chat ID (takes 2 minutes to create) Google Sheets** account 🪜 5-Step Setup Guide (Detailed) 1️⃣ Prepare Your Tools Get your OpenAI key → platform.openai.com Create a Telegram bot via @BotFather → copy your token Use @userinfobot to get your Chat ID Create a Google Sheet with headers: Timestamp | Job | Description | Link | AI Score | Reasoning | Red Flags | Client Type | AI Proposal | Alert Timestamp Keep all keys and URLs ready. 2️⃣ Import the Workflow in n8n Open n8n → + Workflow → Import from File → choose the .json provided below. Once imported, open these nodes and connect your credentials: OpenAI nodes → add your API key Google Sheets nodes → sign in with Google Telegram node → paste your bot token + chat ID Confirm the Schedule Trigger runs every 5 minutes (default). 3️⃣ Personalize Your Keywords & Filters Open Settings (Keyword & Wishlist): Job Keyword: e.g., react, seo, logo design, automation Wishlist: e.g., Budget > $500, clear brief, long-term clients The RSS node auto-fetches new jobs from Freelancer.com: https://www.freelancer.com/rss.xml?keyword={{$json['Job Keyword']}} Optional filters: &min_price=500 → only projects $500+ &max_price=5000 → skip mega-projects Adjust Filter Job Quality: Description > 100 chars Posted within the last 2 hours Tune AI Score Threshold (Gate Node) to >= 7 for balanced alerts. 4️⃣ Test Your Automation Click Execute Workflow once. If everything is set: 🟢 Nodes turn green (success) 📩 Telegram shows your first job alert 📊 Google Sheet updates with a new job entry If empty, try: Broader keyword (e.g., python instead of python scraper) Increase freshness (2 → 6 hours) 5️⃣ Go Live & Expand Activate your workflow. Let it run for 24–48 hours, then refine: Raise score threshold to 8–9 for higher quality Add RSS nodes for new categories (design, dev, content) Extend alerts to Slack, Discord, or Email Replace Google Sheets with Airtable or Notion Pro Tip:* Use Apify* to scrape Upwork, Fiverr, or niche job boards → feed results into the same analyzer chain. ⚙️ How It Works (Behind the Scenes) Schedule → Fetch RSS → Filter → AI Analyze (score 1–10) → If score ≥ 7 → AI Proposal → Log to Sheets → Send Telegram Alert You still review and apply manually (TOS-safe), but you’ll always be among the first 5 applicants. 🔌 Future-Proof Extensions | Extension | Description | |------------|--------------| | Apify Integration | Scrape Upwork, Fiverr, or niche boards with structured data | | Multi-Channel Alerts | Add Slack, Discord, or email digests | | Team Routing | Send design jobs to one chat, dev jobs to another | | Advanced Scoring | Add client history or location weighting | | Database Sync | Replace Sheets with Notion, Airtable, or PostgreSQL | 🧾 Terms & Notes Manual review required (no auto-apply) API costs: OpenAI ~$5–10/month Respects Freelancer.com Terms of Service All keys stored securely inside n8n credentials 🏁 Summary Automate your freelancing workflow. This system finds, filters, and drafts proposals for you while you sleep. ⚙️ Plug it into n8n → 🔑 Add keys → 🎯 Go live → 💰 Start winning faster.

One-way sync between Telegram, Notion, Google Drive, and Google Sheets Who is this for? This workflow is perfect for productivity-focused teams, remote workers, virtual assistants, and digital knowledge managers who receive documents, images, or notes through Telegram and want to automatically organize and store them in Notion, Google Drive, and Google Sheets—without any manual work. What problem is this workflow solving? Managing Telegram messages and media manually across different tools like Notion, Drive, and Sheets can be tedious. This workflow automates the classification and storage of incoming Telegram content, whether it’s a text note, an image, or a document. It saves time, reduces human error, and ensures that media is stored in the right place with metadata tracking. What this workflow does Triggers on a new Telegram message** using the Telegram Trigger node. Classifies the message type** using a Switch node: Text messages are appended to a Notion block. Images are converted to base64, uploaded to imgbb, and then added to Notion as toggle-image blocks. Documents are downloaded, uploaded to Google Drive, and the metadata is logged in Google Sheets. Sends a completion confirmation** back to the original Telegram chat. Setup Telegram Bot: Set up a bot and get the API token. Notion Integration: Share access to your target Notion page/block. Use the Notion API credentials and block ID where content should be appended. Google Drive & Sheets: Connect the relevant accounts. Select the destination folder and spreadsheet. imgbb API: Obtain a free API key from imgbb. Replace placeholder credential IDs and asset URLs as needed in the imported workflow. How to customize this workflow to your needs Change Storage Locations**: Update the Notion block ID or Google Drive folder ID. Switch Google Sheet to log in a different file or sheet. Add More Filters**: Use additional Switch rules to handle other Telegram message types (like videos or voice messages). Modify Response Message**: Personalize the Telegram confirmation text based on the file type or sender. Use a different image hosting service** if you don’t want to use imgbb.

How It Works This workflow creates an AI-powered Telegram chatbot with session management, allowing users to: Start new conversations** (/new). Check current sessions** (/current). Resume past sessions** (/resume). Get summaries** (/summary). Ask questions** (/question). Key Components: Session Management**: Uses Google Sheets to track active/expired sessions (storing SESSION IDs and STATE). /new creates a session; /resume reactivates past ones. AI Processing**: OpenAI GPT-4 generates responses with contextual memory (via Simple Memory node). Summarization: Condenses past conversations when requested. Data Logging**: All interactions (prompts/responses) are saved to Google Sheets for audit and retrieval. User Interaction**: Telegram commands trigger specific actions (e.g., /question [query] fetches answers from session history). Main Advantages Multi-session Handling Each user can create, manage, and switch between multiple sessions independently, perfect for organizing different conversations without confusion. Persistent Memory Conversations are stored in Google Sheets, ensuring that chat history and session states are preserved even if the server or n8n instance restarts. Commands for Full Control With intuitive commands like /new, /current, /resume, /summary, and /question, users can manage sessions easily without needing a web interface. Smart Summarization and Q&A Thanks to OpenAI models, the workflow can summarize entire conversations or answer specific questions about past discussions, saving time and improving the chatbot’s usability. Easy Setup and Scalability By using Google Sheets instead of a database, the workflow is easy to clone, modify, and deploy — ideal for quick prototyping or lightweight production uses. Modular and Extensible Each logical block (new session, get current session, resume, summarize, ask question) is modular, making it easy to extend the workflow with additional features like analytics, personalized greetings, or integrations with CRM systems. Setup Steps Prerequisites: Telegram Bot Token**: Create via BotFather. Google Sheets**: Duplicate this template. Two sheets: Session (active/inactive sessions) and Database (chat logs). OpenAI API Key**: For GPT-4 responses. Configuration: Telegram Integration: Add your bot token to the Telegram Trigger and Telegram Send nodes. Google Sheets Setup: Authenticate the Google Sheets nodes with OAuth. Ensure sheet names (Session, Database) and column mappings match the template. OpenAI & Memory: Add your API key to the OpenAI Chat Model nodes. Adjust contextWindowLength in the Simple Memory node for conversation history length. Testing: Use Telegram commands to test: /new: Starts a session. /question [query]: Tests AI responses. /summary: Checks summarization. Deployment: Activate the workflow; the bot will respond to Telegram messages in real-time. Need help customizing? Contact me for consulting and support or add me on Linkedin.

This n8n automation lets you build a complete AI-powered task management system that integrates Telegram, Google Sheets, and GPT-4o mini to help users easily manage to-do lists and receive daily task reminders. Users can interact with the system via Telegram, while the AI assistant (powered by GPT-4o mini) processes commands naturally, updates a central Google Sheet, and ensures scheduled reminders are sent for pending tasks. ✨ Key Features ✅ Add, list, update, complete, or delete tasks via Telegram ✅ AI-powered conversational responses using GPT-4o ✅ All tasks stored and synced in Google Sheets ✅ Daily scheduled task summary and pending reminders sent to Telegram ✅ Friendly, human-like assistant responses ✅ Fully configurable and easy to set up 🛠️ Workflow Functionality Breakdown User Interacts on Telegram Sends commands like: add buy groceries list tasks complete submit report delete dentist appointment AI-Powered Processing A GPT-4o agent processes user messages Ensures clear, friendly responses Determines task intent: add, update, delete, list, complete Google Sheets Sync Every operation is logged to Google Sheets Google Sheets acts as the master task database Sheet structure includes: Task Status (pending or done) Created At (timestamp) Due Date (optional) Notes (optional) Scheduled Daily Task Summary At 9 PM daily, the workflow: Fetches tasks from Google Sheets Generates a warm, conversational summary via GPT-4o Sends the summary to the user on Telegram Automated Reminders Checks for pending tasks due today Sends reminder messages to Telegram ✅ Prerequisites Before setting up the workflow, ensure you have: ✔️ An n8n instance (Cloud or self-hosted) ✔️ A Telegram Bot Token ✔️ Access to Google Sheets API (OAuth2 credentials) ✔️ An OpenAI API Key with GPT-4o access ✔️ A Google Sheet structured as per the specification below 📝 Google Sheet Structure Your Google Sheet should have the following columns: | Column Name | Description | | -------------- | ---------------------------------------------------- | | Task | Short task description | | Status | pending or done | | Created At | Date & time task was created (YYYY-MM-DD HH:mm:ss) | | Due Date | (Optional) When task is due (YYYY-MM-DD HH:mm:ss) | | Notes | (Optional) Additional details | Important: The first row should be the header row with these exact column names. 🔧 Setup Instructions Telegram Bot Setup Create a bot via BotFather Obtain the Bot Token Connect Telegram Trigger and Telegram Send nodes using your Bot Token in n8n Google Sheets API Setup Follow n8n Google Sheets integration guide Set up OAuth2 credentials Provide access to your task Google Sheet OpenAI API Setup Obtain an API key from OpenAI Ensure GPT-4o mini access is enabled Add OpenAI credentials to relevant nodes Sheet Linking Replace the Google Sheet ID in the workflow with your own Confirm sheet names and column structure match exactly Schedule Configuration (Optional) Adjust the daily summary time (Schedule Trigger node) as desired ⚙️ Configuration Options 🔧 Adjust AI prompt instructions for tone/style 🔧 Change reminder times in the schedule trigger 🔧 Customize Google Sheet columns if needed (update mappings accordingly) 🔧 Add multi-user support with chat ID checks (advanced) 📂 Files Included Full n8n JSON workflow ready to import 💡 Tips You can extend this with Slack, WhatsApp, or Email reminders Combine with Notion, ClickUp, or CRM integrations for more powerful task management Consider adding a "Priority" column for advanced sorting Ready to stay organized with AI-powered task management? Import this workflow, link your accounts, and your Telegram assistant is good to go! 🚀

How it works ++Download the google sheet here++ and replace this with the googles sheet node: Google sheet , upload to google sheets and replace in the google sheets node. Scheduled trigger: Runs once a day at 8 AM (server time). Fetch product list: Reads your “master” sheet (product_url + last known price) from Google Sheets. Loop with delay: Iterates over each row (product) one at a time, inserting a short pause (20 s) between HTTP requests to avoid blocking. Scrape current price: Loads each product_url, extracts the current price via a simple CSS selector. Compare & normalize: Compares the newly scraped price against the “last_price” from your sheet, calculates percentage change, and tags items where price_changed == true. On price change: Send alert: Formats a Telegram message (“Price Drop” or “Price Hike”) and pushes it to your configured chat. Log history: Appends a new row to a separate “price_tracking” tab with timestamp, old price, new price, and % change. Update master sheet: After a 1 min pause, writes the updated current_price back to your “master” sheet so future runs use it as the new baseline. Set up step Google Sheets credentials (~5 min) Create a Google Sheets OAuth credential in n8n. Copy your sheet’s ID and ensure you have two tabs: product_data (columns: product_url, price) price_tracking (columns: timestamp, product_url, last_price, current_price, price_diff_pct, price_changed) Paste the sheet ID into both Google Sheets nodes (“Read” and “Append/Update”). Telegram credentials (~5 min) Create a Telegram Bot token via BotFather. Copy your chat_id (for your target group or personal chat). Add those credentials to n8n and drop them into the “Telegram” node. Workflow parameters (~5 min) Verify the schedule in the Schedule Trigger node is set to 08:00 (or adjust to your preferred run time). In the Loop Over Items node, confirm “Batch Size” is 1 (to process one URL at a time). Adjust the Delay to avoid Request Blocking node if your site requires a longer pause (default is 20 s). In the Parse Data From The HTML Page node, double-check the CSS selector matches how prices appear on your target site. Once credentials are in place and your sheet tabs match the expected column names, the flow should be ready to activate. Total setup time is under 15 minutes—detailed notes are embedded as sticky comments throughout the workflow to help you tweak selectors, change timeouts, or adjust sheet names without digging into code.

AI-Powered Social Video Generator with Auto-Posting to Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Pinterest, Twitter (X), and Bluesky Who is this workflow for? This workflow is ideal for content creators, marketers, social media managers, and automation enthusiasts who want to generate, customize, and publish short-form videos across multiple platforms without manual editing or posting. If you use tools like ChatGPT, Kling, or Blotato and want to streamline your content creation process, this workflow is made for you. What problem does this workflow solve? Publishing regular video content on multiple platforms is time-consuming—especially when adding voice-overs, captions, and managing distribution. This workflow solves that by: Automating video generation using AI (Kling + GPT-4) Adding realistic voice narration Styling subtitles for social media Creating titles and social captions Auto-posting to Instagram, TikTok, YouTube, Facebook, Threads, Twitter (X), LinkedIn, Pinterest, and Bluesky All of this is triggered by a simple message sent via Telegram. How the workflow works This end-to-end automation transforms a short Telegram message into a fully produced and published social video: Receives a text prompt from Telegram Transforms it into a detailed video scene using GPT-4 Generates a cinematic video with Kling Creates a voice-over script and converts it to audio Merges the video and the audio Adds styled captions Writes a social caption and an SEO-optimized title Saves metadata to Google Sheets Sends a preview via Telegram Publishes the video to 9 social platforms using Blotato Setup Connect your Telegram bot to the "Telegram Trigger" node Add your OpenAI API key to all GPT-related nodes Configure Kling API access in the "Generate Video" node Link your Cloudinary account for audio upload Connect JSON2Video to handle video merging and captioning Set up Google Sheets with your preferred spreadsheet ID Connect your Blotato API key and fill in the platform IDs (Instagram, TikTok, etc.) Test by sending a Telegram message like: generate video A robot exploring Mars, Why AI will reshape humanity > Disclaimer: This workflow uses Community Nodes, which are only available on self-hosted instances of n8n. How to customize this workflow to your needs Change the visual style**: Adjust the GPT-4 prompt formatting to reflect your brand tone Edit voice style**: Replace the TTS provider or tweak OpenAI's voice settings Revise captions or titles**: Fine-tune the system prompts in the "Create Description" or "Create Title" nodes Target fewer platforms**: Disable or remove nodes for platforms you don’t use Add approval steps**: Insert a Telegram confirmation step before auto-publishing 📄 Documentation: Notion Guide Demo Video 🎥 Watch the full tutorial here: YouTube Demo

This automation retrieves company information from a Google Sheet, uses the Anymail Finder API to discover email addresses associated with each company, and then writes the results (including the email status) back into the same Google Sheet and send alert on Telegram. Key Advantages ✅ Automated Email Discovery:** No need for manual lookups—emails are found via the Anymail Finder API in bulk. 🔁 Seamless Google Sheets Integration:** Works directly with Google Sheets for input and output, allowing easy data management. 🧠 Smart Filtering:** Automatically classifies emails as valid, risky, or not found for quality control. ⚙️ Reusable & Scalable:** Can be run anytime with a manual trigger or expanded to handle thousands of records with minimal setup. 📊 Real-Time Updates:** Results are immediately reflected in your spreadsheet, streamlining lead generation and outreach workflows. 💸 Cost-Efficient:** Uses a free Anymail Finder trial or API key for testing and validation before scaling up. How it Works This automated workflow finds email addresses for a list of companies using the Anymail Finder API and updates a Google Sheets document with the results. Trigger & Data Retrieval: The workflow starts manually. It first connects to a specified Google Sheet and retrieves a list of company leads that are marked for processing (where the "PROCESSING" column is empty). Batch Processing & API Call: The list of leads is then split into batches (typically one item at a time) to be processed individually. For each company, the workflow sends the "Company Name" and "Website" to the Anymail Finder API to search for a relevant email address. Result Classification: The API's response, which includes the found email and its status (e.g., valid, risky), is passed to a Switch node. This node routes the data down different paths based on the email status. Sheet Update: Depending on the status: Valid/Risky Email: The workflow updates the original Google Sheet row. It marks the "PROCESSING" column with an "x" and writes the found email address into the "EMAIL" column. No Email Found: The workflow also updates the sheet, marking "PROCESSING" with an "x" and leaving the "EMAIL" column empty to indicate no email was found. Loop Completion: After processing each item, the workflow loops back to process the next lead in the batch until all companies have been handled. Set up Steps To use this workflow, you need to complete the following configuration steps: Duplicate the Template Sheet: Clone the provided Google Sheets template to your own Google Drive. This sheet contains the necessary columns ("COMPANY NAME", "WEBSITE", "EMAIL", "PROCESSING") for the workflow to function. Get an API Key: Sign up for a free trial at Anymail Finder to obtain your personal API key. Configure Credentials in n8n: Google Sheets: In both the "Get Leads" and update nodes, set up the Google Sheets OAuth2 credential to grant n8n access to your copied spreadsheet. Anymail Finder: In the "Email finder" HTTP Request node, create a new credential of type "HTTP Header Auth". Name it "Anymail Finder". In the "Name" field, enter Authorization. In the "Value" field, paste your Anymail Finder API key. Update Sheet ID in Nodes: In the n8n workflow, update all Google Sheets nodes ("Get Leads", "Email found", "Email not found") with the Document ID of your cloned Google Sheet. The Sheet ID can be found in your sheet's URL: https://docs.google.com/spreadsheets/d/[YOUR_SHEET_ID_HERE]/edit.... Execute: Once configured, add your list of companies and their websites to the sheet and run the workflow using the "Manual Trigger" node. Need help customizing? Contact me for consulting and support or add me on Linkedin.

📌 Workflow Description This workflow allows users to generate AI images directly from Telegram while automatically logging each request to Google Sheets for tracking. When a user sends a prompt to your Telegram bot, the workflow receives the prompt, generates an image using OpenAI, saves the prompt and generated image link to Google Sheets, and then sends the image back to the user in Telegram. ⚙️ How to Set It Up Connect your Telegram credentials by adding your bot token in both the Telegram Trigger and Telegram Send Message nodes. Ensure your bot is added to the intended chat. Connect your OpenAI credentials by inserting your API key in the OpenAI node and configuring it for image generation. Connect your Google Sheets account by authorising the Google Sheets node and selecting the target spreadsheet and worksheet where you want to save prompts and image links. Finally, activate the workflow and test by sending a prompt to your Telegram bot to confirm that the image is generated, saved to Google Sheets, and sent back to Telegram seamlessly. That’s it – your AI Image Generator with Google Sheets logging is ready to use. ⸻ ✅ That’s it – your AI Image Generator with Google Sheets logging is ready for use.

This workflow automates the process of analyzing emails and their attachments (PDFs and images) using AI models (DeepSeek, Gemini, and OpenRouter). It extracts and summarizes the content of emails and attachments, saves the summaries to Google Sheets, and sends a final consolidated summary via Telegram. This is a powerful tool for automating email analysis and summarization, saving time and ensuring that important information is easily accessible and actionable. Below is a breakdown of the workflow: How It Works The workflow is designed to process incoming emails, analyze their content and attachments, and generate summaries. Here's how it works: Email Trigger: The workflow starts with the Email Trigger (IMAP) node, which monitors an email inbox for new emails. If an email contains attachments, the workflow processes them. Check for Attachments: The Contain Attachments? node checks if the email has attachments. If attachments are present, the workflow proceeds to process them. Process Attachments: The Get PDF and Images Attachments node extracts PDF and image attachments from the email. The Switch node separates PDFs and images for further processing: PDFs: The Extract from PDF node extracts text from PDFs, and the PDF Analyzer node summarizes the content. Images: The Analyze Image node uses AI to describe the content of images. Summarize Email Content: The Convert Text node converts the email's HTML content to plain text. The Email Summarization Chain node uses AI to generate a summary of the email's text content. Save Summaries: The Save Summary PDF, Save Summary Image, and Save Summary Text nodes save the summaries of PDFs, images, and email text, respectively, to Google Sheets. Consolidate Summaries: The All Summaries node aggregates the summaries of the email text, PDFs, and images. The Create Final Summary node uses AI to generate a unified summary of all the content. Send Final Summary: The Send Final Summary node sends the consolidated summary via Telegram to a specified chat ID. Set Up Steps To set up and use this workflow in n8n, follow these steps: IMAP Configuration: Set up IMAP credentials in n8n for the Email Trigger (IMAP) node. Ensure the email account is accessible via IMAP. AI Model Configuration: Configure the DeepSeek, Gemini, and OpenRouter credentials in n8n for the Email Summarization Chain, PDF Analyzer, and Create Final Summary nodes. Ensure the AI models are set up to generate summaries. Google Sheets Integration: Set up Google Sheets credentials in n8n for the Save Summary PDF, Save Summary Image, and Save Summary Text nodes. Specify the Google Sheet and worksheet where the summaries will be saved. Telegram Integration: Set up Telegram credentials in n8n for the Send Final Summary node. Insert your Chat ID in the Telegram node to receive the final summary. Test the Workflow: Send an email with attachments (PDFs and images) to the monitored email account. The workflow will: Extract and summarize the email content and attachments. Save the summaries to Google Sheets. Send a consolidated summary via Telegram. Optional Customization: replace IMAP trigger with Gmail or Outlook trigger Modify the workflow to include additional features, such as: Adding more AI models for different types of analysis. Sending notifications via other channels (e.g., Slack, email). Integrating with other storage services (e.g., Dropbox, AWS S3). Need help customizing? Contact me for consulting and support or add me on Linkedin.

Who Is This For? This workflow is perfect for anyone who wants to automate lead generation using n8n without paying for expensive scraping tools. It uses simple Google Maps API requests and Google Sheets to pull business data by ZIP code and category, then extracts emails at no extra cost. What This Workflow Does Automated Lead Generation**: Runs on a schedule to process ZIP codes and business categories automatically. Data Extraction**: Queries Google Maps for businesses based on each ZIP code + subcategory combo. Data Processing**: Skips entries with a STATUS = "N/A" Removes duplicate results using place.id Extracts and formats relevant business details Error Handling**: Uses exponential backoff when hitting rate limits Stops after 10 retry attempts Data Storage**: Saves results directly to Google Sheets Tracks which ZIP/subcategory pairs have been completed Requirements Google Maps API** (business lookup) Google Sheets OAuth2** (data storage) Telegram Bot API** (notifications) Rapiwa API** (WhatsApp alerts) How to Use — Step-by-Step Setup Set Up Credentials in n8n Add your Google Maps API credentials (named "Google MAP") Add Google Sheets OAuth2 credentials (named "Google Sheets") Add Rapiwa API credentials (named "Rapiwa account 2") Prepare Your Google Sheet Create one Sheet document with these tabs: zip** — ZIP codes to process maps categories** — Business categories/subcategories result** — Where extracted business data will be stored Then update: The document ID inside the workflow nodes The sheet IDs (gid values) so they match your actual tabs Customize the Workflow Change the Limit node to control how many ZIP codes run per batch (default: 10) Adjust retry limits in the relevant nodes (default: 10 attempts) Modify the Schedule node to set your preferred run frequency (default: hourly) > This gives you a simple, scalable, nearly free system for generating targeted leads automatically. Useful Links MAP API Create Project & API How to Use google map docs Rapiwa**: Get your WhatsApp API credentials Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

📘 Description This workflow is an AI-powered roto matte generation and first-pass compositing pipeline designed for VFX production. It transforms structured roto requests into multiple high-precision matte passes using AI, performs automated quality evaluation, generates production-ready Nuke scripts, and delivers fully organized assets and review tasks to the team—bridging the gap between manual rotoscoping and scalable AI-assisted matte generation. ⚙️ Step-by-Step Flow The workflow begins with a Google Sheets trigger that continuously monitors for new roto requests, acting as the intake layer for structured production data such as plate image URLs, subject descriptions, shot codes, subject type, and complexity. Once a new entry is detected, the system moves into a validation and extraction stage, where input fields are normalized, defaults are assigned, and essential attributes like sequence codes, frame ranges, QC thresholds, and project metadata are structured for downstream processing. The pipeline then performs prompt engineering and expands the request into four specialized roto passes: an alpha matte pass for clean silhouette extraction, an edge detail pass for fine hair and motion blur accuracy, a foreground isolation pass for compositing-ready subject separation, and a motion tracking reference pass enriched with tracking markers and velocity overlays. Each variation includes detailed instructions aligned with shot context and technical constraints to ensure precise AI-driven outputs. At the core of the workflow, an image-to-video generation layer constructs structured API requests and submits each variation as an independent job to the Seedance AI model, always using the plate image as a reference for accurate subject extraction. A polling mechanism continuously monitors each job at fixed intervals, ensuring that processing proceeds only after successful completion. Once rendering is complete, a metadata and automated QC layer evaluates each pass by assigning a quality score based on resolution and predefined thresholds, classifying outputs as either AI-approved or requiring manual intervention. A decision routing layer then determines the next stage—approved passes continue through the pipeline, while failed outputs trigger immediate Slack alerts for senior artist review and manual roto assignment. For approved outputs, the system generates a fully production-ready Nuke roto template, automatically configuring nodes for plate input, AI matte extraction, alpha application, edge refinement, and artist-level roto adjustments, along with structured EXR output paths and naming conventions. The pipeline then proceeds to asset handling, where generated videos are downloaded and distributed via email to requesters, while simultaneously creating Jira review tasks to ensure pipeline tracking and accountability. An aggregation layer consolidates all roto passes into a unified structured summary, combining QC results, video links, task references, and technical metadata. Finally, a team notification system delivers a comprehensive summary to the roto team via Telegram, including per-pass QC status, preview links, task tracking, output paths, and artist notes highlighting areas requiring refinement—ensuring seamless collaboration between AI outputs and human artists. 🚨 Error Handling • Global error trigger across the workflow • Instant Slack alerts with failure details • Prevents silent failures and ensures pipeline reliability 🧩 Prerequisites • Seedance API (AI video generation) • Google Sheets OAuth2 (trigger input) • Jira API (task tracking) • Gmail OAuth2 (asset delivery) • Slack OAuth2 (alerts & QC failures) • Telegram Bot (team notifications) 💡 Key Benefits ✔ Automated roto matte generation with AI-assisted precision ✔ Multiple specialized passes for production flexibility ✔ Built-in QC scoring and intelligent decision routing ✔ Auto-generated Nuke scripts with pre-configured nodes ✔ Integrated task tracking via Jira ✔ Seamless delivery via email and team notifications ✔ Scalable pipeline for high-volume roto workflows 👥 Perfect For Roto and paint teams in VFX studios Compositors working with Nuke pipelines Film and post-production environments AI-assisted rotoscoping workflows Studios handling high-volume shot processing

This template monitors Google Drive folder for new files, extracts text from PDFs, images, text files, CSVs, and Google Docs., reads images with meta/llama-3.2-11b-vision-instruct, structures the result with nvidia/llama-3.3-nemotron-super-49b-v1.5, logs everything to Google Sheets, and sends a Telegram notification when processing finishes. ✨ What This Template Does Watches a specific Google Drive folder for new files with Google Drive Trigger. 📂 Downloads each new file with Google Drive before processing. ⬇️ Routes PDFs, images, text files, CSVs, and Google Docs through the correct extraction branch. 🔀 Extracts image text with meta/llama-3.2-11b-vision-instruct 🖼️ Structures extracted content into JSON fields with nvidia/llama-3.3-nemotron-super-49b-v1.5 through NVIDIA NIM. 🤖 Appends the final result to Google Sheets in Extract_Log. 📊 Sends a Telegram notification when processing is complete. 📬 Key Benefits Turns a Drive folder into a reusable intake point for mixed file types. ⏱️ Creates a searchable audit trail in Google Sheets for every processed file. 📚 Sends a lightweight Telegram notification without requiring Telegram as the input channel. ✅ Keeps the extraction and structuring logic reusable for internal ops or client delivery workflows. 🔁 Makes it easier to test multimodal document processing with free-tier NVIDIA NIM models. 💡 Features Google Drive Trigger configured for new files in a specific folder. 📥 Google Drive download step for binary file access before extraction. ⚙️ File-type routing with Switch and normalization with Code nodes. 🧠 Native n8n Extract from File nodes for PDF, TXT, and CSV parsing. 📄 NVIDIA NIM HTTP Request nodes for image OCR and structured JSON generation. 🤖 Google Sheets append logging with a fixed Extract_Log tab schema. 📈 Plain-text Telegram completion notifications with a fixed destination chat ID. 📨 Requirements n8n instance with access to Google Drive Trigger, Google Drive, Google Docs, Google Sheets, HTTP Request, Telegram, and Extract from File nodes. 🧰 Google Drive OAuth2 credential with access to the watched folder. 🔐 Google Docs OAuth2 credential with access to any Google Docs files you want to process. 📘 Google Sheets OAuth2 credential and a sheet with an Extract_Log tab. 📊 Telegram bot credential plus a valid destination chat ID for notifications. 🤝 NVIDIA NIM API key stored as an HTTP Header Auth credential. 🔑 A folder ID and Google Sheet ID added to the provided placeholders before activation. 🛠️ Target Audience Operations teams monitoring a shared Drive folder for inbound files. 🗂️ Founders and solo operators who want document extraction. 👤 Agencies building reusable back-office workflows for receipts, notes, and uploaded files. 🏢 Analysts who want structured text output logged into Google Sheets automatically. 📋 Automation builders testing file-driven multimodal extraction with Drive as the source. 🧪 Step-by-Step Setup Instructions Import the workflow and read every sticky note on the canvas before editing any nodes. 📝 Connect your Google Drive, Google Docs, Google Sheets, Telegram, and NVIDIA NIM credentials. 🔐 Replace REPLACE_WITH_GOOGLE_DRIVE_FOLDER_ID, REPLACE_WITH_GOOGLE_SHEET_ID, and REPLACE_WITH_TELEGRAM_CHAT_ID in the marked nodes. 📌 Create the Extract_Log tab with the required headers shown in the sticky notes. 📑 Test one file at a time in this order: PDF, TXT, CSV, image, then Google Docs file. 🧪 Confirm that each test adds one clean row to Google Sheets and sends one Telegram notification. ✅ Activate the workflow only after every supported path works end to end. 🚀 Built by Cordexa Technologies https://cordexa.tech | [email protected]

🚀 Automated LinkedIn Post Generator from Article Links (Telegram → AI → Google Sheets → LinkedIn) This workflow lets you collect article links through a Telegram bot, automatically analyze and summarize them with AI, store everything neatly in Google Sheets, and generate polished LinkedIn posts on demand whenever the user types “generate”. Perfect for creators, marketers, and founders who want to post consistently without spending hours analyzing articles or writing drafts. 🧠 How It Works 1️⃣ User Sends Articles via Telegram Your Telegram bot is the main input point. Whenever the user drops a link, the workflow: Detects the URL Fetches the content Sends it to AI for analysis This keeps the process simple. 2️⃣ AI Analyzes & Summarizes the Article The workflow uses your LLM (OpenAI, Anthropic, etc.) to: Summarize the article Extract key insights Identify main arguments Capture tone and context It produces a clean, structured dataset for each link. 3️⃣ Everything is Saved into Google Sheets Each article becomes a new row in your Google Sheet. The sheet serves as your content library with fields like: Date Title Link Summary Insights Commentary You can save dozens of articles and generate posts from any of them later. 4️⃣ User Requests a Post with “generate” When the user types “generate”, the workflow will: Pull the latest article(s) from Google Sheets (or any selection logic you choose) Build a LinkedIn-ready post using AI Apply the requested tone/style Format it as a clean, professional post The final post is sent right back to Telegram — ready to copy/paste into LinkedIn. 🛠️ Setup Steps 🔧 1. Create a Telegram Bot Go to @BotFather on Telegram Create a new bot Copy the API token Paste the token into the Telegram Trigger node in n8n 🔧 2. Add Your AI Credentials Go to Credentials → OpenAI (or your provider) Add your API key Select this credential in all AI nodes You can switch to GPT-4o, GPT-4o-mini, or any model you prefer. 🔧 3. Connect Google Sheets Go to Credentials → Google Authenticate with your Google account Make sure the sheet contains the required columns: Date Title Link Summary Insights Commentary You can customize or add additional columns as needed. 🔧 4. Adjust Workflow Logic (Optional) You can modify: How the AI summarizes The LinkedIn post style How posts are selected (latest, random, specific tone, etc.) Whether you store more metadata Multi-language support Everything is modular. 🔧 5. Test the Flow Send yourself a link via the Telegram bot Check that it appears in Google Sheets Type “generate” Receive your LinkedIn post instantly 🎉 You’re Ready! This workflow helps you build a personal content pipeline that: Collects links Saves ideas Summarizes insights Generates LinkedIn posts on demand All directly from your phone, inside Telegram. If you remix or extend this template, I’d love to see what you build!

Complete Video Documentation: https://youtu.be/O-bKlX3G7_4 Explanation WITH clean Video timestamps: Prerequisites: You need a rental agreement document, a BoldSign account (which has a free tier for testing) [00:44], a Google Sheet, and an n8n instance. BoldSign Setup: How to upload your agreement as a template, drag-and-drop the signature and text fields [01:13], get your API key [01:57], and set up a webhook to notify n8n when the agreement is signed or completed [02:13]. Workflow Logic: The video walks through the two main flows: Form Submission: A tenant fills out a form, which triggers n8n to save the details to Google Sheets and then call the BoldSign API to send the agreement to both the owner and tenant [03:01]. Completion: When both parties sign, BoldSign sends an event to the n8n webhook, which then filters for the "Completed" event and updates the Google Sheet [09:12]. Bonus: It also covers the Telegram bot setup, which lets an owner ask an AI about the status of agreements [11:52]. Prerequisites Before you build this, you'll need a few things: An n8n Instance: This can be on n8n.cloud or self-hosted. A Google Sheet: Create a new sheet with columns like Tenant Name, Tenant Email, Property, Estimated Rent per month, contract expiry, and agreement status. A BoldSign Account: An API Key. [01:57] A prepared rental agreement document (like a PDF or .docx). A BoldSign Template created from that document. You'll need to drag and drop the required fields (like signatures, dates, text boxes) onto the template. [01:13] A Telegram Bot (Optional): If you want the AI status checker, you'll need to create a bot with Telegram's BotFather to get an API token. A Google Gemini API Key (Optional): For the AI agent. In BoldSign, you would replace the {{...}} and [Date] parts with draggable form fields. Understanding the BoldSign API Node The key to sending the agreement is the Send aggrement to Tenant's Email node. This is a standard HTTP Request node, not a special BoldSign node. Method: POST URL: https://api.boldsign.com/v1/template/send?templateId=enter-your-template-id This is the official BoldSign API endpoint for sending a document based on a template. You must replace enter-your-template-id with the actual ID of the template you created in BoldSign [07:04]. Authentication: Header Auth BoldSign uses an API key in the header. You would create a credential in n8n where the Name is X-API-KEY and the Value is the secret API key you got from your BoldSign account [07:16]. Body: The jsonBody is the most important part [08:02]. It's a JSON object that tells BoldSign who to send the agreement to and what data to pre-fill. title: Sets the document title, like "Rental Agreement - 123 Main St". roles: This array defines the signers. One role is for the "Owner", dynamically filling their name and email from the form data. The second role is for the "Tenent" (Tenant), also filling their name and email. existingFormFields & mergeFields: This is where you dynamically insert data into the document. You map the data from your n8n form (like {{ $('Retrive Data from submitted form').item.json.address }}) to the id of the fields you created in your BoldSign template [08:16]. Workflow Explanation (From Scratch) This workflow is actually three separate flows that work together. Flow 1: New Tenant Onboarding (Form to Agreement) This is the main flow that kicks everything off when a new tenant is interested. Node: Tenant Form (Form Trigger) What it is: This node creates a public web form [03:10]. This is the starting point. From Scratch: You'd drag in a Form Trigger node. You add fields for "Your Name" (tenant's name) and "Your Email" (tenant's email). This Workflow: It also cleverly uses hidden fields [03:18] to store the owner's details, the property address, and the rent. This is a simple way to manage a single property. For multiple properties, you might use a database or a Google Sheet lookup. Node: Retrive Data from submitted form (Set) What it is: This node takes the messy data from the form and organizes it into clean, named variables (like tenant_name, address, estimated_rent) [05:25]. From Scratch: It's good practice to do this so the rest of your workflow is easy to read. It also calculates the expiry_date as one year from today. Node: Save the tenant Details (Google Sheets) What it is: This logs the new tenant in your Google Sheet before the agreement is sent [05:51]. From Scratch: You'd set this to "Append or Update" mode. It maps the variables ( tenant_name, tenant_email, etc.) to the correct columns in your sheet. Node: Send aggrement to Tenant's Email (HTTP Request) What it is: This is the BoldSign API call we just detailed. It takes all the data and sends the official signing request to both the owner's and tenant's email addresses [06:47]. Node: Update Agreement Status (Google Sheets) What it is: After the email is successfully sent, this node finds the row you just created (using the tenant's email as a key) and updates the agreement status column to "Pending Signing" [08:55]. This is great for tracking. Flow 2: Handling Signed Agreements (Webhook) This flow listens for activity. It doesn't run on a schedule; it waits for BoldSign to tell it something happened. Node: Webhook (Webhook Trigger) What it is: This node generates a unique URL [02:45]. You copy this URL and paste it into your BoldSign account's webhook settings [09:28]. From Scratch: Now, any time an event happens in BoldSign (like the document is viewed, signed, or completed), BoldSign will send a data packet to this URL, triggering the workflow. Node: If (If) What it is: This is a filter. The webhook gets all events, but we only care about the final one [10:49]. From Scratch: It's set to check the incoming data from the webhook. It looks at a header called x-boldsign-event and only continues if the value equals "Completed" [11:02]. This means it will ignore the "Signed" event (when just one person signs) and only proceed when both parties have signed. Node: Retrieve Tenant Email (Set) What it is: This node digs into the large JSON data packet from the webhook to find the tenant's email [11:17]. From Scratch: It uses a JavaScript .find() function to look through the signerDetails and pull the email for the person whose role was "Tenent" (Tenant). This gives us the unique key to update our spreadsheet. Node: Update Agreement Status as completed (Google Sheets) What it is: The final step\! Just like in Flow 1, this node finds the correct row in the Google Sheet (using the tenant's email) and updates the agreement status column to "Completed" [11:32]. Flow 3: AI-Powered Status Bot (Telegram) This is a bonus flow that lets the owner "chat" with the Google Sheet. Node: Telegram Trigger What it is: This listens for any new message sent to your Telegram bot [11:52]. Node: AI Agent (Langchain Agent) What it is: This is the "brain". It takes the message.text from the Telegram user [12:30]. From Scratch: Its prompt tells it to be a helpful assistant for rental agreements and to use the tools it's given. Node: Google Gemini Chat Model (Google Gemini) What it is: This is the Large Language Model (LLM) that the agent uses to think and form sentences. Node: Fetch Rental Agreements (Google Sheets Tool) What it is: This is not a regular node, but a Tool plugged into the AI Agent [12:35]. From Scratch: You give the AI agent this "tool" and tell it: "This tool, named 'Fetch Rental Agreements', can get all the data from the Google Sheet." When the user asks, "What's the status of Jane Doe's agreement?", the AI knows it must use this tool to get the sheet data before it can answer. Node: Send a text message (Telegram) What it is: This takes the final output from the AI Agent and sends it as a reply to the user in Telegram.

Introduction Automates Singapore COE price tracking with AI forecasts and buy/wait recommendations. Weekly scraping collects LTA data, enriches with economic indicators, predicts 6-month trends, and alerts users via Telegram/email—helping car buyers and fleet managers make data-driven purchase decisions while avoiding manual tracking. How it Works Weekly trigger scrapes LTA COE → validates → stores in Google Sheets → calculates indicators → AI forecasts trends → multi-scenario analysis → generates buy/wait signals → sends actionable alerts. Setup Steps Add OpenAI/NVIDIA API credentials in n8n Authenticate Google Sheets and create spreadsheet Configure Telegram bot or Gmail SMTP Set weekly trigger (Thursday 9AM SGT post-bidding) Adjust alert thresholds in conditional nodes Workflow Schedule Trigger → Scrape COE → Validate → Store Sheets → Fetch Historical → Calculate Indicators → AI Prediction → Merge Economics → Multi-Scenario Analysis → Compare Conditions → Generate Dashboard → Send Alerts Workflow Steps Scraping: Fetch LTA COE results with retry logic Validation: Check completeness, flag anomalies Storage: Append timestamped records to Sheets Enrichment: Calculate moving averages, volatility, seasonality AI Analysis: Forecast next 6 months with confidence intervals Decision Engine: Output buy/wait/monitor recommendation Reporting: Create dashboard and send alerts via Telegram/email Prerequisites OpenAI/NVIDIA API key, Google Sheets access, Telegram bot token or Gmail, basic COE category understanding Use Cases First-time buyers timing purchases, fleet operators coordinating bulk acquisitions Customization Add SMS alerts via Twilio, integrate loan calculators for total cost analysis Benefits Saves 5+ hours monthly, captures 10–18% price dips, provides predictive insights (potential $10K–$25K savings)

Automated SEO Watchlist: Continuous Audits Powered by Decodo, Gemini and Google Sheets Automate continuous SEO audits with Decodo and Gemini AI — live data, smart insights, and Google Sheets tracking with team alerts. Who’s it for This workflow is designed for SEO specialists, marketing teams, agencies, and website owners who want an effortless, automated way to monitor SEO health. It’s perfect for ongoing audits, content monitoring, and proactive SEO management — without the manual workload. How it works / What it does Every five days, the workflow: Reads a list of URLs from Google Sheets. Uses Decodo to fetch live on-page data — titles, meta descriptions, headings, schema, links, and Core Web Vitals. Passes that data to Gemini AI for an advanced SEO analysis and scoring based on key factors (content, metadata, links, speed, and structure). Parses results via a Structured Output Parser for clean JSON output. Stores findings in Google Sheets and sends a Telegram alert when the audit completes. Why Decodo matters Decodo is the backbone of this workflow. It powers the real-time page inspection, ensuring Gemini AI has complete, accurate data to analyze. Decodo transforms static audits into live, intelligent monitoring — making your SEO insights far more actionable and reliable. How to set up Connect your Decodo API credentials. Add your Google Sheets URL list. Configure your Telegram bot credentials. Enable the workflow — it runs automatically every 5 days. Requirements Decodo API credentials Google Sheets OAuth connection Telegram Bot token n8n instance (Cloud or Self-hosted) How to customize the workflow Change the trigger interval in the Schedule Trigger node. Modify the SEO Analyzer (LLM Chain) weights for different scoring. Extend the Store Result node to integrate with dashboards or databases. Adjust the AI prompt for additional SEO checks (e.g., backlinks, readability, image optimization). ✅ Highlights Automated SEO auditing Real-time data from Decodo Smart analysis powered by Gemini AI Structured reporting in Google Sheets Team notifications via Telegram

Introduction Automates Singapore COE price tracking, predicts trends using AI, and recommends optimal car purchase timing. Scrapes LTA data biweekly, analyzes historical trends, forecasts next 6 bidding rounds, and sends alerts when buying windows appear—saving time and identifying cost-saving opportunities. How it Works Biweekly trigger scrapes LTA COE data → processes historical trends → AI predicts 6-month prices → compares current vs forecast → generates buy/wait recommendations → alerts sent via Gmail or Telegram. Setup Steps Add NVIDIA/OpenAI API credentials in n8n Connect Google Sheets for data storage Authenticate Gmail/Telegram for notifications Schedule trigger for Wednesdays 8PM SGT Configure alert thresholds in conditional nodes Workflow Schedule Trigger → HTTP Request (Scrape LTA) → Data Processing → Google Sheets (Store) → AI Prediction → Analysis Engine → Conditional Logic → Gmail/Telegram Notification Workflow Steps Scraping: Extract COE prices from OneMotoring Processing: Calculate moving averages, volatility, seasonal trends Storage: Save to Google Sheets with timestamps Prediction: AI forecasts next 6 bidding rounds Analysis: Compare current vs predicted prices, generate recommendation Notification: Alerts via email/Telegram Prerequisites NVIDIA/OpenAI API key, Google account (Sheets), Gmail/Telegram for notifications, basic COE category knowledge Use Cases First-time buyers monitoring price dips, fleet managers timing bulk purchases Customization Add economic indicators, integrate car loan calculators, track parallel imported car prices Benefits Saves hours of manual monitoring, captures 10–15% price dips, provides data-driven purchase timing (potential $5K–$15K savings)

🧠 Automated Resume & Cover Letter Generator This project is an automation workflow that generates a personalized resume and cover letter for each job listing. 🚀 Features Automated Resume Crafting Generates an HTML resume from your data. Hosts it live on GitHub Pages. Converts it to PDF using Gotenberg and saves it to Google Drive. Automated Cover Letter Generation Uses an LLM to create a tailored cover letter for each job listing. Simple Input Database Agent Stores your experience in an n8n Data Table with the following fields: role, summary, task, skills, tools, industry. The main agent pulls this data using RAG (Retrieval-Augmented Generation) to personalize the outputs. One-Time GitHub Setup Initializes a blank GitHub repository to host HTML files online, allowing Gotenberg to access and convert them. 🧩 Tech Stack Gotenberg** – Converts HTML to PDF GitHub Pages** – Hosts live HTML files n8n** – Handles data tables and workflow automation LLM (OpenAI / Cohere / etc.)** – Generates cover letters Google Drive** – Stores the final PDFs ⚙️ Installation & Setup Create a GitHub Repository This repo will host your HTML resume through GitHub Pages. Set the Webhook URL In the notify-n8n.yml file, replace: role | summary | task | skills | tools | industry Create the n8n Data Table Add the following columns: role | summary | task | skills | tools | industry Create a Google Spreadsheet Add these columns: company | cover_letter | resume Install Gotenberg Follow the installation instructions on the Gotenberg GitHub repository: https://github.com/thecodingmachine/gotenberg Customize the HTML Template Modify the HTML resume to your liking. You can use an LLM to locate and edit specific sections. Add Authentication and Link Your GitHub Repo Ensure your workflow has permission to push updates to your GitHub Pages branch. Run the Workflow Once everything is connected, trigger the workflow to automatically generate and save personalized resumes and cover letters. 📝 How to Use Copy and paste the job listing description into the Telegram bot. Wait for the "Done" notification before submitting another job. Do not use the bot again until the notification appears. The process usually takes a few minutes to complete. ✅ Notes This workflow is designed to save time and personalize your job applications efficiently. By combining n8n automation, LLMs, and open-source tools like Gotenberg, you can maintain full control over your data while generating high-quality resumes and cover letters for every job opportunity.

This workflow automates plant care reminders and records using Google Sheets, Telegram, and OpenWeather API. It checks when each plant needs watering or fertilizing, sends a personalized reminder, and lets you confirm the task with a single button. When confirmed, it updates your Google Sheet and shows a confirmation HTML page. Who is it for? Home gardeners who want to automate watering and fertilizing schedules. Anyone managing a plant collection, greenhouse, or garden and wanting a lightweight, no-code reminder system. How it works Schedule Trigger starts the workflow once per day. Read Settings (Google Sheets) checks if vacation_mode is active. Read Plants (Google Sheets) retrieves all plants with columns such as id, plant, last_water, water_freq, etc. DecideDue (Code Node) compares today’s date with the last watering/fertilizing date and marks which plants are due. OpenWeather Request (optional) fetches local forecast for plants with coordinates and weather_delay = true. WeatherGate (Code Node) skips or delays watering if it recently rained or if rain is expected soon. Telegram Send Message sends a reminder for each due task. The message contains an inline button “Mark as done” linking to your webhook URL (opens confirmation window). Webhook – Confirm Done receives the click, update dates on Google Sheets, appends an optional log entry, and returns an HTML confirmation page. Setup steps Principal Workflow Spreadsheet- Create a Google Sheets document with: plants sheet: (id, plant, last_water, water_freq, last_fert, fert_freq, lat, lon, weather_delay , indoor, thirst_level) settings sheet: (vacation_mode, timezone) log sheet: (ts, plant_id, action message_id) Connect your Google account Configure the Schedule Trigger Enable weather integration (Get a free OpenWeather API key) and add it to the HTTP Request node parameters appid. https://openweathermap.org/api Configure Telegram with your credential and your chat id on {YOUR_CHAT_ID}. Configure "Send Dues" node with your custom url https://{YOUR_PROJECT_URL}.app.n8n... Setup steps Sub-Workflow (Webhook) Trigger: Configure your custom Path. Google Sheets: Connect your Google Account and Map sheets and columns. Requirements · A Google account with access to Google Sheets. . A spreadsheet containing three sheets with headers matching the field names used in the workflow. . A telegram bot. . OpenWeather API key for climate-aware watering. How to customise it Add plant photos: Include a photo URL column and show it in the Telegram message. Extend actions: Add pruning, repotting or any other periodic task by duplicating the existing logic.