Google Sheets and Hunter integration

AI-Powered Automated Proposal & Lead Management System This advanced n8n workflow automates the transition from "Raw Lead" to "Sent Proposal." By integrating Email Verification, Large Language Models (LLMs), and Document Automation, it eliminates manual data entry and ensures that every proposal sent is personalized, professional, and delivered to a verified address. 🛠️ How It Works Data Intake & Validation The workflow is triggered via a Webhook. Before any processing occurs, the data passes through the Hunter node, which performs a real-time email verification check. Smart Error Handling: An If Node evaluates the verification result. If the email is invalid or "risky," the workflow redirects to a Respond to Webhook node, providing immediate feedback to the source and preventing wasted API credits on downstream nodes. The AI Agent Layer Once validated, the data reaches the Set Fields node to be mapped for the AI. Custom Prompt Logic: The AI Agent node, powered by Google Gemini, contains a sophisticated custom prompt. This prompt acts as a "template engine," instructing the AI to take specific input variables (like client name, project scope, and budget) and output a clean, professional HTML structure. This allows for dynamic content generation that adapts to the unique context of every lead. Professional PDF Generation Instead of sending a plain text email, the workflow passes the AI-generated HTML to the PDF Generator API. This tool renders the code into a high-quality, brand-consistent PDF document ready for client viewing. Automated Delivery & CRM Logging Gmail Integration: The final PDF is automatically attached and sent to the verified email address with a personalized message. Google Sheets Logging: To ensure full visibility, the workflow appends a row to a Google Sheet, tracking the date, client details, and the status of the sent proposal. 📋 Requirements To run this workflow, you will need active accounts and API credentials for the following services: n8n Instance: (Self-hosted or Cloud). Hunter.io API: For the email verification node. Google Gemini API: To power the AI Agent and custom prompt. PDF Generator API: To convert the AI's HTML output into documents. Google Workspace Account: Required for the Gmail (Sending) and Google Sheets (Logging) nodes. ⚙️ How to Set Up Follow these steps to get the workflow operational: Import the Workflow: Download the JSON file and paste it into your n8n canvas. Configure Credentials: Connect your Hunter API key. Set up your Google Gemini credentials (via Google Cloud Console). Add your PDF Generator API key. Authenticate your Google Account (OAuth2) for Gmail and Google Sheets. Customize the AI Prompt: Open the AI Agent node. Under the "System Message" or "Prompt" section, adjust the HTML template to match your brand's style and the specific fields you want to include in your proposal. Map your Google Sheet: Open the Append row in sheet node and select the specific spreadsheet and worksheet where you want to log your leads. Test the Flow: Use the Webhook simulator (Example DATA) to send a test payload and verify that the PDF is generated and the email is sent correctly.

📺 Full walkthrough video: https://youtu.be/uk-mJRgYnfs Who it's for This workflow is for sales teams, marketers, and PR professionals who need to bulk-enrich a list of company domains with contact data (emails, names, job titles, LinkedIn profiles) and export the results to a spreadsheet for outreach or prospecting. How it works The workflow is triggered manually by clicking Execute workflow in the n8n editor. It reads a list of domain URLs from a source tab in a Google Sheet. Each domain is passed one by one to the Hunter.io Domain Search API, which returns up to 10 associated contacts per domain, including email address, confidence score, full name, job title, seniority, department, LinkedIn, Twitter, and phone number. Each contact record returned by Hunter is appended as a new row in a separate Exported data tab of the same Google Sheet. How to set up [ ] Connect your Google account credentials to both the Read Domain Sheet and Append to Exported Data Sheet nodes [ ] Set the correct Google Sheet ID and source tab name containing your domain URLs in Read Domain Sheet [ ] Set the correct Google Sheet ID and destination tab name in Append to Exported Data Sheet [ ] Add your Hunter.io API key to the Lookup Domain via Hunter node [ ] Ensure the source sheet has a column named Domain URL Requirements Google account with access to Google Sheets Hunter.io account with a valid API key How to customize Replace the manual trigger with a Schedule Trigger to run the enrichment pipeline automatically (e.g., every morning). Add a Filter node between Hunter and the output sheet to only export contacts above a minimum confidence score (e.g., ≥ 80). Insert a Set node to rename, reformat, or add calculated fields (e.g., a combined full-name column) before writing to the sheet.

Streamline your email list hygiene with this automated validation workflow that monitors Google Sheets for new email entries and instantly verifies their deliverability. Perfect for maintaining clean contact databases, reducing bounce rates, and ensuring successful email marketing campaigns. Key Features 📊 Real-Time Processing Monitors Google Sheets for new email entries every minute Automatic validation triggers when emails are added Instant deliverability status updates in the same spreadsheet 🔍 Dual Validation Sources Hunter.io API for comprehensive email verification EmailValidation.io API as backup validation service Cross-verification for higher accuracy ✅ Smart Filtering Skips empty email cells to prevent unnecessary API calls Processes only valid email formats Handles bulk email list uploads efficiently 📈 Seamless Integration Updates original spreadsheet with validation results Preserves existing data while adding deliverability status No manual intervention required after setup Workflow Components Processing Flow: Google Sheets Trigger monitors for new rows Filter removes empty email entries Email extraction and formatting Dual API validation (Hunter + EmailValidation.io) Status processing and formatting Automatic spreadsheet updates Use Cases Email Marketing: Clean lists before campaigns Lead Generation: Validate new prospect emails Database Maintenance: Regular email hygiene checks CRM Integration: Ensure contact data quality Setup Requirements Required: Google Sheets with email column Hunter.io API key EmailValidation.io API key Google Sheets OAuth2 credentials Benefits: Reduce email bounce rates Improve sender reputation Save costs on invalid email sends Maintain clean contact databases This workflow transforms manual email validation into an automated process, ensuring your email lists stay clean and deliverable without any manual effort. Tags: email-validation, google-sheets, hunter-io, data-cleaning, automation

Use this template if you’re collecting leads in Google Sheets manually or automatically and need to send them emails daily using any personal or professional email provider. It’s simple yet effective. I’ve kept it easy so that anyone without technical or coding knowledge can still automate their emails and achieve excellent ROI. Setting up the workflow takes only 15 minutes. How it works: We connect Google Sheets with n8n to automatically fetch lead data. Google Sheets is used because it’s easy and widely accessible. Then, n8n sends emails daily at your scheduled times to the respective email addresses, using the subject lines and body text you've configured. It also verifies emails before sending. It checks email availability, deliverability, and updates the Google Sheet/CRM with the respective fields. Requirements: A Google Sheet/Excel/CRM tools with leads (A sample Google Sheet link is provided in the template) A working email account with SMTP information (SMTP info for the top 10 email providers is provided in the template) API key from any email verification tool (We use the Hunter API key in our use case. You can find the link in the template.) Setup Steps: You need a Google Sheet where you're collecting leads. You can replace Google Sheets with your CRM tool. Connect it using your credentials. Replace the manual trigger with a scheduled trigger to automate emails at your preferred time. Replace the email verification tool/Hunter API with your own API key. Add your SMTP credentials to connect the template with your preferred email provider. Using SMTP, you can send emails through Gmail, Outlook, Zoho, or any similar provider. This makes sending emails simple and cost-efficient. Note: SMTP, which stands for Simple Mail Transfer Protocol, is a communication protocol used to send email messages between mail servers. After sending the email, we update the Google Sheet with “Sent”; hence, the email is not sent again the next day.

How It Works ⚙️ Imagine a relentless, intelligent sales assistant working for you 24/7. That's exactly what this system is. It takes the grueling, manual work of outreach and transforms it into a precision-guided, automated process that wins clients. Your Target Identified & Profiled: You simply tell the system who you're looking for. Our first AI brain dives deep, scouring LinkedIn and the web to find your ideal prospects, pulling in every crucial detail about them – from their recent posts to their company's latest moves. No more endless searching. Hyper-Personalized Messages, Crafted Just For Them: This is where the magic happens. A series of smart AI agents take all that rich data and write your emails. They craft opening lines that instantly grab attention by referencing something specific to your prospect. They tailor your value proposition to hit their exact pain points. They even generate subject lines that get opened and calls-to-action that get clicked. It feels like you wrote every email by hand, but it's all automatic. Strategic Multi-Touch Outreach: Your perfectly crafted email goes out. Then, the system intelligently tracks engagement. If there's no reply, it doesn't give up. It automatically sends follow-ups, each one uniquely generated by AI to re-engage, adding new value or a gentle nudge, until you get that crucial response. Your Pipeline, Optimized: Every action is logged in your database. You see exactly who's been contacted, their status, and when the next touchpoint is. This isn't just sending emails; it's building a predictable, efficient revenue machine that fuels your growth without you lifting a finger. This system isn't just automating tasks; it's automating revenue. Setup Steps 🛠️ Getting this powerhouse running is straightforward. Follow these steps, and you'll be on your way to revolutionizing your outreach. Prep Your Prospect List & Database: Start with a simple list of your target prospects (Company Name, Website, Prospect Name, LinkedIn URL). Create a clean Google Sheet (or Airtable base) to serve as your central database. Set up columns for everything: Name, Email, Company, LinkedIn URL, Status, Follow-Up Count, etc. This is where all the magic gets tracked. Get Your Digital Tools Ready: Apify API Key: You'll need an Apify account and an API key for the powerful LinkedIn scraping. Hunter.io API Key: Secure your Hunter.io API key to accurately find professional email addresses. OpenAI API Key: This is the brain behind the operation. Get your OpenAI API key for GPT-4 access. Gmail / SendGrid / Your Email Service Credentials: Connect your email sending platform so the system can fire off those personalized messages. Slack Credentials (Optional): If you want your team to get instant notifications about replies, have your Slack bot token ready. Build Your Report Template (Google Docs): Create a Google Docs template for any reports or internal summaries you might want to generate. You'll add special placeholders ({{ }} ) where the AI will inject data. Import & Connect: Import the n8n workflow JSON (you'll get this from us!). Connect all your prepared credentials inside n8n. It’s like plugging in the power cords for your new sales machine. Customize Your Strategy: Refine the AI Prompts: This is key! Tweak the OpenAI nodes' instructions to perfectly match your brand voice, your unique value proposition, and the specific nuances of your outreach strategy. This is where you infuse your expertise into the AI. Adjust Follow-Up Timing: Decide how many days to wait between follow-ups and how many follow-ups you want to send. It's fully flexible. Launch & Watch It Work: Hit 'Save' and then 'Activate' your workflow. Run your first test with a few prospects. Watch as the system researches, crafts, sends, and tracks, all on autopilot. Stop leaving money on the table. This is your chance to automate your growth. Start building now!

Product Introduction: You can create a form on n8n through which you can collect leads from interested user's. You can also verify each user's email address to validate whether it's a valid email to make sure it lands on their inbox(suitable for those who have newletter / want's to send bulk email) The leads with valid email will then get saved as a leads with the relevant field data to gmail, google sheets and discord(through webhook). You can add/remove any integration you feel like. Setup Guide: Create Your Form: Begin by logging into your n8n account and navigating to the workflow editor. You can then customize your form fields to gather relevant information from your prospects, such as name, email address, and any additional data you require. Email Verification: After collecting the lead data, add an Email Verification node to validate each user's email address. This crucial step ensures that only genuine and deliverable email addresses are included in your lead database, maximizing the effectiveness of your outreach efforts. We have used hunter.io service in this, you can change it to any other service you need. Save Leads: Next, incorporate nodes to save your verified leads to various platforms for streamlined management. Utilize the Gmail node to store lead information directly in your Gmail account, ensuring easy access and organization. Additionally, leverage the Google Sheets node to archive lead data in a spreadsheet for comprehensive tracking and analysis. Integrate with Discord: For real-time notifications and collaboration, integrate n8n with Discord using the Webhook node. Configure the webhook to send lead information to your designated Discord channel, enabling your team to stay informed and coordinate effectively. Customize Integrations: Tailor your workflow by adding or removing integrations based on your specific requirements. Whether you prefer to connect with additional platforms or streamline your workflow further, n8n offers unparalleled flexibility to adapt to your business needs. Experience the simplicity and efficiency of n8n to revolutionize your lead generation strategy and propel your success to new heights.