Cv resume PDF parsing with multimodal vision AI
This n8n workflow demonstrates how we can use Multimodal LLMs to parse and extract from PDF documents in n8n. In this particular scenario, we're passing a candidate's CV/resume to an AI which filters out unqualified applications. However, this sneaky candidate has added in hidden prompt to bypass our bot! Whatever will we do? No fret, using AI Vision is one approach to solve this problem... read on! How it works Our candidate's CV/Resume is a PDF downloaded via Google Drive for this demonstration. The PDF is then converted into an image PNG using a tool called Stirling PDF. Since the hidden prompt has a white font color, it is is invisible in the converted image. The image is then forwarded to a Basic LLM node to process using our multimodal model - in this example, we'll use Google's Gemini 1.5 Pro. In the Basic LLM node, we'll need to set a User Message with the type of Binary. This allows us to directly send the image file in our request. The LLM is now immune to the hidden prompt and its response is has expected. The example CV/Resume with hidden prompt can be found here: https://drive.google.com/file/d/1MORAdeev6cMcTJBV2EYALAwll8gCDRav/view?usp=sharing Requirements Google Gemini API Key. Alternatively, GPT4 will also work for this use-case. Stirling PDF or another service which can convert PDFs into images. Note for data privacy, this example uses a public API and it is recommended that you self-host and use a private instance of Stirling PDF instead. Customising the workflow Swap out the manual trigger for another trigger such as a webhook to integrate into your existing services. This example demonstrates a validation use-case ie. "does the candidate look qualified?". You can try additionally extracting data points instead such as years of experiences, previous companies etc.
By JimleukScrape 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 SolomonIntelligent web query and semantic re-ranking flow using Brave and Google Gemini
Workflow Description This workflow is a powerful, fully automated web query and semantic reranking system that allows users to perform precise, detailed searches, intelligently rank search results and provide high-quality, structured output. Built with AI-powered components, the workflow leverages semantic query generation, result re-ranking, and real-time reporting to deliver actionable insights. It is particularly well-suited for real-time data retrieval, market research, and any domain requiring automated yet customizable search result processing. --- How It Works Webhook Integration for Input: The workflow begins with a Webhook Node that captures the user's search query as input, enabling seamless integration with other systems. Step 1: Semantic Query Generation (Powered by "Semantic Search - Query Maker"): Using AI (Google Gemini), the initial query is refined and transformed into a context-aware, expert-level search query. The process ensures that the search engine retrieves the most relevant and precise results. Step 2: Web Search Execution: A free Brave Search API processes the refined query to fetch search results, ensuring speed and cost efficiency. Step 3: Semantic Re-Ranking of Results (Powered by "Semantic Search - Result Re-Ranker"): The workflow reranks the search results based on relevance to the original question, prioritizing the most relevant URLs dynamically. Results are passed through AI-powered intelligent reranking to ensure the final output reflects optimal relevance and quality. Step 4: Structured Output Generation: Results are converted into a well-structured, organized JSON format, ranking the top 10 search results with their titles, links, and descriptions. Missing ranks (if fewer than 10 results) are handled gracefully with placeholders, ensuring consistency. Step 5: Real-Time Reporting: The reranked search results are sent back to the user or integrated system via the Webhook Node in a JSON-formatted response. Reports are highly structured and ready for downstream processing or consumption. --- Key Features AI-Powered Query Refinement: Transforms basic queries into detailed, expert-level search terms for optimal results. Dual-Stage Semantic Search: Combines query generation and result reranking for precise, high-relevance outputs. Top 10 Result Reranking: Dynamically ranks and organizes the top 10 results based on semantic relevance to the query. Customizable Integration: Fully modifiable for alternative APIs or integrations, such as other search engines or custom ranking logic. JSON-Formatted Structured Results: Outputs reranked results in a standardized format, ideal for integration into systems requiring machine-readable data. Webhook-Based Flexibility: Works seamlessly with Webhook inputs for easy deployment in diverse workflows. Cost-Effective API Usage: Pre-integrated with the free Brave Search API, minimizing operational costs while delivering accurate search results. --- Instructions for API Setup Brave Search API: Visit api.search.brave.com to obtain a free-tier API key for web search. AI Integration (Google Gemini): Visit Google AI Studio and generate an API key for semantic query generation and reranking. Webhook Configuration: Set up the input Webhook to capture search queries and the output Webhook to deliver reranked results. --- Why Choose This Workflow? Precision and Relevance: Combines AI-based query generation with advanced reranking for accurate results. Fully Customizable: Easily adapt the workflow to alternative APIs, search engines, or ranking logic. Real-Time Insights: Provides structured, real-time output ready for immediate use. Scalable and Modular: Ideal for businesses, researchers, and data analysts needing a robust, repeatable solution. --- Tags AI Workflow, Semantic Search, Query Refinement, Search Result Reranking, Real-Time Search, Web Search Automation, Google Search, Brave Search, News Search, API Integration, Market Research, Competitive Intelligence, Business Intelligence,Google Gemini, Anthropic Claude, OpenAI, GPT, LLM
By Mind-FrontGenerate & upload images with Image-to-Image GPT, Google Sheets & Drive
🖼️ Image-to-Image AI Generator from Google Sheets with Google Drive Upload --- ✅ Use Case Automatically generate AI images from prompts listed in a Google Sheet, upload the images to Google Drive, and log the result back into the sheet. Uses the image-to-image-gpt API for fast, customizable generation. --- 💡 Problem It Solves Manual image generation workflows are inefficient and error-prone. Creative and content teams often have to: Manually paste prompts into image generation tools Save images locally Upload to Google Drive Paste the link back into tracking spreadsheets This automation removes all that friction—turning one spreadsheet into a complete image creation pipeline. --- 🌟 Benefits 🔁 Fully automated image generation 📤 Direct uploads to Google Drive 🧾 Image links and timestamps logged in Google Sheets ⚠️ Built-in error logging for API failures 🧩 Modular and easily extensible 📊 Keeps a historical log of successes and errors --- 🧩 Workflow Overview | Node | Description | |------|-------------| | 1. Manual Trigger | Starts the workflow when executed manually | | 2. Google Sheets2 | Reads all rows from the input Google Sheet | | 3. Loop Over Items | Processes one row (prompt) at a time | | 4. If2 | Filters only rows where Prompt is not empty and drive path is empty | | 5. HTTP Request1 | Calls the image-to-image-gpt API with the prompt | | 6. If1 (Error Handling) | If an error exists in the API response, route to logging | | 7. Google Sheets4 (Error Log) | Appends error details to a log sheet for review | | 8. Code1 | Decodes the base64 image returned by the API | | 9. Google Drive1 | Uploads the image to a selected Google Drive folder | | 10. Google Sheets1 (Write Back) | Updates the original row with the image drive path and timestamp | | 11. Wait | Delays the next prompt to prevent hitting API rate limits | --- 🛠 Tech Stack n8n (no-code automation) Google Sheets (data input/output) Google Drive (image storage) image-to-image-gpt API via RapidAPI JavaScript (in Code node) for base64 processing --- 📝 Sheet Format Your Google Sheet should include the following columns: | Column | Purpose | |----------------|----------------------------------| | Prompt | The AI prompt to send to the API | | Image url | (Optional) Initial image URL | | drive path | Updated with Drive link by flow | | Generated Date | Auto-filled by the workflow | | Base64 | Stores raw or error data | --- 🚀 How to Use Import this workflow into your n8n instance Set up Google Sheets and Google Drive service credentials Add your RapidAPI key in the HTTP Request node headers Use the image-to-image-gpt endpoint in the HTTP request Configure the Google Sheet and Drive folder in the respective nodes Execute manually or add a Cron node for scheduling --- 📌 Example Applications 🛍 eCommerce: Auto-generate product mockups 🧵 Fashion/Design: Visualize styles or fabrics from prompts ✍️ Blogging/Content: Auto-generate header images from titles 📣 Marketing: Generate ad banners from text --- 🧪 Tips You can add a Cron node if you want this to run on a schedule Use a separate tab/sheet for logging failed prompts Extend the flow by adding: Email notifications Slack alerts File name templating --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort SolutionsAutomate Solana trading with Gemini AI, multi-timeframe analysis & AFK Crypto
Try It Out! The SOL/USDT Multi-Timeframe AI Market Analyzer and Trader with Telegram Approval is your fully automated Solana trading assistant powered by AI, AFK Crypto, and Telegram. It runs hourly by default, fetches real-time market data for the SOL/USDT pair, and uses AI-driven logic to determine optimal entry, exit, and risk management strategies. You receive a Telegram approval message that lets you confirm or reject the trade instantly. Once approved, the bot executes trades via your AFK Crypto Wallet and keeps monitoring for Take-Profit or Stop-Loss triggers — sending alerts directly to Telegram when they’re hit. This system combines automation with manual oversight, giving you AI precision with human approval control. --- How It Works Hourly Trigger – The workflow initiates every hour to analyze the current market status. Fetch SOL Market Data (Crypto Compare) – Retrieves multiple timeframe data (1m, 5m, 1h) for trend, momentum, and volatility analysis. AI Market Analyzer – Processes data through an AI agent to identify: Market sentiment (bullish, bearish, neutral) Recommended position: LONG / SHORT / HOLD Stop-Loss and Take-Profit levels Confidence rating and reasoning Balance Check (AFK Crypto) – Verifies wallet balance via /v1/wallets/balances?chain=solana and calculates position size based on 1% risk. Telegram Approval Message – Sends a Telegram message containing AI insights and trade details with “✅ Approve” or “❌ Decline” buttons. Trade Execution (AFK Trade API) – If approved, executes trade instantly via /v1/trade/swap using your AFK Crypto wallet. Live Trade Monitoring – Monitors SOL price in real-time. Once Take-Profit or Stop-Loss conditions are met: The position auto-closes. A Telegram notification is sent summarizing results and updated balance. --- How to Use Import the workflow into your n8n workspace. Add your credentials: AFK Crypto API Key – For balance and trading operations. Telegram Bot Token + Chat ID – For sending messages and approvals. Crypto Compare API Key – For fetching market data. Edit “Fetch SOL Market Data” Node: Update the endpoint if you want different timeframes or markets. Set the schedule: Default trigger = every hour (modifiable in the “Every Hour” node). Deploy and activate. The bot will send you hourly market analyses via Telegram — allowing you to approve or skip each suggested trade. --- (Optional) Extend This Workflow Auto Mode: Allow the AI to auto-trade when confidence > 90%. Portfolio Sync: Log every trade and PnL automatically to Notion or Airtable. Risk Adjuster: Dynamically modify the 1% risk per trade based on balance or volatility. Multi-Pair Trading: Expand to include ETH/USDT or BTC/USDT using the same logic. --- Requirements AFK Crypto Wallet + API Key Telegram Bot Token + Chat ID Crypto Compare API Key n8n Instance with HTTP Request, AI, and Telegram nodes enabled --- AFK APIs Used GET https://api.afkcrypto.com/v1/wallets/balances?chain=solana POST https://api.afkcrypto.com/v1/trade/swap --- Summary The SOL/USDT Multi-Timeframe AI Market Analyzer and Trader with Telegram Approval workflow is an intelligent trading automation system that merges AI analytics, Telegram decision prompts, and AFK Crypto execution. It empowers you to make data-driven trading decisions — with AI doing the heavy lifting and you retaining the final say before every trade. A perfect hybrid between automation and control, optimized for active Solana traders who value precision and security. --- Our Website: https://afkcrypto.com/ Check our blogs: https://www.afkcrypto.com/blog
By AFK CryptoGenerate creative ADV images from references with Seedream v4 for Instagram & Facebook
This workflow automates the process of generating advertising (ADV) images from multiple reference images and publishing them directly to social media (Instagram and Facebook with Upload-Post) with Seedream v4 AI. This workflow automates the process of generating an AI image based on a user's text prompt and up to 6 reference images. The process is triggered by a user submitting a web form. --- Key Advantages ✅ Automated Image Creation – Generates high-quality, consistent visuals from multiple references without manual editing. ✅ Seamless Social Media Publishing – Automatically posts to Instagram and Facebook with minimal effort. ✅ SEO-Optimized Titles – Ensures your posts get better reach with AI-generated, keyword-friendly titles. ✅ Scalable Workflow – Can be triggered manually, on schedule, or via form submissions. ✅ Time-Saving – Reduces manual steps from design to publishing, enabling faster content production. ✅ Multi-Platform Support – Easily extendable to other platforms (TikTok, LinkedIn, etc.) with Upload-Post API. --- How It Works Form Trigger: A user fills out a form with a "Prompt" (text description) and a list of "Reference images" (comma-separated URLs). Data Processing: The workflow converts the submitted image URL string into a proper array for the AI API. AI Image Generation: The workflow sends the prompt and image URLs to the fal.ai API (specifically, the ByteDance seedream model) to generate a new, consistent image. Status Polling: It periodically checks the status of the AI job until the image generation is COMPLETED. Result Retrieval: Once complete, it fetches the URL of the generated image and downloads the image file itself. SEO Title Generation: The original user prompt is sent to OpenAI's GPT-4o-mini model to generate an optimized, engaging social media title. Cloud Backup: The generated image is uploaded to a specified Google Drive folder for storage. Social Media Posting: Finally, the workflow posts the downloaded image file to both Instagram and Facebook via the Upload-Post.com API, using the AI-generated title. --- Set Up Steps To make this workflow functional, you need to configure several third-party services and their corresponding credentials within n8n. Obtain fal.ai API Key: Create an account at fal.ai. Locate your API key in your account settings. In the "Create Video" and "Get status" nodes, edit the HTTP Header Auth credentials. Set the Header Name to Authorization and the Value to Key YOURFALAIAPIKEY. Configure Upload-Post.com API: Create an account at Upload-Post.com and get your API key. Create a profile within the Upload-Post app (e.g., test1); this profile manages your social account connections. In both the "Post to Instagram" and "Post to Facebook" nodes, edit the HTTP Header Auth credentials. Set the Header Name to Authorization and the Value to Apikey YOURUPLOADPOSTAPIKEY. Crucially, in the same nodes, find the user parameter in the body and replace the placeholder YOUR_USERNAME with the profile name you created (e.g., test1). Configure OpenAI/OpenRouter (Optional for Title Generation): The "Generate title" node uses an OpenAI-compatible API. The provided example uses OpenRouter. Ensure you have valid credentials (e.g., for OpenRouter or directly for OpenAI) configured in n8n and selected in this node. Configure Google Drive (Optional for Backup): The "Upload Image" node requires Google OAuth credentials. Set up a Google Cloud project, enable the Drive API, and create OAuth 2.0 credentials in the n8n settings. Authenticate and select the desired destination folder in the node's parameters. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
By DavideGenerate personalized travel itineraries with Llama AI via email & WhatsApp
This n8n workflow automatically creates friendly, personalized travel itineraries based on messages received via email or WhatsApp. When a user says "I want to go to Dubai with friends for 5 days" or something similar, the AI agent understands the request, generates a detailed daily plan with suggested activities, transport tips, and hotel ideas — all in a warm, human tone. It saves time, adds value for travelers, and delivers ready-to-send itineraries without any manual effort. Good to know The AI agent uses advanced language processing to understand natural travel requests in multiple formats. Itineraries are generated with personalized recommendations based on travel preferences, group size, and duration. The workflow supports both email and WhatsApp communication channels for maximum accessibility. All responses maintain a warm, friendly tone to enhance user experience. How it works The Get Query from Email node captures travel requests sent via email, parsing the message content for trip details. The Get Query from WhatsApp node simultaneously monitors WhatsApp messages for travel planning requests. Both inputs feed into the Itinerary Creator Agent node, which uses AI to analyze the request and generate comprehensive travel plans including activities, accommodations, and transportation suggestions. The Check Proper Data node validates the generated itinerary to ensure all essential information is included and properly formatted. The Check where to send Answer node determines the appropriate response channel (email or WhatsApp) based on the original request source. If the request came via email, the Sending Itinerary from Email node sends the personalized itinerary back to the user's email address. If the request came via WhatsApp, the Send Itinerary from message node delivers the travel plan through WhatsApp messaging. How to use Import the workflow into n8n and configure the nodes with your email service credentials and WhatsApp API access. Set up the AI agent with your preferred travel data sources and recommendation algorithms. Test the workflow by sending sample travel requests through both email and WhatsApp channels. Monitor the generated itineraries to ensure quality and adjust the AI agent parameters as needed. Requirements Email service API credentials (SMTP or email provider API) WhatsApp Business API access or WhatsApp integration service AI/LLM service for the Itinerary Creator Agent (OpenAI, Anthropic, or similar) Access to travel data sources for recommendations (optional but recommended) Customising this workflow Modify the Itinerary Creator Agent node to include specific travel preferences, local recommendations, or branded content. Adjust the data validation rules in the Check Proper Data node to match your quality standards. Customize response templates in both sending nodes to align with your brand voice and style. Add additional input channels or integrate with other messaging platforms as needed.
By Oneclick AI SquadQuery-to-action automation with Bright Data MCP & OpenAI GPT
📌 AI Agent Template with Bright Data MCP Tool Integration This template obtains all the possible tools from Bright Data MCP, process this through chatbot, then run any tool based on the user's query --- ❓ Problem It Solves The problem that the MCP solves is the complexity and difficulty of traditional automation, where users need to have specific knowledge of APIs or interfaces to trigger backend processes. By allowing interaction through natural language, automatically classifying and routing queries, and managing context and memory effectively, MCP simplifies complex data operations, customer support, and workflow orchestration scenarios where inputs and responses change dynamically. --- 🧰 Pre-requisites Before deploying this template, ensure you have: An active n8n instance (self-hosted or cloud). A valid OpenAI API key (or any AI models) Access to Bright Data MCP API with credentials. Basic familiarity with n8n workflows and nodes. --- ⚙️ Setup Instructions Install the MCP Community Node in N8N In your N8N self-hosted instance, go to Settings → Community Nodes. Search and install n8n-nodes-mcp. Configure Credentials: Add your OpenAI API key or any AI mdeols to the relevant nodes. If you want other AI model, please replace all associated nodes of OpenAI in the workflow Set up Bright Data MCP client credentials in the installed community node (STDIO) Obtain your API in Bright Data and put it in Environment field in the credentials window. It should be written as API_Key=<your api key from Bright Data> --- 🔄 Workflow Functionality (Summary) User message triggers the workflow. AI Classifier (OpenAI) interprets the intent and maps it to a tool from Bright Data MCP. If no match is found, the user is notified. If more information is needed, the AI requests it. Memory preserves context for follow-up actions. The tool is executed, and results are returned contextually to the user. > 🧠 Optional memory buffer and chat memory manager nodes keep conversations context-aware across multiple messages. --- 🧩 Use Cases Data Scraping Automation: Trigger scraping tasks via chat. Lead Generation Bots: Use MCP tools to fetch, enrich, or validate data. Customer Support Agents: Automatically classify and respond to queries with tool-backed answers. Internal Workflow Agents: Let team members trigger backend jobs (e.g., reports, lookups) by chatting naturally. --- 🛠️ Customization Tool Matching Logic: Modify the AI classifier prompt and schema to suit different APIs or services. Memory Size and Retention: Adjust memory buffer size and filtering to fit your app’s complexity. Tool Execution: Extend the "Execute the tool" sub-workflow to handle additional actions, fallback strategies, or logging. Frontend Integration: Connect this with various platforms (e.g., WhatsApp, Slack, web chatbots) using the webhook. --- ✅ Summary This template delivers a powerful no-code/low-code agent that turns chat into automation, combining AI intelligence with real-world tool execution. With minimal setup, you can build contextual, dynamic assistants that drive backend operations using natural language.
By Cyril Nicko GasparExtract business card data from Telegram to Google Sheets with OpenRouter AI Vision
Title (suggested): Extract business card data from Telegram to Google Sheets Who’s it for Teams that receive business cards digitally (sales, marketing, back-office) and want a plug-and-play way to capture contacts into a sheet without manual typing. What it does / How it works This workflow ingests a business card sent to your Telegram bot, detects whether the message contains an image or text, extracts key fields with an AI Vision Agent (company, full name, department, job title, postal code, address, phone, mobile, fax, email, website), and appends or updates a contact row in Google Sheets automatically. How to set up Connect Telegram (bot token) and enable file download. Connect your AI provider (OpenRouter or equivalent) used by the AI Vision Agent. Connect Google Sheets and select your spreadsheet + sheet tab. Rename nodes clearly and keep sticky notes: one overview note (this description) + step notes. Test by sending a sample card image to your bot and verify the row is appended/updated. Requirements Telegram Bot API credential AI chat/vision credential Google Sheets OAuth credential and an accessible spreadsheet How to customize the workflow Map fields to your sheet headers (add/remove columns as needed). Adjust the system prompt to prefer your locale or specific field formats. Change the matching key for update logic (e.g., company name or email). Add downstream steps (CRM push, dedupe rules, notifications). Security note: Do not hardcode API keys or include real IDs/emails. Use credentials and environment configs only. JSON [ { "company_name": "Example Company Ltd.", "department": "Sales", "job_title": "Sales Manager", "full_name": "Taro Yamada", "postal_code": "100-0001", "address": "1-1-1 Marunouchi, Chiyoda-ku, Tokyo", "phone_number": "+81-3-0000-0000", "mobilephonenumber": "+81-90-0000-0000", "fax_number": "+81-3-1111-1111", "email": "example@company.com", "website_url": "https://example.com" } ] Troubleshooting Nothing appears in Google Sheets Solution: Verify that your Google Sheets credentials are correctly authorized. Confirm the Spreadsheet ID and Sheet Name in the node match your target file. Make sure the Google Sheets node is connected downstream of the AI Vision Agent. If the workflow runs successfully but nothing is added, check whether the matching column (company_name) already exists — in appendOrUpdate mode it will only update that row. AI returns incomplete or invalid data Solution: Review the system prompt in the AI Vision Agent to ensure it instructs the model to return a structured JSON object with all required fields (company name, full name, department, job title, address, etc.). If the result is partial, verify the image quality of the uploaded business card — low contrast or skewed images can reduce OCR accuracy. You can reduce temperature in the AI node to make output more deterministic. Workflow doesn’t start automatically Solution: Check that the workflow is activated (toggle is ON in the top right of n8n). Verify the Webhook URL is correctly registered in Telegram’s bot settings. Run manually once to ensure all credentials and nodes are configured correctly.
By Haruki KuwaiTransform meeting notes into Asana tasks & Slack summaries with GPT-4o
Transform meeting notes into organized tasks automatically This workflow uses AI to extract action items, decisions, and key details from any meeting notes format—then creates tasks in Asana and sends a formatted summary to Slack. Perfect for sales teams, project managers, and anyone who wants to stop manually tracking action items from meetings. What gets extracted Action items with assignees and due dates Key decisions made Pain points or challenges mentioned Budget discussions Next meeting dates How it works The workflow uses a simple form where you paste meeting notes (from AI notetakers like Otter.ai, manual notes, or any text). GPT-4o analyzes the content and extracts structured data. Each action item becomes an Asana task with the assignee name, due date, and full meeting context in the notes. All tasks are then aggregated into a formatted Slack message with clickable links, key decisions, pain points, and budget info. Your team gets a complete meeting summary without reading through pages of notes. Setup requirements OpenAI API key for GPT-4o Asana workspace with OAuth2 connection Slack workspace with OAuth2 connection Customization ideas Replace the form trigger with an email trigger to auto-process notes sent to a specific inbox Modify the AI prompt to extract additional fields like risks, dependencies, or next steps Add conditional logic to route different meeting types to different Asana projects or Slack channels Connect to other project management tools like ClickUp, Monday.com, or Jira instead of Asana Add Google Calendar integration to automatically schedule next meetings Good to know GPT-4o costs approximately $0.01-0.03 per meeting analysis The form can be shared with your team for easy submission All meeting context is preserved in Asana task notes for reference Slack messages include clickable task links for quick access
By KareemCreate secure human-in-the-loop approval flows with Postgres and Telegram
🔐 Human-in-the-Loop Approval Flow (n8n + Postgres + Telegram) 👥 Who’s it for Teams that need a manager approval step before a ticket or request can change status. Great for internal ops, IT requests, or any workflow where “a human must sign off.” ⚡ What it does 📨 Manager receives approval/reject link 🔑 Link is signed with HMAC + expiry (secure & tamper-proof) 🗄️ Postgres updates the ticket status 📝 Audit trail records every decision 📲 Telegram notifies both manager and requester ⏰ Expired or invalid links trigger alerts and logs 🛠 Requirements n8n instance (self-hosted) Postgres database (with tickets, ticketaudit, workflowerrors) Telegram bot token One environment variable set: SECRET_KEY ⚙️ How to set up Set SECRET_KEY in .env Create Postgres tables (SQL provided) Add Telegram + Postgres credentials in n8n Import the workflow JSON Test by opening an approval/reject link in your browser 🎨 How to customize Change who the “manager” is (currently hardcoded in the Code node). Swap Telegram for Slack or email notifications. Extend the audit schema to include more metadata (IP, username).
By MohammadAutomatic backlink data export from Semrush to Google Sheets via RapidAPI
🔗 Automated Semrush Backlink Checker with n8n and Google Sheets 📘 Description This n8n workflow automates backlink data extraction using the Semrush Backlink Checker API available on RapidAPI. By submitting a website via a simple form, the workflow fetches both backlink overview metrics and detailed backlink entries, saving the results directly into a connected Google Sheet. This is an ideal solution for SEO professionals who want fast, automated insights without logging into multiple tools. --- 🧩 Node-by-Node Explanation On form submission – Starts the workflow when a user submits a website URL through a web form. HTTP Request – Sends the URL to the Semrush Backlink Checker API using a POST request with headers and form data. Reformat 1 – Extracts high-level backlink overview data like total backlinks and referring domains. Reformat 2 – Extracts individual backlink records such as source URLs, anchors, and metrics. Backlink overview – Appends overview metrics into the "backlink overflow" tab of a Google Sheet. Backlinks – Appends detailed backlink data into the main "backlinks" tab of the same Google Sheet. --- ✅ Benefits of This Workflow No-code integration: Built entirely within n8n—no scripting required. Time-saving automation: Eliminates the need to manually log in or export reports from Semrush. Centralized results: All backlink data is organized in Google Sheets for easy access and sharing. Powered by RapidAPI: Uses the Semrush Backlink Checker API hosted on RapidAPI for fast, reliable access. Easily extendable: Can be enhanced with notifications, dashboards, or additional data enrichment. --- 🛠️ Use Cases 📊 SEO Audit Automation – Auto-generate backlink insights for multiple websites via form submissions. 🧾 Client Reporting – Streamline backlink reporting for SEO agencies or consultants. 📥 Lead Capture Tool – Offer a free backlink analysis tool on your site to capture leads while showcasing value. 🔁 Scheduled Backlink Monitoring – Modify the trigger to run on a schedule for recurring reports. 📈 Campaign Tracking – Monitor backlinks earned during content marketing or digital PR campaigns. --- 🔐 How to Get Your API Key for the Competitor Keyword Analysis API Go to 👉 Semrush Backlink Checker API - RapidAPI Click "Subscribe to Test" (you may need to sign up or log in). Choose a pricing plan (there’s a free tier for testing). After subscribing, click on the "Endpoints" tab. Your API Key will be visible in the "x-rapidapi-key" header. 🔑 Copy and paste this key into the httpRequest node in your workflow. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
By Evoort Solutions