Franz
Workflows by Franz
Lead generation and qualification with GPT-4o, Google Workspace, and automated follow-up
# 🚀 AI Lead Generation and Follow-Up Template ## 📋 Overview This n8n workflow template automates your lead generation and follow-up process using AI. It captures leads through a form, enriches them with company data, classifies them into different categories, and sends appropriate follow-up sequences automatically. ### Key Features: - 🤖 AI-powered lead classification (Demo-ready, Nurture, Drop) - 📊 Automatic lead enrichment with company data - 📧 Intelligent email responses and follow-up sequences - 📅 Automated demo scheduling for qualified leads - 📝 Complete lead logging in Google Sheets - 💬 AI assistant for immediate query responses ## 🛠️ Prerequisites Before setting up this workflow, ensure you have: 1. **n8n Instance**: Self-hosted or cloud version 2. **OpenAI API Key**: For AI-powered features 3. **Google Workspace Account** with: - Gmail access - Google Sheets - Google Calendar 4. **Basic understanding** of your Ideal Customer Profile (ICP) ## ⚡ Quick Start Guide ### Step 1: Import the Workflow 1. Copy the workflow JSON 2. Import into your n8n instance 3. The workflow will appear with all nodes connected ### Step 2: Configure Credentials You'll need to set up the following credentials: - **OpenAI API**: For AI agents and classification - **Gmail OAuth2**: For sending emails - **Google Sheets OAuth2**: For lead logging - **Google Calendar OAuth2**: For demo scheduling ### Step 3: Create Your Lead Log Sheet Create a Google Sheet with these columns: - Date - Name - Email - Company - Job Title - Message - Number of Employees - Industry - Geography - Annual Revenue - Technology - Pain Points - Lead Classification ### Step 4: Update Configuration Nodes 1. **Replace Sheet ID**: Update all Google Sheets nodes with your sheet ID 2. **Update Email Templates**: Customize all email content 3. **Set Escalation Email**: Replace "[email protected]" with your team's email 4. **Configure ICP Criteria**: Edit the "Define ICP and Lead Criteria" node ## 🎯 Lead Classification Setup ### Define Your ICP (Ideal Customer Profile) Edit the "Define ICP and Lead Criteria" node to set your criteria: #### 📌 ICP Criteria Example: ``` - Company Size: 50+ employees - Industry: SaaS, Finance, Healthcare, Manufacturing - Geography: North America, Europe - Pain Points: Manual processes, compliance needs, scaling challenges - Annual Revenue: $5M+ ``` #### ✅ Demo-Ready Criteria: High-intent prospects who meet multiple qualifying factors: - Large company size (your threshold) - Clear pain points mentioned - Urgent timeline - Budget authority indicated - Specific solution requests #### 🌱 Nurture Criteria: Prospects with future potential: - Meet basic size requirements - In target industry - General interest expressed - Planning future implementation - Exploring options #### ❌ Drop Criteria: Only drop leads that clearly don't fit: - Outside target geography - Wrong industry (B2C if you're B2B) - Too small with no growth - Already with competitor - Spam or test messages ## 📧 Email Customization ### Customize Follow-Up Sequences: #### Demo-Ready Sequence: 1. Immediate calendar invitation 2. Personalized demo confirmation 3. Meeting reminder (optional) #### Nurture Sequence: 1. Welcome email with resources 2. Educational content (Day 2) 3. Webinar/event invitation (Day 3) 4. Demo offer (Day 4) #### Drop Message: - Polite acknowledgment - Clear explanation - Keep door open for future ## 🔧 Advanced Configuration ### AI Answer Agent Setup: 1. Update the system prompt with your company information 2. Add common Q&A patterns 3. Set escalation rules 4. Configure language preferences ### Lead Enrichment Options: - Add API keys for additional data sources - Configure enrichment fields - Set data quality thresholds - Enable duplicate detection ### Calendar Integration: - Set available meeting times - Configure meeting duration - Add buffer times - Set timezone handling ## 📊 Monitoring and Optimization ### Track Key Metrics: - Lead volume by classification - Response rates - Demo conversion rates - Time to first response - Enrichment success rate ### Optimization Tips: 1. **Regular Review**: Check classification accuracy weekly 2. **A/B Testing**: Test different email sequences 3. **Feedback Loop**: Use outcomes to refine ICP criteria 4. **AI Training**: Update prompts based on results ## 🎉 Best Practices 1. **Start Simple**: Begin with basic criteria and refine over time 2. **Test Thoroughly**: Use test leads before going live 3. **Monitor Daily**: Check logs for the first week 4. **Iterate Quickly**: Adjust based on results 5. **Document Changes**: Keep track of criteria updates ## 📈 Scaling Your Workflow As your lead volume grows: 1. **Add Sub-workflows**: Separate complex processes 2. **Implement Queuing**: Handle high volumes 3. **Add CRM Integration**: Sync with your sales tools 4. **Enable Analytics**: Track detailed metrics 5. **Set Up Alerts**: Monitor for issues
Monitor dynamic website changes with Firecrawl, Sheets & Gmail alerts
# 🕸️ Dynamic Website Change Monitor with Smart Email Alerts Never miss important website updates again! This workflow automatically tracks changes on dynamic websites (think React apps, JavaScript-heavy sites) and sends you instant email notifications when something changes. Perfect for keeping tabs on competitors, monitoring product updates, or staying on top of important announcements. ## ✨ What makes this special? 🚀 **Handles Dynamic Websites**: Uses Firecrawl API to scrape JavaScript-rendered content that basic scrapers can't touch 📧 **Smart Email Alerts**: Only sends notifications when content actually changes (no spam!) 📊 **Historical Tracking**: Keeps a complete log of all changes in Google Sheets 🛡️ **Bulletproof**: Continues working even if one part fails ⚡ **Ready to Deploy**: Webhook-triggered, perfect for cron jobs or external schedulers ## 🎯 Perfect for monitoring: - Competitor pricing pages - Job board postings - Product availability updates - News sites for breaking stories - API documentation changes - Terms of service updates ## 🛠️ What you'll need to get started: ### API Accounts & Keys: 1. **Firecrawl Account** 🔥 - Sign up at [firecrawl.dev](https://firecrawl.dev) - Grab your API key from the dashboard - Create a "Bearer Auth" credential in n8n 2. **Google Cloud Setup** ☁️ - Enable Google Sheets API - Enable Gmail API - Set up OAuth2 credentials - Add both as credentials in n8n 3. **Google Sheets Document** 📋 - Create a new spreadsheet - Add two tabs: "Log" and "comparison" - Follow the structure outlined in the workflow notes ## 🚀 How it works: 1. **Webhook receives trigger** → Starts the monitoring process 2. **Firecrawl scrapes website** → Gets fresh content (even JavaScript-rendered!) 3. **Smart comparison** → Checks against previously stored content 4. **Change detected?** → If yes, send email + log everything 5. **Update storage** → Prepares for next monitoring cycle ## ⚙️ Setup Steps: 1. **Import this workflow** into your n8n instance 2. **Configure credentials** for Firecrawl, Google Sheets, and Gmail 3. **Update the target URL** in the Firecrawl node 4. **Set your email address** in the Gmail node 5. **Create your Google Sheets** with the required structure 6. **Test it manually** first, then activate! ## 🎨 Customize it your way: - **Target any website** by updating the URL - **Change email templates** to match your style - **Adjust monitoring frequency** with external cron jobs - **Switch between markdown/HTML** extraction formats - **Fine-tune change detection** sensitivity ## 🔧 Troubleshooting: - **Firecrawl errors?** Check your API key and rate limits - **Google Sheets issues?** Verify OAuth permissions and sheet structure - **Email not sending?** Check Gmail API quotas and spam folders - **Webhook problems?** Make sure the workflow is activated Ready to never miss another website change? Let's get this automation running! 🎉
Sentiment analytics visualizer
# 🧠 **Sentiment Analyzer** Google Sheets → OpenAI GPT-4o → QuickChart → Gmail --- ## 🚀 What this workflow does 1. **Fetches customer reviews** from a Google Sheet. 2. **Classifies each review** as **Positive**, **Neutral** or **Negative** with GPT-4o-mini. 3. **Writes the sentiment** back to your sheet. 4. **Builds a doughnut chart** summarising the totals. 5. **Emails the chart** to your chosen recipient so the whole team stays in the loop. Perfect for support teams, product managers or anyone who wants a zero-code mood ring for their users’ feedback. --- ## 🗺️ Node-by-node tour | 🔩 Node | 💡 Purpose | | ------------------------------------------------------- | ---------------------------------------------------------- | | **Manual Trigger** | Lets you test the workflow on demand. | | **Select Google Sheet** | Points to the spreadsheet that holds your reviews. | | **Loop Over Items** | Feeds each row through the analysis routine. | | **Sentiment Analysis (LangChain)** | Calls GPT-4o-mini and returns only the sentiment category. | | **Update Google Sheet** | Writes the new **Sentiment** value into column C. | | **Read Data from Google Sheet** | Pulls the full sheet again to create a summary. | | **Extract Number of Answers per Sentiment (Code node)** | Tallies up how many reviews fall into each category. | | **Generate QuickChart** | Creates a doughnut (or pie) chart as a PNG. | | **Send Gmail with Sentiment Chart** | Fires the chart off to your inbox. | | *(Sticky Notes)* | Friendly setup tips scattered around the canvas. | --- ## 🛠️ Setup checklist | ✅ Step | Where | | ------------------------------------------------------------------------------------- | -------------------------------- | | **Connect Google Sheets** → paste your **Spreadsheet ID** & choose the correct sheet. | All Google Sheets nodes | | **Add OpenAI credentials** (sk-… key). | Sentiment Analysis node | | **Configure Gmail OAuth2 + recipient address.** | Gmail node | | **Match your sheet columns** → “Review title”, “Review text”, empty “Sentiment”. | Google Sheet itself | | *(Optional)* Switch to **gpt-4o** for maximum accuracy. | Sentiment Analysis “Model” param | --- ## 🏃♂️ How to run 1. Drop a few sample reviews into the sheet. 2. Click **“Test workflow”** on the Manual Trigger. 3. Watch each row march through → sentiment appears in column C. 4. After all rows finish, check your inbox for a fresh chart. ✔️ --- ## ✨ Ideas for next level * **Schedule** the trigger (Cron) to auto-process new reviews daily. * Feed the counts to **Slack** or **Discord** instead of email. * Add a second GPT call to generate a short summary for each review. --- Happy automating! 🎉
Build custom workflows automatically with GPT-4o, RAG, and web search
## 🚀 What the “Agent Builder” template does Need to **turn a one-line chat request into a fully-wired n8n workflow template—complete with AI agents, RAG, and web-search super-powers—without lifting a finger?** That’s exactly what *Agent Builder* automates: 1. **Listens to any incoming chat message** (via the *Chat Trigger*). 2. **Spins up an AI architect** that analyses the request, searches the web, reads n8n docs from a Pinecone vector store, and designs the smallest possible set of nodes. 3. **Auto-generates a ready-to-import JSON template** and hands it back as a downloadable file—plus all the supporting assets (embeddings, vector store etc.) so the next prompt is even smarter. Think of it as your personal “workflow chef”: you shout the order, it shops for ingredients, cooks, plates, and serves the meal. All you do is eat. --- ## 🤗 Who will love this? * **No-code builders / power users** who don’t want to wrestle with AI node wiring. * **Agencies & consultants** delivering lots of bespoke automations. * **Internal platform teams** who need a “workflow self-service portal” for non-technical colleagues. --- ## 🧩 How it’s wired | Sub-process | What happens inside | Key nodes | | -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | -------------------------------------------------------------------------------------- | | **Web Crawler** (optional) | Firecrawl scrapes docs.n8n.io (or any URL you drop in) and streams raw markdown back. | `Set URL → HTTP Request (Extract) → Wait & Retry` | | **RAG Trainer** | Splits the scraped docs, embeds them with OpenAI, and upserts vectors into Pinecone. | `Recursive Text Splitter → Embeddings OpenAI → Train Pinecone` | | **Agent Builder** | The star of the show – orchestrates GPT-4o (via OpenRouter), SerpAPI web-search, your Pinecone index and a Structured Output Parser to **produce → validate → prettify** the final n8n template. | `Chat Trigger → AI Agent → OpenAI (validator) → Code (extract) → Convert to JSON file` | *Every arrow in the drawn workflow is pre-connected, so the generated template always passes n8n’s import check.* --- ## 🛠️ Getting set up (5 quick creds) | Service | Credential type | | --------------------------------------------------- | ---------------------------------------------------------- | | **OpenAI / Azure OpenAI** – embeddings & validation | *OpenAI API* | | **Pinecone** – vector store | *Pinecone API* | | **OpenRouter** – GPT-4o LLM | *OpenRouter API Key* | | **SerpAPI** – web search | *SerpAPI Key* | | **Firecrawl** (only if you plan to crawl) | Generic **Header Auth** → `Authorization: Bearer YOUR_KEY` | Each node already expects those creds; just create them once, select in the dropdown, hit **Activate**. --- ## 🏃♀️ What a typical run looks like 1. **User says:** “Build me a workflow that monitors our support inbox, summarises new tickets with GPT and posts to Slack.” 2. *Chat Trigger* captures the message. 3. **AI Agent**: * queries Pinecone for relevant n8n docs, * fires a SerpAPI search for “n8n gmail trigger example”, * sketches an architecture (Gmail Trigger → GPT Model → Slack). 4. The agent **returns JSON** ➜ OpenAI node double-checks field names, connections, type versions. 5. A tiny JS Code node slices the JSON out of the chat blob and **saves it as `template.json`** ready for download. 6. You download, import, and… done. --- ## ✏️ Customising * **Switch the LLM** – plug in Claude 3, Gemini 1.5, or a local model; just swap the *OpenRouter Chat Model* node. * **Point the RAG at your own docs** – change the crawl URL or feed PDFs via the *Default Data Loader*. * **Hard-code preferred nodes** – edit the “User node preferences” in the system message so the agent always chooses *Notion* for databases, etc. --- ## 🥡 Take-away notes * It's a **prototype** feel free to experiment with it to improve its capabilities. * **Have fun building!**