Workflow Templates

How it works: This project teaches you to create a personal AI assistant named Jackie that operates through Telegram. Jackie can summarize unread emails, check calendar events, manage Google Tasks, and handle both voice and text interactions. The assistant provides a comprehensive digital life management solution accessible via Telegram messaging. Key Features: Supports hands-free voice interaction Maintains conversation memory Integrates with major Google services Provides personalized assistance for email management, scheduling, and task organization Step-by-step: Telegram Trigger: The workflow starts with a Telegram trigger that listens for incoming message events. The system determines if the incoming message is voice or text input. Voice Processing: If a voice message is received, the workflow retrieves the voice file from Telegram and uses OpenAI's transcription API to convert speech to text. AI Assistant: The processed text (whether original text or transcribed voice) is passed to Jackie, the AI assistant powered by OpenRouter's language model. Tools Integration: Jackie is equipped with several productivity tools: Get Email: Uses Gmail API to fetch unread emails from the inbox with sender, date, subject, and summary information Google Calendar: Retrieves calendar events for specified dates, filtering out irrelevant future events Google Tasks: Both creates new tasks and retrieves existing tasks from Google Tasks lists API Keys Required: Telegram Bot API: Create a bot via @BotFather on Telegram to get your bot token OpenAI API: Required for voice-to-text transcription OpenRouter API: Powers the AI language model responses Google OAuth2: Needed for Gmail, Google Calendar, and Google Tasks integration Response Generation: The AI formulates intelligent responses based on the gathered information, current date context, and conversation history, then sends the response back to the user via Telegram in Markdown format.

beginner

5 nodes34347 views

Extract Amazon Book Data & Generate Purchase Reports with Decodo Scraper

by Trung Tran

Decodo Scraper API Workflow Template (n8n Automation Amazon Book Purchase Report) Watch the demo video below: > This workflow demos how to use Decodo Scraper API to crawl any public web page (headless JS, device emulation: mobile/desktop/tablet), extract structured product data from the returned HTML, generate a purchase-ready report, and automatically deliver it as a Google Doc + PDF to Slack/Drive. Who’s it for Creators / Analysts** who need quick product lists (books, gadgets, etc.) with prices/ratings. Ops & Marketing teams** building weekly “top picks” reports. Engineers** validating the Decodo Scraper API + LLM extraction pattern before scaling. How it works / What it does Trigger – Manually run the workflow. Edit Fields (manual) – Provide inputs: targetUrl (e.g., an Amazon category/search/listing page) deviceType (desktop | mobile | tablet) Optional: maxItems, notes, reportTitle, reportOwner Scraper API Request (HTTP Request → POST) Calls Decodo Scraper API with: URL to crawl, headless JS enabled Device emulation (UA + viewport) Optional waitFor / executeJS to ensure late-loading content is captured HTML Response Parser (Code/Function or HTML node) Pulls the HTML string from Decodo response and normalizes it (strip scripts/styles, collapse whitespace). Product Analyzer Agent (LLM + Structured Output Parser) Prompts an LLM to extract structured “book” objects from the HTML: The Structured Output Parser enforces a strict JSON schema and drops malformed items. Build 📚 Book Purchase Report (Code/LLM) Converts the JSON array into a Markdown (or HTML) report with: Executive summary (top picks, average price/rating) Table of items (rank, title, author, price, rating, link) “Recommended to buy” shortlist (rules configurable) Notes / owner / timestamp Configure Google Drive Folder (manual) Choose/create a Drive folder for output artifacts. Create Document File (Google Docs API) Creates a Doc from the generated Markdown/HTML. Convert Document to PDF (Google Drive export) Exports the Doc to PDF. Upload report to Slack Sends the PDF (and/or Doc link) to a chosen Slack channel with a short summary. How to set up 1 Prerequisites n8n** (self-hosted or Cloud) Decodo Scraper API** key OpenAI (or compatible) API key** for the Analyzer Agent Google Drive/Docs** credentials (OAuth2) Slack** Bot/User token (files:write, chat:write) 2 Environment variables (recommended) DECODO_API_KEY OPENAI_API_KEY DRIVE_FOLDER_ID (optional default) SLACK_CHANNEL_ID 3 Nodes configuration (high level) Edit Fields (Set node) Scraper API Request (HTTP Request → POST) HTML Response Parser (Code node) Product Analyzer Agent Build Book Purchase Report (Code/LLM) Create Document File Convert to PDF Upload to Slack Requirements Decodo**: Active API key and endpoint access. Be mindful of concurrency/rate limits. Model**: GPT-4o/4.1-mini or similar for reliable structured extraction. Google**: OAuth client (Docs/Drive scopes). Ensure n8n can write to the target folder. Slack**: Bot token with files:write + chat:write. How to customize the workflow Target site: Change targetUrl to any **public page (category, search, or listing). For other domains (not Amazon), tweak the LLM guidance (e.g., price/label patterns). Device emulation**: Switch deviceType to mobile to fetch mobile-optimized markup (often simpler DOMs). Late-loading pages**: Adjust waitFor.selector or use waitUntil: "networkidle" (if supported) to ensure full content loads. Client-side JS**: Extend executeJS if you need to interact (scroll, click “next”, expand sections). You can also loop over pagination by iterating URLs. Extraction schema**: Add fields (e.g., discount_percent, bestseller_badge, prime_eligible) and update the Structured Output schema accordingly. Filtering rules**: Modify recommendation logic (e.g., min ratings count, price bands, languages). Report branding**: Add logo, cover page, footer with company info; switch to HTML + inline CSS for richer Docs formatting. Destinations**: Besides Slack & Drive, add Email, Notion, Confluence, or a database sink. Scheduling: Add a **Cron trigger for weekly/monthly auto-reports.

Automate Chinese Language Teaching Posts on Facebook with Gemini & Recraft.ai

by lin@davoy.tech

Workflow Overview This workflow automates the process of creating and publishing engaging Facebook posts that teach Chinese words to a Thai-speaking audience. It integrates multiple AI models, APIs, and tools to generate content, create visuals, and publish posts seamlessly. Below is a detailed breakdown of the workflow: Who Is This Template For? Social Media Managers: Teams managing Facebook pages and looking for automated, engaging content creation. Content Creators: Professionals who want to streamline the process of generating educational and visually appealing posts. Language Enthusiasts: Individuals or organizations teaching languages (e.g., Chinese) to a Thai-speaking audience. What Problem Does This Workflow Solve? Creating engaging social media content manually can be time-consuming and inconsistent. This workflow solves that by: Automating the generation of educational posts in Thai with Chinese vocabulary. Creating visually appealing images tailored to the post's theme. Publishing posts directly to Facebook using the Pages API. What This Workflow Does Input Handling The workflow starts with an input word (e.g., received via chat or fetched from a Google Sheet). The input is split into two variables (word and input) to ensure data persistence throughout the workflow. Generate Text Content An AI model (OpenRouter Chat Model) generates a structured Facebook post in Thai, including: Engaging hook Core vocabulary (Chinese word, Pinyin, and Thai meaning) Real-world usage examples Pro-tip or fun fact Call-to-action for engagement Relevant hashtags Describe Image Concept Another AI model creates a brief description of the visual theme for the post. This description is used as input for generating an image. Generate Image The workflow uses Recraft.ai to generate an image based on the description. The image is styled consistently using predefined themes (e.g., digital illustration). Publish Post The generated text and image are published to Facebook using the Pages API. The post includes: The educational content as the caption. The generated image as the visual element. Setup Guide Pre-Requisites Access to the following APIs: OpenRouter.ai: For generating text content and image descriptions. Recraft.ai: For generating images. Facebook Graph API: For publishing posts. Step-by-Step Setup Configure Input Source: Replace the chat input node with your preferred source (e.g., Google Sheet, email, or manual input). Set Up OpenRouter.ai: Configure the credentials for OpenRouter.ai in the respective nodes (OpenRouter Chat Model and OpenRouter Chat Model1). Set Up Recraft.ai: Add your API key for Recraft.ai in the Generate Image (Recraft.ai) node. Configure Facebook Graph API: Set up the Facebook Graph API credentials with the required permissions (pages_manage_posts, pages_read_engagement, etc.). Update the page_id and graphApiVersion in the Facebook Graph API node. Test the Workflow: Run the workflow manually to verify that it generates content, creates images, publishes posts, and logs details correctly. How to Customize This Workflow to Your Needs Change Input Source: Replace the chat input with a Google Sheet, email, or database query. Modify Content Style: Adjust the AI prompts to suit your audience (e.g., professional tone, casual language). Use Different Image Styles: Experiment with other styles/themes in Recraft.ai for the generated images. Expand Use Cases: Adapt the workflow to other social media platforms (e.g., Instagram, LinkedIn) by modifying the API calls. Why Use This Template? Efficiency: Automates repetitive tasks like content creation and image generation. Consistency: Ensures posts follow a consistent format and style. Engagement: Creates visually appealing and interactive content to boost audience engagement. Scalability: Easily adaptable for different topics, languages, or platforms. Additional Resources

6 nodes3 views

Find Perfect Jobs & Generate Tailored Cover Letters with Gemini & Google Jobs

by Khairul Muhtadin

Say goodbye to endless applications and hello to more time for perfecting your interview skills! The JOB Hunter Agent uses the power of Google Gemini and SerpAPI to find the perfect job match and generate a personalized cover letter. Result example: 💡 Why Use JOB Hunter Agent? Save Precious Time: Stop sifting through countless job boards; this agent does the heavy lifting, saving you hours every week. Land Your Dream Job Faster: Get laser-focused job matches and a custom-crafted cover letter that speaks directly to the hiring manager, increasing your chances of getting noticed. Never Miss an Opportunity: Your personal AI assistant works 24/7, ensuring you're always on top of the latest openings, even while you sleep! Stand Out from the Crowd: A perfectly tailored cover letter generated on the fly gives you an edge over generic applications, making you look like a superstar. ⚡ Perfect For Job Seekers: Anyone actively looking for a new role who wants to streamline their application process. Busy Professionals: Those with limited time who need an efficient way to find relevant opportunities. Career Changers: Individuals exploring new industries who need a helping hand in crafting compelling applications. 🔧 How It Works ⏱ Trigger: You submit your CV and job preferences through a simple n8n form. 📎 Process: Your CV is extracted from the PDF, and your preferences (location, job type, salary, email) are neatly organized. 🤖 Smart Logic: The "Job Hunter Agent" uses Google Gemini and SerpAPI to find the single best job match for you and then drafts a bespoke cover letter based on your CV and the job description. It's like magic, but with more code! 💌 Output: A beautifully formatted HTML email containing your profile summary, the best job match, your personalized cover letter, and handy application tips is sent straight to your inbox. 🗂 Storage: All the initial data from your form submission is processed and used to craft your perfect job application package. 🔐 Quick Setup Import JSON file to your n8n instances Add credentials: Google Gemini (Gemini 2.5 Pro model) and SerpAPI Customize: Adjust the system prompt in the "Job Hunter Agent" to fine-tune the cover letter tone or length, update the email footer, and expand job filters. Update: Ensure your Gmail OAuth2 credentials are valid for sending emails. Test: Run the workflow with your own CV and preferences to see the magic happen! 🧩 You'll Need Active n8n instances Google Gemini API key (for Gemini 2.5 Pro) SerpAPI account for Google Jobs search results A Gmail account for sending personalized job match emails 🛠️ Level Up Ideas Integrate with LinkedIn, Jobstreet, or Indeed APIs for a wider range of job sources. Allow the agent to find multiple job matches and present them as a curated list. Add an option to attach a parsed CV summary as a PDF to the email for quick reference. Made by: khaisa Studio Tags: AI, Gemini, Google Jobs, Job Search, Automation, Cover Letter Category: job hunter Need custom work? Contact me

beginner

5 nodes622 views

Auto-Create TikTok Videos with VEED.io AI Avatars, ElevenLabs & GPT-4

by Dr. Firas

💥 Viral TikTok Video Machine: Auto-Create Videos with Your AI Avatar 🎯 Who is this for? This workflow is for content creators, marketers, and agencies who want to use Veed.io’s AI avatar technology to produce short, engaging TikTok videos automatically. It’s ideal for creators who want to appear on camera without recording themselves, and for teams managing multiple brands who need to generate videos at scale. ⚙️ What problem this workflow solves Manually creating videos for TikTok can take hours — finding trends, writing scripts, recording, and editing. By combining Veed.io, ElevenLabs, and GPT-4, this workflow transforms a simple Telegram input into a ready-to-post TikTok video featuring your AI avatar powered by Veed.io — speaking naturally with your cloned voice. 🚀 What this workflow does This automation links Veed.io’s video-generation API with multiple AI tools: Analyzes TikTok trends via Perplexity AI Writes a 10-second viral script using GPT-4 Generates your voiceover via ElevenLabs Uses Veed.io (Fabric 1.0 via FAL.ai) to animate your avatar and sync the lips to the voice Creates an engaging caption + hashtags for TikTok virality Publishes the video automatically via Blotato TikTok API Logs all results to Google Sheets for tracking 🧩 Setup Telegram Bot Create your bot via @BotFather Configure it as the trigger for sending your photo and theme Connect Veed.io Create an account on Veed.io Get your FAL.ai API key (Veed Fabric 1.0 model) Use HTTPS image/audio URLs compatible with Veed Fabric Other APIs Add Perplexity, ElevenLabs, and Blotato TikTok keys Connect your Google Sheet for logging results 🛠️ How to customize this workflow Change your Avatar:* Upload a new image through Telegram, and *Veed.io** will generate a new talking version automatically. Modify the Script Style:** Adjust the GPT prompt for tone (educational, funny, storytelling). Adjust Voice Tone:* Tweak *ElevenLabs** stability and similarity settings. Expand Platforms:** Add Instagram, YouTube Shorts, or X (Twitter) posting nodes. Track Performance:** Customize your Google Sheet to measure your most successful Veed.io-based videos. 🧠 Expected Outcome In just a few seconds after sending your photo and theme, this workflow — powered by Veed.io — creates a fully automated TikTok video featuring your AI avatar with natural lip-sync and voice. The result is a continuous stream of viral short videos, made without cameras, editing, or effort. ✅ Import the JSON file in n8n, add your API keys (including Veed.io via FAL.ai), and start generating viral TikTok videos starring your AI avatar today! 🎥 Watch This Tutorial 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

6 nodes121 views

Generate Social Media Captions for Product Images with Gemini AI and Telegram Approval

by Ketan Sharma

This n8n template demonstrates a complete AI-driven content pipeline for social media. It automatically generates captions and hashtags for new product images, collects human approval via Telegram, and publishes approved content to Twitter. It’s ideal for marketers, e-commerce businesses, and creators who want to speed up content creation while keeping human oversight. How it works Trigger: The workflow starts when a new file is added to a specific Google Drive folder. File Analysis: The image is processed to extract product information. AI Captioning: Gemini generates a caption and five relevant hashtags based on the product. Telegram Approval: The image, caption, and hashtags are sent to the user for approval. ✅ If approved → The content is posted to Twitter and a confirmation is sent back via Telegram. 🔄 If regenerate → Gemini creates a new caption and hashtags, and the approval loop repeats. ❌ If discard → A message is sent on Telegram and the workflow ends. Requirements Google Drive account Gemini API credentials for captioning and hashtags Telegram bot for approvals Twitter Developer Account with API credentials Customising this workflow Swap Google Drive with Dropbox, Notion, or Airtable as the content source. Extend publishing to LinkedIn, Instagram, or multiple platforms. Add multi-user approval flows in Telegram for team-based decisions.

6 nodes

Automated Trip Expense Claim Form With OpenAI Agent & Google Drive

by Trung Tran

🧾 Automated Trip Expense Claim Form With OpenAI Agent & Google Drive Watch the demo video below: > This workflow is designed for employees who need to submit expense claims for business trips. It automates the process of extracting data from receipts/invoices, logging it to a Google Sheet, and notifying the finance team via email. 👤 Who’s it for Ideal users: Employees submitting business trip expense claims HR or Admins reviewing travel-related reimbursements Finance teams responsible for processing claims ⚙️ How it works / What it does Employee submits a form with trip information (name, department, purpose, dates) and uploads one or more receipts/invoices (PDF). Uploaded files are saved to Google Drive for record-keeping. Each PDF is passed to a DocClaim Assistant agent, which uses GPT-4o and a structured parser to extract structured invoice data. The data is transformed and formatted into a standard JSON structure. Two parallel paths are followed: Invoice records are appended to a Google Sheet for centralized tracking. A detailed HTML email summarizing the trip and expenses is generated and sent to the finance department for claim processing. 🛠 How to set up Create a form to capture: Employee Name Department Trip Purpose From Date / To Date Receipt/Invoice File Upload (multiple PDFs) Configure file upload node to store files in a specific Google Drive folder. Set up DocClaim Agent using: GPT-4o or any LLM with document analysis capability Output parser for standardizing extracted receipt data (e.g., vendor, total, tax, date) Transform extracted data into a structured claim record (Code Node). Path 1: Save records to a Google Sheet (one row per expense). Path 2: Format the employee + claim data into a dynamic HTML email Use Send Email node to notify the finance department (e.g., finance@yourcompany.com) ✅ Requirements n8n running with access to: Google Drive API (for file uploads) Google Sheets API (for logging expenses) Email node (SMTP or Gmail for sending) GPT-4o or equivalent LLM with document parsing ability PDF invoices with clear formatting Shared Google Sheet for claim tracking Optional: Shared inbox for finance team 🧩 How to customize the workflow Add approval steps**: route the email to a manager before finance Attach original PDFs**: include uploaded files in the email as attachments Localize for other languages**: adapt form labels, email content, or parser prompts Sync to ERP or accounting system**: replace Google Sheet with QuickBooks, Xero, etc. Set limits/validation**: enforce max claim per trip or required fields before submission Auto-tag expenses**: add categories (e.g., travel, accommodation) for better reporting

7 nodes98 views

Optimize multi-property rents and analytics with GPT-4o and Google Sheets

by Cheng Siong Chin

How It Works This workflow automates comprehensive real estate investment analysis by orchestrating specialized AI agents to evaluate property data, market trends, and financial metrics. Designed for real estate investors, portfolio managers, and property analysts managing multiple properties or evaluating acquisition opportunities, it eliminates the manual research and analysis that typically requires days of work across multiple data sources. The system aggregates data from real estate APIs, market databases, and local statistics, then deploys specialized agents: performance analysis evaluates ROI and cash flow, recommendation engines identify optimal properties, market analysis assesses location trends, sentiment analysis mines reviews and local feedback, and workflow tools calculate financial projections. An orchestrator coordinates these agents to generate consolidated investment reports with property rankings, risk assessments, and portfolio recommendations. Results populate Google Sheets dashboards and trigger email notifications, transforming weeks of analysis into automated insights delivered in hours. Setup Steps Configure real estate API credentials (Zillow/Realtor.com) Add market data API keys for local statistics and demographics Input NVIDIA API keys for all OpenAI Model nodes Set OpenAI API key in Team Collaboration Agent/Orchestrator Configure Calculator Tool parameters for financial projections Connect Google Sheets and specify portfolio tracking spreadsheet ID Set up Gmail credentials and specify recipient addresses for reports Prerequisites NVIDIA API access, OpenAI API key, real estate data API subscriptions Use Cases Multi-property portfolio analysis, acquisition opportunity screening. Customization Adjust investment criteria thresholds, add custom financial metrics Benefits Reduces analysis time by 90%, evaluates unlimited properties simultaneously

Create automated video ad clones with NanoBanana, Kling, Airtable and Blotato

by Dr. Firas

💥 Clone Video Ads Factory using NanoBanana, Kling and Publish with Blotato 📄 Documentation: Notion Guide Who is this for? This workflow is built for marketers, growth hackers, agencies, content creators, and automation builders who want to industrialize video ad production. Perfect for anyone running paid ads, social media campaigns, UGC-style content, dropshipping creatives, AI ad testing, or scalable content factories. What problem is this workflow solving? / Use case Creating high-performing video ads is: Slow Manual Expensive Hard to scale Hard to test in volume This workflow solves: ❌ Manual editing ❌ Manual prompt writing ❌ Manual scene creation ❌ Manual video assembly ❌ Manual audio integration ❌ Manual publishing It turns one input video + prompt into a fully automated ad production pipeline. What this workflow does This automation system acts as a full AI video ads factory: Step-by-step pipeline: Video Analysis Breaks down the source video into cinematic scenes Extracts structure, rhythm, composition, pacing, and visual logic Prompt Engineering Generates structured prompts for: Images Videos Music Captions Global script Scene structure Image Generation Uses NanoBanana to generate consistent AI images per scene Keeps visual identity across scenes Video Generation Uses Kling to generate cinematic video clips Scene-based video creation Video Merging Automatically merges all generated scenes into one final video Music Generation Generates a full song from prompt (AI music model) Audio + Video Merge Merges generated music with the final video Publishing Automatically publishes content using Blotato Creates posts and media assets ➡️ Result: Fully automated AI video ad production system Setup Required accounts: Airtable fal.ai AtlasCloud** Blotato** Initial configuration: Create Airtable base Add required fields: Original Video Avatar Image Product Image Status Prompts Scenes Music File Final Video Add API keys in the Setup nodes: AtlasCloud fal.ai Airtable Blotato Expected outcome You get a fully automated AI content factory that can: Clone ad styles Scale ad production Test creatives at scale Generate UGC-style ads Build content farms Automate marketing pipelines Create AI ad studios Run continuous ad experiments Typical use cases AI UGC ad factories Dropshipping ad automation SaaS promo videos Influencer content cloning Brand video scaling Marketing automation Ad testing labs Growth hacking pipelines AI content studios 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n

7 nodes583 views

Update Zammad Roles by Excel

by Sirhexalot

This n8n workflow allows you to update user roles in Zammad based on data from an Excel file. The workflow automates role assignments, ensuring efficient and consistent updates. Features Excel Integration**: Import user data from an Excel file containing emails and role assignments. Dynamic Updates**: Match Zammad users by email and update their roles. Error Handling**: Continue workflow execution even if some updates fail. Customizable Variables**: Configure Zammad API URL, API key, and Excel file URL. Usage Import the Workflow: Upload the provided .json file into your n8n instance. Set Variables: zammad_base_url: Your Zammad instance URL. excel_source_url: URL of the Excel file containing user data. Authentication for Zammad Create in the Node "Find Zammad User by email" and "Update User Roles" a Header Auth Authentication Name**: Authorization Value**: Bearer <put here your zammad api token> Run the Workflow: Execute the workflow to update user roles based on the Excel data. Issues and Suggestions For issues or suggestions, visit the GitHub Repository.

Create screenshots with uProc, save to Dropbox and send by email

by Miquel Colomer

Do you want to create a website screenshot without browser extensions? This workflow creates screenshots of any website using the uProc Get Screenshot by URL tool and sends an email with the screenshots. You need to add your credentials (Email and API Key - real -) located at Integration section to n8n. Node "Create Web + Email Item" can be replaced by any other supported service returning Website and Email values, like Google Sheets, Mailchimp, MySQL, or Typeform. Every "uProc" node returns an image URL of the captured website. This generated URL will remain only 24 hours in our server. You can set up the uProc node with several parameters: width: you can choose one of the predefined values to generate the screenshot, or you can set up a custom width you want. full-page: the tool will return a screenshot of the website from top to bottom with the defined width. In our workflow, we generate two screenshots: 1) One screenshot of 640 pixels width. 2) One full-page screenshot of 640 pixels width. Screenshots are downloaded by "Get File" nodes and saved to the screenshots folder in Dropbox. Finally, we use the Amazon SES node to send an HTML email with both screenshots to the specified email. We will receive the next email: