by Stéphane Heckel
Emailing Using Google Sheet, Google Docs, and SMTP Automate personalized email campaigns using a Google Sheets contact list, a Google Docs template, and SMTP delivery. How It Works Google Docs** is used as the email template with variables: {{firstname}}, {{lastname}}, {{company}}, {{email}}. Google Sheet** contains your list of recipients (one per row). For each contact, the workflow merges personal data into the Google Docs template. Email is sent to each recipient via SMTP (batch size: 1). Use the Wait node to respect provider quotas. After sending, the workflow updates the "process" column of the Google Sheet with the date/time. How to Use Copy Templates: Google Docs Template Google Sheet Template Find each document’s ID (the text after /d/ and before /edit in the URL). Configure Workflow: Enter your Google Docs and Google Sheets IDs in the settings node. Set your email subject in the appropriate parameter. Set Up Credentials: Connect your Google account. Configure the SMTP node with your mail server details. Update Data: Edit the Google Docs template with your message and variables. Prepare your Google Sheet with these columns: email, firstname, lastname, company. Deploy and Test: Connect all nodes. Test with a small contact batch. Troubleshoot any node errors (indicated in red in n8n). Requirements Google Credentials & permissions**: For Sheets and Docs access. SMTP Server**: For email delivery (adjust Wait node for rate limits). n8n Version**: Tested on 1.105.2 (Ubuntu). Need Help? Contact me on LinkedIn or ask in the n8n Community Forum!
by Yaron Been
This workflow automatically monitors marketing job boards to identify growing companies and potential business opportunities. It saves you time by eliminating the need to manually check job listings and provides insights into which companies are actively hiring and expanding their marketing teams. Overview This workflow automatically scrapes marketing job listings from Indeed and other job boards to extract company information, job details, and growth indicators. It uses Bright Data to access job sites without being blocked and AI to intelligently parse job postings into structured data, then sends formatted email alerts to your marketing team. Tools Used n8n**: The automation platform that orchestrates the workflow Bright Data**: For scraping job boards without being blocked OpenAI**: AI agent for intelligent job data extraction and parsing Gmail**: For sending automated job alert emails to your team How to Install Import the Workflow: Download the .json file and import it into your n8n instance Configure Bright Data: Add your Bright Data credentials to the MCP Client node Set Up OpenAI: Configure your OpenAI API credentials Configure Gmail: Connect your Gmail account for sending notifications Customize: Set your target job search parameters and email recipients Use Cases Business Development**: Identify rapidly growing companies for potential partnerships Sales Teams**: Target companies actively hiring for sales outreach opportunities Market Research**: Track hiring trends and identify emerging market players Recruitment**: Monitor competitor hiring patterns and market opportunities Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #jobboards #marketingj jobs #brightdata #webscraping #businessdevelopment #leadgeneration #companyresearch #jobmonitoring #n8nworkflow #workflow #nocode #jobautomation #marketresearch #growingcompanies #hiringtrends #salesleads #prospecting #jobscraping #indeed #recruitmentintel #businessintelligence #marketanalysis #companytracking #automatedalerts #emailnotifications #jobdata #hiringinsights #marketopportunities
by Yaron Been
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically monitors competitor product launches across news sites, press releases, and social channels. It saves you hours of manual tracking and ensures your team is instantly alerted when a rival announces something new. Overview The automation regularly scrapes predefined sources for mentions of your competitors combined with launch-related keywords. Bright Data provides reliable scraping, while OpenAI analyzes each article to extract key details (product name, features, launch date, pricing). Summaries are pushed to Slack and logged in Google Sheets so your marketing and product teams can react quickly. Tools Used n8n** – Orchestrates the entire workflow Bright Data** – Scrapes news, blogs, and social posts without blocks OpenAI** – Extracts and summarizes launch information Slack** – Sends real-time alerts to a chosen channel Google Sheets** – Creates a searchable launch database How to Install Import the Workflow: Upload the provided .json to your n8n instance. Configure Bright Data: Add your Bright Data credentials in the MCP Client node. Set Up OpenAI: Enter your OpenAI API key. Connect Slack & Google Sheets: Authorize both services and choose the target channel / spreadsheet. Customize Sources: Edit the list of competitor domains and launch keywords in the initial Set node. Use Cases Product Marketing**: Track rival announcements to refine positioning. Sales Enablement**: Equip reps with up-to-date competitive intel. Competitive Intelligence**: Maintain a historical log of launches for trend analysis. Investor Relations**: Stay informed of market movements that affect valuation. Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #competitiveintelligence #productlaunch #brightdata #webscraping #openai #slackalerts #n8nworkflow #nocode #marketintel
by Yaron Been
This workflow automatically monitors competitor social media engagement on LinkedIn to track their content performance and posting strategies. It saves you time by eliminating the need to manually check competitor social media accounts and provides detailed analytics on their engagement metrics. Overview This workflow automatically scrapes LinkedIn company profiles to extract the latest 5 posts and analyzes their engagement metrics including likes, comments, and content performance. It uses Bright Data to access LinkedIn without being blocked and AI to intelligently parse post data, calculating average engagement rates and storing detailed post information. Tools Used n8n**: The automation platform that orchestrates the workflow Bright Data**: For scraping LinkedIn company profiles without being blocked OpenAI**: AI agent for intelligent post data extraction and analysis Google Sheets**: For storing engagement metrics and detailed post information How to Install Import the Workflow: Download the .json file and import it into your n8n instance Configure Bright Data: Add your Bright Data credentials to the MCP Client node Set Up OpenAI: Configure your OpenAI API credentials Configure Google Sheets: Connect your Google Sheets account and set up your competitor tracking spreadsheets Customize: Enter target LinkedIn company URLs and adjust engagement tracking parameters Use Cases Social Media Marketing**: Analyze competitor content strategies and engagement patterns Competitive Intelligence**: Track competitor posting frequency and content performance Content Strategy**: Identify high-performing content types and messaging approaches Brand Monitoring**: Monitor competitor social media presence and audience engagement Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #socialmedia #competitoranalysis #linkedin #brightdata #webscraping #socialmonitoring #engagementtracking #n8nworkflow #workflow #nocode #socialautomation #competitormonitoring #contentanalysis #socialmediamonitoring #linkedinanalytics #engagementmetrics #competitorresearch #socialintelligence #contentperformance #socialmediaanalytics #brandmonitoring #competitortracking #socialmediastrategy #contentmarketing #socialmediadata #engagementanalysis #competitiveanalysis #linkedinscraping
by Yaron Been
Description This workflow automatically finds trending headlines and content from various sources and posts them to your social media accounts. It helps maintain an active social media presence without the daily manual effort of content curation. Overview This workflow automatically scrapes trending headlines and content from various sources and posts them to your social media accounts. It uses Bright Data to access content and n8n to schedule and post to platforms like Twitter, LinkedIn, or Facebook. Tools Used n8n:** The automation platform that orchestrates the workflow. Bright Data:** For scraping trending content from news sites, blogs, or other sources without getting blocked. Social Media APIs:** To post content to your accounts. How to Install Import the Workflow: Download the .json file and import it into your n8n instance. Configure Bright Data: Add your Bright Data credentials to the Bright Data node. Connect Social Media: Authenticate your social media accounts. Customize: Set your content preferences, posting schedule, and hashtag strategy. Use Cases Social Media Managers:** Automate content curation and posting. Content Creators:** Share trending topics in your niche. Businesses:** Maintain an active social media presence with minimal effort. Connect with Me Website:** https://www.nofluff.online YouTube:** https://www.youtube.com/@YaronBeen/videos LinkedIn:** https://www.linkedin.com/in/yaronbeen/ Get Bright Data:** https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #socialmedia #brightdata #contentcuration #scheduling #socialmediaautomation #contentmarketing #socialmediamanagement #autoposting #trendingcontent #n8nworkflow #workflow #nocode #socialmediatools #digitalmarketing #contentcalendar #socialmediapresence #headlinecuration #trendalerts #socialmediaschedule #contentautomation #socialmediamarketing #contentdistribution #automatedposting #socialmediastrategy
by Emmanuel Bernard
🎉 Do you want to master AI automation, so you can save time and build cool stuff? I’ve created a welcoming Skool community for non-technical yet resourceful learners. 👉🏻 Join the AI Atelier 👈🏻 Unlock streamlined Zoom Meeting organization and exclusive access management with this n8n workflow. Designed for educators, event organizers, and businesses, this tool automates your event logistics, so you can focus on delivering valuable content. Features Zoom Meetings Creation:** Instantly generate new Zoom meetings with the n8n built-in form. Collect Payments Using Stripe:** Effortlessly monetize your events with secure, automatically created Stripe payment pages for each meeting. Exclusive Gated Access:** Ensure your content remains exclusive by sending Zoom meeting passwords only to verified subscribers who have completed their payment through Stripe. Participants Email Notifications:** Automate the distribution of Zoom meeting details post-payment, eliminating the need for manual email management and ensuring participants are promptly informed. Instant and Easy Participants Overview:** Manage and track your event registrations with ease. All related data is stored in a Google Sheets document that you own. You're notified via email with each new subscription, simplifying participant management. Set Up Steps Connect your Zoom, Stripe, Gmail and Google Sheet credentials. Create an empty Google Sheet in your Google Drive. Fill the config node (Sheet URL, email and currency). Edit email text. This n8n workflow template is designed to minimize setup time and maximize efficiency, allowing you to focus on delivering value to your subscribers. With just a few clicks, you can automate the entire process of organizing and monetizing your Zoom meetings. Created by the n8ninja.
by galelem
This n8n workflow automates the entire pipeline of generating, formatting, and publishing SEO-rich blog posts to a Blogger site—ideal for auto service businesses. What it does: ⏱ Runs on a schedule via the Schedule Trigger 📰 Fetches trending news from Mediastack (technology category) 🖼 Generates relevant images using the Pexels API 🧠 Creates SEO-optimized content using AI agents (LangChain & OpenRouter) 📝 Formats content into Blogger-compatible HTML, including title, metadata, images, FAQs, and internal linking 🔄 Posts directly to Blogger via authenticated Google Blogger API 📢 Sends Telegram notifications with previews and publishing confirmations 🔐 Uses secure credentials (no hardcoded API keys) Ideal For: Bloggers and marketers looking to automate content creation Auto repair, dealership, or detailing businesses maintaining a content strategy Agencies managing multiple Blogger-based SEO campaigns
by Oneclick AI Squad
This automated n8n workflow performs daily forecasting of sales and raw material needs for a restaurant. By analyzing historical data and predicting future usage with AI, businesses can minimize food waste, optimize inventory, and improve operational efficiency. The forecast is stored in Google Sheets and sent via email for easy review by staff and management. What is AI Forecast Generator? The AI Forecast Generator is a machine learning component that analyzes historical sales data, weather patterns, and seasonal trends to predict future food demand and recommend optimal inventory levels to minimize waste. Good to Know AI forecasting accuracy improves over time with more historical data Weather and seasonal factors significantly impact food demand predictions Google Sheets access must be properly authorized to avoid data sync issues Email notifications help ensure timely review of daily forecasts The system works with two main data sources: historical food wastage data and predicted low-waste food requirements How It Works Daily Trigger - Initiates the workflow every day to perform food waste prediction Fetch Historical Sales Data - Reads past food usage & sales data from Google Sheets to understand trends Format Data for AI Forecasting - Cleans and organizes raw data into a structured format for AI processing AI Forecast Generator - Uses Gemini AI to forecast food demand and recommend waste reduction strategies Clean & Structure AI Output - Parses AI response into structured and actionable format for reporting Log Forecast to Google Sheets - Stores AI-generated forecast back into Google Sheets for historical tracking Create Email Summary - Creates a concise, human-friendly summary of the forecast findings Send Email Forecast Report - Delivers the forecast report via email to decision makers and management Data Sources The workflow utilizes two Google Sheets: Food Wastage Data Sheet - Contains historical data with columns: Date (date) Food Item (text) Quantity Wasted (number) Cost Impact (currency) Category (text) Reason for Waste (text) Predicted Food Data Sheet - Contains AI predictions with columns: Date (date) Food Item (text) Predicted Demand (number) Recommended Order Quantity (number) Waste Risk Level (text) Optimization Notes (text) How to Use Import the workflow into n8n Configure Google Sheets API access and authorize the application Set up email credentials for forecast report delivery Create the two required Google Sheets with the specified column structures Configure the AI model credentials (Gemini API key) Test with sample historical data to verify predictions and email delivery Adjust forecasting parameters based on your restaurant's specific needs Monitor and refine the system based on actual vs. predicted results Requirements Google Sheets API access Email service credentials (Gmail, SMTP, etc.) AI model API credentials (Gemini AI) Historical food wastage data for initial training Customizing This Workflow Modify the AI Forecast Generator prompts to focus on specific food categories, seasonal adjustments, or local market conditions. Adjust the email summary format to match your restaurant's reporting preferences and add additional data sources like supplier information or menu planning data.
by Preston Zeller
How It Works This N8N workflow creates an automated system for discovering high-potential real estate investment opportunities. The workflow runs on a customizable schedule to scan the market for properties that match your specific criteria, then alerts your team about the most promising leads. The process follows these steps: Connects to BatchData API on a regular schedule to search for properties matching your parameters Compares new results with previous scans to identify new listings and property changes Applies intelligent filtering to focus on high-potential opportunities (high equity, absentee owners, etc.) Retrieves comprehensive property details and owner information for qualified leads Delivers formatted alerts through multiple channels (email and Slack/Teams) Each email alert includes detailed property information, owner details, equity percentage, and a direct Google Maps link to view the property location. The workflow also posts concise notifications to your team's communication channels for quick updates. Who It's For This workflow is designed for: Real Estate Investors: Find off-market properties with high equity and motivated sellers Real Estate Agents: Identify potential listing opportunities before they hit the market Property Acquisition Teams: Streamline the lead generation process with automated scanning Real Estate Wholesalers: Discover properties with significant equity spreads for potential deals REITs and Property Management Companies: Monitor market changes and expansion opportunities The workflow is especially valuable for professionals who want to: Save hours of manual market research time Get early notifications about high-potential properties Access comprehensive property and owner information in one place Focus their efforts on the most promising opportunities About BatchData BatchData is a powerful property data platform for real estate professionals. Their API provides access to comprehensive property and owner information across the United States, including: Property details (bedrooms, bathrooms, square footage, year built, etc.) Valuation and equity estimates Owner information (name, mailing address, contact info) Transaction history and sales data Foreclosure and distressed property status Demographic and neighborhood data The platform specializes in providing accurate, actionable property data that helps real estate professionals make informed decisions and identify opportunities efficiently. BatchData's extensive database covers millions of properties nationwide and is regularly updated to ensure data accuracy. The API's flexible search capabilities allow you to filter properties based on numerous criteria, making it an ideal data source for automated lead generation workflows like this one.
by ObisDev
**Get Started ** Creator: @obisdev This workflow powers a fully automated WhatsApp chatbot using a self-hosted Venom Bot instead of the official WhatsApp Business API. It integrates Google Gemini AI to generate intelligent, conversational responses and optionally pulls factual information from a Google Docs-based knowledge base. Designed for small businesses and creators, the bot can maintain contextual memory across messages and act as a smart virtual assistant for sales, support, and lead generation. Overview This n8n workflow connects with a custom-hosted Venom Bot that simulates WhatsApp Web to send and receive messages. It uses a Webhook trigger to receive incoming messages, processes them with an AI Agent powered by Gemini, optionally pulls extra data from a Google Doc or Google Sheet, and sends a smart reply back through the Venom Bot. The workflow also includes a memory system to retain user context, making it capable of handling follow-up questions and dynamic conversations. Who this workflow is for Small Business Owners: Offer 24/7 customer service on WhatsApp without paying for Meta’s Business API. Freelancers & Developers: Build, test, and monetize intelligent bots without the approval process of WhatsApp’s API. Online Sellers & Creators: Handle FAQs, orders, and customer inquiries via WhatsApp on autopilot. Marketers: Deploy campaign bots that respond to DMs with personalized product suggestions or lead captures. Hackers & Builders: Experiment with unofficial APIs to control WhatsApp reliably without breaking TOS for small-scale use. Tools Used n8n: The automation platform managing flow, context, and decision logic. Venom Bot: A Node.js-based, self-hosted WhatsApp Web bot used to send/receive messages. Google Gemini: AI engine for generating context-aware replies. Google Docs (Optional): Acts as a structured knowledge base for business info or FAQs. Google Sheets (Optional): Feeds real-time or structured data into your AI responses. How to Install Import the Workflow: Download the .json and import it into your n8n instance. Set Up Venom Bot: Deploy Venom Bot (on VPS or local) and set it to send messages to your Webhook URL. Webhook Configuration: Update the Webhook node in n8n and set 'Respond' to "Using Respond to Webhook Node". Connect Google Gemini: Add your Gemini API key in n8n credentials. Set Up Google Docs (Optional): Link the document containing your knowledge base. Enable Conversational Memory: Use ={{ $("Process Message").first().json.from }} as the session ID. Check API Key Matching: Ensure the API_SECRET_KEY in Venom .env matches the authorization header in n8n. Customize Persona & Prompts: Update the AI Agent system message to fit your brand tone. Use Cases Customer service without WhatsApp Business API Smart lead generation bots E-commerce order responders AI-powered chatbot for DMs FAQ responder with knowledge base support Connect with Me Email: obisdev@gmail.com Twitter/X: @obisdev GitHub: github.com/obisdev Visit: obisdev.vercel.app #n8n #whatsappautomation #venombot #chatbots #noapi #geminiapi #googleworkspace #aiassistant #nocode #vpsautomation #chatbotwithoutapi #automationtools #customerbot #salesautomation #googleintegration
by Yaron Been
This workflow automatically identifies trending topics and hashtags across social media platforms to keep you informed of current trends and viral content. It saves you time by eliminating the need to manually research trending topics and provides data-driven insights for content strategy and social media planning. Overview This workflow automatically scrapes trending hashtag platforms and social media sites to extract currently trending topics, hashtags, and viral content themes. It uses Bright Data to access trend data sources without restrictions and AI to intelligently analyze trending content and provide actionable insights for content creators and marketers. Tools Used n8n**: The automation platform that orchestrates the workflow Bright Data**: For scraping trend platforms and social media without being blocked OpenAI**: AI agent for intelligent trend analysis and content insights Google Sheets**: For storing trending topics data and analysis results How to Install Import the Workflow: Download the .json file and import it into your n8n instance Configure Bright Data: Add your Bright Data credentials to the MCP Client node Set Up OpenAI: Configure your OpenAI API credentials Configure Google Sheets: Connect your Google Sheets account and set up your trending topics tracking spreadsheet Customize: Define target trend platforms and topics of interest Use Cases Content Marketing**: Discover trending topics for timely and relevant content creation Social Media Strategy**: Plan posts around viral hashtags and trending themes Brand Monitoring**: Track if your brand or industry topics are trending Influencer Marketing**: Identify trending content opportunities for collaborations Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #trendingtopics #hashtags #brightdata #webscraping #contentmarketing #n8nworkflow #workflow #nocode #socialmediatrends #trendanalysis #viralcontent #contentresearch #socialmediamonitoring #trendtracking #contentdiscovery #hashtagresearch #socialmediamarketing #contentautomation #trendmonitoring #socialmediainsights #contentplanning #trendalerts #viralmarketing #socialtrends #contentoptimization #trendingcontent #socialmediadata #contentintelligence
by Sk developer
YouTube Transcript Summarization in Any Language for Social Media This n8n workflow automates the process of: Retrieving YouTube Video Transcripts: It fetches the transcript for any YouTube video URL provided using the YouTube Transcript API from RapidAPI. Generating a Concise Summary in Any Language: The workflow uses Google Gemini (PaLM) to create a concise summary of the transcript in the language specified by the user (e.g., English, Spanish, etc.). Storing the Summary in Google Docs: The generated summary is inserted into a predefined Google Document, making it easy for users to share or edit. Features: Language Flexibility:** Summaries are created in the desired language. Fully Automated:** From fetching the transcript to updating Google Docs, the process is fully automated. Social Media Ready:** The summary is formatted and stored in a Google Doc, ready for use in social media posts. This workflow integrates with YouTube Transcript API via RapidAPI, allowing you to easily fetch video transcripts and summarize them with AI. The entire process is automated and seamless. Powered by RapidAPI: API Used:* YouTube Transcript API via *RapidAPI** to get the transcript data. Benefits: Saves Time:** Automates the transcript summarization process, eliminating the need for manual content extraction and summarization. Customizable Language Support:** Provides summaries in any language, enabling accessibility and engagement for a global audience. Streamlined Content Creation:** Automatically generates concise, engaging summaries that are ready for social media use. Google Docs Integration:** Saves summaries directly into a Google Doc for easy sharing, editing, and content management. Challenges Addressed: Manual Transcript Extraction:** Problem: Manually transcribing and summarizing YouTube videos for social media can be time-consuming and error-prone. Solution: This workflow fully automates the process, saving hours of manual work using the YouTube Transcript API. Lack of Language Support in Summaries:** Problem: Many automated tools only summarize content in a single language, limiting their accessibility. Solution: With language flexibility, the workflow creates summaries in the language of your choice, helping you cater to diverse audiences. Inconsistent Video Quality & Transcript Accuracy:** Problem: Not all YouTube videos have well-structured or accurate transcripts, leading to incomplete or inaccurate summaries. Solution: The workflow can process and format even imperfect transcripts, ensuring that the generated summaries are still accurate and useful. Managing Content Across Platforms:** Problem: Transcripts and summaries often need to be stored in multiple locations for social media posts, which can be cumbersome. Solution: The workflow integrates with Google Docs to automatically store and manage summaries in one place, making it easier to share and reuse content.