Automate blog content creation with OpenAI, Google Sheets & email approval flow
Who is this for? This workflow is perfect for: Digital marketers who need to scale SEO-optimized content production Bloggers and content creators who want to maintain consistent publishing schedules Small business owners who need regular blog content but lack writing resources What problem is this workflow solving? Creating high-quality, SEO-optimized blog content consistently is time-consuming and resource-intensive. This workflow solves that by: Automating the content generation process from topic to final draft Ensuring quality control through human-in-the-loop approval Managing topic queues and preventing duplicate content creation Streamlining the revision process based on human feedback Organizing and archiving all generated content for future reference What this workflow does From topics stored in Google Sheets, this workflow: Automatically retrieves pending topics from your Google Sheets tracking document Generates SEO-optimized blog posts (800-1200 words) using OpenAI GPT-4 with structured prompts Sends content for human approval via email with custom approval forms Handles revision requests by incorporating feedback while maintaining SEO best practices Updates topic status to prevent duplicate processing Add approved generated content in Google Sheets for easy access and management Routes workflow based on approval decisions (approve, revise, or cancel) Setup Copy the Google Sheet template here: 👉 Automate Blog Content Creation – Google Sheet Template Connect Google Sheets with your topic tracking document (requires "Topic List" and "Generated Content" sheets) Add your OpenAI API key to the AI agent nodes for content generation Configure Gmail for the approval notification system Set up your topic list in Google Sheets with "Topic" and "Status" columns Customize the schedule trigger to run at your preferred intervals Update email recipient in the approval node to your email address Test with a sample topic marked as "Pending" in your Google Sheet How to customize this workflow to your needs Adjust content length: modify the word count requirements in the AI agent prompts Change writing style: customize the copywriter prompts for different tones (formal, casual, technical) Add multiple reviewers: extend the approval system to include additional stakeholders Integrate with CMS: add nodes to automatically publish approved content to WordPress, Webflow, or other platforms Include keyword research: add Ahrefs or SEMrush nodes to incorporate keyword data Add image generation: integrate DALL-E or Midjourney for automatic featured image creation Customize approval criteria: modify the approval form to include specific feedback categories Add content scoring: integrate readability checkers or SEO analysis tools before approval Contact me for consulting and support: 📧 billychartanto@gmail.com
By Billy ChristiReal estate lead generation with BatchData skip tracing & CRM integration
How It Works This workflow automates the entire property lead generation process in a few simple steps: Property Search: Connects to BatchData's Property Search API with customizable parameters (location, property type, value range, equity percentage, etc.) Lead Filtering & Scoring: Processes results to identify the most promising leads based on criteria like absentee ownership, years owned, equity percentage, and tax status. Each property receives a lead score to prioritize follow-up. Skip Tracing: Automatically retrieves owner contact information (phone, email, mailing address) for each qualified property. Data Formatting: Structures all property and owner data into a clean, organized format ready for your systems. Multi-Channel Output: Generates an Excel spreadsheet with all lead details Pushes leads directly to your CRM (configurable for HubSpot, Salesforce, etc.) Sends a summary email with the spreadsheet attached The workflow can run on a daily schedule or be triggered manually as needed. All parameters are easily configurable through dedicated nodes, requiring no coding knowledge. Who's It For This workflow is perfect for: Real Estate Investors looking to find off-market properties with motivated sellers Real Estate Agents who want to generate listing leads from distressed or high-equity properties Investment Companies that need regular lead flow for acquisitions Real Estate Marketers who run targeted campaigns to property owners Wholesalers seeking to build a pipeline of potential deals Property Service Providers (roof repair, renovation contractors, etc.) who target specific property types Anyone who needs reliable, consistent lead generation for real estate without the manual work of searching, filtering, and organizing property data will benefit from this automation. About BatchData BatchData is a comprehensive property data provider that offers access to nationwide property information, owner details, and skip tracing services. Key features include: Extensive Database: Covers 150+ million properties across all 50 states Rich Property Data: Includes ownership information, tax records, sales history, valuation estimates, equity positions, and more Skip Tracing Services: Provides owner contact information including phone numbers, email addresses, and mailing addresses Distressed Property Indicators: Flags for pre-foreclosure, tax delinquency, vacancy, and other motivation factors RESTful API: Professional API for programmatic access to all property data services Regular Updates: Continuously refreshed data for accurate information BatchData's services are designed for real estate professionals who need reliable property and owner information to power their marketing and acquisition strategies. Their API-first approach makes it ideal for workflow automation tools like N8N.
By Preston ZellerSave Telegram daily messages to Google Sheets
A goal for 2022 is to write 1 thing I do each day. Combined with this workflow you will get daily messages via Telegram and when you reply to them they will be saved in a Google Sheet. Note: Make sure to configure your Telegram and Google Sheet credentials! You will also need to modify the functions to have your Telegram username and bot name.
By Nicholas LewanowiczPersonal portfolio CV Rag chatbot - with conversation store and email summary
Personal Portfolio CV Rag Chatbot - with Conversation Store and Email Summary Target Audience This template is perfect for: Individuals looking to create a working professional and interactive personal portfolio chatbot. Developers interested in integrating RAG Chatbot functionality with conversation storage. Description Create a stunning Personal Portfolio CV with integrated RAG Chatbot capabilities, including conversation storage and daily email summaries. 2.Features: Training: Setup Ingestion stage Upload your CV to Google Drive and let the Drive trigger updates to read your resume cv and convert it into your vector database (RAG purpose). Modify any parts as needed. Chat & Track: Use any frontend/backend interface to call the chat API and chat history API. Reporting Daily Chat Conversations: Receive daily automatic summaries of chat conversations. Data stored via NocoDB. 3.Setup Guide: Step-by-Step Instructions: Ensure all credentials are ready. Follow the notes provided. Ingestion: Upload your CV to Google Drive. The Drive triggers RAG update in your vector database. You can change the folder name, files and indexname of the vector database accordingly. Chat: Use any frontend/backend interface to call the chat API (refer to the notes for details) . [optional] Use any frontend/backend interface to call the update chat history API (refer to the notes for details). 3.Tracking Chat: Get daily automatic summaries of chat conversations.Format email conversations report as you like. You are ready to go!
By Sean LonSend a message with an inline embedded image with Gmail
The built-in Gmail node doesn't yet support embedding images within the body of the email, but you can pull this off using the HTTP node, and this template shows you how. Requirements A Gmail account How it works The workflow downloads an image, converts it into the format that the Gmail API expects (base64), packages it into a multipart MIME email and uses the HTTP node to send it.
By David RobertsAI-powered technical analyst with Perplexity R1 research
[](https://youtu.be/D11S0s3PDNc) Leverage the latest AI technology to analyze financial charts and make informed trading decisions with our Technical Analysis AI Agent. This powerful workflow combines Claude Sonnet 3.7 vision capabilities with Perplexity deep reasoning and up-to-date internet information to deliver comprehensive market analysis. Key Capabilities: Visual Chart Analysis - AI vision technology examines technical charts to identify key price points, volume patterns, and trend indicators Fundamental Research Integration - Combines technical analysis with real-time fundamental data using DeepSeek R1 reasoning Fully Cited Reports - Fundamental analysis backed by verifiable sources for confident decision-making Automated Email Delivery - Receive complete analysis reports directly to your inbox How It Works: This workflow orchestrates multiple AI components to analyze financial instruments: The Technical Analysis Leader coordinates the entire analysis process Chart analysis tool identifies the appropriate exchange and downloads Trading View charts AI Vision examines the chart for technical indicators including RSI, volume patterns, and support/resistance levels Perplexity tool conducts fundamental research using DeepSeek R1 reasoning capabilities All data is synthesized into a comprehensive report with trading recommendations Results can be automatically emailed for reference Setup Instructions: Quick start video included in the template. Get API key from OpenRouter.ai to access the Sonnet 3.7 model Get API key from chart-img.com to access tradingview charts Connect the Gmail node for email delivery functionality IMPORTANT DISCLAIMER: This tool provides technical analysis for informational purposes only and should not be construed as investment advice. This AI-powered technical analysis tool is designed to assist with market analysis but should not be used as the sole basis for any investment decision
By Derek CheungManage emails via WhatsApp with Gmail, GPT and voice recognition
🔍 How it works This workflow turns WhatsApp into a smart email command center using AI. Users can speak or type instructions like: "Send a follow-up to Claire” "Write a draft email to Claire to confirm tomorrow’s meeting at 5 PM” "What is the name of Claire's firm?” The agent transcribes voice notes, extracts intent with GPT, interacts with Gmail (send, draft, search), and replies with a confirmation via WhatsApp — either as text or a voice message. ⚙️ Key Modules Used WhatsApp Business Webhook (Meta) OpenAI Whisper (voice transcription) GPT (intent + content generation) Gmail (search, draft, send) Airtable (contact lookup + memory logging) 🧠 Memory Layer (Optional) The agent logs key fields in Airtable: Recipient email Company / job title And more... This creates a lightweight "gut memory” so the agent feels context-aware. 🗺️ Setup Steps Connect WhatsApp Business API (via Meta Developer Console) Add OpenAI and Gmail credentials in n8n Link your Airtable base for contacts and logging 🧩 Best Use Cases Hands-free email reply while commuting Fast Gmail access for busy consultants / solopreneurs Custom business agents for service-based professionals ⏱️ Estimated Setup Time 30–60 minutes ✅ Requirements WhatsApp Business Cloud access OpenAI API Key Gmail or Google Workspace Airtable account (free plan OK) n8n instance (cloud or self-hosted with HTTPS)
By Floyd MahouBackup n8n workflows to Github
Introduction This workflow will backup all of your existed workflows to a single Github repository. The Backup folders' name are based on the current backup date and have default format: "yyyy/MM/dd" (setup at "Create sub path" node). Throughout the backup process, the N8N will inform user via discord with clear message about Start, Success and Failure backups. The workflow will be Tech Stack The following nodes / services / libraries are used in this workflow: Nodes: Discord: To send message to configured setup channel. N8N: To get all workflows' information. Github: To store backup data. Code: To run data comparison (Existed vs Latest workflow data). Wait: To avoid discord message rate limit. External libraries: Underscore.js: JavaScript library that provides lots of common Javascript functions, to help user save time when using code node. Guideline Open "Config" node and setup the following information: repo_owner: Your Github username. repo_name: The repository that you want to store workflows backup data. Open "Create sub path" node and change the naming and path format of backup folder(s). Setup custom messages in 3 discord nodes: Starting Message: N8N inform user at the time workflow start. Inform Success Flows: After each success backup, N8N will notify user. Inform Failed Flows: After each failure backup, N8N will notify user to have appropriate action. Completed Notifications: Then at the final, the workflow will give user a summary. Setup "Schedule Trigger" node to change default automated backup time. Screenshots Discord output
By Dat ProtoAutomate LinkedIn profile search & cold email outreach with OpenAI and Hunter
Problem 🚨 LinkedIn search is BROKEN. I waste hours on LinkedIn manually filtering profiles, reading summaries, hoping they’d reply—tedious, frustrating, inefficient. I wish LinkedIn had built an agent that would get me to the right profile with one click! If only I could just type: "Product managers working on YouTube Shorts' generative AI features." and seconds later, have LinkedIn URLs, names, emails, and full context about them. Introducing LinkGPT, a LinkedIn Agent, an automated agentic workflow powered by n8n. Prerequisites: Required accounts/API keys for Hunter.io, Google, and OpenAI. This would be helpful for: 🎯 Job Seekers: Skip ATS, email hiring managers directly ( I wish I had this when I was recruiting!) 🎯 Recruiters: Reach your dream candidates first 🎯 Founders & Sales Teams: Share your demos with customers directly (this does NOT use the expensive Sales Navigator API) Step-by-step workflow: Takes 5-10 minutes to setup. Generate a Boolean search string for LinkedIn profiles. Perform authenticated Google searches using your query. Extract LinkedIn URLs and workplace context from the search results. Use OpenAI to extract first name, last name, and domain name from the context. Use Hunter.io to find emails of the contacts. Append all results to your connected Google Sheet. Columns: firstname, lastname, domain_name, email, context I put together a clear, step-by-step guide on setting this up yourself. Sample Query Sample: Input: "I am headed to NYC later this month, whom should I meet with that works in product management for gen AI products?" Output: List of 10 contacts with first name, last name, workplace, email address and context about them so you can email them.
By Abhijay VuyyuruAutomate lead generation from Google Search & Maps to Google Sheets
This n8n template from Intuz provides a complete solution to automate on-demand lead generation. It acts as a powerful scraping agent that takes a simple chat query, scours both Google Search and Google Maps for relevant businesses, scrapes their websites for contact details, and compiles an enriched lead list directly in Google Sheets. Who's this workflow for? Sales Development Representatives (SDRs) Local Marketing Agencies Business Development Teams Freelancers & Consultants Market Researchers How it works Start with a Chat Query: The user initiates the workflow by typing a search query (e.g., "dentists in New York") into a chat interface. Multi-Source Search: The workflow queries both the Google Custom Search API (for web results across multiple pages) and scrapes Google Maps (for local businesses) to gather a broad list of potential leads. Deep Dive Website Scraping: For each unique business website found, the workflow visits the URL to scrape the raw HTML content of the page. Intelligent Contact Extraction: Using custom code, it then parses the scraped website content to find and extract valuable contact information like email addresses, phone numbers, and social media links. Deduplicate and Log to Sheets: Before saving, the workflow checks your Google Sheet to ensure the lead doesn't already exist. All unique, newly enriched leads are then appended as clean rows to your sheet, along with the original search query for tracking. Key Requirements to Use This Template n8n Instance & Required Nodes: An active n8n account (Cloud or self-hosted). This workflow uses the official n8n LangChain integration (@n8n/n8n-nodes-langchain) for the chat trigger. If you are using a self-hosted version of n8n, please ensure this package is installed. Google Custom Search API: A Google Cloud Project with the "Custom Search API" enabled. You will need an API Key for this service. You must also create a Programmable Search Engine and get its Search engine ID (cx). This tells Google what to search (e.g., the whole web). Google Sheets Account: A Google account and a pre-made Google Sheet with columns for Business Name, Primary Email, Contact Number, URL, Description, Socials, and Search Query. Setup Instructions Configure the Chat Trigger: In the "When chat message received" node, you can find the Direct URL or Embed code to use the chat interface. Set Up Google Custom Search API (Crucial Step): Go to the "Custom Google Search API" (HTTP Request) node. Under "Query Parameters", you must replace the placeholder values for key (with your API Key) and cx (with your Search Engine ID). Configure Google Sheets: In all Google Sheets nodes (Append row in sheet, Get row(s) in sheet, etc.), connect your Google Sheets credentials. Select your target spreadsheet (Document ID) and the specific sheet (Sheet Name) where you want to store the leads. Activate the Workflow: Save the workflow and toggle the "Active" switch to ON. Open the chat URL and enter a search query to start generating leads. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Workflow Automation Click here- Get Started
By Intuz LINE BOT - Google Sheets file lookup with AI agent
This workflow integrates LINE BOT, AI Agent (GPT), Google Sheets, and Google Drive to enable users to search for file URLs using natural language. The AI Agent extracts the filename from the message, searches for the file in Google Sheets, and returns the corresponding Google Drive URL via LINE BOT. Supports natural language queries (e.g., "Find file 1.pdf for me") AI-powered filename extraction Google Sheets Lookup for file URLs Auto-response via LINE BOT How to Use This Template Download & Import Copy and save the Template Code as a .json file. Go to n8n Editor → Click Import → Upload the file. Update Required Fields Replace YOURGOOGLESHEET_ID with your actual Google Sheet ID. Replace YOURLINEACCESS_TOKEN with your LINE BOT Channel Access Token. Activate & Test Click Execute Workflow to test manually. Set Webhook URL in LINE Developer Console. Features of This Template Supports Natural Language Queries (e.g., “Find file 1.pdf for me”) AI-powered filename extraction using OpenAI (GPT-4/3.5) Real-time file lookup in Google Sheets Automatic LINE BOT Response Fully Automated Workflow
By Jaruphat J.AI DJ: Text-to-Spotify playlist generator with Linkup and GPT4
Stop manually searching for songs and let an AI DJ do the work for you. This template provides a complete, end-to-end system that transforms any text prompt into a ready-to-play Spotify playlist. It combines the creative understanding of a powerful AI Agent with the real-time web knowledge of Linkup to curate perfect, up-to-the-minute playlists for any occasion. The experience is seamless: simply describe the vibe you're looking for in a web form, and the workflow will automatically create the playlist in your Spotify account and redirect you straight to it. Whether you need "upbeat funk for a sunny afternoon" or "moody electronic tracks for late-night coding," your personal AI DJ is ready to deliver. Who is this for? Music lovers: Create hyper-specific playlists for any mood, activity, or niche genre without the hassle of manual searching. DJs & event planners: Quickly generate themed playlists for parties, weddings, or corporate events based on a simple brief. Content creators: Easily create companion playlists for your podcasts, videos, or articles to share with your audience. n8n developers: A powerful example of how to build an AI agent that uses an external web-search tool to accomplish a creative task. What problem does this solve? Creates up-to-date playlists: A standard AI doesn't know about music released yesterday. By using Linkup's live web search, this workflow can find and include the very latest tracks. Automates the entire creation process: It handles everything from understanding a vague prompt (like "songs that feel like a summer road trip") to creating a fully populated Spotify playlist. Saves time and effort: It completely eliminates the tedious task of searching for individual tracks, checking for relevance, and manually adding them to a playlist one by one. Provides a seamless user experience: The workflow begins with a simple form and ends by automatically opening the finished playlist in your browser. There are no intermediate steps for you to manage. How it works Submit your playlist idea: You describe the playlist you want and the desired number of tracks in a simple, Spotify-themed web form. The AI DJ plans the search: An AI Agent (acting as your personal DJ) analyzes your request. It then intelligently formulates a specific query to find the best music. Web research with Linkup: The agent uses its Linkup web-search tool to find artists and tracks from across the web that perfectly match your request, returning a list of high-quality suggestions. The AI DJ curates the list: The agent reviews the search results and finalizes the tracklist and a creative name for your playlist. Build the playlist in Spotify: The workflow takes the agent's final list, creates a new public playlist in your Spotify account, then searches for each individual track to get its ID and adds them all. Instant redirection: As soon as the last track is added, the workflow automatically redirects your browser to the newly created playlist on Spotify, ready to be played. Setup Connect your accounts: You will need to add your credentials for: Spotify: In the Spotify nodes. Linkup: In the Web query to find tracks (HTTP Request Tool) node. Linkup's free plan is very generous! Your AI provider (e.g., OpenAI): In the OpenAI Chat Model node. Activate the workflow: Toggle the workflow to "Active." Use the form: Open the URL from the On form submission trigger and start creating playlists! Taking it further Change the trigger: Instead of a form, trigger the playlist creation from a Telegram message, a Discord bot command, or even a webhook from another application. Create collaborative playlists: Set up a workflow where multiple people can submit song ideas. You could then have a final AI step consolidate all the requests into a single, cohesive prompt to generate the ultimate group playlist. Optimize for speed: The Web query to find tracks node is set to deep search mode for the highest quality results. You can change this to standard mode for faster and cheaper (but potentially less thorough) playlist creation.
By Guillaume Duvernay