by Yang
Who’s it for This template is perfect for digital agencies, SDRs, lead generators, or outreach teams that want to automatically convert LinkedIn company profiles into high-quality cold emails. If you spend too much time researching and writing outreach messages, this workflow does all the heavy lifting for you. What it does Once a LinkedIn company profile URL is submitted via a web form, the workflow: Scrapes detailed company data using Dumpling AI Enriches the contact (email, name, country) using Dropcontact Sends company data and contact info to GPT-4, which generates: A personalized subject line (max 8 words) A short HTML cold email (4–6 sentences) Sends the cold email via Gmail Logs the lead details to Airtable for tracking All AI-generated content follows strict formatting and tone guidelines, ensuring it's professional, human, and clean. How it works Form Trigger: Collects the LinkedIn URL Dumpling AI: Extracts company name, description, size, location, website, etc. Dropcontact: Finds the contact's email and name based on enriched company details GPT-4: Writes a structured cold email and subject line in JSON format Gmail: Sends the personalized email to a fixed recipient Airtable: Logs the lead into a specified base/table for follow-up Requirements ✅ Dumpling AI API key (stored in HTTP header credentials) ✅ Dropcontact API key ✅ OpenAI GPT-4 credentials ✅ Gmail account (OAuth2) ✅ Airtable base & table set up with at least these fields: Name LinkedIn Company URL People website How to customize Modify the GPT prompt to reflect your brand tone or service offering Replace Gmail with Slack, Outlook, or another communication tool Add a “review and approve” step before sending emails Add logic to avoid duplicates (e.g., check Airtable first) > This workflow lets you go from LinkedIn profile to inbox-ready cold email in less than a minute—with full AI support.
by Wessel Bulte
Description This workflow is a practical, “dirty” solution for real-world scenarios where frontline workers keep using Excel in their daily processes. Instead of forcing change, we take their spreadsheets as-is, clean and normalize the data, generate embeddings, and store everything in Supabase. The benefit: frontline staff continue with their familiar tools, while data analysts gain clean, structured, and vectorized data ready for analysis or RAG-style AI applications. How it works Frontline workers continue with Excel** – no disruption to their daily routines. Upload & trigger** – The workflow runs when a new Excel sheet is ready. Read Excel rows** – Data is pulled from the specified workbook and worksheet. Clean & normalize** – HTML is stripped, Excel dates are fixed, and text fields are standardized. Batch & switch** – Rows are split and routed into Question/Answer processing paths. Generate embeddings** – Cleaned Questions and Answers are converted into vectors via OpenAI. Merge enriched records** – Original business data is combined with embeddings. Write into Supabase** – Data lands in a structured table (excel_records) with vector and FTS indexes. Why it’s “dirty but useful” No disruption** – frontline workers don’t need to change how they work. Analyst-ready data** – Supabase holds clean, queryable data for dashboards, reporting, or AI pipelines. Bridge between old and new** – Excel remains the input, but the backend becomes modern and scalable. Incremental modernization** – paves the way for future workflow upgrades without blocking current work. Outcome Frontline workers keep their Excel-based workflows, while data can immediately be structured, searchable, and vectorized in Supabase — enabling AI-powered search, reporting, and retrieval-augmented generation. Required setup Supabase account Create a project and enable the pgvector extension. OpenAI API Key Required for generating embeddings (text-embedding-3-small). Microsoft Excel credentials Needed to connect to your workbook and worksheet. Need Help 🔗 LinkedIn – Wessel Bulte
by David Olusola
💰 Track Daily Fiat & Crypto Exchange Rates Report with ExchangeRate-API & CoinGecko A simple, reliable workflow that emails you a beautiful HTML currency report every morning at 8:00 AM (your n8n server’s timezone). It pulls USD→EUR and USD→NGN fiat rates and BTC/ETH prices (+ 24h % change), then formats a clean HTML email. 📌 What It Does ⏰ Schedule: Runs daily at 8:00 AM 🌍 Fiat Rates: USD→EUR and USD→NGN (via ExchangeRate-API, no key needed) ₿ Crypto: BTC & ETH prices + 24h change (via CoinGecko, no key needed) ✉️ Email: Sends a mobile-friendly HTML + plain text fallback 🗺️ Node Map (At a Glance) | # | Node Name | Type | Purpose | |---|-----------|------|---------| | 1 | Daily 8AM Trigger | Schedule Trigger | Fires every day at 08:00 | | 2 | Get Fiat Exchange Rates | HTTP Request | https://api.exchangerate-api.com/v4/latest/USD | | 3 | Get Crypto Prices | HTTP Request | CoinGecko simple price endpoint | | 4 | Merge | Merge | Combines fiat + crypto responses | | 5 | Format Email Content | Code (v2) | Builds HTML + text, sets subject & summary | | 6 | Send Daily Currency Email | Email Send | Sends the HTML email via SMTP | > 📝 Sticky Notes in the canvas explain each section. They’re optional and safe to delete. ⚙️ Required Setup 1) Schedule Time Open Daily 8AM Trigger → set cron to 08:00 daily. Suggested cron: 0 8 * * (server local time; if you’re in Lagos, ensure server timezone matches *Africa/Lagos** or adjust accordingly). 2) SMTP Credentials Open Send Daily Currency Email → set: From Email: your sender (e.g. your-email@gmail.com) To Email: recipient address Credentials: select your SMTP account Gmail tip:* use *App Passwords** (with 2FA enabled). Server: smtp.gmail.com Port: 587 (STARTTLS) or 465 (SSL) Auth: your full Gmail address + app password 3) API Access Both endpoints are free & no API key: Fiat (USD base): https://api.exchangerate-api.com/v4/latest/USD Crypto (BTC/ETH): https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum&vs_currencies=usd&include_24hr_change=true 🧩 Input Order The Format Email Content node is written to auto-detect which input is fiat vs crypto, so the Merge order doesn’t matter. A clean pattern is: Get Crypto Prices* → *Merge** (Input 1) Get Fiat Exchange Rates* → *Merge** (Input 2) Merge* → *Format Email Content* → *Send Daily Currency Email** 🚀 Test It Quickly Run Get Fiat Exchange Rates → verify rates.EUR and rates.NGN exist. Run Get Crypto Prices → verify BTC/ETH usd and usd_24h_change. Run Format Email Content → check it outputs subject, html, text. Run Send Daily Currency Email → confirm the styled report arrives. 🎛 Customize Currencies:** Add more fiat codes from rates (e.g., GBP, ZAR) and extend the HTML template. Coins:** Add ids= in CoinGecko (e.g., bitcoin,ethereum,solana) and render extra cards. Send time:** Adjust the cron (e.g., 30 7 * * * for 7:30 AM). Branding:** Edit colors, fonts, and header gradient in the HTML string. Timezone stamp:** Change the display timezone inside the Code node if needed. 🧩 Common Pitfalls & Fixes Email not styled:* Ensure the Email node is set to *HTML** format. Gmail auth fails:* Use an *App Password* and port *587** with STARTTLS. Empty values:** Run the two HTTP nodes once and confirm the responses contain data. Rate limits:** If you increase frequency, consider adding a short Wait node or caching.
by Roshan Ramani
Who's it for Business owners, marketers, and web developers who want to instantly respond to website contact form submissions and maintain organized lead records without manual monitoring. What it does This workflow automatically processes contact form submissions from your website, sending immediate WhatsApp notifications with formatted lead details while simultaneously logging all data to Google Sheets for organized lead management and follow-up tracking. How it works When someone submits your website contact form, the webhook instantly receives the data, formats it into a professional WhatsApp message with emojis and structure, sends the notification to your phone, and logs all details (name, email, phone, service, message, timestamp) to a Google Sheets database for permanent storage and analysis. Requirements WhatsApp Business API credentials Google Sheets API access with a spreadsheet containing these columns: date (for timestamp) name (contact's full name) email (contact's email address) phone (contact's phone number) service (requested service/interest) message (contact's message/inquiry) Website contact form that can POST to webhook URL with fields: name, email, phone, service, message n8n instance (self-hosted or cloud) Google Sheets Setup Create a new Google Sheet with the following column headers in row 1: Column A: date Column B: name Column C: email Column D: phone Column E: service Column F: message The workflow will automatically populate these columns with each form submission and use the date column for duplicate checking. How to set up Credentials Setup: Configure WhatsApp Business API credentials in the WhatsApp node Set up Google Sheets API connection and grant necessary permissions Configuration: Update the recipient phone number in the WhatsApp node (format: +1234567890) Replace the Google Sheets document ID with your spreadsheet ID Ensure your Google Sheet has the required column structure mentioned above Integration: Copy the webhook URL from the Contact Form Trigger node Configure your website form to POST data to this endpoint with field names: name, email, phone, service, message Testing: Test the workflow by submitting a sample form entry Verify WhatsApp notification is received and data appears in Google Sheets How to customize the workflow Message Format:** Modify the WhatsApp message template in the Format Lead Data node Additional Fields:** Add more form fields by updating both the Code node and Google Sheets mapping Email Notifications:** Include email alerts by adding an Email node after the Format Lead Data node Conditional Logic:** Set up different notifications for high-priority services or VIP customers Data Validation:** Add filtering rules in the Code node to handle spam or invalid submissions Multiple Recipients:** Configure the WhatsApp node to send alerts to multiple team members
by Cong Nguyen
📄 What this workflow does This workflow automates the process of finding LinkedIn leads and writing personalized outreach messages. It takes user input (keywords + purpose), generates a Boolean LinkedIn search query with Gemini, fetches up to 20 results via Google Custom Search API, logs them into Google Sheets, and then drafts custom outreach messages for each lead. Finally, the workflow updates the sheet and optionally sends you an email notification with the results. 👤 Who is this for Sales and business development teams who want to automate LinkedIn prospecting. Recruiters searching for candidates and generating outreach at scale. Marketers or founders looking for potential partners, clients, or collaborators. Anyone tired of manual LinkedIn searches and copy-pasting outreach messages. ✅ Requirements Google Sheets account (with a sheet for storing LinkedIn leads + messages). Google Custom Search Engine (CSE) enabled with "Search the entire web" and valid cx. Gemini API access (for Boolean query generation + outreach message drafting). SMTP credentials for optional email notifications. ⚙️ How to set up Connect your Google Sheets account and select the sheet to store results. Configure Gemini API credentials in n8n for both search query + outreach message generation. Create a Google Custom Search Engine and note down the key and cx. Update the HTTP Request node with your credentials (key, cx, hl, gl). Set up SMTP credentials if you want email notifications. Publish the Form trigger and test with sample keywords + purposes. 🔁 How it works Form Submit → Collects user input: keywords + purpose of contact. Gemini (Boolean Generator) → Creates a LinkedIn-specific search query (site:linkedin.com). Google Custom Search API → Fetches up to 20 matching profiles or company pages. Append to Google Sheets → Saves name, LinkedIn URL, description. Split & Loop → Processes each LinkedIn entry one by one. Gemini (Message Writer) → Generates personalized outreach messages using Purpose + company info. Update Google Sheets → Adds outreach message to the matching LinkedIn row. Optional Email Notification → Sends you a link to the updated sheet. 💡 About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable, automated workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, chatbot development, and more.
by Cristian Tala Sánchez
Who is this workflow for This workflow is designed for busy professionals, productivity enthusiasts, and teams drowning in email overload. Whether you're a startup founder, operations manager, executive assistant, or team lead, this solution helps you bring structure and clarity to your inbox. If you struggle to identify which emails deserve immediate attention versus which can be scheduled, delegated, or ignored, this workflow is for you. What it does / How it works This n8n automation integrates Gmail and OpenAI to apply the Eisenhower Matrix—a classic productivity framework—to incoming emails. It reads each new unread email from your inbox and automatically classifies it into one of four categories based on urgency and importance: Urgent + Important**: Critical messages requiring immediate action (e.g., legal, financial, investor or user-blocking issues). Not Urgent + Important**: High-value strategic emails you should schedule time for (e.g., partnership opportunities, key coordination). Urgent + Not Important**: Time-sensitive but delegable tasks (e.g., routine operations or technical updates). Not Urgent + Not Important**: Low-value noise like spam or promotions that should be archived or batch-reviewed later. The classification is powered by a GPT model with custom prompts tailored to understand email context and assign the right category with high accuracy. After classification, the workflow adds the appropriate label in Gmail and automatically archives emails marked as low-priority. The result: your inbox becomes a dynamic priority system, helping you make faster, smarter decisions without the mental load of constant triage. How to set it up Create Gmail Labels: Manually create these four labels in your Gmail account: Urgent + Important Not Urgent + Important Urgent + Not Important Not Urgent + Not Important Connect Accounts in n8n: Set up Gmail OAuth2 credentials in your n8n instance to allow reading and labeling emails. Add your OpenAI API key to enable the AI classification. Update Label IDs: In the Gmail nodes of the workflow, replace the label IDs (e.g., Label_4335697733647997523) with the IDs from your own Gmail account. You can find these by creating a dummy workflow with a “Gmail → Get All Labels” node. Test and Deploy: You can run the workflow manually using the “Execute Workflow” trigger or set it to run automatically with the Gmail Trigger that polls every minute. Review your Gmail inbox to see how labels are applied and ensure the archive function is working as expected. Requirements A free or paid n8n instance (self-hosted or cloud) Gmail account with OAuth2 access configured in n8n OpenAI API key (GPT-4.1-mini recommended for accuracy) Four predefined Gmail labels that match the Eisenhower Matrix Basic familiarity with editing Gmail node parameters in n8n How to customize the workflow Tailor the AI prompts**: Update the Text Classifier node with your own examples or definitions of what counts as urgent or important based on your business context. Refine inputs**: Add filters to process only emails from specific senders or domains (e.g., VIP clients, your team). Extend outcomes**: Trigger Slack alerts for urgent messages, auto-reply to certain senders, or sync scheduled items to your calendar. Localization**: Adjust labels and prompts to match your preferred language or naming conventions. Archive rules**: Modify the "Remove Labels" node to exclude specific categories from archiving or add additional cleanup actions. Why this improves productivity This workflow removes decision fatigue from your email routine. By automatically labeling and sorting emails according to urgency and importance, you: Spend less time sorting emails manually Focus energy on what truly matters Schedule strategic tasks thoughtfully Delegate or ignore distractions confidently Instead of reacting to your inbox, you take control of it—turning email chaos into a structured priority system that aligns with your goals.
by Shelly-Ann Davy
Who’s it for Busy homemakers, creators, and anyone who wants a simple, no-cost way to plan weekly meals and get a ready-to-shop grocery list—without extra apps. What it does Runs on a weekly Cron schedule, generates a grocery list, creates rows in your Notion database (Ingredient, Quantity, Status), and emails the list (optional Telegram confirmation). It includes a Notion connection check, detailed error notifications (email and optional Telegram), a success email with timestamp, and optional persistent logging to a Notion “Logs” database. Requirements Notion account + integration connected to your database SMTP credentials for the Email node (Optional) Telegram bot and chat ID for alerts (Optional) Notion log database if you want persistent logs How to set up Import the workflow and open Set: Configuration to fill: fromEmail, emailTo, notifyEmail, notionDb, telegramChatId (Optional) logToNotion (true/false), notionLogDb In Notion, create a DB with properties: Ingredient (Title), Quantity (Rich text), Status (Select: “To Buy”) Attach your Notion and SMTP credentials (and Telegram if used). Run once to test, then set Cron to your preferred weekly time. How to customize Edit the recipe/grocery items in the Code node. Change the Cron schedule (test with “Every minute,” then revert to weekly). Enable Telegram alerts, and/or turn on Notion logging for audit trails.
by ScoutNow
Automated Daily Competitor Tweet Summarizer with X API, GPT-5-Nano, and Gmail Stay on top of your competition with this powerful n8n workflow that automatically fetches and summarizes your competitors’ latest tweets every day. Using the official X (formerly Twitter) API and OpenAI's GPT-5-Nano model, this template extracts insights from public tweets and sends concise summaries directly to your Gmail inbox. Ideal for marketing teams, product managers, PR professionals, and competitive intelligence analysts, this solution turns noisy social feeds into clear, actionable summaries—automated and customized to your needs. Features Daily automation: Fetches competitor tweets every 24 hours using X API AI summarization: Uses GPT-5-Nano to highlight key insights and themes Smart filtering: Cleans and filters tweets for relevance before summarizing Email delivery: Sends summaries to Gmail (or your team’s inbox) Fully customizable: Modify schedules, accounts, and integrations as needed Setup Instructions Get API Keys: X API (Bearer Token) – from developer.x.com OpenAI API Key – from platform.openai.com Gmail OAuth2 credentials (via Google Cloud Console) Configure in n8n: Import the workflow Add credentials under the "Credentials" tab Set target X usernames and schedule Customize Delivery (Optional): Set email subject, recipients Add additional integrations (e.g., Slack, Notion, Sheets) How It Works Trigger: A daily cron node initiates the workflow. Fetch User ID: The workflow uses the X API to retrieve the user ID based on the provided username. This step is necessary because the tweet retrieval endpoint requires a user ID, not a username. Fetch Tweets: Using the extracted user ID, the workflow queries the X API for recent tweets from the selected account. Clean Data: Filters out replies, retweets, and any irrelevant content to ensure only meaningful tweets are summarized. Summarize: GPT-4 processes the cleaned tweet content and generates a concise, insightful summary. Send Email: The Gmail node sends the final summary to your inbox or chosen recipient. Use Cases Track competitor announcements and marketing messages Automate daily social media briefs for leadership Monitor trends in your industry effortlessly Keep your team aligned with market developments Requirements Valid X API credentials (Bearer token) OpenAI API key Gmail OAuth2 credentials Access to n8n (cloud or self-hosted) Delivery Options While Gmail is the default, you can easily extend the workflow to integrate with: Slack Notion Google Sheets Webhooks Any supported n8n integration Automate your competitive intelligence process and stay informed—without lifting a finger.
by David Olusola
🧠 Workflow Summary Automates lead management by: 🔗 Webhook Trigger: Captures form data from your website. 🧼 Code Node: Standardizes the data format. 📄 Google Sheets: Appends a new row with lead info. 🔔 Slack Notification: Alerts your team instantly. ⚙️ Quick Setup 1. Import Workflow In n8n, go to Workflows → + New → Import from JSON. 2. Add Credentials Google Sheets**: Use OAuth2 to connect your account. Slack**: Create a Slack App → Add bot scopes → Connect via OAuth2. 3. Google Sheet Prep Create a sheet with these columns in row 1: Full Name Email Address Business Name Project Intent/Needs Project Timeline Budget Range Received At 4. Configure Nodes Webhook**: Use the generated URL in your form settings. Code**: Cleans and maps form fields. Google Sheets Node**: Set to Append Map fields using expressions like ={{ $json.email }} Slack Node**: Choose your channel Send a templated lead alert message with form data 5. Activate & Test Click Activate Send a test POST to the Webhook Confirm: New row in Sheet ✅ Slack alert sent ✅ 🎯 Use this automation to capture leads, log data, and notify your team—all hands-free.
by ermanatalay
Create a powerful brand/company monitoring system that fetches news headlines, performs AI-powered sentiment analysis, and delivers witty, easy-to-read reports via email. This workflow turns brand mentions into a lively “personality analysis” — making your reports not only insightful but also fun to read. Perfect for teams that want to stay informed and entertained. How it works ++Data Collection++: A Google Sheets table captures brand name and recipient email which triggers the workflow. ++News Aggregation++: The RSS Read node fetches recent news headlines from Google News based on the specified brand or company keyword. ++Content Processing++: News headlines are aggregated and formatted for AI analysis. ++AI Analysis++: Gemini 2.5 Flash model plays the role of a brand analyst, writing reports as if the brand were a character in a story. It highlights strengths, quirks, and challenges in a witty, narrative-driven style — while still providing sentiment scores and action points. ++Report Generation++: JavaScript code structures the AI response into well-formatted HTML paragraphs for a smooth email reading experience. ++Automated Delivery++: Gmail integration sends the analysis report directly to the specified email address. How to use First, create a google sheets document with sheet name="page1", A1 cell name="keyword" and B1 cell name="email". The system will read the keyword & email data when a new row data is entered. Paste the url of your google sheets document into the first trigger node. Select trigger on "row added" in the node. Enter your credentials to connect Gemini PaLM API account in the "message a model" node of Google. Enter your credentials to connect Gmail account in the "send a message" node. The workflow automatically runs when new row is detected. Recipients receive comprehensive sentiment analysis reports within minutes! Requirements -Google Sheets URL -Google Gemini API credentials for AI analysis -Gmail API credentials for email delivery
by Dahiana
This template demonstrates how to build an AI-powered name generator that creates realistic names perfect for UX/UI designers, developers, and content creators. Use cases: User persona creation, mockup development, prototype testing, customer testimonials, team member listings, app interface examples, website content, accessibility testing, and any scenario requiring realistic placeholder names. How it works AI-Powered Generation:** Uses any LLM to generate names based on your specifications Customizable Parameters:** Accepts gender preferences, name count, and optional reference names for style matching UX/UI Optimized:** Names are specifically chosen to work well in design mockups and prototypes Smart Formatting:** Returns clean JSON arrays ready for integration with design tools and applications Reference Matching:** Can generate names similar in style to a provided reference name How to set up Replace "Dummy API" credentials with your preferred language model API key Update webhook path and authentication as needed for your application Test with different parameters: gender (masculine/feminine/neutral), count (1-20), reference_name (optional) Integrate webhook URL with your design tools, Bubble apps, or other platforms Requirements LLM API access (OpenAI, Claude, or other language model) n8n instance (cloud or self-hosted) Platform capable of making HTTP POST requests API Usage POST to webhook with JSON body: { "gender": "masculine", "count": 5, "reference_name": "Alex Chen" // optional } Response: { "success": true, "names": ["Marcus Johnson", "David Kim", "Sofia Rodriguez", "Chen Wei", "James Wilson"], "count": 5 } How to customize Modify AI prompt for specific naming styles or regions Add additional parameters (age, profession, cultural background) Connect to databases for persistent name storage Integrate with design tools APIs (Figma, Sketch, Adobe XD) Create batch processing for large mockup projects
by WhySoSerious
📬 Plex Recently Added → Responsive Email Newsletter (Tautulli Alternative) What it is This workflow automatically creates a weekly Plex newsletter that highlights recently added Movies & TV Shows. It’s designed to be mobile-friendly and Gmail/iOS Mail compatible, making it easy to share Plex updates with friends, family, or your community. How it works • ⏰ Runs on a weekly schedule (customizable). • 🎬 Fetches recently added Movies & TV Shows from Tautulli API. • 📰 Builds a responsive HTML newsletter that works in Gmail, iOS Mail, and most clients. • 📧 Sends one personalized email per recipient via SMTP. • 🗒️ Every node has a Sticky Note explaining setup and purpose. How to set up Replace the placeholders in the nodes with your own details: • YOUR_TAUTULLI_URL • YOUR_API_KEY • YOUR_PLEX_TOKEN • YOUR_PLEX_SERVER_ID Update the recipient list in Prepare Emails for Recipients. Add your SMTP credentials in Send Newsletter Emails. (Optional) Customize the HTML/CSS in Generate HTML Newsletter. Requirements • Plex Media Server with Tautulli installed. • SMTP account (Gmail, custom domain, etc.). Customization • Change the schedule to daily/weekly as needed. • Edit the HTML template for your own branding. • Extend with additional nodes (Discord, Slack, etc.). ⸻ ⚡ Workflow Overview: ``⏰ Schedule Trigger → 🎬 Fetch Movies → 📺 Fetch TV → 🔗 Merge → 📰 Build HTML → 📧 Prepare Recipients → 📤 Send → ✅ Finish ``