Enrich Linkedin profiles from Google Sheets via RapidAPI
LinkedIn Profile Enrichment Workflow Who is this for? This workflow is ideal for recruiters, sales professionals, and marketing teams who need to enrich LinkedIn profiles with additional data for lead generation, talent sourcing, or market research. What problem is this workflow solving? Manually gathering detailed LinkedIn profile information can be time-consuming and prone to errors. This workflow automates the process of enriching profile data from LinkedIn, saving time and ensuring accuracy. What this workflow does Input: Reads LinkedIn profile URLs from a Google Sheet. Validation: Filters out already enriched profiles to avoid redundant processing. Data Enrichment: Uses RapidAPI's Fresh LinkedIn Profile Data API to retrieve detailed profile information. Output: Updates the Google Sheet with enriched profile data, appending new information efficiently. Setup Google Sheet: Create a sheet with a column named linkedin_url and populate it with the profile URLs to enrich. RapidAPI Account: Sign up at RapidAPI and subscribe to the Real-Time Data Enrichment API. API Integration: Replace the x-rapidapi-key and x-rapidapi-host values with your credentials from RapidAPI. Run the Workflow: Trigger the workflow and monitor the updates to your Google Sheet. How to customize this workflow Filter Criteria: Modify the filter step to include additional conditions for processing profiles. API Configuration: Adjust API parameters to retrieve specific fields or extend usage. Output Format: Customize how the enriched data is appended to the Google Sheet (e.g., format, column mappings). Error Handling: Add steps to handle API rate limits or missing data for smoother automation. This workflow streamlines LinkedIn profile enrichment, making it faster and more effective for data-driven decision-making.
By PollupAIAutomated cold email campaign with Google Sheets, email verification & SMTP
Use this template if you’re collecting leads in Google Sheets manually or automatically and need to send them emails daily using any personal or professional email provider. It’s simple yet effective. I’ve kept it easy so that anyone without technical or coding knowledge can still automate their emails and achieve excellent ROI. Setting up the workflow takes only 15 minutes. How it works: We connect Google Sheets with n8n to automatically fetch lead data. Google Sheets is used because it’s easy and widely accessible. Then, n8n sends emails daily at your scheduled times to the respective email addresses, using the subject lines and body text you've configured. It also verifies emails before sending. It checks email availability, deliverability, and updates the Google Sheet/CRM with the respective fields. Requirements: A Google Sheet/Excel/CRM tools with leads (A sample Google Sheet link is provided in the template) A working email account with SMTP information (SMTP info for the top 10 email providers is provided in the template) API key from any email verification tool (We use the Hunter API key in our use case. You can find the link in the template.) Setup Steps: You need a Google Sheet where you're collecting leads. You can replace Google Sheets with your CRM tool. Connect it using your credentials. Replace the manual trigger with a scheduled trigger to automate emails at your preferred time. Replace the email verification tool/Hunter API with your own API key. Add your SMTP credentials to connect the template with your preferred email provider. Using SMTP, you can send emails through Gmail, Outlook, Zoho, or any similar provider. This makes sending emails simple and cost-efficient. Note: SMTP, which stands for Simple Mail Transfer Protocol, is a communication protocol used to send email messages between mail servers. After sending the email, we update the Google Sheet with “Sent”; hence, the email is not sent again the next day.
By Janak PatelGenerate YouTube SEO content & thumbnail from video scripts with GPT-4o & Runway
Who’s it for This template is ideal for YouTube video creators who spend a lot of time manually generating SEO assets like descriptions, tags, titles, keywords, and thumbnails. If you're looking to automate your YouTube SEO workflow, this is the perfect solution for you. How it works / What it does Connect a Google Sheet to n8n and pull in the Hindi script (or any language). Use OpenAI to generate SEO content: Video description Tags Keywords Titles Thumbnail titles etc. Use the generated description as input to create a thumbnail image using an image generation API. Store all outputs in the same Google Sheet in separate columns. Optionally, use tools like VidIQ or TubeBuddy to test the SEO strength of generated titles, tags, and keywords. 💡 Note: This example uses Runway’s image generation API, but you can plug in any other image-generation service of your choice. Requirements A Google Sheet with clearly named columns Hindi, English, or other language scripts in the sheet OpenAI API key Runway API key (or any other image generation API) How to set up You can set up this workflow in 15 minutes by following the pre-defined steps. Replace the manual Google Sheet trigger with a scheduled trigger for daily or timed automation. You may also swap Google Sheets with any database or data source of your choice. No Google Sheets API required. Requires minimal JavaScript or Python knowledge for advanced customizations.
By Janak PatelGenerate personalized weather reports with OpenWeatherMap, Python and GPT-4.1-mini
How it works User enters name of a city for which most current weather information will be gathered Custom Python code processes the weather data and generates a custom email about the weather AI agent further customizes the email and add a related joke about the weather Recipient gets the custom email for the city Set up instructions Enter city to get the weather data Add OpenWeather API and replace <yourAPIkey> with your actual API key Add your OpenAI API in OpenAI Chat Model Node Add your Gmail credentials and specify a recipient for the custom email
By Moe AhadAutomate email triage with GPT-4.1-mini classification and Gmail auto-replies
How it works: Detects new unread Gmail messages Extracts sender name for personalized replies Classifies the email into one of four categories Applies the correct Gmail label and either sends an auto-reply, creates a draft, or logs the contact in Google Sheets Setup steps: Takes about 5–10 minutes to connect accounts and set labels Connect Gmail, OpenAI, and optional Google Sheets in n8n Add label IDs, Google Sheet ID, sheet name, and phone number in Set – Config Create four Gmail labels for the categories Keep full setup instructions in the sticky notes inside the workflow
By Giovanni BeggiatoSmart Gmail inbox management with Gemini: Auto-label and draft replies
Keep your Gmail inbox organized and stress-free with this AI-powered workflow. Ideal for freelancers, small business owners, and productivity enthusiasts who receive a high volume of mixed emails. This template automatically sorts messages into predefined labels and drafts a professional reply when follow-up is needed. How it works Gmail Trigger starts the workflow whenever a new email arrives. AI Classifier (Gemini or compatible model) analyzes the message, checks your previous conversations and sent emails, and assigns the correct Gmail label. Smart rules ensure irrelevant messages are deleted or archived, while actionable ones are prepared for a response. AI Draft Node creates a concise, friendly, and professional draft reply — stored safely in your Gmail drafts folder (never auto-sent). Optional tools like CheckCalendar can suggest time slots for meetings automatically. Together, these steps make your inbox work for you: sorting, prioritizing, and drafting responses. Set up steps Connect your Gmail account and ensure your label categories already exist. Connect your Gemini (or other AI) credentials. (Optional) Enable CheckCalendar for scheduling suggestions. Adjust the labeling rules and prompt text to match your personal or business workflow. Requirements Gemini account for LLM Google OAuth2 credentials
By SalvadorAutomated Competitor Intelligence: CrunchBase to ClickUp Tracking Workflow
🚀 Automated Competitor Intelligence: CrunchBase to ClickUp Tracking Workflow! Workflow Overview This cutting-edge n8n automation is a sophisticated competitive intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, ClickUp, and intelligent data processing, this workflow: Discovers Competitor Insights: Automatically retrieves company data Tracks real-time business updates Eliminates manual research efforts Intelligent Data Processing: Converts company names to API-compatible formats Fetches comprehensive company information Ensures precise data retrieval Automated Task Management: Creates instant review tasks in ClickUp Distributes competitive intelligence Enables rapid team response Seamless Workflow Integration: Cross-platform data synchronization Reduces manual intervention Provides structured competitive insights Key Benefits 🤖 Full Automation: Zero-touch competitive tracking 💡 Smart Data Processing: Intelligent insight generation 📊 Comprehensive Intelligence: Detailed company information 🌐 Multi-Platform Synchronization: Seamless data flow Workflow Architecture 🔹 Stage 1: Competitor Identification Manual Trigger: Workflow initiation Competitor Name Setting Slug Generation: Converts names to API-compatible formats Ensures precise data matching 🔹 Stage 2: Data Retrieval CrunchBase API Integration Comprehensive Company Lookup Real-Time Information Gathering 🔹 Stage 3: Insight Distribution ClickUp Task Creation Structured Information Sharing Team Notification Mechanism Potential Use Cases Strategic Planning: Competitive landscape monitoring Sales Teams: Market intelligence gathering Product Managers: Tracking industry innovations Investors: Investment opportunity research Marketing Departments: Competitive analysis Setup Requirements CrunchBase API API credentials Configured access permissions Company tracking setup ClickUp Workspace Connected ClickUp account Task management configuration Team collaboration settings n8n Installation Cloud or self-hosted instance Workflow configuration API credential management Future Enhancement Suggestions 🤖 Multi-competitor tracking 📊 Advanced trend analysis 🔔 Customizable alert mechanisms 🌐 Expanded data source integration 🧠 Machine learning insights generation Technical Considerations Implement robust error handling Use secure API authentication Maintain flexible data processing Ensure compliance with API usage guidelines Ethical Guidelines Respect business privacy Use data for legitimate research Maintain transparent information gathering Provide proper attribution Hashtag Performance Boost 🚀 CompetitiveIntelligence MarketResearch BusinessTracking AIWorkflow DataAutomation TechInnovation StrategicPlanning BusinessIntelligence MarketInsights APIAutomation Workflow Visualization plaintext [Manual Trigger] ⬇️ [Set Competitor Name] ⬇️ [Generate Crunchbase Slug] ⬇️ [Fetch Crunchbase Data] ⬇️ [Create ClickUp Task] Connect With Me Ready to revolutionize your competitive intelligence? 📧 Email: Yaron@nofluff.online 🎥 YouTube: @YaronBeen 💼 LinkedIn: Yaron Been Transform your competitive research with intelligent, automated workflows!
By Yaron BeenGenerate branded word documents with Claude AI and Json2Doc (up to 20 pages)
Overview This n8n workflow automatically generates professionally formatted Word documents (DOCX) with consistent company branding using AI. It leverages Json2Doc and the Json2Doc MCP server to transform simple text prompts into complete, multi-page documents. Get your free API key at: app.json2doc.com Use Cases Generate first drafts of: Contracts and legal agreements Internal forms and templates Company announcements and notices Internal documentation and policies Business reports and presentations Guidelines and procedures and much more ... Key Features Consistent Company Branding Custom fonts, colors, and typography Company logo in headers Page numbers in footers Controlled spacing and layout Professional heading styles Multi-Page Document Support Page-based sections (new page) Flow sections (continuous across pages) Automatic pagination Consistent headers and footers throughout Rich Content Types Multiple heading levels Formatted text and paragraphs Tables with custom styling Ordered and unordered lists Images and logos Auto Generated QR Codes AI-Driven Generation Uses Claude Sonnet 4.5 to: Generate appropriate document structure Apply correct formatting Create professional, coherent content How It Works Input Form Users provide: Prompt - Description of the desired document (e.g., "Generate an employment contract template") Logo URL - Web-accessible URL to company logo Company Styling Pre-configured branding is applied (See workflow for Description on how to Update): Font, font Styles (for H1,H2, ...) Header: Company name + logo Footer: Page numbers ("Page X of Y") Spacing rules for all content types Table Styles AI Document Generation The AI agent: Retrieves the Json2Doc section schema Generates JSON configuration for the document Validates the configuration Creates a document generation job Returns the Job ID Processing & Download Waits for document completion (3 seconds initially) Polls job status via API Retries if not complete Downloads the final DOCX file when ready Setup Requirements Authentication You need a Json2Doc API key from app.json2doc.com (Permanently free version available). Processing Times Configuration Generation (Model-dependent) The AI model generates the JSON configuration: Simple documents (1-2 pages): 10-30 seconds Medium documents (3-5 pages): 30-60 seconds Complex documents (10-20 pages): 60-120 seconds Time varies based on the selected AI model and document complexity. Json2Doc Processing Once the configuration is created, Json2Doc generates the DOCX file in 2-6 seconds regardless of document size. Extensions This workflow can be integrated with: Cloud storage (Google Drive, Dropbox) Email services for automated delivery Approval workflows Document management systems Important Limitation This workflow is only suitable for documents up to 20 pages, as larger documents will exceed the AI model's context window. For longer documents, use the Builder Mode instead: DocumentBuilder Docs
By 8AutomatorExtract PDF itineraries to Google Sheets with GPT-4.1-Mini & Gmail notifications
Extract PDF Itineraries to Google Sheets with GPT-4.1-Mini & Gmail Notifications Overview Automates PDF data extraction using OpenAI GPT, saves to Google Sheets, sends email confirmations. Reduces manual entry by 90%. How It Works Receives PDF uploads via form Splits & loops through files AI extracts structured data Appends to Sheets with timestamps Sends confirmation email Prerequisites OpenAI API key (platform.openai.com) Google Workspace (Sheets & Gmail) n8n v1.0.0+ Setup Add OpenAI API key to n8n credentials Create Google Sheet with extraction columns, authorize OAuth2 Configure Gmail OAuth2 Import workflow JSON Edit AI prompt for your fields Activate & share form URL Customization Modify extraction prompts Adjust Sheets mapping Customize email templates Add error handling/validation Extend to Word/Excel files Use Cases Invoices, expense reports, resumes, contracts, forms, legal docs
By Cheng Siong ChinAutomated inventory management with Airtable PO creation & supplier emails
In-depth description of this automation: This is a fully automated daily supply chain and procurement workflow that keeps product stock levels healthy and suppliers updated, by automatically generating and emailing purchase orders (POs) and syncing PO statuses in Airtable. --- 📅 Daily triggers Two Schedule Trigger nodes run: One runs at midnight (00:00) to manage low stock and new purchase order creation. Another runs at 1:00 AM to process existing pending POs and email suppliers. --- 🚦 Step-by-step breakdown 1️⃣ Get Products with low stock Searches the “Products Table” in Airtable for items where {stocklevel} <= {reorderthreshold}. Detects products that need restocking. 2️⃣ Get supplier details Fetches supplier data for each low-stock product using its supplier_id. 3️⃣ Calculate Dynamic Reorder Quantity JS code calculates an optimal reorder quantity: Uses averagedailysales × (leadtime × 1.5) × safetymargin (1.2) Adds extra buffer so the new order covers both immediate demand and next cycle. 4️⃣ Search existing POs Looks in the “Purchase Orders” table for active POs (status Pending or Sent) matching each product. Prevents duplicate orders. 5️⃣ Remove duplicate product orders JS node compares current low-stock products with existing POs. Filters out products already covered, so new POs are only created for truly uncovered products. 6️⃣ Create new purchase orders For filtered products, creates new PO records in Airtable with: product_name product_id calculated reorder_qty supplier info and email initial status Pending --- 📧 Process existing pending purchase orders and email suppliers 7️⃣ Get Purchase Orders which are pending Searches Airtable for all POs with status Pending. 8️⃣ Group products with suppliers JS code groups these POs by supplier_id. Builds a summary (total products, total quantity) and an HTML email with a styled table of items. 9️⃣ Send PO emails to suppliers Uses Brevo (SendInBlue) to send emails. Subject and content include supplier-specific order details. 🔄 Update PO statuses to Sent Extracts Airtable record IDs of the sent POs. Updates those POs in Airtable, changing status from Pending → Sent. --- 📌 Summary ✅ Runs every day ✅ Dynamically calculates reorder needs ✅ Avoids duplicate purchase orders ✅ Automatically creates purchase orders in Airtable ✅ Groups & emails daily PO summaries to suppliers ✅ Updates PO status after sending email --- ⚙ Tables involved Products Table: stores products, stock levels, reorder thresholds, average daily sales, supplier references. Suppliers Table: stores supplier emails and metadata. Purchase Orders Table: tracks product orders with supplier IDs, status, quantities, etc. --- This workflow makes daily procurement fully automated: detects risk of stockouts, creates POs smartly, keeps suppliers in sync by email, and updates order statuses in one closed loop — perfect for any small or mid-sized business using Airtable + N8N.
By iamvaarComplete Google Tasks management: Create, update & delete tasks automatically
Comprehensive workflow template for managing Google Tasks through n8n automation. Provides full CRUD operations (Create, Read, Update, Delete) for seamless task management integration. 🚀 Features Create Tasks - Add new tasks programmatically Retrieve Tasks - Get individual or multiple tasks with filtering Update Tasks - Modify existing task details and status Delete Tasks - Remove completed or obsolete tasks Batch Operations - Handle multiple tasks efficiently 💼 Perfect For Project Management - Automate task creation from project milestones Email Integration - Convert emails to actionable tasks CRM Workflows - Create follow-up tasks from customer interactions Content Planning - Generate tasks from editorial calendars Team Collaboration - Sync tasks across different platforms 🔧 What's Included Pre-configured Google Tasks API nodes Error handling and validation Flexible task filtering and sorting Status management (pending/completed) Batch processing capabilities ⚡ Quick Start Connect your Google Tasks account Configure task list preferences Test individual operations Deploy and automate! Transform your productivity workflow with automated task management.
By Jitesh DugarLinkedIn scraping, structuring, and messaging using PhantomBuster and GPT-4
Description This template automates the end-to-end process of extracting professional data from LinkedIn and converting it into a usable format—ideal for recruiters, SDRs, marketers, and growth teams. With a few simple configurations, you’ll be able to trigger the flow, scrape profiles, and use AI to extract name, headline, company, role, industry, and more—without writing a single line of code. Key Features 🔗 Launch PhantomBuster Agent using a profile URL ⏳ Wait 45 seconds for PhantomBuster to complete scraping 📥 Fetch and parse scraped data (download URL to JSON) 🤖 Use GPT-4 (OpenAI/Azure) to extract structured information 📄 Output fields: Name, Headline, Company, Job Title, Industry, Experience, etc. 🧰 Optional: Personalize messages using extracted data 📊 Send structured output to Google Sheets, Airtable, or CRM Setup Instructions PhantomBuster Configuration Sign up for PhantomBuster Use the LinkedIn Profile Scraper Phantom Obtain your API Key and Agent ID Provide a valid LinkedIn session cookie (from browser dev tools) OpenAI or Azure Setup Add your GPT-4 or GPT-4o API credentials Can be from either OpenAI or Azure OpenAI Google Sheet (Optional) Add a sheet with LinkedIn profile URLs to process in batch mode Environment Cleanup This version uses n8n credentials manager All hardcoded tokens and API keys are removed for security compliance Customization Tips You can adjust the wait duration depending on PhantomBuster execution time Replace or extend the AI parsing prompt to include more fields (e.g., education, location, skills) Add additional automations: Slack notifications, CRM sync, or enrichment tools like Clearbit or Hunter.io Perfect For 🚀 Growth hackers and SDRs automating lead generation 🧠 Recruiters scraping profiles for outreach 📊 Marketing teams enriching data for campaigns 🛠️ SaaS builders building LinkedIn intelligence tools
By Rahul Joshi