Workflow Templates

💥 Scrape leads from businesses with Claude and Apify to Gmail outreach 📄 Documentation: Notion Guide Automatically scrape business leads with Claude Co-Work and Apify, send the data to n8n through a webhook, store it in Google Sheets, generate personalized outreach emails, and send them automatically with Gmail. This workflow combines lead scraping, lead qualification, data organization, AI copywriting, and cold outreach into one automated pipeline. Who is this for? This template is ideal for: Agencies offering SEO, automation, web design, or lead generation services Freelancers looking to automate prospecting Sales teams doing cold outreach Entrepreneurs searching for local business leads Anyone using AI to scale outbound email campaigns What problem is this workflow solving? / Use case Manual prospecting is slow and repetitive. Most businesses waste hours every week: Searching for leads manually Copying business data into spreadsheets Writing cold emails one by one Sending outreach emails manually This workflow solves that by automating the full process from lead discovery to email delivery. Example use case: Use Claude Co-Work with Apify to find restaurants in Paris Scrape lead data such as business name, address, website, phone number, email, and booking status Automatically send the collected leads to n8n through a webhook Save lead data in Google Sheets Generate a personalized outreach email for each valid lead Send the email automatically with Gmail What this workflow does Claude Co-Work uses Apify to scrape business leads and collect their data Claude Co-Work automatically triggers the n8n webhook with the scraped lead data n8n splits each business lead into separate items n8n appends lead data to Google Sheets n8n checks whether the lead has an email address n8n uses Claude to generate a personalized outreach email n8n extracts the email subject and body automatically n8n sends the email via Gmail Expected outcome: Automated lead scraping with Claude Co-Work and Apify Organized lead database in Google Sheets Personalized AI-generated outreach emails Automated email sending Faster prospecting with less manual work Setup Before using this template, create and connect the following accounts: Google Sheets account Gmail account Anthropic / Claude account required to run Claude Co-Work Apify account required for scraping lead data Then configure: 1. Claude Co-Work + Apify Set up Claude Co-Work so it can use Apify to scrape lead data before n8n starts. Claude Co-Work should collect fields such as: collection_date business_category region_state city_name street_address business_name business_description website_url phone_number customer_rating email_address contact_status 2. Webhook Configure Claude Co-Work to send the scraped data to the n8n Webhook node. The webhook receives the lead payload and starts the workflow automatically. 3. Google Sheets Replace: YOUR_ID_GOOLE_SHEETS YOUR_ID-sheet_GOOLE_SHEETS With your own Google Sheet ID and Sheet tab ID. 4. Claude Prompt Customize the outreach message inside the Outreach email copywriter node. How to customize this workflow to your needs Change target industry Replace restaurants with: Dentists Lawyers Real estate agencies Coaches Ecommerce stores Local businesses Change outreach offer Instead of SEO or booking systems, promote: Web design AI chatbots Lead generation Marketing automation CRM setup Ads management Notes Claude Co-Work and Apify handle the lead scraping step before n8n starts The webhook is triggered automatically after the lead data is collected Phone numbers are automatically cleaned before saving to Google Sheets Only leads with email addresses continue to outreach Gmail errors continue without stopping the workflow Built for users who want to automate scraping, prospecting, and outbound sales with AI. 🎥 Watch This Tutorial 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: n8n courses (in French) Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 n8n courses (in French)

Who this is for This workflow is designed for: Automation engineers building AI-powered data pipelines Product managers & analysts needing structured insights from web pages Researchers & content teams extracting summaries from documentation or articles HR, compliance, and knowledge teams converting unstructured web content into structured records n8n self-hosted users leveraging advanced scraping and LLM enrichment It is ideal for anyone who wants to transform any public URL into structured data + clean summaries automatically. What problem this workflow solves Web content is often unstructured, verbose, and inconsistent, making it difficult to: Extract structured fields reliably Generate consistent summaries Reuse data across spreadsheets, dashboards, or databases Eliminate manual copy-paste and interpretation This workflow solves the problem of turning arbitrary web pages into machine-readable JSON and human-readable summaries, without custom scrapers or manual parsing logic. What this workflow does The workflow integrates Decodo, Google Gemini, and Google Sheets to perform automated extraction of structured data. Here’s how it works step-by-step: Input Setup The workflow begins when the user executes it manually or passes a valid URL. The input includes url. Profile Extraction with Decodo Accepts any valid URL as input Scrapes the page content using Decodo Uses Google Gemini to: Extract structured data in JSON format Generate a concise, factual summary Cleans and parses AI-generated JSON safely Merges structured data and summary output Stores the final result in Google Sheets for reporting or downstream automation JSON Parsing & Merging The Code Node cleans and parses the JSON output from the AI for reliable downstream use. The Merge Node combines both structured data and the AI-generated summary. Data Storage in Google Sheets The Google Sheets Node appends or updates the record, storing the structured JSON and summary into a connected spreadsheet. End Output A unified, machine-readable data in JSON + an executive-level summary suitable data analysis or downstream automation. Setup Instructions Prerequisites n8n account** with workflow editor access Decodo API credentials** - You need to register, login and obtain the Basic Authentication Token via Decodo Dashboard Google Gemini (PaLM) API access** Google Sheets OAuth credentials** Setup Steps Import the workflow into your n8n instance. Configure Credentials Add your Decodo API credentials in the Decodo node. Connect your Google Gemini (PaLM) credentials for both AI nodes. Authenticate your Google Sheets account. Edit Input Node In the Set the Input Fields node, replace the default URL with your desired profile or dynamic data source. Run the Workflow Trigger manually or via webhook integration for automation. Verify that structured profile data and summary are written to the linked Google Sheet. How to customize this workflow to your needs You can easily extend or adapt this workflow: Modify Structured Output Change the Gemini extraction prompt to match your own JSON schema Add required fields such as authors, dates, entities, or metadata Improve Summarization Adjust summary length or tone (technical, executive, simplified) Add multi-language summarization using Gemini Change Output Destination Replace Google Sheets with: Databases (Postgres, MySQL) Notion Slack / Email File storage (JSON, CSV) Add Validation or Filtering Insert IF nodes to: Reject incomplete data Detect errors or hallucinated output Trigger alerts for malformed JSON Scale the Workflow Replace manual trigger with: Webhook Scheduled trigger Batch URL processing Summary This workflow provides a powerful, generic solution for converting unstructured web pages into structured, AI-enriched datasets. By combining Decodo for scraping, Google Gemini for intelligence, and Google Sheets for persistence, it enables repeatable, scalable, and production-ready data extraction without custom scrapers or brittle parsing logic.

Automated AWS IAM Compliance Workflow for MFA Enforcement and Access Key Deactivation > This workflow leverages AWS IAM APIs and n8n automation to ensure strict security compliance by continuously monitoring IAM users for MFA (Multi-Factor Authentication) enforcement. .jpg) Who’s it for This workflow is designed for DevOps, Security, or Cloud Engineers responsible for maintaining IAM security compliance in AWS accounts. It's ideal for teams who want to enforce MFA usage and automatically disable access for non-compliant IAM users. How it works / What it does This automated workflow performs a daily check to detect IAM users without an MFA device and deactivate their access keys. Step-by-step: Daily scheduler: Triggers the workflow once a day. Get many users: Retrieves a list of all IAM users in the account. Get IAM User MFA Devices: Calls AWS API to get MFA device info for each user. Filter out IAM users with MFA: Keeps only users without any MFA device. Send warning message(s): Sends Slack alerts for users who do not have MFA enabled. Get User Access Key(s): Fetches access keys for each non-MFA user. Parse the list of user access key(s): Extracts and flattens key information like AccessKeyId, Status, and UserName. Filter out inactive keys: Keeps only active access keys for further action. Deactivate Access Key(s): Calls AWS API to deactivate each active key for non-MFA users. How to set up Configure AWS credentials in your environment (IAM role or AWS access key with required permissions). Connect Slack via the Slack node for alerting (set channel and credentials). Set the scheduler to your preferred frequency (e.g., daily at 9AM). Adjust any Slack message template or filtering conditions as needed. Requirements IAM user or role credentials with the following AWS IAM permissions: iam:ListUsers iam:ListMFADevices iam:ListAccessKeys iam:UpdateAccessKey Slack credentials (Bot token with chat:write permission). n8n environment with: Slack integration AWS credentials (set via environment or credentials manager) How to customize the workflow Alert threshold**: Instead of immediate deactivation, you can delay action (e.g., alert first, wait 24h, then disable). Change notification channel**: Modify the Slack node to send alerts to a different channel or add email integration. Whitelist exceptions**: Add a Set or IF node to exclude specific usernames (e.g., service accounts). Add audit logging**: Use Google Sheets, Airtable, or a database to log which users were flagged or had access disabled. Extend access checks**: Include console password check (GetLoginProfile) if needed.

What Problem Does It Solve? We’ve all been there: you want to check if a product is cheaper on Amazon or Jumia, but opening a dozen tabs is a pain. Building a bot to do this usually fails because big e-commerce sites love to block scrapers with CAPTCHAs. This workflow fixes that headache by: Taking a product name from a chat message. Using Decodo to handle the hard part—searching Google and scraping the product pages without getting blocked. Using AI to read the messy HTML and pull out just the price and product name. Sending a clean "Best Price" summary back to the user instantly. How to Configure It Telegram Setup Create a bot with BotFather and paste your token into the Telegram node. Make sure your webhook is set up so the bot actually "hears" the messages. Decodo This is the engine that makes the workflow reliable. You'll need to add your Decodo API key in the credentials. We used Decodo here specifically because it handles the proxies and browser fingerprinting for you—so your Amazon requests actually go through instead of failing. AI Setup Plug in your OpenAI API key (or swap the node for Claude/Gemini if you prefer). The system prompt is already set up to ignore ads and find the real price, but feel free to tweak the tone. How It Works Trigger: You text the bot a product name (e.g., "Sony XM5"). Search: The workflow asks Decodo to Google that specific term on sites like Amazon.eg. Scrape: It grabs the URLs and passes them back to Decodo to fetch the page content safely. Extract: The AI reads through the text, finds the lowest price, and ignores the clutter. Reply: The bot texts you back with the best deal found. Customization Ideas Go wider:** Edit the search query to check other stores like Noon or Carrefour. Track trends:** Connect a Google Sheet to log what people are searching for—great for market research. If you need any help Get In Touch

Description Submit your page URL, a competitor's page URL, and a target keyword using a simple form. The workflow automatically scrapes both pages, strips all HTML, and sends the full comparison to GPT-4o-mini for analysis. Within seconds, a structured 6-section content gap report lands in your Slack channel — ready to act on. Built for SEO teams, content strategists, and agency analysts who need fast, repeatable competitor insights. What This Workflow Does Parallel page scraping** — Fetches your page and the competitor's page simultaneously so you get results faster, not one site at a time HTML cleaning** — Strips all scripts, ads, and navigation clutter from both pages, leaving only the actual content GPT-4o-mini needs to compare Content gap identification** — AI pinpoints exactly which topics, subtopics, and questions your page is missing that the competitor already covers Competitive advantage mapping** — Surfaces what your page has that the competitor lacks, so you know what to protect and promote Priority action list** — Delivers 5 concrete, ranked improvements specific to your page — not generic SEO advice Token-efficient processing** — Caps each page at 8,000 characters so every run stays fast and API costs stay predictable Slack report delivery** — Posts the full 6-section analysis with business name, keyword, both URLs, and run date directly to your team channel — ready to act on or forward to a client Setup Requirements Tools Needed n8n instance (self-hosted or cloud) OpenAI account with GPT-4o-mini API access Slack workspace with OAuth2 app configured Estimated Setup Time: 10–15 minutes Step-by-Step Setup Import the workflow — Open n8n → Workflows → Import from JSON → paste the workflow JSON → click Import Connect your OpenAI credential — Go to node 10. OpenAI — GPT-4o-mini Model → click the credential dropdown → add your OpenAI API key → test the connection Connect your Slack credential — Go to node 12. Slack — Send Gap Report → click the credential dropdown → select OAuth2 → follow the Slack OAuth flow to connect your workspace Set your Slack channel — In node 12. Slack — Send Gap Report, set the channel field to the channel name where reports should be posted (e.g. #seo-reports) Activate the workflow — Toggle the workflow to Active → copy the Form URL from node 1. Form — Submit Page URLs → open it in a browser to test > ⚠️ Bot-Protected Sites — Some sites return a 403 Forbidden error when scraped. If this happens, open nodes 3. HTTP — Scrape Your Page and 4. HTTP — Scrape Competitor Page, add a header with Name = User-Agent and Value = Mozilla/5.0 (compatible; n8n-bot/1.0) in both nodes. How It Works (Step by Step) Step 1 — Form: Submit Page URLs You open the form URL in a browser and fill in four fields: your page URL, the competitor's page URL, the target keyword, and your business name. Submitting the form kicks off the entire workflow automatically. Step 2 — Set: Extract Form Fields All four form inputs are mapped to clean named variables. A run timestamp is automatically added so every report is dated. These variables flow into every downstream step. Step 3 — HTTP: Scrape Your Page (parallel) An HTTP request fetches the full HTML content of your page. This step runs at the same time as Step 4, so both pages are retrieved simultaneously without waiting. Step 4 — HTTP: Scrape Competitor Page (parallel) An identical HTTP request fetches the competitor's page in parallel with Step 3. Both pages are ready at the same time. Step 5 — Code: Clean Your Page HTML A code step removes all script tags, style tags, and HTML markup from your page. The result is plain readable text, trimmed to 8,000 characters to keep AI costs low and responses fast. Step 6 — Code: Clean Competitor Page HTML The same cleaning process runs on the competitor's page. This step also carries forward all the form variables (keyword, URLs, business name, run date) so nothing is lost in the merge. Step 7 — Merge: Combine Both Pages Both cleaned page texts — yours and the competitor's — flow into a merge step that combines them into a single pipeline for the next step. Step 8 — Code: Combine Page Data A code step safely joins both items into one clean object. If either page failed to scrape, it uses a fallback message instead of crashing the workflow. Step 9 — AI Agent: Gap Analyzer GPT-4o-mini receives both page texts, the target keyword, business name, and both URLs. It produces a plain-text 6-section analysis: keyword usage comparison, topics your page is missing, topics you have that the competitor lacks, content depth and quality comparison, five priority actions ranked by impact, and a quick 3-sentence verdict. Step 10 — OpenAI: GPT-4o-mini Model This is the language model powering the AI Agent. It is configured with a temperature of 0.4 for consistent, factual analysis and a max token limit of 1,500 to keep reports concise. Step 11 — Set: Prepare Slack Message All report fields are assembled into a single clean object: the AI analysis, both URLs, target keyword, business name, and run date. This is the complete payload that goes to Slack. Step 12 — Slack: Send Gap Report The full report is posted to your Slack channel in a formatted message. It includes the business name, keyword, run date, both URLs, the full 6-section AI analysis, and a footer noting the report was generated by n8n + GPT-4o-mini. Key Features ✅ Parallel scraping — Both pages are fetched at the same time, not one after the other, saving you time on every run ✅ Auto HTML stripping — Scripts, styles, and all tags are removed automatically — no manual cleanup needed ✅ Token budget control — Each page is hard-capped at 8,000 characters so API costs stay predictable ✅ Fallback handling — If a page fails to scrape, the workflow continues and notes the failure rather than crashing ✅ 6-section structured report — Every report follows the same format so results are easy to compare across competitors and dates ✅ Slack delivery with metadata — Reports arrive with business name, keyword, run date, and both URLs for full context ✅ Plain text output — No markdown symbols in the AI analysis, making it easy to paste directly into a doc or client report ✅ One-form trigger — The whole workflow starts with a single form submission — no coding, no manual steps Customisation Options Change the text limit per page — In nodes 5. Code — Clean Your Page HTML and 6. Code — Clean Competitor Page HTML, change .substring(0, 8000) to a higher number (e.g. 12000) if you want deeper analysis on long-form pages. Note this will increase GPT token usage. Add email delivery — After node 11. Set — Prepare Slack Message, add a Gmail or SMTP node to also send the report by email. Use the same gapReport variable for the email body. Save reports to Google Sheets — Add a Google Sheets node after the Slack node to log every run: business name, keyword, date, competitor URL, and a summary of the verdict section. Schedule weekly competitor checks — Replace the form trigger with a Schedule trigger and a Set node with hardcoded URLs and keywords to automatically run gap analysis every Monday morning. Expand the AI report sections — In node 9. AI Agent — Gap Analyzer, edit the prompt to add a Section 7 covering suggested internal links, or a Section 8 comparing schema markup signals. Troubleshooting OpenAI credential not working: Confirm you added the API key in node 10. OpenAI — GPT-4o-mini Model, not elsewhere Check that your OpenAI account has available credits Make sure you are using a key with access to GPT-4o-mini (not a restricted key) Scraping returns a 403 or empty result: Add a User-Agent header to both 3. HTTP — Scrape Your Page and 4. HTTP — Scrape Competitor Page Header Name: User-Agent, Value: Mozilla/5.0 (compatible; n8n-bot/1.0) Some enterprise or Cloudflare-protected sites cannot be scraped — try the mobile version of the URL instead Slack message not arriving: Confirm the OAuth2 credential in node 12. Slack — Send Gap Report is connected and authorised Check that the channel name is correct and the bot has been invited to that channel In Slack, go to the channel → click the channel name → Integrations → confirm the n8n app is listed Report is too short or generic: The page text may have been mostly scripts with little readable content — check the cleaned text in node 5 or 6 by running a test Try a different URL format (e.g. without trailing slash) or the AMP version of the page Increase the max token setting in node 10 from 1500 to 2000 for more detailed output Form submission not triggering the workflow: Make sure the workflow is set to Active (toggle in the top right of the workflow editor) Copy the Form URL fresh from node 1. Form — Submit Page URLs after activating — inactive workflows generate a test URL, not a live one Support Need help setting this up or want a custom version built for your team or agency? 📧 Email: info@incrementors.com 🌐 Website: https://www.incrementors.com/contact-us/

Sales Pipeline Automation Dashboard with AI Lead Intelligence 🎯 Target Audience Sales managers and team leads Business development representatives Marketing teams managing lead generation CRM administrators and sales operations Account executives and sales representatives Sales enablement professionals Revenue operations (RevOps) teams 🚀 Problem Statement Manual lead qualification and sales pipeline management is inefficient and often leads to missed opportunities or poor lead prioritization. This template solves the challenge of automatically scoring, qualifying, and routing leads using AI-powered intelligence to maximize conversion rates and sales team productivity. 🔧 How it Works This workflow automatically processes new leads using AI-powered intelligence, scores and qualifies them based on multiple factors, and automates the entire sales pipeline from lead capture to deal creation. Key Components Dual Trigger System - Scheduled monitoring and webhook triggers for real-time lead processing AI-Powered Lead Intelligence - Advanced scoring algorithm based on 7 key factors Multi-Source Data Enrichment - LinkedIn and Crunchbase integration for comprehensive lead profiles Automated Sales Actions - Intelligent routing, task creation, and follow-up sequences Multi-Platform Integration - HubSpot CRM, Slack notifications, and Google Sheets dashboard 📊 Google Sheets Column Specifications The template creates the following columns in your Google Sheets: | Column | Data Type | Description | Example | |--------|-----------|-------------|---------| | timestamp | DateTime | When the lead was processed | "2024-01-15T10:30:00Z" | | lead_id | String | Unique lead identifier | "LEAD-2024-001234" | | first_name | String | Lead's first name | "John" | | last_name | String | Lead's last name | "Smith" | | email | String | Lead's email address | "john@company.com" | | company_name | String | Company name | "Acme Corp" | | job_title | String | Lead's job title | "Marketing Director" | | lead_score | Number | AI-calculated score (0-100) | 85 | | grade | String | Lead grade (A+, A, B+, B, C+) | "A+" | | category | String | Lead category | "Enterprise" | | priority | String | Priority level | "Critical" | | lead_source | String | How the lead was acquired | "Website Form" | | assigned_rep | String | Assigned sales representative | "Senior AE" | | company_size | String | Company employee count | "201-500 employees" | | industry | String | Company industry | "Technology" | | funding_stage | String | Company funding stage | "Series B" | | estimated_value | String | Estimated deal value | "$50K-100K" | 🛠️ Setup Instructions Estimated setup time: 25-30 minutes Prerequisites n8n instance with community nodes enabled ScrapeGraphAI API account and credentials HubSpot CRM account with API access Google Sheets account with API access Slack workspace for notifications (optional) Email service for welcome emails (optional) Step-by-Step Configuration 1. Install Community Nodes Install required community nodes npm install n8n-nodes-scrapegraphai npm install n8n-nodes-slack 2. Configure ScrapeGraphAI Credentials Navigate to Credentials in your n8n instance Add new ScrapeGraphAI API credentials Enter your API key from ScrapeGraphAI dashboard Test the connection to ensure it's working 3. Set up HubSpot CRM Integration Add HubSpot API credentials Grant necessary permissions for contacts, deals, and tasks Configure custom properties for lead scoring and qualification Test the connection to ensure it's working 4. Set up Google Sheets Connection Add Google Sheets OAuth2 credentials Grant necessary permissions for spreadsheet access Create a new spreadsheet for sales pipeline data Configure the sheet name (default: "Sales Pipeline") 5. Configure Lead Scoring Parameters Update the lead scoring weights in the Code node Customize ideal customer profile criteria Set automation trigger thresholds Adjust sales rep assignment logic 6. Set up Notification Channels Configure Slack webhook or API credentials Set up email service credentials for welcome emails Define notification preferences for different lead grades Test notification delivery 7. Configure Triggers Set up webhook endpoint for real-time lead capture Configure scheduled trigger for periodic monitoring Choose appropriate time zones for your business hours Test both trigger mechanisms 8. Test and Validate Run the workflow manually with sample lead data Check HubSpot for proper contact and deal creation Verify Google Sheets data formatting Test all notification channels 🔄 Workflow Customization Options Modify Lead Scoring Algorithm Adjust scoring weights for different factors Add new scoring criteria (geographic location, technology stack, etc.) Customize ideal customer profile parameters Implement industry-specific scoring models Extend Data Enrichment Add more data sources (ZoomInfo, Apollo, etc.) Include social media presence analysis Add technographic data collection Implement intent signal detection Customize Sales Automation Modify follow-up sequences for different lead categories Add more sophisticated sales rep assignment logic Implement territory-based routing Add automated meeting scheduling Output Customization Add data visualization and reporting features Implement sales pipeline analytics Create executive dashboards with key metrics Add conversion rate tracking and analysis 📈 Use Cases Lead Qualification**: Automatically score and qualify incoming leads Sales Pipeline Management**: Streamline the entire sales process Lead Routing**: Intelligently assign leads to appropriate sales reps Follow-up Automation**: Ensure consistent and timely follow-up Sales Intelligence**: Provide comprehensive lead insights Performance Tracking**: Monitor sales team and pipeline performance 🚨 Important Notes Respect LinkedIn and Crunchbase terms of service and rate limits Implement appropriate delays between requests to avoid rate limiting Regularly review and update your lead scoring parameters Monitor API usage to manage costs effectively Keep your credentials secure and rotate them regularly Ensure GDPR compliance for lead data processing 🔧 Troubleshooting Common Issues: ScrapeGraphAI connection errors: Verify API key and account status HubSpot API errors: Check API key and permissions Google Sheets permission errors: Check OAuth2 scope and permissions Lead scoring errors: Review the Code node's JavaScript logic Rate limiting: Adjust request frequency and implement delays Support Resources: ScrapeGraphAI documentation and API reference HubSpot API documentation and developer resources n8n community forums for workflow assistance Google Sheets API documentation for advanced configurations Sales automation best practices and guidelines

This n8n workflow template automatically processes phone interview transcripts using AI to evaluate candidates against specific criteria and saves the results to Google Sheets. Perfect for HR departments, recruitment agencies, or any business conducting phone screenings. What This Workflow Does This automated workflow: Receives phone interview transcripts via webhook Uses OpenAI GPT models to analyze candidate responses against predefined qualification criteria Extracts key information (name, phone, location, qualification status) Automatically saves structured results to a Google Sheet for easy review and follow-up The workflow is specifically designed for driving job interviews but can be easily adapted for any position with custom evaluation criteria. Tools & Services Used N8N** - Workflow automation platform OpenAI API** - AI-powered transcript analysis (GPT-4o-mini) Google Sheets** - Data storage and management Webhook** - Receiving transcript data Prerequisites Before implementing this workflow, you'll need: N8N Instance - Self-hosted or cloud version OpenAI API Account - For AI transcript processing Google Account - For Google Sheets integration Phone Interview System - That can send webhooks (like Vapi.ai) Step-by-Step Setup Instructions Step 1: Set Up OpenAI API Access Visit OpenAI's API platform Create an account or log in Navigate to API Keys section Generate a new API key Copy and securely store your API key Step 2: Create Your Google Sheet Option 1: Use Our Pre-Made Template (Recommended) Copy our template: Driver Interview Results Template Click "File" → "Make a copy" to create your own version Rename it as desired Copy your new sheet's URL - you'll need this for the workflow Option 2: Create From Scratch Go to Google Sheets Create a new spreadsheet Name it "Driver Interview Results" (or your preferred name) Set up the following column headers in row 1: A1: name B1: phone C1: cityState D1: qualifies E1: reasoning Copy the Google Sheet URL - you'll need this for the workflow Step 3: Import and Configure the N8N Workflow Import the Workflow Copy the workflow JSON from the template In your N8N instance, go to Workflows → Import from JSON Paste the JSON and import Configure OpenAI Credentials Click on either "OpenAI Chat Model" node Set up credentials using your OpenAI API key Test the connection to ensure it works Configure Google Sheets Integration Click on the "Save to Google Sheets" node Set up Google Sheets OAuth2 credentials Select your spreadsheet from the dropdown Choose the correct sheet (usually "Sheet1") Update the Webhook Click on the "Webhook" node Note the webhook URL that n8n generates This URL will receive your transcript data Step 4: Customize Evaluation Criteria The workflow includes predefined criteria for a Massachusetts driving job. To customize for your needs: Click on the "Evaluate Candidate" node Modify the system message to include your specific requirements Update the evaluation criteria checklist Adjust the JSON output format if needed Current Evaluation Criteria: Valid Massachusetts driver's license No felony convictions Clean driving record (no recent tickets/accidents) Willing to complete background check Can pass drug test (including marijuana) Available full-time Monday-Friday Lives in Massachusetts Step 5: Connect to Vapi.ai (Phone Interview System) This workflow is specifically designed to work with Vapi.ai's phone interview system. Here's how to connect it: Setting Up the Vapi Integration Copy Your N8N Webhook URL In your n8n workflow, click on the "Webhook" node Copy the webhook URL (it should look like: https://your-n8n-instance.com/webhook-test/351ffe7c-69f2-4657-b593-c848d59205c0) Configure Your Vapi Assistant Log into your Vapi.ai dashboard Create or edit your phone interview assistant In the assistant settings, find the "Server" section Set the Server URL to your n8n webhook URL Set timeout to 20 seconds (as configured in the workflow) Configure Server Messages In your Vapi assistant settings, enable these server messages: end-of-call-report transcript[transcriptType="final"] Set Up the Interview Script Use the provided interview script in your Vapi assistant (found in the workflow's system message) This ensures consistent data collection for the AI evaluation Expected Data Format from Vapi The workflow expects Vapi to send data in this specific format: { "body": { "message": { "artifact": { "transcript": "AI: Hi. Are you interested in driving for Bank of Transport?\nUser: Yes.\nAI: Great. Before we go further..." } } } } Vapi Configuration Checklist ✅ Webhook URL set in Vapi assistant server settings ✅ Server messages enabled: end-of-call-report, transcript[transcriptType="final"] ✅ Interview script configured in assistant ✅ Assistant set to send webhooks on call completion Alternative Phone Systems If you're not using Vapi.ai, you can adapt this workflow for other phone systems by: Modifying the "Edit Fields2" node to extract transcripts from your system's data format Updating the webhook data structure expectations Ensuring your phone system sends the complete interview transcript Step 6: Test the Workflow Test with Sample Data Use the "Execute Workflow" button with test data Verify that data appears correctly in your Google Sheet Check that the AI evaluation logic works as expected End-to-End Testing Send a test webhook with a real transcript Monitor each step of the workflow Confirm the final result is saved to Google Sheets Workflow Node Breakdown Webhook - Receives transcript data from your phone system Edit Fields2 - Extracts the transcript from the incoming data Evaluate Candidate - AI analysis using GPT-4o-mini to assess qualification Convert to JSON - Ensures proper JSON formatting with structured output parser Save to Google Sheets - Automatically logs results to your spreadsheet Customization Options Modify Evaluation Criteria Edit the system prompt in the "Evaluate Candidate" node Add or remove qualification requirements Adjust the scoring logic Change Output Format Modify the JSON schema in the "Structured Output Parser" node Update Google Sheets column mapping accordingly Add Additional Processing Insert nodes for email notifications Add Slack/Discord alerts for qualified candidates Integrate with your CRM or ATS system Troubleshooting Common Issues: OpenAI API Errors**: Check API key validity and billing status Google Sheets Not Updating**: Verify OAuth permissions and sheet access Webhook Not Receiving Data**: Confirm URL and POST format from your phone system AI Evaluation Inconsistencies**: Refine the system prompt with more specific criteria Usage Tips Monitor Token Usage**: OpenAI charges per token, so monitor your usage Regular Review**: Periodically review AI evaluations for accuracy Backup Data**: Export Google Sheets data regularly for backup Privacy Compliance**: Ensure transcript handling complies with local privacy laws Need Help with Implementation? For professional setup, customization, or troubleshooting of this workflow, contact: Robert - Ynteractive Solutions Email**: rbreen@ynteractive.com Website**: www.ynteractive.com LinkedIn**: linkedin.com/in/robert-interactive Specializing in AI-powered workflow automation, business process optimization, and custom integration solutions.

How It Works Automates financial aggregation, validation, and intelligent tax assessment. Integrates revenue, expenses, and invoices via scheduled connectors, merges data into unified records, and applies AI-driven analysis for anomaly detection and tax calculations. The system evaluates tax liability against configurable thresholds, intelligently routes filings to government portals or tax agents based on jurisdiction rules, and triggers automated email notifications for compliance deadlines and payment reminders. Designed for accountants, small business owners, and finance teams managing quarterly tax obligations while minimizing manual errors and compliance risks across multiple entities. Setup Steps Configure OpenAI, Gmail, and Google Sheets credentials Connect revenue and expense data sources Define tax thresholds and jurisdiction-specific rules in workflow nodes Map output fields to government or tax agent systems Create email templates for notifications Test the workflow with sample financial data before enabling Prerequisites OpenAI API key, Gmail account, Google Sheets, accounting software or data source connectivity Use Cases Quarterly tax filing automation, multi-client accountant workflows, enterprise compliance monitoring Customization Adjust tax thresholds by jurisdiction, integrate additional data sources Benefits Significant reduction in calculation errors, faster filing timelines, automated deadline alerts

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Create and Auto-Post Viral AI Videos with VEO3 and Blotato to 9 Platforms Who is this for? This template is ideal for content creators, growth marketers, e-commerce entrepreneurs, and video-first brands who want to automate the creation and multi-platform distribution of viral short-form ads using AI. If you're looking to scale video production without editing tools or posting manually, this is for you. What problem is this workflow solving? Creating high-converting video content is time-consuming. You need to: Come up with ideas Write compelling scripts Generate visuals Adapt content for each platform Manually publish and track results This workflow automates that entire process and turns a single idea into a ready-to-publish video campaign across 9 platforms. What this workflow does Triggers via Telegram when a new video idea is submitted Fetches parameters (style, tone, duration) from Google Sheets Generates the video script using GPT-4 and a master AI prompt Creates the video using Google’s VEO3 video generation model Downloads the final video once rendering is complete Rewrites the caption with GPT-4o for platform-optimized posting Logs the result in Google Sheets for tracking Sends preview links to Telegram for review Auto-posts the video to 9 platforms using Blotato (TikTok, YouTube, Instagram, Threads, Facebook, X, LinkedIn, Pinterest, Bluesky) Setup Install n8n (self-hosted) with Community Nodes enabled Connect your Telegram Bot Token to the trigger node Add your OpenAI API Key for GPT-4 and GPT-4o models Configure your VEO3 API access (Google AI Studio) Set up Blotato with your platform tokens & IDs Link your Google Sheets and set the expected column structure (idea, style, caption, etc.) Adjust the Telegram trigger format (e.g., idea: ...) to your team’s input style How to customize this workflow to your needs Edit the master prompt to match your brand voice or industry Replace the caption prompt to generate more marketing-style hooks Modify the platform list if you only publish to a few specific channels Add approval steps (Slack, email, Telegram) before publishing Integrate tracking by pushing published URLs to your analytics or CRM 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

This workflow is designed to fully automate the creation and publishing of Instagram marketing content by combining AI-powered text generation with Bytedance Seedream 4.0, image creation, and social media scheduling into a single streamlined pipeline. Starting from a simple prompt and reference images, the workflow generates both the visual asset and the caption, then automatically publishes the final content to Instagram. It eliminates the need for manual design, copywriting, and posting, enabling a faster and more scalable content production process. | BEFORE | AFTER | |--------|-------| | | | Key Advantages 1. ✅ End-to-End Automation The workflow fully automates the process from initial input (prompt + reference images) to final delivery (Instagram post), eliminating manual content creation and publishing steps. 2. ✅ AI-Powered Content Creation It leverages advanced AI models to: Generate engaging, platform-optimized Instagram captions Create branded visual assets from prompts and reference images Ensure content is creative, relevant, and ready for social media 3. ✅ Automated Visual Generation Integrates AI image editing (Kie AI Seedream) to automatically produce high-quality, branded visuals without the need for design tools or manual editing. 4. ✅ Social Media Optimization Captions are generated with built-in best practices, including: Platform-specific tone and structure Hashtag optimization for reach and discoverability Engagement-driven calls to action 5. ✅ Scalability The workflow structure allows easy scaling to generate and publish large volumes of content across campaigns with minimal effort. 6. ✅ Modular & Extensible Design Each step (input setup, caption generation, image creation, upload, publishing) is modular, making it easy to: Swap AI models Add new social platforms Extend functionality with additional services 7. ✅ Automated Publishing & Scheduling Integration with Postiz enables seamless upload and scheduling of posts directly to Instagram, streamlining the entire publishing pipeline. 8. ✅ Reliability with Asynchronous Processing The wait/resume mechanism ensures that image generation tasks are completed before proceeding, improving workflow stability and preventing failures. 9. ✅ Consistency & Brand Alignment Using structured prompts and predefined logic ensures all generated content maintains a consistent brand voice, visual identity, and messaging across posts. How it works This workflow automates the creation of a branded visual + Instagram caption, then posts the result to Instagram via Postiz. Manual trigger starts the workflow. Set params defines: A creative prompt for generating an images A reference logo URL Normalize converts the image URL(s) into a JSON array. The workflow splits into two parallel branches: Image generation branch: Calls Kie AI Seedream 4.0 Edit API with the prompt + image URL(s) Waits for async completion via a webhook Extracts the generated image URL Downloads the image binary Caption generation branch: Sends the prompt to an OpenAI Chat Model Uses a Social Media Manager LLM chain to produce an Instagram caption with emojis and hashtags Parses the JSON output into a clean caption Merge combines the downloaded image and the caption. Upload IG Image sends the image to Postiz’s upload endpoint. Instagram node schedules/posts the image + caption to Instagram. Set up steps Add credentials: OpenAi account I – OpenAI API key Kie AI – Token from Kie.ai API credentials Postiz account – Postiz API credentials Adjust the prompt (optional): Edit the Set params node → PROMPT value to change the image generation text Confirm webhook for async wait: The Wait node uses a resume webhook – ensure the webhook URL is reachable by Kie AI Validate Postiz integration: Check that the Instagram node has the correct Postiz integration ID Activate the workflow (if scheduling needed, replace Manual Trigger with a schedule trigger) Execute manually to test the full flow from prompt → image → caption → Instagram post 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

🚀 Enrich CRM Leads with LinkedIn Company Data Using AI Who's it for Sales teams, marketers, and business development professionals who need to automatically enrich their CRM records with detailed company information from LinkedIn profiles. Perfect for anyone doing B2B outreach who wants to personalize their messaging at scale. What it does This workflow transforms bare-bones lead records into rich, personalized prospect profiles by: Automatically scraping LinkedIn company profiles Using AI (GPT-4) to extract key business intelligence Generating 15+ email-ready personalization variables Updating your CRM with structured, actionable data The workflow pulls company overviews, products/services, funding information, recent posts, and converts everything into natural-language variables that can be dropped directly into your outreach templates. How it works Trigger: Workflow starts when a new lead is added to Airtable (or on schedule) Fetch: Retrieves the lead record containing the LinkedIn company URL Scrape: Pulls the raw HTML from the company's LinkedIn profile Clean: Strips HTML tags and formats content for AI processing Analyze: GPT-4 extracts structured company intelligence (overview, products, market presence, recent posts) Transform: Converts analysis into 15+ email-ready variables with natural phrasing Update: Writes enriched data back to your CRM Setup Requirements Airtable account** (free tier works fine) OpenAI API key** (GPT-4o-mini recommended for cost-effectiveness) LinkedIn company URLs** stored in your CRM 5 minutes** for initial configuration How to set up Configure Airtable Connection Replace YOUR_AIRTABLE_BASE_ID with your base ID Replace YOUR_TABLE_ID with your leads table ID Ensure your table has a "LinkedIn Organization URL" field Add your Airtable API credentials Add OpenAI Credentials Click on both OpenAI nodes Add your OpenAI API key GPT-4o-mini is recommended (cost-effective and fast) Set Up Trigger Add a trigger node (Schedule, Webhook, or Airtable trigger) Configure to run when new leads are added or on a daily schedule Test the Workflow Add a test lead with a LinkedIn company URL Execute

🚀 Transform Your Job Hunt with AI-Powered Telegram Bot Turn job searching into a conversational experience! This intelligent Telegram bot automatically scrapes job postings from LinkedIn, Indeed, and Monster, filters for sales & marketing positions, and delivers personalized results directly to your chat. ✨ Key Features Interactive Telegram Commands**: Simple /jobs [keyword] [location] searches Multi-Platform Scraping**: Simultaneous data collection from 3 major job boards AI-Powered Filtering**: Smart relevance detection and experience level classification Real-Time Notifications**: Instant job alerts delivered to Telegram Automated Data Storage**: Saves results to Google Sheets and Airtable Duplicate Removal**: Advanced deduplication across platforms Mobile-First Experience**: Full job search functionality through Telegram 🎯 Perfect For Sales Professionals**: Account managers, sales representatives, business development Marketing Experts**: Digital marketers, marketing managers, growth specialists Recruiters**: Streamlined candidate sourcing and job market analysis Job Seekers**: Hands-free job discovery with instant notifications 🛠️ Setup Requirements Required Credentials: Telegram Bot Token**: Create bot via @BotFather Bright Data API**: Professional web scraping service (LinkedIn/Indeed datasets) Google Sheets OAuth2**: For spreadsheet integration Airtable Token**: Database storage and management Prerequisites: n8n instance with HTTPS enabled (required for Telegram webhooks) Valid domain name with SSL certificate Basic understanding of Telegram bot commands 🔧 How It Works User Experience: Send /start to activate the bot and see available commands Use /jobs sales manager New York to search for specific positions Receive formatted job results instantly in Telegram Click "Apply Now" links to go directly to job postings All jobs automatically saved to your connected spreadsheets Behind the Scenes: Command Processing: Bot parses user input for keywords and location Parallel Scraping: Simultaneous API calls to LinkedIn, Indeed, and Monster AI Processing: Intelligent filtering, experience level detection, remote work identification Data Enhancement: Salary extraction, duplicate removal, relevance scoring Multi-Format Storage: Automatic saving to Google Sheets, Airtable, and JSON export Real-Time Response: Formatted results delivered back to Telegram chat 🎨 Telegram Bot Commands /start - Welcome message and command overview /jobs [keyword] [location] - Search for jobs (e.g., /jobs marketing manager remote) /help - Show detailed help information /status - Check bot status and recent activity 📊 Sample Output The bot delivers beautifully formatted job results: 🎯 Job Search Results 🎯 Found 7 relevant opportunities Platforms: linkedin, indeed, monster Remote jobs: 3 ─────────────────── 💼 Senior Sales Manager 🏢 TechCorp Industries 📍 New York, NY 💰 $80,000 - $120,000 🌐 Remote Available 📊 senior level 🔗 Apply Now 🔒 Security & Best Practices Rate Limiting**: Built-in Telegram API compliance (30 requests/second) Error Handling**: Graceful failure recovery with user-friendly messages Input Validation**: Sanitized user input to prevent injection attacks Credential Management**: Secure API key storage using n8n credentials system HTTPS Enforcement**: Required for production Telegram webhook integration 📈 Benefits & ROI 95% Time Reduction**: Automated job discovery vs manual searching Multi-Source Coverage**: Access 3 major job platforms simultaneously Mobile Accessibility**: Search jobs anywhere using Telegram mobile app Real-Time Alerts**: Never miss new opportunities with instant notifications Data Organization**: Automatic spreadsheet management for job tracking Market Intelligence**: Comprehensive job market analysis and trends 🚀 Advanced Customization Custom Keywords**: Modify filtering logic for specific industries Location Targeting**: Adjust geographic search parameters Experience Levels**: Fine-tune senior/mid/entry level detection Additional Platforms**: Easily add more job boards via HTTP requests Notification Scheduling**: Set up periodic automated job alerts Team Integration**: Deploy for multiple users or team channels 💡 Use Cases Individual Job Seekers**: Personal job hunting assistant Recruitment Agencies**: Streamlined candidate sourcing Sales Teams**: Territory-specific opportunity monitoring Marketing Departments**: Industry trend analysis and competitor tracking Career Coaches**: Client job market research and opportunity identification Ready to revolutionize your job search? Deploy this workflow and start receiving personalized job opportunities directly in Telegram!