Workflow Templates

AI-Powered Automated Outreach Scheduling with Gemini, Gmail & Google Sheets Automate your lead generation and outreach process seamlessly using AI, Gmail, and Google Sheets—all within n8n. No complicated setup—just import, activate, and start reaching prospects with personalized messages generated by Google Gemini’s AI model. Quick Setup Import the Workflow Download and import the provided workflow into your n8n instance. Connect Your Accounts Authenticate your Google Sheets account. Connect your Gmail account for sending emails. Prepare the Spreadsheet Use this template to set up your leads and tracking sheet. Configure the Gemini API Obtain your Gemini API key. Here Add it to the Gemini API credentials within n8n. Set Scheduling Preferences Customize the Schedule Trigger node to control when the workflow runs. Edit Email Prompts Update the initial and follow-up email prompts to match your outreach tone and goals. Set Rate Limits Configure the rate limiting settings to comply with Gmail sending limits and avoid spam filters. Activate the Workflow Enable the workflow to begin automated outreach to your leads. Track and Manage Leads Monitor responses and update lead statuses directly in your Google Sheet. How It Works Schedule Trigger:** Automatically starts outreach based on your defined schedule Google Sheets Integration:** Fetches leads and updates their status after outreach Email Validation:** Checks if lead emails are valid before sending Website Scraper:** Gathers info from lead websites to personalize messages Google Gemini AI:** Generates tailored cold outreach messages optimized for high response Gmail Node:** Sends personalized emails directly from your Gmail account Core Features Pull leads automatically from Google Sheets Validate emails to avoid bounces Scrape lead websites for custom messaging context Generate AI-crafted outreach emails with dynamic personalization Send emails on schedule without manual intervention Update lead status to track outreach progress AI Integration Uses Google Gemini AI to create professional, friendly, and engaging outreach emails Dynamic prompt templates tailored to each lead’s company and website content Structured JSON output to easily map subject, greeting, and body content 💡 Usage Examples B2B cold outreach campaigns with personalized emails Automated follow-ups based on lead engagement Lead nurturing with context-aware messaging Sales prospecting workflows integrated into your CRM ✨ Benefits Save hours by automating personalized outreach Increase response rates with AI-optimized messaging Keep lead data organized and updated in Google Sheets Fully scalable and customizable n8n workflow Minimal setup, ready to run out-of-the-box

How it works: This project creates a personal AI assistant named Angie that operates through Telegram. Angie can summarize daily emails, look up calendar entries, remind users of upcoming tasks, and retrieve contact information. The assistant can interact with users via both voice and text inputs. Step-by-step: Telegram Trigger: The workflow starts with a Telegram trigger that listens for incoming message events. The system determines if the incoming message is voice or text. If voice, the voice file is retrieved and transcribed to text using OpenAI's API Speech to Text AI Assistant: The telegram request is passed to the AI assistant (Angie). Tools Integration: The AI assistant is equipped with several tools: Get Email: Uses Gmail API to fetch recent emails, filtering by date. Get Calendar: Retrieves calendar entries for specified dates. Get Tasks: Connects to a Baserow (open-source Airtable alternative) database to fetch to-do list items. Get Contacts: Also uses Baserow to retrieve contact information. Response Generation: The AI formulates a response based on the gathered information and sends back to the user on Telegram

This n8n workflow automates the process of scraping LinkedIn profiles using the Apify platform and organizing the extracted data into Google Sheets for easy analysis and follow-up. Use Cases Lead Generation**: Extract contact information and professional details from LinkedIn profiles Recruitment**: Gather candidate information for talent acquisition Market Research**: Analyze professional networks and industry connections Sales Prospecting**: Build targeted prospect lists with detailed professional information How It Works 1. Workflow Initialization & Input Webhook Start Scraper**: Triggers the entire scraping workflow Read LinkedIn URLs**: Retrieves LinkedIn profile URLs from Google Sheets Schedule Scraper Trigger**: Sets up automated scheduling for regular scraping 2. Data Processing & Extraction Data Formatting**: Prepares and structures the LinkedIn URLs for processing Fetch Profile Data**: Makes HTTP requests to Apify API with profile URLs Run Scraper Actor**: Executes the Apify LinkedIn scraper actor Get Scraped Results**: Retrieves the extracted profile data from Apify 3. Data Storage & Completion Save to Google Sheets**: Stores the scraped profile data in organized spreadsheet format Update Progress Tracker**: Updates workflow status and progress tracking Process Complete Wait**: Ensures all operations finish before final steps Send Success Notification**: Alerts users when scraping is successfully completed Requirements Apify Account Active Apify account with sufficient credits API token for authentication Access to LinkedIn Profile Scraper actor Google Sheets Google account with Sheets access Properly formatted input sheet with LinkedIn URLs Credentials configured in n8n n8n Setup HTTP Request node credentials for Apify Google Sheets node credentials Webhook endpoint configured How to Use Step 1: Prepare Your Data Create a Google Sheet with LinkedIn profile URLs Ensure the sheet has a column named 'linkedin_url' Add any additional columns for metadata (name, company, etc.) Step 2: Configure Credentials Set up Apify API credentials in n8n Configure Google Sheets authentication Update webhook endpoint URL Step 3: Customize Settings Adjust scraping parameters in the Apify node Modify data fields to extract based on your needs Set up notification preferences Step 4: Execute Workflow Trigger via webhook or manual execution Monitor progress through the workflow Check Google Sheets for scraped data Review completion notifications Good to Know Rate Limits**: LinkedIn scraping is subject to rate limits. The workflow includes delays to respect these limits. Data Quality**: Results depend on profile visibility and LinkedIn's anti-scraping measures. Costs**: Apify charges based on compute units used. Monitor your usage to control costs. Compliance**: Ensure your scraping activities comply with LinkedIn's Terms of Service and applicable laws. Customizing This Workflow Enhanced Data Processing Add data enrichment steps to append additional information Implement duplicate detection and merge logic Create data validation rules for quality control Advanced Notifications Set up Slack or email alerts for different scenarios Create detailed reports with scraping statistics Implement error recovery mechanisms Integration Options Connect to CRM systems for automatic lead creation Integrate with marketing automation platforms Export data to analytics tools for further analysis Troubleshooting Common Issues Apify Actor Failures**: Check API limits and actor status Google Sheets Errors**: Verify permissions and sheet structure Rate Limiting**: Implement longer delays between requests Data Quality Issues**: Review scraping parameters and target profiles Best Practices Test with small batches before scaling up Monitor Apify credit usage regularly Keep backup copies of your data Regular validation of scraped information accuracy

Good to know: This workflow automatically processes incoming emails (you can filter them base on your needs) and creates concise AI-powered summaries, then logs them to a Google Sheets spreadsheet for easy tracking and analysis. Who is this for? ➖Business professionals who receive many emails and need quick summaries ➖Customer service teams tracking email communications ➖Project managers monitoring email correspondence ➖Anyone who wants to automatically organize and summarize their email communications What problem is this workflow solving? This workflow solves the problem of email overload by automatically reading incoming emails, generating concise summaries using AI, and organizing them in a structured format. It eliminates the need to manually read through every email to understand the key points and maintains a searchable record of communications. What this workflow does: ✅Monitors your Gmail inbox for new emails ✅Filters emails based on specific criteria (sender validation) ✅Extracts key information (sender, date, subject, content) ✅Uses AI to generate concise summaries of email content ✅Automatically logs all data including the AI summary to a Google Sheets spreadsheet How it works: 1️⃣Gmail trigger monitors for new emails at specified intervals 2️⃣Email data is processed and formatted using JavaScript 3️⃣A conditional check validates the sender 4️⃣AI agent (powered by Groq's language model) reads the email content and generates a summary 5️⃣All information is automatically appended to a Google Sheets document How to use: Set up Gmail OAuth2 credentials in n8n Configure Google Sheets OAuth2 credentials Set up Groq API credentials for AI processing Create a Google Sheets document and update the document ID Customize the sender validation criteria as needed Activate the workflow Requirements: ✅n8n instance (cloud or self-hosted) ✅Gmail account with OAuth2 access ✅Google Sheets account ✅AI API ✅Basic understanding of n8n workflow Customizing this workflow: 🟢Modify the Gmail trigger filters to target specific labels or criteria 🟢Adjust the sender validation logic in the conditional node 🟢Customize the AI prompt to change summary style or focus 🟢Add additional data fields to the Google Sheets output 🟢Change the polling frequency for checking new emails 🟢Switch to different AI models by replacing the Groq node

This workflow automates the generation and delivery of personalized business documents (e.g., contracts, job offers, invoices, pay slips) in PDF format. The data source is a Google Sheet, and the documents are created using CraftMyPDF, then uploaded to Google Drive and optionally sent via email. This workflow is ideal for bulk document generation (contracts, invoices, etc.) with minimal manual intervention. Benefits Fully Automated**: Once triggered, it handles the whole pipeline end-to-end—no manual editing or document creation needed. Customizable**: Works with any type of business document as long as you provide a CraftMyPDF template. Scalable**: Processes multiple entries in batch, ideal for HR departments or finance teams. Integrated**: Seamlessly connects Google Sheets, CraftMyPDF, Google Drive, and Gmail. Trackable**: Updates the original spreadsheet to keep track of which documents have been processed. Requirements Self-hosted n8n instance (required for some advanced node usage). Google Sheet template with columns like: FIRST NAME, LAST NAME, ADDRESS, etc. A CraftMyPDF account with a ready-made template. Google OAuth2 credentials for Sheets, Drive, and Gmail integrations. How It Works Trigger & Data Fetch: The workflow starts with a manual trigger ("When clicking ‘Execute workflow’"). It retrieves employee data from a Google Sheet ("Get employees"), filtering rows where the "DONE" column is empty. PDF Generation & Processing: The "Loop Over Items" node processes each employee record individually. The "Create agreement" node uses CraftMyPDF to generate a PDF contract, populating it with employee details (name, address, email, etc.). A conditional node ("Success?") checks if PDF creation was successful. PDF Handling & Notifications: The PDF is fetched ("Get agreement") and uploaded to Google Drive ("Upload agreement") with a filename like [First-Name]-[Last-Name].pdf. An email with the PDF attachment is sent to the employee via Gmail ("Send email with PDF"). Tracking & Completion: The Google Sheet row is updated with "x" in the "DONE" column ("Update row") to mark completion. The workflow merges results and loops until all records are processed. Set Up Steps Prerequisites: Use the self-hosted version of n8n (required for this workflow). Clone the provided Google Sheet template. Configure CraftMyPDF: Create an account on CraftMyPDF. Design a PDF template and note its Template ID. Insert this ID in the "Create agreement" node. Credentials Setup: Connect nodes to: Google Sheets (to fetch/update data). Google Drive (to store PDFs). Gmail (to send emails). CraftMyPDF (for PDF generation). Customization: Adjust field mappings in the "Create agreement" node to match your PDF template placeholders. Modify the email template in "Send email with PDF" as needed. Execution: Run the workflow manually. It will process all rows lacking a "DONE" marker, generating PDFs, sending emails, and updating the sheet automatically. Need help customizing? Contact me for consulting and support or add me on Linkedin.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Description See the transformation in action! Here's an example of what this workflow can achieve: This automation template is designed for content creators, social media managers, and anyone looking to breathe new life into old family photos and historical images. It transforms any old black and white or sepia photograph into a colorized, animated video using cutting-edge AI technology, then automatically publishes the results across multiple social media platforms including Facebook, Instagram, YouTube, and X (Twitter). The workflow combines powerful AI services to create engaging content from vintage photographs: first enhancing and colorizing the image using FLUX Kontext, then bringing it to life with realistic animations using Kling Video AI, and finally distributing the results across your social media channels automatically. Note: The estimated cost per workflow execution is approximately $0.29 USD, covering the AI processing for both image colorization and video animation. The upload-post node only works for self-hosted n8n instances, but you can use the standard HTTP request node for uploading content on n8n Cloud.* Who Is This For? Content Creators & Social Media Managers:** Transform historical content into engaging videos that capture audience attention and drive engagement across platforms. Family History Enthusiasts:** Bring old family photos to life by adding color and motion, creating emotional connections with your audience. Marketing Professionals:** Leverage nostalgic content for brand storytelling, using vintage aesthetics to create compelling social media campaigns. Digital Artists & Photo Restorers:** Streamline the process of enhancing and sharing restored vintage photographs with automated AI enhancement. Social Media Influencers:** Create unique, eye-catching content from historical images that stands out in crowded social feeds. What Problem Does This Workflow Solve? Creating engaging social media content from old photos typically requires multiple manual steps: photo restoration, colorization, animation, and then individual posting to each platform. This workflow addresses these challenges by: Automating Photo Enhancement:** Uses advanced AI (FLUX Kontext) to automatically colorize and enhance old photographs, removing artifacts and improving quality. Creating Dynamic Content:** Transforms static images into animated videos using Kling Video AI, making historical photos come alive with natural movements. Streamlining Multi-Platform Publishing:** Automatically distributes the final animated videos across Facebook, Instagram, YouTube, and X with a single workflow execution. Saving Time & Effort:** Eliminates the need for manual photo editing, video creation, and individual social media posting. How It Works Photo Upload: Users submit old photographs through a simple web form, with optional custom animation descriptions. Image Enhancement: The workflow uploads the photo to imgbb, then sends it to FLUX Kontext AI for colorization and quality enhancement. Animation Creation: The colorized image is processed by Kling Video AI to create a 5-second animated video with natural movements. Cloud Storage: The final video is automatically saved to Google Drive for backup and easy access. Multi-Platform Publishing: The animated video is simultaneously posted to Facebook, Instagram, YouTube, and X using the upload-post service. Setup FAL.AI API Key: Sign up at fal.ai and add your API key to the HTTP Request nodes for both FLUX Kontext and Kling Video AI services. ImgBB API Token: Create a free account at api.imgbb.com to get an API token for image hosting, then update the "Upload Image to imgbb" node. Google Drive Connection: Connect your Google Drive account to enable automatic video storage and backup. Upload-Post Service: Create an account at upload-post.com to get your API credentials for multi-platform social media posting. Important: The upload-post node currently only works with self-hosted n8n instances. For n8n Cloud users, replace the upload-post node with standard HTTP request nodes to publish to each social media platform individually. Form Customization: (Optional) Modify the form fields in the "Photo Upload Form" node to collect additional information or customize the user experience. Requirements Accounts:** n8n, FAL.AI, ImgBB, Google Drive, upload-post.com API Keys & Credentials:** FAL.AI API Key, ImgBB API Token, Google Drive OAuth2, Upload-post.com API Token & User ID File Types:** Supports JPG, PNG image formats for photo uploads Cost:** Approximately $0.29 USD per workflow execution for AI processing Transform your old photographs into viral social media content with this powerful AI-driven workflow that handles everything from restoration to distribution automatically.

A reasoning agent that can think, search, calculate, and remember — powered by GROQ inference and ready to deploy in one click. Unlike traditional AI bots that only respond, this assistant reasons before replying, fetches real-time facts, does math, and keeps short-term memory of your conversation. 🔧 How it works This template builds a conversational AI agent using the GROQ LLaMA 3 or LLaMA 4 API, combined with modular tools like: 🧠 Think Tool – performs step-by-step logical reasoning 🔍 SerpAPI – fetches live data from Google search ➗ Calculator – handles arithmetic and math queries 💾 Memory Buffer – keeps track of the last 5 messages for context Everything is integrated inside n8n and optimized for blazing-fast replies using GROQ’s ultra-low latency. 🧠 Your Agent Will: Understand and analyze your queries Think through solutions before answering Pull real-time data via SerpAPI Perform calculations with the built-in math engine Recall prior context using short-term memory Respond clearly, conversationally — like a real assistant 🧑‍💼 Who is this template for? Perfect for: AI builders and creators using GROQ + n8n Teams needing a real-time LLaMA-powered assistant Beginners exploring LangChain + n8n workflows Developers combining LLMs + tools + memory 🚀 How to Set Up Plug in your GROQ API key Add your SerpAPI key Import and run — it’s ready to chat! All tools are pre-wired. You can expand the memory, customize prompts, or plug in more tools. 📬 Use Cases Connect this agent with: Telegram Bots 🤖 WhatsApp via Twilio 📱 Slack, Discord, or Gmail 💬 Manual triggers in n8n 🔁 👉 Check out more templates by this creator: https://n8n.io/creators/digimetalab

LinkedIn AI Agent: Auto-Post Creator & Multi-Group Distributor Transform simple topic ideas into engaging LinkedIn posts and automatically distribute them across your profile and multiple LinkedIn groups. This powerful n8n workflow combines AI content generation with intelligent distribution, helping you maintain a consistent professional presence while maximizing your reach across relevant communities. 🚀 How It Works This sophisticated 6-step automation turns content ideas into LinkedIn success: Step 1: Smart Content Monitoring The workflow continuously monitors your Google Sheets for new post topics marked as "Pending", checking every minute for fresh content to process. Step 2: AI-Powered Content Generation GPT-4 transforms your basic topic into a professionally crafted LinkedIn post featuring: Compelling opening hooks that grab attention 3-4 informative paragraphs with valuable insights Strategic questions to encourage engagement 4-6 relevant hashtags for discoverability Professional emoji placement for visual appeal Optimized formatting for LinkedIn's platform Step 3: Professional Formatting The workflow ensures your content meets LinkedIn's technical requirements with proper JSON formatting, character limits, and special character handling. Step 4: Personal Profile Publishing Your generated post is automatically published to your personal LinkedIn profile, maintaining your professional brand presence. Step 5: Multi-Group Distribution The same content is intelligently distributed across all your specified LinkedIn groups, amplifying your reach to targeted professional communities. Step 6: Status Management The workflow automatically updates your Google Sheets to mark posts as "Posted", providing clear tracking of your content pipeline. ⚙️ Setup Steps Prerequisites Active LinkedIn account with API access Google Sheets access for content management OpenAI API key with GPT-4 access LinkedIn group memberships with posting permissions n8n instance (cloud or self-hosted) Required Google Sheets Structure Sheet 1 - Main Content: | ID | LinkedIn Post Title | Status | |----|-------------------|--------| | 1 | AI Trends in 2024 | Pending | | 2 | Remote Work Tips | Posted | Sheet 2 - Groups: | GroupIds | |-------------| | 123456789 | | 987654321 | | 456789123 | Note: Collect LinkedIn group IDs from groups where you have posting permissions. These can be found in the group URL or through LinkedIn's API. Configuration Steps Credential Setup Google Sheets OAuth2: Access your content spreadsheet OpenAI API Key: Required for AI content generation LinkedIn OAuth2: Enable profile and group posting HTTP Authentication: Configure LinkedIn API headers Google Sheets Preparation Create spreadsheet with the required two-sheet structure Populate group IDs from your joined LinkedIn groups Add initial post topics with "Pending" status Ensure proper column naming and data types LinkedIn Group Setup Join relevant professional LinkedIn groups Verify posting permissions in each group Collect group IDs using LinkedIn's interface or API Test posting permissions before full automation AI Content Customization The default prompt generates professional LinkedIn content, but can be customized for: Industry-specific terminology and trends Company voice and brand guidelines Target audience preferences Content style (educational, promotional, thought leadership) Workflow Activation Import the workflow JSON into your n8n instance Configure all credential connections Test with sample content before going live Activate the Google Sheets trigger 🎯 Use Cases Content Creators & Influencers Consistent Posting: Maintain regular LinkedIn presence without daily manual work Audience Growth: Reach multiple professional communities simultaneously Content Scaling: Transform brief ideas into full-length engaging posts Brand Building: Establish thought leadership across industry groups Marketing Teams Lead Generation: Share valuable content across targeted professional groups Brand Awareness: Increase visibility in relevant industry communities Thought Leadership: Position company experts as industry authorities Content Distribution: Maximize reach of marketing messages and insights Sales Professionals Pipeline Building: Share insights that attract potential clients Network Expansion: Engage with prospects across multiple professional groups Authority Building: Establish credibility through valuable content sharing Relationship Nurturing: Maintain visibility with existing connections Consultants & Freelancers Client Acquisition: Demonstrate expertise to potential clients Professional Branding: Build reputation across industry-specific groups Service Promotion: Share case studies and success stories broadly Network Building: Connect with peers and potential collaborators Business Leaders & Executives Industry Influence: Share strategic insights across professional networks Talent Attraction: Showcase company culture and opportunities Partnership Development: Connect with potential business partners Market Education: Share expertise to influence industry conversations 🔧 Advanced Customization Options Content Strategy Enhancement Multi-Tone Generation: Create different content styles for various audiences Industry Templates: Pre-built prompts for specific professional sectors Engagement Optimization: A/B testing different post formats and styles Content Calendar Integration: Schedule posts for optimal timing Distribution Intelligence Group Performance Tracking: Monitor engagement across different groups Selective Distribution: Choose specific groups based on content type Audience Segmentation: Tailor content for different professional communities Engagement Analysis: Track which groups provide best ROI Content Quality Control Approval Workflows: Add human review before automatic posting Content Scoring: Rate post quality before distribution Brand Compliance: Ensure posts meet company guidelines Duplicate Detection: Avoid posting similar content too frequently Extended Integration Options CRM Integration: Track leads generated from LinkedIn posts Analytics Platforms: Monitor engagement and conversion metrics Content Management: Connect to existing content planning tools Social Media Expansion: Extend to other professional platforms 📊 Content Generation Features AI Writing Capabilities The workflow generates LinkedIn posts that include: Professional Structure: Attention-grabbing opening statements Well-organized multi-paragraph content Clear value propositions and insights Strategic calls-to-action for engagement LinkedIn Optimization: Platform-specific formatting and spacing Proper hashtag research and placement Emoji usage that enhances readability Character count optimization for maximum impact Engagement Drivers: Thought-provoking questions to encourage comments Industry insights that spark discussions Personal anecdotes that build connections Actionable tips that provide immediate value Sample Output Input Topic: "Remote Work Productivity Tips" Generated Post: 🏠 Working from home has taught me that productivity isn't about being busy—it's about being intentional. After managing remote teams for 3 years, I've discovered that the most successful remote workers share three key habits that transform their daily performance. First, they create physical boundaries even in small spaces. A dedicated workspace signals to your brain that it's time to focus, even if it's just a corner of your kitchen table. Second, they batch similar tasks together. Instead of jumping between emails, calls, and deep work, they group activities to maintain mental flow and reduce cognitive switching costs. Third, they communicate proactively rather than reactively. They share progress updates before being asked and clarify expectations upfront to avoid confusion later. What's your most effective remote work strategy? I'd love to hear what's working for your team! 💪 #RemoteWork #Productivity #WorkFromHome #Leadership #TeamManagement #ProfessionalDevelopment 🛠️ Troubleshooting & Best Practices Common Issues & Solutions LinkedIn API Limitations Respect posting frequency limits to avoid account restrictions Monitor API usage and implement appropriate delays between posts Ensure compliance with LinkedIn's terms of service Maintain authentic engagement rather than purely automated interactions Group Posting Permissions Verify membership status and posting rights before adding group IDs Some groups require administrator approval for posts Monitor group rules and community guidelines Remove inactive or restricted groups from your list Content Quality Control Review AI-generated content periodically for brand consistency Adjust prompts based on engagement performance Maintain a balance between automation and personal touch Monitor comments and engage authentically with your audience Optimization Strategies Performance Enhancement Track engagement metrics across different groups A/B test posting times and content formats Refine prompts based on successful post patterns Gradually expand to new groups based on performance Content Strategy Develop content themes that resonate with your target audience Create series of related posts for deeper engagement Balance promotional content with value-driven insights Maintain consistency in voice and messaging Network Growth Engage with comments on your automated posts Connect with active commenters to expand your network Participate in group discussions beyond your own posts Build genuine relationships through authentic interactions 📈 Success Metrics Engagement Indicators Post Reach: Total views across profile and groups Interaction Rate: Comments, likes, and shares per post Network Growth: New connections from content engagement Group Performance: Which communities provide best engagement Business Impact Measurements Lead Generation: Connections and inquiries from LinkedIn posts Brand Awareness: Mentions and sharing of your content Thought Leadership: Recognition as industry expert Professional Opportunities: Speaking, collaboration, or job opportunities 📞 Questions & Support Need help setting up or optimizing your LinkedIn AI Agent workflow? 📧 Direct Technical Support Email: Yaron@nofluff.online Response Time: Within 24 hours on business days Expertise: LinkedIn API integration, AI prompt optimization, workflow scaling 🎥 Comprehensive Learning Resources YouTube Channel: https://www.youtube.com/@YaronBeen/videos Complete setup walkthrough and configuration Advanced customization techniques and strategies LinkedIn API best practices and limitations Content strategy optimization for maximum engagement Troubleshooting common integration issues 🤝 Professional Networking & Updates LinkedIn: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing automation support and advice Share your LinkedIn growth success stories Get early access to new workflow templates and features Join discussions about LinkedIn marketing automation 💬 Support Request Guidelines Include in your support message: Your current LinkedIn strategy and goals Target audience and industry focus Specific LinkedIn groups you want to target Any technical errors or integration issues Current content creation process and pain points

🧠 Email real time RAG Assistant with Gmail, OpenAI & PGVector 📌 Who’s it for This workflow is ideal for: Professionals Project managers Sales and support teams Anyone managing high volumes of Gmail messages It enables fast and intelligent search through your email inbox using natural language queries. ⚙️ How it works / What it does Continuously monitors your Gmail inbox for new emails. Extracts email content and metadata (subject, body, sender, date). Converts email content into vector embeddings using OpenAI. Stores embeddings in a PostgreSQL database with PGVector. A conversational AI agent performs semantic search on your stored email history. Supports time-sensitive and context-aware responses via OpenAI Chat model. 🚀 How to set up Connect your Gmail account to the Gmail Trigger node (with API access enabled). Configure OpenAI credentials for the Embedding and Chat nodes. Set up a PostgreSQL database with the PGVector extension enabled. Import the workflow into your n8n instance (Cloud or Self-hosted). Customize parameters like polling frequency, embedding settings, or vector query depth. 📋 Requirements ✅ n8n instance (Self-hosted or Cloud) ✅ Gmail account with API access ✅ OpenAI API Key ✅ PostgreSQL database with PGVector extension installed 🛠️ How to customize the workflow Email Filtering**: Change filters in the Gmail Trigger to watch specific labels or senders. Text Splitting Granularity**: Adjust chunkSize and chunkOverlap in the text splitter node. Query Depth**: Modify topK in the vector search node to retrieve more or fewer similar results. Prompt Tuning**: Customize the system message or agent instructions in the RAG node. Workflow Extensions**: Add notifications, error logging, Slack/Telegram alerts, or data exports.

💼 LinkedIn Content Machine – AI-Powered Post Generator & Scheduler for X and LinkedIn How it works: This end-to-end workflow automates your personal or brand content strategy by: 🧠 Using Google Gemini or OpenAI to generate engaging LinkedIn/X content from a title or trending posts. 🗓️ Posting directly to LinkedIn and X (formerly Twitter). 📊 Pulling high-performing LinkedIn posts to inspire new ideas. ✍️ Saving AI-generated drafts to Google Sheets for review. 🔔 Notifying your team on Slack when drafts are ready. Steps to set up: Add your API keys for Google Gemini or OpenAI. Set up your LinkedIn, X (Twitter), Google Sheets, and Slack credentials. Customize prompt logic or post filters if needed. Schedule the idea generation module or trigger it manually. Start generating and posting consistent, high-quality content with zero manual effort!

Overview This workflow automates the process of sending personalized cold email sequences to your prospects. It fetches un-emailed leads from your Google Sheet, validates their email addresses, and then dispatches tailored emails according to a predefined schedule. It updates your CRM (Google Sheet) with the status of each sent email, ensuring your outreach efforts are tracked and efficient. Use Case This workflow is perfect for: Sales Teams**: Automate the delivery of multi-stage cold email campaigns to a large volume of leads. Business Development**: Nurture prospects over time with a structured email sequence. Recruiters**: Send out introductory emails to potential candidates for open positions. Marketers**: Distribute personalized outreach for events, content, or product launches. Anyone doing cold outreach**: Ensure consistent follow-up and track email performance without manual effort. How It Works Scheduled Trigger: The workflow is set to run automatically at a defined interval (e.g., every 6 hours, as currently configured by the "Set Timer" node). This ensures regular outreach without manual intervention. Fetch Unsent Emails: The "Get Emails" node queries your Google Sheet to identify prospects who haven't yet received the current email in the sequence (i.e., "Email Sent " is "No"). Control Volume: A "Limit" node can be used to control the number of emails sent in each batch, preventing you from sending too many emails at once and potentially hitting sending limits. Loop Through Prospects: The "Loop Over Items" node processes each selected prospect individually. Email Validation (Conditional Send): An "If" node checks if the prospect's "Email Address" is valid and exists. This prevents sending emails to invalid addresses, improving deliverability. Send Email: "Send Email" Node: For valid email addresses, this node dispatches the personalized email to the prospect. It retrieves the recipient's email, subject, and body from your Google Sheet. "connect" Node: (Note: The provided JSON uses a generic emailSend node named "connect" that links to an SMTP credential. This represents the actual email sending mechanism, whether it's Gmail or a custom SMTP server.) Update CRM: After successfully sending an email, the "Update Records" node updates your Google Sheet. It marks the "Email Sent " column as "Yes" and records the "Sent on" timestamp and a "Message Id" for tracking. Delay Between Sends: A "Wait" node introduces a delay between sending emails to individual prospects. This helps mimic human sending behavior and can improve deliverability. How to Set It Up To set up your Automated Cold Email Sender, follow these steps: Google Sheet Setup: Duplicate the Provided Template: Make a copy of the Google Sheet Template (1TjXelyGPg5G8lbPDI9_XOReTzmU1o52z2R3v8dYaoQM) into your own Google Drive. This sheet should contain columns for "Name", "Email Address ", "Sender Email", "Email Subject", "Email Body", "Email Sent ", "Sent on", and "Message Id". Connect Google Sheets: Ensure your Google Sheets OAuth2 API credentials are set up in n8n and linked to the "Get Emails" and "Update Records" nodes. Update Sheet IDs: In both "Get Emails" and "Update Records" nodes, update the documentId with the ID of your copied template. Email Sending Service Credentials: Gmail: If using Gmail, ensure your Gmail OAuth2 credentials are configured and connected to the "Send Email" node (or the "connect" node, if that's your chosen sender). Other Email Services (SMTP): If you use a different email service, you'll need to set up an SMTP credential in n8n and connect it to the "connect" node. Refer to the "Sticky Note4" for guidance on non-Google email services. Configure Timer: In the "Set Timer" node, adjust the hoursInterval or other time settings to define how frequently you want the email sending process to run (e.g., every 6 hours, once a day, etc.). Control Volume (Optional): In the "Limit" node, you can set the maxItems to control how many emails are processed and sent in each batch. This is useful for managing email sending limits or gradual outreach. Import the Workflow: Import the provided workflow JSON into your n8n instance. Populate Your Sheet: Fill your copied Google Sheet with prospect data, including the email subject and body for each email you wish to send. Ensure the "Email Sent " column is initially "No". Activate and Monitor: Activate the workflow. It will begin fetching and sending emails based on your configured schedule. Monitor your Google Sheet to track the "Email Sent " status. This workflow provides a robust and automated solution for managing your cold email campaigns, saving you time and increasing your outreach efficiency.

How it works Automatic Detection: Instantly identifies abandoned carts via webhook from your e-commerce store. Progressive Sequence: Automatically sends 3 recovery emails over 7 days with increasing incentives. Dynamic Personalization: Inserts abandoned products, customer name, and unique promo codes. Performance Tracking: Analyzes conversion rates and recovered revenue. Set up steps Configure the webhook: Connect your e-commerce platform (Shopify, WooCommerce, Magento) to trigger the workflow when a cart is abandoned. Email service: Set up your email sending service (Gmail, SendGrid, Mailgun) with proper credentials. Customization: Adapt email templates with your brand guidelines, logo, and tone of voice. Promo codes: Integrate your discount code system (10%, 15%, 20%). Analytics tracking: Connect a Google Sheet to track recovery performance. Testing: Validate the workflow with test data before activation. Key Features 🎯 Smart targeting: Automatically filters qualified carts (minimum value, valid email) ⏰ Optimized timing: Scientifically timed sequence (1h, 24h, 72h) to maximize conversions 💰 Progressive incentives: Increasing discounts (10% → 15% → 20%) to create urgency 📱 Responsive design: Email templates optimized for all devices 🔄 Unique codes: Automatically generates personalized promo codes for each customer 📊 Built-in analytics: Real-time tracking of open rates, clicks, and conversions 🛡️ Error handling: Robust system with notifications in case of technical issues 🎨 Professional templates: Modern email designs with optimized call-to-actions Advanced Features Customer segmentation**: Differentiates between new and returning customers Automatic exclusions**: Avoids sending to customers who already purchased Multi-language**: Supports different languages based on location A/B Testing**: Tests different email versions to optimize performance CRM integration**: Syncs data with your customer management system Metrics Tracked Recovery rate per email in the sequence Real-time recovered revenue Open and click-through rates for each email Promo codes used and their effectiveness Average delay between abandonment and conversion Customization Options Flexible timing**: Adjust sending delays to fit your industry Variable incentives**: Change discount percentages as needed Dynamic content**: Adjust messages based on product types Configurable thresholds**: Set your own qualification criteria Full branding**: Integrate your complete visual identity > This workflow automatically turns abandoned carts into sales opportunities with a scientific and personalized approach, generating measurable ROI for your e-commerce.