Workflow Templates

Personalized Cold Email System with Google Gemini AI and Telegram Approval An AI-powered cold email automation that uses Google Gemini to generate personalized outreach and a Telegram workflow for manual approval, ensuring high-quality, human-in-the-loop campaigns. Features Smart Lead Selection**: Fetches leads with an "Available" status from a designated Google Sheet. AI Email Generation**: Google Gemini creates a personalized subject line and email body based on lead data. Telegram Approval**: Sends each generated email to a Telegram chat for a one-click "Approve" or "Reject" decision. Edit & Regenerate**: Allows users to provide feedback on rejected emails, which the AI uses to regenerate a new version for re-approval. Auto-Send**: Approved emails are automatically dispatched via a configured SMTP server, including a professional signature. Complete Tracking**: Updates three separate Google Sheets (Filtered Leads, Sent Leads, Emails Sent) to maintain a clear audit trail. Rate Limiting**: A one-second delay between email sends helps avoid spam filters and protects sender reputation. Batch Processing**: Handles three leads per execution by default, which is configurable to scale up or down. How It Works A manual trigger initiates the workflow and captures the current date and time for logging. The system fetches a set number of leads (default is three) from the Filtered Leads sheet where the status is "Available". It loops through each lead individually to generate and send a unique email. The AI generates a personalized email (Subject + Body) using the lead's data. A preview of the email is sent to a specified Telegram chat with "Approve" and "Reject" buttons. If approved: The email is sent via SMTP. The lead's status is updated, and logs are written to the Sent Leads and Emails Sent sheets. The system waits one second before processing the next lead. If rejected: The system prompts the user for feedback in Telegram. The feedback is combined with the original prompt to generate a new email draft, which is sent for re-approval. A final notification is sent to Telegram when the batch is complete. Requirements Google Sheets with three tabs (see structure below). Telegram Bot Token and user/group Chat ID. Google Gemini API Key. SMTP Email Account credentials (server, port, username, password). Setup Instructions Google Sheets Setup: Create a new Google Sheet. Rename three tabs to exactly Filtered Leads, Sent Leads, and Emails Sent. Populate the Filtered Leads sheet with your lead data according to the structure specified below. API Credentials: Google Gemini: Generate an API key from your Google AI Studio account. Telegram Bot: Create a new bot by messaging @BotFather on Telegram and follow the prompts to get your API token. Get your Chat ID by messaging @userinfobot. SMTP Configuration: Obtain the SMTP server address, port, username, and password from your email provider (e.g., Google Workspace, Outlook). Automation Platform: In your automation platform (e.g., n8n, Make), create a new workflow. Connect your Google Sheets account using OAuth2. Add the Gemini API Key, Telegram Bot Token, Chat ID, and SMTP credentials into the respective modules or credential stores. Map the sheet columns to the variables in the workflow modules. Google Sheets Structure The automation requires the following column headers in each sheet. The names must be exact. Filtered Leads (Input Sheet)** FirstName: Lead's first name. LastName: Lead's last name. Email: Lead's email address. CompanyName: Name of the lead's company. JobTitle: Lead's current job title. Website: Company website (for AI context). LinkedIn: URL of the lead's LinkedIn profile. Notes: Any specific details or pain points for personalization. Status: Workflow status. Set to Available for leads ready to be processed. Sent Leads (Tracking Sheet)** Email: Email address of the contacted lead. CompanyName: Name of the company. TimestampSent: Date and time the email was sent. Emails Sent (Archive Sheet)** RecipientEmail: The lead's email address. Subject: The exact subject line that was sent. Body: The full email body that was sent. TimestampSent: Date and time the email was sent. Customization Guide This template can be adapted to fit specific campaign needs. Batch Size**: The number of leads processed per execution is controlled by the initial "Get Leads" module. Change the Limit parameter from 3 to your desired number. AI Prompt**: The core of the personalization is the prompt sent to the Gemini API. Modify this prompt to change the email's tone, structure, or call-to-action. You can instruct the AI to focus on specific data from the Notes column or reference a different value proposition. Lead Filtering**: The trigger condition is set to pull leads where Status = "Available". This can be changed to any other logic, such as Priority = "High" or Campaign = "Q4-Push", by adjusting the filter in the Google Sheets module. Email Signature**: The signature is typically configured within the SMTP "Send Email" module. Update the HTML or plain text here to change the signature across all sends. Telegram Notifications**: The text and buttons sent to Telegram for approval can be modified. You can add more lead data to the approval message (e.g., Job Title, Company Name) to give the approver more context.

🌍 Auto-Translate Incoming Emails to English This workflow automatically detects the language of every new Gmail email and translates non-English messages into English. The translated email is forwarded to your inbox with a clear "[TRANSLATED]" subject tag, and a label is added for easy filtering. ⚙️ How It Works Gmail New Email Trigger Listens for new unread emails in your Gmail inbox. Captures subject, sender, body text, and metadata. Normalize Email Data A Code node extracts the raw content from the email. Strips HTML, normalizes plain text, and prepares data for language detection. Detect Language (OpenAI) Uses OpenAI GPT-3.5-turbo to detect the email’s language. If the language is English, workflow ends. If not, continues to translation. Translate to English OpenAI translates the email body into clear English. Prepare Translated Email Builds a forwarded email containing: Original sender & subject Received date Message ID Translated content (with formatting) Send Translated Email A Gmail node sends the translated message to your inbox. Subject is prefixed with [TRANSLATED] for easy recognition. Add "Translated Emails" Label Automatically tags the original message in Gmail with "Translated Emails". Helps you filter all auto-translated emails later. 🛠️ Setup Steps 1. Gmail Label In Gmail, create a new label: Translated Emails Or update the label in the final Gmail node. 2. OpenAI API Key Get your key from platform.openai.com. Add credentials in n8n. Uses GPT-3.5-turbo (low cost, reliable). 3. Gmail OAuth In n8n, connect your Gmail account. Requires read/modify permissions. 📧 Example Output Subject: [TRANSLATED] Meeting Proposal Body: 🌍 AUTO-TRANSLATED EMAIL (Original Language: ES) 📧 Original From: juan@example.com 📅 Received: 2025-08-29 🔗 Message ID: 123456abcdef ═══════════════════════════════════════ TRANSLATED CONTENT: Hello, I wanted to ask if we can schedule the meeting for next week. ═══════════════════════════════════════ ✨ This email was automatically translated by n8n workflow. ⚡ With this workflow, every foreign-language email is instantly translated and delivered to you in English — no manual copy-pasting into Google Translate again.

AI Meeting Summary Generator with Google Docs Integration Who’s it for Teams that record meetings and want fast, clear summaries without manual note-taking. Managers who need action items extracted automatically. Anyone using Google Drive + Google Docs as their central workspace. How it works / What it does This workflow automates meeting documentation: Watches a Google Drive folder for new audio/video meeting files. Downloads the file and transcribes speech into text using Gemini AI. Summarizes transcripts into Key Discussions and Action Items. Creates or updates a Google Doc with the formatted summary (title, bullets, checkmarks, styling). Sends final output to Docs with bold headings, bullets, and spacing for readability. How to set up Add your Google Drive Trigger to monitor a folder. Connect Gemini AI to handle transcription + summarization. Configure the Google Docs Tool to create/update your summary documents. (Optional) Use the Code Node + Docs API to apply bullet/checkmark formatting. Requirements Google Drive OAuth2 – for monitoring & downloading files Google Docs OAuth2 – for creating and updating documents Google Gemini API – for transcription + AI-powered summarization How to customize the workflow Change the Google Drive folder to monitor a different workspace. Edit the system prompt in the Summarizer to tweak summary style (e.g., more detail, decisions only, etc.). Modify the Code Node formatting rules (bullets, checkmarks, bold text). Add integrations (e.g., Slack, Email, Notion) to send summaries beyond Google Docs.

This automated n8n workflow monitors real-time cryptocurrency prices using CoinGecko API and sends smart alerts when price conditions are met. It supports multi-coin tracking, dynamic conditions, and instant notifications via Email, Telegram, and Discord. Good to Know Reads crypto watchlist data from Google Sheets. Monitors prices at defined intervals (24/7 monitoring). Handles upper and lower price limits with direction-based alerts (above, below, both). Implements cooldown logic to avoid duplicate alerts. Updates last alert price and timestamp in Google Sheets. Supports multiple alert channels: Email, Telegram, Discord. Uses CoinGecko API for price data (Free tier supported). How It Works 24/7 Crypto Trigger – Runs every minute (or custom interval) to check latest prices. Read Crypto Watchlist – Fetches symbols and conditions from Google Sheets. Parse Crypto Data – Converts Google Sheet data into structured JSON. Fetch Live Crypto Price – Uses CoinGecko API to get latest market price for each coin. Smart Crypto Alert Logic – Compares live price with upper/lower limits and evaluates conditions: Above – Trigger alert if price > upper\_limit. Below – Trigger alert if price < lower\_limit. Both – Trigger alert if either condition is met. Implements cooldown\_minutes to prevent repeated alerts. Check Crypto Alert Conditions – Validates alerts before sending notifications. Send Crypto Email Alert – Sends email alert if condition is true. Send Telegram Crypto Alert – Sends Telegram alert. Send Discord Crypto Alert – Sends Discord alert. Update Crypto Alert History – Updates last_alert_price and last_alert_time in Google Sheet. Crypto Alert Status Check – Ensures alert process completed successfully. Success Notification – Sends confirmation message on success. Error Notification – Sends an error alert if something fails. Google Sheet Columns (A-G) | Column | Description | | ------ | ---------------------------------- | | A | symbol (BTC, ETH, SOL, etc.) | | B | upper_limit (e.g., 45000) | | C | lower_limit (e.g., 40000) | | D | direction (both / above / below) | | E | cooldown_minutes (e.g., 10) | | F | last_alert_price (auto-updated) | | G | last_alert_time (auto-updated) | How to Use Import the workflow into n8n. Configure Google Sheets credentials and link your watchlist sheet. Add your CoinGecko API endpoint in the Fetch Price node (Free tier). Set up Email, Telegram, and Discord credentials for notifications. Test with sample data: Example: BTC, upper\_limit=45000, lower\_limit=40000, direction=both. Execute the workflow and monitor alerts. Requirements n8n environment with execution permissions. Google Sheets integration (with API credentials). CoinGecko API (Free tier supported). Notification channels: Email (SMTP settings in n8n). Telegram Bot Token. Discord Webhook URL. Customizing This Workflow Add more coins in Google Sheet. Modify alert conditions (e.g., percentage change, moving averages). Add SMS or WhatsApp notifications. Integrate with Slack or Microsoft Teams. Use AI-based price predictions for smarter alerts.

Why Creating and sending invoices manually is a major administrative bottleneck. It's not only slow but also prone to human error, such as creating duplicate invoice numbers or sending sensitive financial data in an unsecured format. This workflow solves these problems by creating a robust, end-to-end automation. It ensures every invoice has a unique ID, is professionally generated, is password-protected, and is delivered to your customer automatically. What This workflow provides a complete, secure solution for automated invoicing. It is designed to be triggered by a Webhook (e.g., from your e-commerce store, CRM, or billing platform) that provides customer and order details. The workflow then executes the following steps: Generate & Verify ID: It first generates a new invoice ID. It then performs a critical check by reading your master Google Sheet to ensure this ID is unique, preventing duplicate invoices. Generate PDF: Once the ID is verified, it passes the data to the PDF Generator API. This service dynamically populates your custom invoice template. (PDF Generator API makes it incredibly easy to build and manage your document templates via their web-based editor). Encrypt Document: For enhanced security, the workflow uses a PDF Generator API operation to encrypt the newly generated invoice with a password, protecting your client's sensitive data. Store & Deliver: Finally, it uploads the secure PDF to a specified Google Drive folder for your records and then automatically sends it to the customer as an attachment using Gmail. How Prerequisites: You will need active accounts for: PDF Generator API (for both generation and encryption) Google Suite (for Sheets, Drive, and Gmail) PDF Generator API Setup: Log in to your PDF Generator API account and use their template builder to create your invoice design. Note your Template ID, API Key, and API Secret. In the n8n PDFGeneratorAPI node (Generate a PDF document), create new credentials using your Key and Secret. In the node's parameters, select your Template ID from the list. Google Sheets Setup: Create a Google Sheet to act as your master list of invoices. In the Check If ID Already Exists node, authenticate your Google Sheets account. Set the Spreadsheet ID and Sheet Name. In the "Columns to Return" field, enter the name of the column where you store your invoice IDs. Security & Delivery Setup: Encrypt Node: In the Encrypt PDF document node, authenticate your PDF Generator API credentials (the same ones from Step 2). You can set a static password, or for better security, use an expression to set a dynamic password from the webhook data (e.g., the customer's postal code or order ID). Google Drive Node: Authenticate the Upload file node and specify the Drive and Folder ID where invoices should be stored. Gmail Node: Authenticate the Send a message + file node. Use an expression to map the customer's email from the trigger data into the "To" field. Test & Activate: The Webhook node has pinned test data. You can click "Test workflow" to run the entire process with this sample data. Once you confirm the file is generated, encrypted, and sent, connect your live app (e.g., Shopify, Stripe, etc.) to the production Webhook URL. Activate the workflow.

Workflow Description and Setup Guide This workflow provides comprehensive AI-driven stock analysis, generating detailed deep reports by leveraging advanced vector-based data retrieval and API integrations for precise financial analytics using Danelfin scoring and strategy. Overview This workflow automates stock analysis utilizing: AI-driven scoring and sector insights** (Danelfin configuration) Vector-based data retrieval** (Supabase) Deep analytical reports** Key Components and API Integrations 1. Danelfin AI Stock Analysis API Provides advanced stock scores, rankings, and sector insights. Endpoints:** /ranking: Stock rankings and scores /sectors: Sector information /industries: Industry details 2. Supabase Vector Store Vector embedding storage and quick data retrieval. Workflow Steps Initialization Chat Trigger: Activates when a message requesting stock analysis is received. Stock Analysis and Deep Reporting Main AI Agent: Processes the query, retrieves relevant data from Danelfin, and generates deep analytical reports. Supabase Vector Store: Facilitates efficient data retrieval using embeddings. Reporting Markdown Conversion: Transforms analysis into a readable HTML format. Email Reporting: Sends detailed reports via Gmail. Setup Instructions Prerequisites Obtain API Keys for Supabase and Danelfin. Configuration Steps Set API Keys: Supabase API credentials for vector storage. Danelfin API credentials for stock analysis. Gmail API Credentials: Configure Gmail node for sending reports. Running the Workflow Triggered automatically by chat messages requesting analysis. Reports sent directly via email. This setup ensures precise, AI-driven stock analysis delivered clearly through automated deep reporting.

Description Transform training prescriptions into perfectly formatted Intervals.icu workouts using AI. This workflow automatically converts free-text workout descriptions into structured interval training sessions with proper heart rate zones, pace calculations, and exercise formatting. What this workflow does Collects workout details via a web form (date, title, and workout description) Fetches athlete data from Intervals.icu (FTP, max HR, threshold pace, LTHR) Processes with AI using Claude Opus 4.1 to intelligently parse and format the workout Auto-detects workout type (Run, Ride, Strength, HYROX, CrossFit, etc.) Converts training zones - RPE → HR%, pace calculations, power zones Formats workout structure with proper transitions, rest periods, circuit formatting Creates the workout in Intervals.icu via API Use cases Coaches**: Convert training plans from documents/spreadsheets into Intervals.icu format Athletes**: Quickly add structured workouts from coaching apps or training programs Hybrid training**: Handle complex HYROX, CrossFit, or multi-sport sessions with circuit formatting Time savings**: Eliminate manual workout entry and zone calculations Supported workout types Running, cycling, swimming, strength training, HYROX, CrossFit, indoor rowing, virtual training (Zwift), triathlon, and more. Key features ✅ Intelligent workout type detection ✅ Automatic RPE to HR zone conversion using athlete-specific data ✅ Proper formatting for intervals, circuits, supersets, and progressions ✅ Adds transitions between exercises/machines ✅ Calculates exercise durations and pacing ✅ Handles warmup/cooldown sections ✅ Generates unique workout IDs Setup requirements Intervals.icu account** with API access (API key required) Anthropic API key** for Claude AI Athlete must have training zones configured in Intervals.icu (FTP, max HR, LTHR, threshold pace) Setup instructions Getting your Intervals.icu API key Log in to Intervals.icu Go to Settings (gear icon) → Developer Settings Click Generate API Key (or copy your existing key) Save the API key securely Configuring credentials in n8n For Intervals.icu (HTTP Basic Auth): In n8n, open the GetAthleteInfo or CreateWorkoutAPI node Click on Credentials → Create New Credential Select HTTP Basic Auth Enter: Username: API_KEY (literally type "API_KEY") Password: Your actual API key from Intervals.icu Click Save Apply this credential to both HTTP Request nodes For Anthropic: Open the Anthropic Chat Model node Click on Credentials → Create New Credential Enter your Anthropic API key Click Save Important: The Intervals.icu API uses HTTP Basic Authentication where the username is always the literal string "API_KEY" and the password is your actual API key. How it works The workflow uses a sophisticated AI agent with a detailed system prompt that understands training terminology, zones, and Intervals.icu formatting requirements. It applies sport-specific rules to ensure workouts are properly structured for tracking during training sessions.

AI Personal Assistant Telegram Bot Template Description Transform your Telegram into a powerful AI-powered personal assistant that manages your calendar, sends daily schedules, searches the web, and accesses your contacts - all through simple text messages. What This Template Does This workflow creates an intelligent Telegram bot that serves as your personal assistant, capable of: Daily Schedule Management**: Automatically checks your Google Calendar and emails you a formatted daily schedule summary Intelligent Conversations**: Uses OpenAI GPT-4o-mini with conversation memory for natural interactions Web Research**: Searches Wikipedia and the web using SerpAPI for any questions you have Contact Management**: Accesses your Google Sheets contact database to find email addresses and information Email Automation**: Sends emails on your behalf using Gmail integration Calendar Integration**: Reads and manages your Google Calendar events Target Users Busy Professionals** who need quick access to their schedule and want to automate daily planning Small Business Owners** who want an AI assistant for managing contacts and communications Personal Productivity Enthusiasts** who want to streamline their daily workflow Anyone** who prefers text-based interaction over switching between multiple apps Key Features ✅ Multi-Tool AI Agent: Combines Wikipedia, web search, calendar, email, and contacts in one interface ✅ Conversation Memory: Remembers context across multiple interactions ✅ Automatic Daily Scheduling: Proactive daily schedule emails ✅ Contact Intelligence: Automatically finds contact information before sending emails ✅ Telegram Integration: Works through the familiar Telegram interface Use Cases "What's on my schedule today?" → Receives formatted email with daily agenda "Send an email to John about the meeting" → Finds John's email and sends message "What's the weather in Paris?" → Gets current weather information via web search "Tell me about quantum computing" → Provides Wikipedia information "Schedule a meeting with Sarah tomorrow at 2 PM" → Creates calendar event Prerequisites Before setting up this template, you'll need accounts and API access for: Telegram Bot** (free via @BotFather) OpenAI API** (paid service) Google Calendar API** (free) Gmail API** (free) Google Sheets API** (free) SerpAPI** (freemium web search) Setup Instructions 1. Create Telegram Bot Message @BotFather on Telegram Use /newbot command and follow instructions Save your bot token for later 2. Set Up Google APIs Go to Google Cloud Console Create a new project or select existing Enable Google Calendar, Gmail, and Sheets APIs Create OAuth2 credentials Download credentials JSON file 3. Get API Keys OpenAI: Visit platform.openai.com, create API key SerpAPI: Sign up at serpapi.com, get API key 4. Configure Credentials in n8n Add Telegram Bot credentials using your bot token Set up Google OAuth2 for Calendar, Gmail, and Sheets Add OpenAI API credentials Add SerpAPI credentials 5. Customize the Workflow Update Calendar ID: Replace a________@gmail.com with your calendar Set Google Sheets ID: Replace the sheet ID with your contacts spreadsheet Modify System Message: Update the AI agent's instructions to match your preferences Adjust Memory Settings: Configure conversation memory window as needed 6. Test the Setup Activate the workflow Message your Telegram bot Verify all integrations are working Customization Options Change AI Model**: Switch between OpenAI models (GPT-3.5, GPT-4, etc.) Adjust Memory**: Modify conversation memory window length Add More Tools**: Integrate additional services like Notion, Slack, or weather APIs Modify Schedule**: Change when daily schedule emails are sent Customize Responses**: Update the system message to change assistant personality Important Notes Privacy**: This bot has access to your calendar, contacts, and email - ensure proper security API Costs**: OpenAI and SerpAPI usage will incur costs based on usage Rate Limits**: Be aware of API rate limits for each service Security**: Use environment variables for sensitive credentials Troubleshooting Bot not responding**: Check Telegram credentials and webhook configuration Calendar access issues**: Verify Google Calendar API permissions Email not sending**: Confirm Gmail API scopes include send permissions Memory not working**: Check that session keys are properly configured Support For issues with this template, check: n8n Community Forum Individual API service documentation Google Cloud Console for API errors OpenAI usage dashboard for model issues

Live Demo Booking Form with Outlook Calendar and Zoom link Who’s it for This workflow is designed for SaaS companies, consultants, or sales teams that regularly run live demos. It helps automate demo scheduling, ensuring clients can only book from available time slots while instantly generating Zoom links and calendar invitations. How it works / What it does Client fills demo request form → Collects company, contact details, and a preferred date. Check Outlook calendar availability → Searches for pre-created “Online Meeting Slot” events. Time slot selection → If the date has slots, the client chooses from up to 3 nearest available times. If not, they’re asked to pick another date. Create Zoom meeting → Once a date & time are confirmed, a Zoom link is automatically generated. Update Outlook calendar → The chosen slot is updated with the client’s details and Zoom link, marked as “Booked Live Demo” so it can’t be double-booked. Send confirmation → The client receives a styled confirmation screen, and both parties get the calendar invite. How to set up Import the workflow JSON into your n8n instance. Configure the following credentials: Microsoft Outlook OAuth2 API (for calendar access). Zoom OAuth2 API (for automatic meeting creation). Pre-create “Online Meeting Slot” events in your Outlook calendar to define available demo times. Publish the form via n8n’s webhook URL (embed it in your website or share the link). Test by submitting a request to ensure slots update correctly and Zoom links are created. Requirements n8n self-hosted or cloud account. Microsoft Outlook account with calendar access. Zoom account with OAuth2 credentials. Pre-created calendar slots named “Online Meeting Slot”. How to customize the workflow Form fields**: Adjust the client details form to capture additional data (e.g., industry, product interest). Email/notification**: Add an Email or Slack node to notify your sales team of new demo bookings. Custom branding**: Update the CSS in the form nodes to match your company’s style. Capacity rules**: Modify the IF nodes to limit the number of bookings per day or adjust the slot-checking logic.

Who this is for This workflow is built for recruiters, HR professionals, talent acquisition teams, and AI-powered recruitment startups who need to analyze LinkedIn profiles at scale. It’s ideal for anyone looking to turn raw LinkedIn data into structured, ATS-ready candidate profiles and summarized professional insights automatically. What problem this workflow solves Recruiters spend countless hours manually reviewing LinkedIn profiles, extracting details like experience, skills, education, and crafting summaries for ATS or reporting. This process is time-consuming, inconsistent, and error-prone. This workflow automates that process — from profile scraping to data structuring and AI-driven summarization, allowing recruiters to instantly generate standardized talent profiles. What this workflow does The workflow integrates Decodo, Google Gemini, and Google Sheets to perform automated LinkedIn talent profiling. Here’s how it works step-by-step: Input Setup The workflow begins when the user executes it manually or passes a LinkedIn profile URL. The input includes url (LinkedIn profile link) and geo (location, e.g., India). Profile Extraction with Decodo The Decodo node scrapes structured data from the LinkedIn profile (headline, experience, skills, education, etc.). Output: Detailed text-based content of the LinkedIn profile. AI Processing and Enrichment (Google Gemini) Structured Data Extractor Node parses the scraped data into JSON Resume Schema using Gemini AI. The Summarize Content Node uses Gemini AI to produce a short, professional summary of the candidate’s profile. The two Gemini nodes ensure both structured and human-readable data formats are available. 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 profile 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. This creates a live repository of candidate profiles with summaries for quick access or ATS integration. End Output A unified, machine-readable profile in JSON + an executive-level summary suitable for HR review 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 LinkedIn 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 Bulk Profile Input** Connect the “Set Input” node to a Google Sheet or CSV input for batch LinkedIn URLs. Alternate Output Format** Instead of Google Sheets, connect to Notion, Airtable, or PostgreSQL for centralized profile databases. Advanced Summaries** Modify the Summarize Content Gemini prompt to generate more specialized summaries — e.g., "Leadership Potential Summary" or "Technical Fit Analysis" Resume Comparison Feature** Add another Gemini node to compare a candidate’s profile against a job description and output a fit score or gap analysis. Notification Integration** Use Slack or Gmail nodes to send alerts when a new candidate summary is generated. Language Localization** Add a language detection step before summarization to support multilingual summaries. Summary The Automated LinkedIn Talent Profiling & Summary via Decodo + Google Gemini workflow streamlines recruitment intelligence by automating every step of LinkedIn profile research: Scraping (via Decodo) Structuring (via Gemini JSON Extraction) Summarizing (via Gemini Summarizer) Storing results (in Google Sheets) This workflow empowers recruiters to analyze hundreds of profiles within minutes, ensuring data consistency, faster candidate evaluation, and smarter hiring decisions — powered by Bright Data scraping intelligence and Google Gemini’s AI reasoning.

GPT-4o Resume Screener with Error Handling - Google Sheets & Drive Pipeline How it works Enterprise-grade resume screening automation built for production environments. This workflow combines intelligent AI analysis with comprehensive error handling to ensure reliable processing of candidate applications. Every potential failure point is monitored with automatic recovery and notification systems. Core workflow steps: Intelligent Email Processing - Monitors Gmail with attachment validation and file type detection Robust File Handling - Multi-format support with upload verification and extraction validation Quality-Controlled AI Analysis - GPT-4o evaluation with output validation and fallback mechanisms Verified Data Extraction - Contact and qualification extraction with data integrity checks Dual Logging System - Success tracking in main dashboard, error logging in separate audit trail Error Recovery Features: Upload failure detection with retry mechanisms Text extraction validation with quality thresholds AI processing timeout protection and fallback responses Data validation before final logging Comprehensive error notification and tracking system Set up steps Total setup time: 25-35 minutes Core Credentials Setup (8 minutes) Gmail OAuth2 with attachment permissions Google Drive API with folder creation rights Google Sheets API with read/write access OpenAI API key with GPT-4o model access Primary Configuration (12 minutes) Configure monitoring systems - Set up Gmail trigger with error detection Establish file processing pipeline - Create Drive folders for resumes and configure upload validation Deploy dual spreadsheet system - Set up main tracking sheet and error logging sheet Initialize AI processing - Configure GPT-4o with structured output parsing and timeout settings Customize job requirements - Update role specifications and scoring criteria Error Handling Setup (10 minutes) Configure error notifications - Set administrator email for failure alerts Set up error logging spreadsheet - Create audit trail for failed processing attempts Customize timeout settings - Adjust processing limits based on expected file sizes Test error pathways - Validate notification system with sample failures Advanced Customization (5 minutes) Modify validation thresholds for resume quality Adjust AI prompt for industry-specific requirements Configure custom error messages and escalation rules Set up automated retry logic for transient failures Production-Ready Features: Comprehensive logging for compliance and auditing Graceful degradation when services are temporarily unavailable Detailed error context for troubleshooting Scalable architecture for high-volume processing Template Features Enterprise Error Management Multi-layer validation at every processing stage Automatic error categorization and routing Administrative alerts with detailed context Separate error logging for audit compliance Timeout protection preventing workflow hangs Advanced File Processing Upload success verification before processing Text extraction quality validation Resume content quality thresholds Corrupted file detection and handling Format conversion error recovery Robust AI Integration GPT-4o processing with output validation Structured response parsing with error checking AI timeout protection and fallback responses Failed analysis logging with manual review triggers Retry logic for transient API failures Production Monitoring Real-time error notifications via email Comprehensive error logging dashboard Processing success/failure metrics Failed resume tracking for manual review Audit trail for compliance requirements Data Integrity Controls Pre-logging validation of all extracted data Missing information detection and flagging Contact information verification checks Score validation and boundary enforcement Duplicate detection and handling Designed for HR departments and recruiting agencies that need reliable, scalable resume processing with enterprise-level monitoring and error recovery capabilities.

This workflow is designed to automatically process AI news emails, extract and summarize articles, categorize them, and store the results in a structured Google Sheet for daily tracking and insights. This automated workflow processes a daily AI newsletter from AlphaSignal, extracting individual articles, summarizing them, categorizing them, and saving the results to a Google Sheet. Key Features 1. ✅ Fully Automated Daily News Pipeline No manual work is required — the workflow runs autonomously every time a new email arrives. This eliminates repetitive human tasks such as opening, reading, and summarizing newsletters. 2. ✅ Cross-AI Model Integration It combines multiple AI systems: Google Gemini* and *OpenAI GPT-5 Mini** for natural language processing and categorization. Scrapegraph AI** for external web scraping and summarization. This multi-model approach enhances accuracy and flexibility. 3. ✅ Accurate Content Structuring The workflow transforms unstructured email text into clean, structured JSON data, ensuring reliability and easy export or reuse. 4. ✅ Multi-Language Support The summaries are generated in Italian, which is ideal for local or internal reporting, while the metadata and logic remain in English — enabling global adaptability. 5. ✅ Scalable and Extensible New newsletters, categories, or destinations (like Notion, Slack, or a database) can be added easily without changing the core logic. 6. ✅ Centralized Knowledge Repository By appending to Google Sheets, the team can: Track daily AI developments at a glance. Filter or visualize trends across categories. Use the dataset for further analysis or content creation. 7. ✅ Error-Resilient and Maintainable The JSON validation and loop-based design ensure that if a single article fails, the rest continue to process smoothly. How it Works Email Trigger & Processing: The workflow is automatically triggered when a new email arrives from news@alphasignal.ai. It retrieves the full email content and converts its HTML body into clean Markdown format for easier parsing. Article Extraction & Scraping: A LangChain Agent, powered by Google Gemini, analyzes the newsletter's Markdown text. Its task is to identify and split the content into individual articles. For each article it finds, it outputs a JSON object containing the title, URL, and an initial summary. Crucially, the agent uses the "Scrape" tool to visit each article's URL and generate a more accurate summary in Italian based on the full page content. Data Preparation & Categorization: The JSON output from the previous step is validated and split into individual data items (one per article). Each article is then processed in a loop: Categorization: An OpenAI model analyzes the article's title and summary, assigning it to the most relevant pre-defined category (e.g., "LLM & Foundation Models," "AI Automation & WF"). URL Shortening: The article's link is sent to the CleanURI API to generate a shortened URL. Data Storage: Finally, for each article, a new row is appended to a specified Google Sheet. The row includes the current date, the article's title, the shortened link, the Italian summary, and its assigned category. Set up Steps To implement this workflow, you need to configure the following credentials and nodes in n8n: Email Credentials: Set up a Gmail OAuth2 credential (named "Gmail account" in the workflow) to allow n8n to access and read emails from the specified inbox. AI Model APIs: Google Gemini: Configure the "Google Gemini(PaLM)" credential with a valid API key to power the initial article extraction and scraping agent. OpenAI: Configure the "OpenAi account (Eure)" credential with a valid API key to power the article categorization step. Scraping Tool: Set up the ScrapegraphAI account credential with its required API key to enable the agent to access and scrape content from the article URLs. Google Sheets Destination: Configure the "Google Sheets account" credential via OAuth2. You must also specify the exact Google Sheet ID and sheet name (tab) where the processed article data will be stored. Activation: Once all credentials are tested and correctly configured, the workflow can be activated. It will then run automatically upon receiving a new newsletter from the specified sender. Need help customizing? Contact me for consulting and support or add me on Linkedin.