Extract text from images with Telegram Bot & OCR Tesseractjs
Description This n8n workflow enables users to send an image to a Telegram bot and receive the extracted text using Tesseract OCR (via the n8n-nodes-tesseractjs Community Node). It's a quick and straightforward way to convert images into readable text directly through chat. How it Works The workflow listens for new image messages coming in via the Telegram bot. Once an image is received, it downloads the image file from Telegram (which initially arrives as application/octet-stream). The image data, now properly identified, is then sent to the Tesseract OCR node to extract the text. Finally, the recognized text is sent back as a reply to the Telegram user. Setup Steps Install Community Node: Ensure you have installed n8n-nodes-tesseractjs in your n8n instance. Connect Telegram Bot: Configure the Telegram Trigger node with your Telegram bot. Bot Token: Add your Telegram bot token to the Send Message node to send replies. Deploy & Test: Activate (deploy) the workflow and send an image to your Telegram bot to test.
By Rudi AfandiStreamline data from an n8n form into Google Sheet, Airtable and Email Sending
Streamline data from an n8n form into Google Sheet Airtable and and Email Sending Video for workflow process This workflow facilitates efficient data collection and management by leveraging the capabilities of various nodes within the n8n platform. It commences with the n8n Form Trigger node, where users provide their name, location, and email address. Subsequently, the data seamlessly flows through nodes like Google Sheets, Code, Set, Airtable, Gmail, and Gmail1 for processing and storage. n8n Form Trigger: Gathers user input data, including Name, City, and Email. Google Sheets: Manages data operations related to Google Sheets. Code: Executes JavaScript code to manipulate data fields. Set: Formats and sets data values for further processing. Airtable: Facilitates data operations specific to Airtable. Gmail: Sends custom emails to the provided Email address. Gmail: Sends additional emails using different templates. Each node within the workflow performs specialized tasks such as extracting date and time fields, formatting data, appending it to Google Sheets and Airtable, and sending personalized emails to the submitter. This streamlined process ensures effective handling of collected information and enhances overall data management efficiency. Workflow Description: n8n Form Trigger: A trigger node that initiates the workflow upon form submission. Captures essential user details like Name, City, and Email. Extracting Date and Time Fields from 'submittedAt' Field: Utilizes a code node to extract Date and Time information from the submitted data. Format the Fields: Standardizes the format of extracted fields (Name, City, Date, Time, Email) for consistency. Airtable: Creates a new record in Airtable with the formatted data. Includes columns for Name, City, Email, Time, and Date. Google Sheets: Appends the formatted data to a designated Google Sheet. Includes columns for Name, City, Email, Date, and Time. Gmail: Sends an email to the provided Email address with a customized message. Subject: "Testing Text Message Delivery" Message: Personalized content with a Name placeholder. Gmail1: Sends another email using a different template. Subject incorporates the Date field for variation. Message content tailored to the subject line. Workflow Connections: n8n Form Trigger -> Extracting Date and Time Fields -> Format the Fields -> Google Sheets & Airtable -> Gmail Google Sheets -> Gmail1 This comprehensive workflow efficiently collects user data, processes it to extract Date and Time fields, stores the formatted information in Google Sheets and Airtable, and delivers tailored emails to the recipients. Copy these templates to get started : Google Sheet Airtable Links to Node Documentation: n8n Form Trigger Documentation Code Node Documentation Set Node Documentation Airtable Node Documentation Google Sheets Node Documentation Gmail Node Documentation
By AlQaisiSmart Gmail cleaner with AI validator & Telegram alerts
Automatically clean up your Gmail inbox by deleting unwanted emails, validated by Gemini AI. Ideal for anyone tired of manual inbox cleanup, this workflow helps you save time while staying in control, with full transparency via Telegram alerts. How it works Scans Gmail inbox in adjustable 2-week batches Uses Gemini AI to decide if an email should be deleted or skipped Applies a label to skipped emails to avoid rechecking in future runs Deletes unwanted emails and sends a Telegram message with the AI's reasoning Also notifies on skipped emails, with explanation included Set up steps Connect your Gmail, Gemini AI, and Telegram accounts Adjust the AI baseline to control sensitivity (e.g. how strict the filtering should be) Set your batch range (default: last 2 weeks, adjustable) Define your Telegram chat/channel for notifications --- Note: Thanks to n8n's modular design, you can easily switch Gemini for another AI model (like OpenAI, Claude, etc.) or replace Telegram with Discord, Slack, or even email, no code changes needed, just swap the nodes.
By ReyhanExport WordPress posts to spreadsheet
Export WordPress Posts to Spreadsheet and download .csv to your local machine.
By Przemek ChojeckiAI-powered reservation reminder calls for restaurant with Twilio & Grok-4
🤖📞 This workflow automates the process of calling customers to remind them of their booking reservations using AI-generated messages and a Twilio phone number. It can easily be adapted for other venues. --- Key Benefits Time-Saving Automation: Eliminates the need for manual calls by staff, saving hours per week. Human-like AI Messages: Uses a custom language model to generate polite, natural phone messages tailored to each customer. Multi-Channel Integration: Google Sheets for reservation tracking. Twilio for automated calling. OpenRouter (or other LLMs) for generating speech content. Error Reduction: Ensures all customers receive reminders exactly on the reservation day, minimizing no-shows. Scalable: Easily adapts to growing reservation lists and more complex message logic. Suitable for restaurants, hairdressers, offices and any other business --- How It Works Trigger: The workflow can be triggered manually (via "When clicking ‘Execute workflow’) or automatically at 11 AM daily (via Schedule Trigger). Data Fetch: Retrieves today’s reservations from a Google Sheet, filtering rows where DATE = today and CALLED is empty. AI-Generated Call Script: For each reservation, the Secretary Agent (powered by OpenRouter’s Grok-4) generates a phone script using the guest’s name, time, and party size. Twilio Call: The script is sent to Twilio, which calls the guest’s phone number (from the sheet) and reads the message aloud using text-to-speech. Update & Loop: Marks the reservation as called (CALLED = "x") in the sheet and waits 2 minutes between calls to avoid rate limits. --- Set Up Steps Twilio Configuration: Sign up for Twilio, buy a phone number, and: Enable text-to-speech (set language to Italian). Configure geo permissions for the target country. Add credentials to the Twilio node (sender number in From field). Google Sheets Setup: Clone the Google Sheet template and ensure: Phone numbers include the international prefix (without "+"). Columns: DATE, TIME, NAME, N. PEOPLE, PHONE, CALLED. OpenRouter API: Connect the OpenRouter Chat Model node to your account (using Grok-4 or another model). Deploy: Activate the workflow and test with manual execution. Note: The workflow is currently inactive (active: false). Enable it after setup. ---- Need help customizing? Contact me for consulting and support or add me on Linkedin.
By DavideGenerate YouTube scripts for shorts & long-form with Gemini AI and Tavily Research
🤖 Automated YouTube Script Generator (Shorts & Long-Form) This workflow is a content multiplier. Provide a single video topic via a form, and it automatically researches, outlines, and writes two separate scripts: one for a YouTube Shorts and another for a Long-form video, saving both directly to Google Docs. --- ✨ Key Features Dual-Format Output: Creates tailored scripts for both Shorts and long-form videos from one idea. AI-Powered Writing: Uses Google Gemini for all creative steps, from building a structured outline to writing the final scripts. Up-to-Date Research: Integrates Tavily AI to pull fresh, relevant information from the web. Fully Automated: An end-to-end process that takes a form submission and delivers final documents to your Google Drive with no manual steps. --- ⚙️ How It Works After a topic is submitted, the workflow splits into two parallel branches: The Shorts Branch: This path is built for speed. It performs a quick web search and immediately uses an AI agent to write a short, punchy script. The Long-Form Branch: This path focuses on structure. It conducts a web search, uses an AI agent to first create a detailed outline, and then uses another AI agent to write a comprehensive script based on that outline. --- 🔑 Prerequisites An active n8n instance. A form to submit your video topic. API keys for Tavily AI and Google Gemini. Google Account credentials (OAuth2) configured in n8n for Google Docs. --- 🛠️ Setup Guide On form submission Trigger: Configure your form to accept a field for your video topic (e.g., a field named topic). Tavily Nodes: In both Tavily nodes, select or create your Tavily API credential and paste in your API key. Google Gemini Chat Model: In the nodes labeled AI Agent and Create Outline, select your Google AI credential linked to your Gemini API key. Google Docs Nodes: For all four Google Docs nodes (Create Doc, Update Doc, etc.), select your Google OAuth2 credential. Activate the Workflow: Once all credentials are in place, save and activate the workflow. --- 🚀 How to Use Activate the workflow. Submit your topic via the connected form. Check your Google Drive a few moments later for your the new script!
By Anshul ChauhanSend message on Mattermost when your n8n instance starts
This workflow allows you to receive a message on Mattermost when your n8n instance starts. n8n Trigger node: The n8n Trigger node will trigger the workflow whenever the instance starts. Mattermost node: This node will send a message on Mattermost, notifying you when n8n starts.
By Harshil AgrawalGet new time entries from Toggl
No description available.
By tanaypantTrack SEO keyword rankings in Google Search with ScrapingBee API
Who is this template for? This SEO Reporting workflow template is ideal for digital marketers, SEO consultants, content strategists, and founders who need to quickly gather, format, and store Google search result data. If you regularly audit SERPs, track keyword performance, or monitor competitors, this automation lets you generate polished SEO reports in seconds—ready to share or analyze further. What problem does this workflow solve? Scraping and formatting Google search results for SEO insights is often manual, repetitive, and error-prone or requires expensive software. Professionals frequently face challenges like: Collecting live, structured data from Google for multiple keywords Converting raw search results into readable reports for clients or stakeholders Logging changes in rankings or URLs across time for historical tracking Exporting SEO data into spreadsheets for deeper analysis High monthly software fees What this workflow does This n8n workflow scrapes the top organic Google search results for a given keyword and automatically creates a downloadable report while also logging the results in a table format for long-term storage or further processing. Here’s what it includes: A trigger form that accepts a search keyword from the user An automated API call to fetch Google’s SERP data Two output formats: a formatted HTML table for emails and a Markdown table for download (e.g., for Excel, Airtable or Google Sheets) Automatic CSV file generation for download Optional email delivery of the report Setup Getting started is simple: Enter your API key Add your API key to the “Scrape Google SERPs” HTTP Request node (Step-by-step guide inside the template) Replace the default query with your own custom Google search parameters if needed Set up delivery options Update your email in the “Mail SEO Report” node for report delivery Use the downloadable file output from the “Convert to File” node Optional: Add a Google Sheets (or similar) node which imports the file Test the workflow Use the built-in form to input a keyword Confirm that results appear in both your email and downloadable file Activate the workflow Turn on the trigger so your team or clients can submit keywords at any time How to customize this workflow This template is easy to extend for a variety of SEO automation needs: Add a loop to handle multiple keywords at once Connect to Airtable, Notion or Google Sheets Integrate with Slack or Discord for notifications Apply additional filtering to track only new or changed search results Schedule it to run daily or weekly with a cron trigger By combining live SERP scraping, report formatting, and spreadsheet integration, this workflow gives you a fast and flexible SEO reporting system you can use right away or scale up as needed.
By GegenfeldPostgres data freshness monitoring with email alerts
Monitor Postgres Data Freshness and Email Alert If Stale This template monitors a set of tables inside a Postgres database to ensure they're getting updated. If the table hasn't been updated in 3 days (configurable), an email alert is sent containing the tables that are stale. Requirements You must have a Postgres database containing one or more tables that you'd like to monitor. Each table to monitor must have a date or timestamp column that tracks when data was pushed. For example, this might be: A timestamp column if your table holds event/timeseries data A last_updated column if your rows are expected to be modified Usage Use this template Add your Postgres and email credentials Adjust the Produce tables + date columns node to produce pairs of [table, date_column] that should be monitored for freshness 💁♂️ Note that a timestamp column also works (Optional) Adjust the Remove fresh tables node for your desired staleness window (default is 3 days, but you can adjust as you please) (Optional) Customize the Send alerts node to call whichever alerting workflow you please (I recommend my alerting workflow for easiest plug-and-play) How it works This template works by: Pulling the most recent row for each table Calculating how out-of-date each table is, in days Dropping fresh tables that have been updated within the past 3 days Sending an email alert with the stale tables that haven't been updated within the past 3 days
By KevinQualify and route sales leads with Mistral-Saba AI and MCDM scoring
How It Works The workflow starts with a scheduled trigger that activates at set intervals. Behavioral data from multiple sources is parsed and sent to the MCDN routing engine, which intelligently assigns leads to the right teams based on predefined rules. AI-powered scoring evaluates each prospect’s potential, ensuring high-quality leads are prioritized. The results are synced to the CRM, and updates are reflected on an analytics dashboard for real-time visibility. Setup Steps Trigger: Define schedule frequency. Data Fetch: Configure APIs for all behavioral data sources. MCDN Router: Set routing rules, thresholds, and team assignments. AI Models: Connect OpenAI/NVIDIA APIs and configure scoring prompts. CRM Integration: Enter credentials for Salesforce, HubSpot, or other CRMs. Dashboard: Link to analytics tools like Tableau or Google Sheets for reporting. Prerequisites API credentials: NVIDIA AI, OpenAI, CRM platform; data sources; spreadsheet/analytics access Use Cases Lead prioritization for sales teams; customer segmentation; automated routing; Customization Adjust routing rules, add custom scoring models, modify team assignments, expand data sources, integrate additional AI providers Benefits Reduces manual lead routing 90%; improves scoring accuracy; accelerates sales cycle; enables data-driven team assignments;
By Cheng Siong Chin