Personal life manager with Telegram, Google services & voice-enabled AI
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.
By Derek CheungAutomated job hunter: Upwork opportunity aggregator & AI-powered notifier
๐ Automated Job Hunter: Upwork Opportunity Aggregator & AI-Powered Notifier! Workflow Overview This cutting-edge n8n automation is a sophisticated job discovery and notification tool designed to transform freelance job hunting into a seamless, intelligent process. By intelligently connecting Apify, OpenAI, Google Sheets, and Gmail, this workflow: Discovers Job Opportunities: Automatically scrapes Upwork job listings Tracks recent freelance opportunities Eliminates manual job searching efforts Intelligent Data Processing: Filters and extracts key job details Structures job information Ensures comprehensive opportunity tracking AI-Powered Summarization: Generates concise job summaries Creates human-readable job digests Provides quick, actionable insights Seamless Notification: Automatically logs jobs to Google Sheets Sends personalized email digests Enables rapid opportunity assessment Key Benefits ๐ค Full Automation: Zero-touch job discovery ๐ก Smart Filtering: Targeted job opportunities ๐ Comprehensive Tracking: Detailed job market insights ๐ Multi-Platform Synchronization: Seamless data flow Workflow Architecture ๐น Stage 1: Job Discovery Scheduled Trigger: Daily job scanning Apify Integration: Upwork job scraping Intelligent Filtering: Recent job postings Specific keywords Relevant opportunities ๐น Stage 2: Data Extraction Comprehensive Job Metadata Parsing Key Information Retrieval Structured Data Preparation ๐น Stage 3: AI Summarization OpenAI GPT Processing Professional Summary Generation Contextual Job Insight Creation ๐น Stage 4: Multi-Platform Distribution Google Sheets Logging Gmail Integration Automated Job Digest Delivery Potential Use Cases Freelancers: Opportunity tracking Job Seekers: Automated job discovery Recruitment Agencies: Market intelligence Skill Development Professionals: Trend monitoring Career Coaches: Client opportunity identification Setup Requirements Apify Upwork scraping actor API token Configured scraping parameters OpenAI API GPT model access Summarization configuration API key management Google Sheets Connected Google account Prepared job tracking spreadsheet Appropriate sharing settings Gmail Account Connected email Job digest configuration Appropriate sending permissions n8n Installation Cloud or self-hosted instance Workflow configuration API credential management Future Enhancement Suggestions ๐ค Advanced job matching algorithms ๐ Multi-platform job aggregation ๐ Customizable alert mechanisms ๐ Expanded job category tracking ๐ง Machine learning job recommendation Technical Considerations Implement robust error handling Use secure API authentication Maintain flexible data processing Ensure compliance with platform guidelines Ethical Guidelines Respect job poster privacy Use data for legitimate job searching Maintain transparent information gathering Provide proper attribution Hashtag Performance Boost ๐ FreelanceJobHunting CareerAutomation JobDiscovery AIJobSearch WorkflowAutomation FreelanceTech CareerIntelligence JobMarketInsights ProfessionalNetworking TechJobSearch Workflow Visualization plaintext [Daily Trigger] โฌ๏ธ [Fetch Upwork Jobs] โฌ๏ธ [Format Job Fields] โฌ๏ธ [Log to Google Sheets] โฌ๏ธ [AI Summarization] โฌ๏ธ [Send Email Digest] Connect With Me Ready to revolutionize your job hunting strategy? ๐ง Email: Yaron@nofluff.online ๐ฅ YouTube: @YaronBeen ๐ผ LinkedIn: Yaron Been Transform your job search with intelligent, automated workflows!
By Yaron BeenAutomated financial tracker: Telegram invoices to Notion with Gemini AI reports
Automated Financial Tracker: Telegram Invoices to Notion with AI Summaries & Reports --- Tired of manually logging every expense? Streamline your financial tracking with this powerful n8n workflow! Snap a photo of your invoice in Telegram, and let AI (powered by Google Gemini) automatically extract the details, record them in your Notion database, and even send you a quick summary. Plus, get scheduled weekly reports with charts to visualize your spending. Automate your finances, save time, and gain better insights with this easy-to-use template! Transform your expense tracking from a chore into an automated breeze. Try it out! --- Overview: This workflow revolutionizes how you track your finances by automating the entire process from invoice capture to reporting. Simply send a photo of an invoice or receipt to a designated Telegram chat, and this workflow will: Extract Data with AI: Utilize Google Gemini's capabilities to perform OCR on the image, understand the content, and extract key details like item name, quantity, price, total, date, and even attempt to categorize the expense. Store in Notion: Automatically log each extracted transaction into a structured Notion database. Instant Feedback: Send a summary of the processed transaction back to your Telegram chat. Scheduled Reporting: Generate and send a visual summary of your expenses (e.g., weekly spending by category) as a chart to your preferred Telegram chat or group. This workflow is perfect for individuals, freelancers, or small teams looking to effortlessly manage their expenses without manual data entry. Key Features & Benefits: Effortless Expense Logging: Just send a picture โ no more typing! AI-Powered Data Extraction: Leverages Google Gemini for intelligent invoice processing. Centralized Data in Notion: Keep all your financial records neatly organized in a Notion database. Automated Categorization: AI helps in categorizing your expenses (e.g., Food & Beverage, Transportation). Instant Summaries: Get immediate confirmation and a summary of what was recorded. Visual Reporting: Receive scheduled charts (e.g., bar charts of spending by category) directly in Telegram. Customizable: Easily adapt the workflow to your specific needs, categories, and reporting preferences. Time-Saving: Drastically reduces the time spent on manual financial administration. How It Works (Workflow Breakdown): The workflow is divided into two main parts: Part 1: Real-time Invoice Processing & Logging (Auto Notes Transaction with Telegram and Notion database) Telegram Trigger (Telegram Trigger | When recive photo): Activates when a new photo is sent to the configured Telegram chat. Get Photo Info (Get Info Photo from telegram chat): Retrieves the details of the received photo. Get Image Info (Get Image Info): Prepares the image data. AI Data Extraction (Google Gemini Chat Model & Basic LLM Chain): The image data is sent to the Google Gemini Chat Model. A specific prompt instructs the AI to extract details (date, ID, name, quantity, price, total, category, tax) in a JSON array format and provide a summary message. The categories include Food & Beverage, Transportation, Utilities, Shopping, Healthcare, Entertainment, Housing, and Education. Parse AI Output (Parse To your object | Table): Structures the AI's JSON output for easier handling. Split Transactions (Split Out | data transaction): If an invoice contains multiple items, this node splits them into individual records. Record to Notion (Record To Notion Database): Each transaction item is added as a new page/entry in your specified Notion database, mapping fields like Name, Quantity, Price, Total, Category, Date, and Tax. Send Telegram Summary (Sendback to chat and give summarize text): The summary message generated by the AI is sent back to the original Telegram chat. Part 2: Scheduled Financial Reporting (Schedule report to send on chanel or private message) Schedule Trigger (Schedule Trigger | for send chart report): Runs at a predefined interval (e.g., every week) to generate reports. Get Recent Data from Notion (Get Recent Data from Notions): Fetches transaction data from the Notion database for a specific period (e.g., the past week). Summarize Data (Summarize Transaction Data): Aggregates the data, for example, by summing up the 'total' amount for each 'category'. Prepare Chart Data (Convert Data to JSON chart payload): Transforms the summarized data into a JSON format suitable for generating a chart (e.g., labels for categories, data for spending amounts). Generate Chart (Generate Chart): Uses the QuickChart node to create a visual chart (e.g., a bar chart) from the prepared data. Send Chart to Telegram (Send Chart Image to Group or Private Chat): Sends the generated chart image to a specified Telegram chat ID or group. Nodes Used (Key Nodes): Telegram Trigger & Telegram Node: For receiving images and sending messages/images. Google Gemini Chat Model (Langchain): For AI-powered OCR and data extraction from invoices. Basic LLM Chain (Langchain): To interact with the language model using specific prompts. Output Parser Structured (Langchain): To structure the output from the language model. Notion Node: For reading from and writing to your Notion databases. Schedule Trigger: To automate the reporting process. Summarize Node: To aggregate data for reports. Code Node: Used here to format data for the chart. QuickChart Node: For generating charts. SplitOut Node: To process multiple items from a single invoice. Setup Instructions: Credentials: Telegram: Create a Telegram bot and get its API token. You'll also need the Chat ID where you'll send invoices and where reports should be sent. Google Gemini (PaLM) API: You'll need an API key for Google Gemini. Notion: Create a Notion integration and get the API key. Create a Notion database with properties corresponding to the data you want to save (e.g., Name (Title), Quantity (Number), Price (Number), Total (Number), Category (Select), Date (Text or Date), Tax (Number)). Share this database with your Notion integration. Configure Telegram Trigger: Add your Telegram Bot API token. When you first activate the workflow or test the trigger, send /start to your bot in the chat you want to use for sending invoices. n8n will then capture the Chat ID. Configure Google Gemini Node (Google Gemini Chat Model): Select or add your Google Gemini API credentials. Review the prompt in the Basic LLM Chain node and adjust if necessary (e.g., date format, categories). Configure Notion Nodes: Record To Notion Database: Select or add your Notion API credentials. Select your target Notion Database ID. Map the properties from the workflow (e.g., ={{ $json.name }}) to your Notion database columns. Get Recent Data from Notions: Select or add your Notion API credentials. Select your target Notion Database ID. Adjust the filter if needed (default is "past_week"). Configure Telegram Node for Reports (Send Chart Image to Group or Private Chat): Select or add your Telegram Bot API token. Enter the Chat ID for the group or private chat where you want to receive the reports. Configure Schedule Trigger (Schedule Trigger | for send chart report): Set your desired schedule (e.g., every Monday at 9 AM). Test: Send an image of an invoice to your Telegram bot and check if the data appears in Notion and if you receive a summary message. Wait for the scheduled report or manually trigger it to test the reporting functionality. --- Sticky Note Text for Your n8n Template: (These are suggestions. You would place these directly into the sticky notes within your n8n workflow editor.) Existing High-Level Sticky Notes: Auto Notes Transaction with Telegram and Notion database Schedule report to send on chanel or private message Specific Sticky Notes to Add: On Telegram Trigger | When recive photo: ๐ธ INVOICE INPUT ๐ธ Bot listens here for photos of your receipts/invoices. Ensure your Telegram Bot API token is set in credentials. Near Google Gemini Chat Model & Basic LLM Chain: ๐ค AI MAGIC HAPPENS HERE ๐ง Image is sent to Google Gemini for data extraction. Check 'Basic LLM Chain' to customize the AI prompt (e.g., categories, output format). Requires Google Gemini API credentials. On Parse To your object | Table: โจ STRUCTURING AI DATA โจ Converts the AI's text output into a usable JSON object. Check the schema if you modify the AI prompt significantly. On Record To Notion Database: ๐ SAVING TO NOTION ๐ Extracted transaction data is saved here. Configure with your Notion API key & Database ID. Map fields correctly to your database columns! On Sendback to chat and give summarize text: ๐ฌ TRANSACTION SUMMARY ๐ฌ Sends a confirmation message back to the user in Telegram with a summary of the recorded expense. On Schedule Trigger | for send chart report: ๐๏ธ REPORTING SCHEDULE ๐๏ธ Set how often you want to receive your spending report (e.g., weekly, monthly). On Get Recent Data from Notions: ๐ FETCHING DATA FOR REPORT ๐ Retrieves transactions from Notion for the report period. Default: "Past Week". Adjust filter as needed. Requires Notion API credentials & Database ID. On Summarize Transaction Data: โ SUMMARIZING SPENDING โ Aggregates your expenses, usually by category, to prepare for the chart. On Convert Data to JSON chart payload (Code Node): ๐จ PREPARING CHART DATA ๐จ This Code node formats the summarized data into the JSON structure needed by QuickChart. On Generate Chart (QuickChart Node): ๐ GENERATING VISUAL REPORT ๐ Creates the actual chart image based on your spending data. You can customize chart type (bar, pie, etc.) here. On Send Chart Image to Group or Private Chat: ๐ค SENDING REPORT TO TELEGRAM ๐ค Delivers the generated chart to your chosen Telegram chat/group. Set the correct Chat ID and Bot API token. General Sticky Note (Place where relevant): ๐ CREDENTIALS NEEDED ๐ Remember to set up API keys/tokens for: Telegram Google Gemini Notion General Sticky Note (Place where relevant): ๐ก CUSTOMIZE ME! ๐ก Adjust AI prompts for better accuracy. Change Notion database structure. Modify report frequency and content.
By Rizqi Pratama RamadhaniCreate a table in MySQL and insert data
Companion workflow for MySQL node docs
By amudhanScrape Google Maps by area & generate outreach messages for lead generation
This n8n workflow automates lead extraction from Google Maps, enriches data with AI, and stores results for cold outreach. It uses the Bright Data community node and Bright Data MCP for scraping and AI message generation. How it works Form Submission User provides Google Maps starting location, keyword and country. Bright Data Scraping Bright Data community node triggers a Maps scraping job, monitors progress, and downloads results. AI Message Generation Uses Bright Data MCP with LLMs to create a personalized cold call script and talking points for each lead. Database Storage Enriched leads and scripts are upserted to Supabase. How to use Set up all the credentials, create your Postgres table and submit the form. The rest happens automatically. Requirements LLM account (OpenAI, Geminiโฆ) for API usage. Bright Data account for API and MCP usage. Supabase account (or other Postgres database) to store information.
By SolomonHacker News throwback machine - see what was hot on this day, every year!
This is a simple workflow that grabs HackerNews front-page headlines from today's date across every year since 2007 and uses a little AI magic (Google Gemini) to sort 'em into themes, sends a neat Markdown summary on Telegram. How it works Runs daily, grabs Hacker News front page for this day across every year since 2007. Pulls headlines & dates. Uses Google Gemini to sort headlines into topics & spot trends. Sends a Markdown summary to Telegram. Set up steps Clone the workflow. Add your Google Gemini API key. Add your Telegram bot token and chat ID. Built on Day-01 as part of the 100DaysOfAgenticAi Fork it, tweak it, have fun!
By ibrhdotmeTransform data in Google Sheets
This workflow appends, lookup, updates, and reads data from a Google Sheet spreadsheet. Set node: The Set node is used to generate data that we want to add to Google Sheets. Depending on your use-case you might have data coming from a different source. For example, you might be fetching data from a WebHook call. Add the node that will fetch the data that you want to add to the Google Sheet. Use can then use the Set node to set the data that you want to add to the Google Sheets. Google Sheets node: This node will add the data from the Set node in a new row to the Google Sheet. You will have to enter the Spreadsheet ID and the Range to specify which sheet you want to add the data to. Google Sheets1 node: This node looks for a specific value in the Google Sheet and returns all the rows that contain the value. In this example, we are looking for the value Berlin in our Google Sheet. If you want to look for a different value, enter that value in the Lookup Value field, and specify the column in the Lookup Column field. Set1 node: The Set node sets the value of the rent by $100 for the houses in Berlin. We pass this new data to the next nodes in the workflow. Google Sheets2 node: This node will update the rent for the houses in Berlin with the new rent set in the previous node. We are mapping the rows with their ID. Depending on your use-case, you might want to map the values with a different column. To set this enter the column name in the Key field. Google Sheets3 node: This node returns the information from the Google Sheet. You can specify the columns that should get returned in the Range field. Currently, the node fetches the data for columns A to D. To fetch the data only for columns A to C set the range to A:C. This workflow can be broken down into different workflows each with its own use case. For example, we can have a workflow that appends new data to a Google Sheet, and another workflow that lookups for a certain value and returns that value. You can learn to build this workflow on the documentation page of the Google Sheets node.
By Harshil AgrawalYouTube video to AI-powered auto blogging and affiliate automation
๐ YouTube to WordPress AI-Powered Automation Transform your YouTube content into professional blog posts automatically! This n8n template seamlessly converts your YouTube videos into fully-formatted, SEO-optimized WordPress blog posts using AI-powered content generationโall without lifting a finger. --- ๐ฏ What This Automation Does ๐บ Monitors your YouTube channel for new video uploads ๐ Extracts key video information (title, description, URL, thumbnail) ๐ค Leverages AI to generate comprehensive blog content based on video material โ๏ธ Creates SEO-optimized titles, excerpts, and tags ๐ผ๏ธ Formats posts beautifully with embedded videos and proper HTML structure ๐ Publishes directly to WordPress via secure API connection โฑ๏ธ Runs on your schedule โ daily, weekly, or after each new upload --- ๐งโ๐ซ Step-by-Step Video Tutorial ๐ฅ Watch the implementation tutorial: [](https://youtu.be/IkFgllPNkCo) ๐ See the complete workflow setup and content transformation in action. --- ๐ Useful Links ๐ Get started with n8n Cloud: ๐ https://n8n.io/cloud/ ๐ YouTube Data API documentation: ๐ https://developers.google.com/youtube/v3 ๐ WordPress REST API handbook: ๐ https://developer.wordpress.org/rest-api/ ๐ง OpenAI API documentation: ๐ https://platform.openai.com/docs/api-reference --- ๐ Prerequisites โ n8n installation (self-hosted or cloud) โ YouTube Data API key โ AI provider API key (OpenAI, Google Gemini, etc.) โ WordPress website with REST API enabled โ WordPress application password for secure authentication --- ๐ Step-by-Step Implementation 1๏ธโฃ YouTube Video Detection Youtube RSS Feedlink to fetch new video automatically Implement filtering to process only videos not yet published to WordPress 2๏ธโฃ Content Preparation Extract essential video metadata (ID, title, description, thumbnail URL) Structure the information for AI processing and WordPress publication Format video thumbnails for use as featured images in blog posts 3๏ธโฃ AI Content Generation Configure your preferred AI provider (OpenAI, Gemini, etc.) Create detailed prompts that instruct the AI to: Maintain your brand voice and writing style Structure content with proper headings and subheadings Creates Internal Links from existing blogposts Creators Extenal links using affilaite links and other link database. Engaging SEO frendly. Automatically monetizes by embedding social PartnerStack Links Include key points from the video Generate SEO-friendly paragraphs and conclusions 4๏ธโฃ Content Enhancement Format the AI-generated content with proper HTML structure Add responsive embedded YouTube player Include attribution links back to original video Create custom intro and conclusion sections 5๏ธโฃ WordPress Publishing Securely connect to WordPress via REST API Set post parameters (title, content, excerpt, categories, tags) Configure post status (publish immediately or save as draft) Add featured image using video thumbnail 6๏ธโฃ Notification & Logging Receive email or Slack notifications when new posts are published Log workflow executions for troubleshooting Track successful publications for reporting --- ๐ฐ Automatic Affiliate Marketing Integration Transform your blog posts into passive income generators by automatically embedding relevant affiliate links based on your video content: PartnerStack Integration Dynamically fetch relevant affiliate links from your PartnerStack account Intelligently match products to video content using AI-powered relevance scoring Automatically insert formatted affiliate links with proper disclosure notices Track performance metrics for each generated post's affiliate conversions Example setup: Connect PartnerStack API โ Filter relevant products โ Insert links in strategic post positions Custom Affiliate Database via Airtable Create a centralized product-keyword Airtable database: Product name and description Affiliate link with your unique ID Category and keyword triggers Commission rates and expiration dates Auto-scan blog content to identify keyword matches Insert highest-converting links based on historical performance Rotate affiliate links to test different products and placements Advanced Monetization Features Amazon Associates product matching based on video content Time-sensitive promo codes inserted for limited-time offers Geo-targeted affiliate links based on visitor location A/B testing system to optimize link placement and conversion Automated disclosure statements to maintain FTC compliance Implementation Steps Connect to your PartnerStack account via API Create an Airtable base with your affiliate product database Configure the AI to identify product-mention opportunities Add a post-processing node to insert relevant affiliate links Implement tracking parameters to measure performance This integration not only saves time manually adding affiliate links, but also increases conversion rates through intelligent product matching and optimal placement within your automatically generated blog content. > ๐ก Pro Tip: Create separate tracking IDs for your automated YouTube-to-WordPress posts to measure this specific channel's performance in your affiliate dashboards. ๐ก Advanced Customizations Content Templates Create specialized formatting based on video categories: Tutorial videos: Step-by-step instructions with timestamps Review videos: Pros/cons sections with ratings Interview videos: Question-answer format with speaker attribution Category & Tag Management Automatically organize your WordPress content: Assign categories based on video topics or playlists Generate tags from video keywords and descriptions Create custom taxonomies for video series Multi-Platform Distribution Extend your content reach by adding: Social media announcement posts Email newsletter inclusion Content syndication to Medium or LinkedIn --- โ ๏ธ Troubleshooting | Issue | Solution | |-------|----------| | AI generation timeout | Increase timeout settings or use chunked processing | | WordPress API errors | Verify application password and user permissions | | Missing video embedding | Check oEmbed settings in WordPress | | Duplicate posts | Implement content fingerprinting for detection | | Poor content quality | Refine AI prompts with better instructions | --- ๐ Why Use This Template Content creators typically spend 2-4 hours converting each video into a quality blog post. This automation: โฑ๏ธ Saves 10+ hours weekly for active YouTube creators ๐ Boosts SEO performance with multi-platform content ๐ Expands audience reach to text-preferring visitors ๐ฐ Increases monetization opportunities across platforms ๐ง Frees creative energy for producing better videos Don't choose between video and written contentโhave both automatically! --- ๐ Get Started Now Import the template โ Connect your accounts โ Watch your blog grow alongside your channel. ๐ AMJID ALI'S PROFILE ๐ website ๐ Explore more on youtube --- Knowledge Base: youtube-api, wordpress-automation, content-repurposing, ai-blog-generation, n8n-workflow, creator-tools, video-to-text, multi-platform-publishing
By Amjid AliSend personalized WhatsApp templates triggered by KlickTipp with auto-responses
Community Node Disclaimer: This workflow uses KlickTipp community nodes. How It Works This workflow automates personalized WhatsApp message template delivery triggered by events in KlickTipp or by messages sent to the Whatsapp Business account. When a contact triggers an Outbound, the workflow uses a pre-approved WhatsApp message template to send dynamic, real-time messages through the WhatsApp Business Cloud API. When receiving messages it checks whether a cancellation should be processed or if a auto-response is sent. This setup is ideal for time-sensitive campaigns such as: Birthday greetings Discount or promo notifications Follow-ups on product or service interest Key Features KlickTipp Trigger Starts the workflow when a specific outbound is triggered Typical use case: subcriber receives activation Tag and triggers an Outbound which sends a webhook call to trigger WhatsApp messaging. WhatsApp Business Cloud - Message Trigger Listens to messages from the contact and processes answers with answering auto-responder or by tagging the contact in KlickTipp. WhatsApp Business Cloud - Sending Template Messages Sends WhatsApp message templates using a pre-approved template. Template placeholders are filled with data from KlickTipp custom fields. Setup Instructions Set up the KlickTipp and Whatsapp nodes in your n8n instance. Authenticate your WhatsApp and KlickTipp accounts. Create the necessary custom fields to match the data structure Verify and customize field assignments in the workflow to align with your specific form and subscriber list setup. | Field Label | Field Type | |-----------------------------|-------------| | Whatsapp \| Product/service | Single line | | Whatsapp \| URL | URL | | Whatsapp \| Name/company | Single line | | Whatsapp \| URL ending | Single line | --- Testing & Deployment Use a real test contact with all required fields filled. Trigger the Outbound in KlickTipp using the activation tag and answer with a message to the template. Run the scenario once in n8n to verify successful delivery of the whatsapp message template to your test contact as well as the reception of the auto-responder and the subscription and tagging in KlickTipp to stop further messages. --- Campaign Expansion Ideas Connect campaign to process keywords like "STOP" from WhatsApp messages Pair WhatsApp with welcome email series for onboarding. Use tags like productinterestX for precise segmentation. A/B test templates with different CTA formats or timings. Monitor CTRs via dynamic URLs in WhatsApp templates. Benefits Multi-channel engagement: Adds WhatsApp to your marketing toolkit. Dynamic content: Personalizes messages using contact data. -KlickTipp campaign control Whatsapp contacts can for example signal with messages like "STOP" to receive the according Tag in KlickTipp in order to start/end automations. > ๐ก Pro Tip: Customize the domain link ending per campaign or product line. This allows targeted redirects, e.g., meinshop.de/ProduktA or `mein Ressources: Send WhatsApp Templates with KlickTipp Use KlickTipp Community Node in n8n Automate Workflows: KlickTipp Integration in n8n
By KlickTippGenerate trend-based video marketing ideas with GPT-4, Tavily and Veo 3
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Automate your entire video content creation pipeline with this AI-powered, no-code workflow built in n8n. Watch Step-by-step video guide here: https://www.youtube.com/watch?v=x7nHpcggpX8&t=5s This template connects a suite of smart tools to help you generate scroll-stopping short video ideas based on daily trending topics and auto-deliver them via emailโready for production in Veo 3. ๐ง How it works: Scheduled Trigger (Daily) Kicks off the process each day at your chosen time. Tavily Agent (Web Search) Searches the latest trends, viral moments, or market news based on your e-commerce brand (e.g. โSallyโs Closetโ). OpenAI GPT-4 Agent (Creative Brainstorming) Generates high-conversion marketing video ideas based on your brandโs tone and whatโs trending. Prompt Formatter for Veo 3 Converts the idea into a cinematic-style prompt, optimized for Veoโs video generation engine (via FAL API). Send via Gmail The final Veo 3 prompt is emailed to you or your creative team for immediate use or manual refinement. Watch full step-by-step Tutorial Build Video: https://youtu.be/x7nHpcggpX8 ๐ง Use Cases: E-commerce brands that need fresh daily content Marketing teams looking to automate creative ideation Solopreneurs building a lean video production engine Anyone experimenting with Veo 3 prompt-based storytelling ๐ ๏ธ Tools used: n8n Scheduled Trigger Tavily Node (for real-time web search) Langchain Agent (GPT-4 via OpenAI) FAL API (Veo 3 prompt delivery) Gmail Node (send final output) โก๏ธ Ready-to-use. Fully editable. Zero coding required. ๐ก Pro Tip: You can hook this up with the Veo 3 generation API (FAL) to complete the automation end-to-end!
By Automate With MarcBuild your own Qdrant vector store MCP server
This n8n demonstrates how to build your own Qdrant MCP server to extend its functionality beyond that of the official implementation. This n8n implementation exposes other cool API features from Qdrant such as facet search, grouped search and recommendations APIs. With this, we can build an easily customisable and maintainable Qdrant MCP server for business intelligence. This MCP example is based off an official MCP reference implementation which can be found here - https://github.com/qdrant/mcp-server-qdrant How it works A MCP server trigger is used and connected to 5 custom workflow tools. We're using custom workflow tools as there is quite a few nodes required for each task. We use a mix of n8n supported Qdrant nodes for simple operations such as insert documents and similarity search, and HTTP node to hit the Qdrant API directly for Facet search, group search and recommendations. We use "Edit Field" and "Aggregate" nodes to return suitable responses to the MCP client. How to use This Qdrant MCP server allows any compatible MCP client to manage a Qdrant Collection by supporting select and create operations. You will need to have a collection available before you can use this server. Use the Prerequisite manual steps to get started! Connect your MCP client by following the n8n guidelines here - https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-langchain.mcptrigger/integrating-with-claude-desktop Try the following queries in your MCP client: "Can you help me list the available companies in the collection?" "What do customers say about product deliveries from company X?" "What do customers of company X and company Y say about product ease of use?" Requirements Qdrant for vector store. This can be an a cloud-hosted instance or one you can self-host internally. MCP Client or Agent for usage such as Claude Desktop - https://claude.ai/download Customising this workflow Depending on what queries you'll receive, adjust the tool inputs to make it easier for the agent to set the right parameters. Not interested in Reviews? The techniques shared in this template can be used for other types of collections. Remember to set the MCP server to require credentials before going to production and sharing this MCP server with others!
By JimleukAutomate CV screening with GPT-4o-mini: Gmail to Google Sheets HR evaluation system
AI-Powered HR Workflow: CV Analysis and Evaluation from Gmail to Sheets Who is this for? This workflow is designed for HR professionals, recruiters, startup founders, and operations teams who receive candidate resumes by email and want to automate the evaluation process using AI. It's ideal for teams that receive high volumes of applications and want to streamline screening without sacrificing quality. What problem is this workflow solving? Manually reviewing every resume is time-consuming, inconsistent, and often inefficient. This workflow automates the initial screening process by: Extracting resume data directly from incoming emails Analyzing resumes using GPT-4 to evaluate candidate fit Saving scores and notes in Google Sheets for easy filtering It helps teams qualify candidates faster while staying organized. What this workflow does Detects when a new email with a CV is received (Gmail) Filters out non-relevant messages using an AI classifier Extracts the resume text (PDF parsing) Uploads the original file to Google Drive Retrieves job offer details from a connected Google Sheet Uses GPT-4 to evaluate the candidateโs fit for the job Parses the AI output to extract the candidate's score Logs the results into a central Google Sheet Sends a confirmation email to the applicant Setup Install n8n self-hosted Add your OpenAI API Key in the AI nodes Enable the following APIs in your Google Cloud Console: Gmail API Google Drive API Google Sheets API Create OAuth credentials and connect them in n8n Configure your Gmail trigger to watch the inbox receiving CVs Create a Google Sheet with columns like: Candidate, Score, Job, Status, etc. How to customize this workflow to your needs Adjust the AI scoring prompt to match your companyโs hiring criteria Add new columns to the Google Sheet for additional metadata Include Slack or email notifications for each qualified candidate Add multiple job profiles and route candidates accordingly Add a Telegram or WhatsApp step to notify HR in real time ๐ Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube
By Dr. Firas