HumationHuman + Automation
Back to Catalog

Email Verification and Enrichment from Google Sheets with Hunter and Dropcontact

Calvin CunninghamCalvin Cunningham
42 views
2/3/2026
User InputLead ManagementSalesforceData EntryCRM
Official Page

Description

This workflow automatically validates email addresses stored in a Google Sheet using Hunter Email Verifier, enriches the valid ones with Dropcontact, updates the sheet with verification and enrichment results, and sends a Slack summary showing total emails checked, valid emails, and enriched profiles.

It helps teams clean their data, improve outreach accuracy, and eliminate the manual effort of checking and researching email contacts one by one.

How It Works

  1. The workflow triggers whenever a new row is added or updated in your Google Sheet.
  2. It reads any emails that still need to be processed.
  3. Each email is validated using Hunter Email Verifier, which returns validity and a confidence score.
  4. Emails marked as valid and above the confidence threshold are enriched with Dropcontact to gather additional profile information, including:
    • Full name
    • Job title
    • Company
    • Domain
    • Country
  5. Invalid or low-confidence emails are marked as invalid and skipped.
  6. Verification and enrichment results are written back into the corresponding row in your Google Sheet.
  7. A Slack summary message is sent showing:
    • Total emails processed
    • Number of valid emails
    • Number of enriched profiles

Credential Requirements

  • Hunter Email Verifier: Required for the email validation step.
  • Dropcontact: Requires a business email address (non-Gmail, non-Outlook, non-Yahoo) to create an account and use their API.
  • Google Sheets: Required for reading and updating your contact list.
  • Slack: Required to send the summary notification.

Why This Is Helpful

  • Automates a repetitive and error-prone workflow.
  • Saves Dropcontact credits by enriching only valid, high-quality emails.
  • Improves data accuracy for outreach, lead generation, and CRM imports.
  • Keeps your Google Sheet updated with clean, structured verification and enrichment results.
  • Sends a summary to Slack so your team gets instant visibility without opening the sheet.
  • Ideal for teams preparing outbound lists, cleaning CRM data, or verifying large batches of emails before campaigns.

Customization Ideas

  • Add a second enrichment provider (such as Clearbit or People Data Labs) to fill in missing fields when Dropcontact does not return enough data.
  • Send enriched contacts to a CRM, such as HubSpot, Airtable, Pipedrive, or Notion, instead of keeping everything in Google Sheets.
  • Create separate Slack channels for valid vs. invalid contacts to help teams prioritize follow-up.
  • Add quality tiers by creating categories such as "High Confidence," "Medium Confidence," and "Low Confidence" based on the verification score.
  • Auto-tag enriched leads with fields like industry, employee count, or revenue if you integrate additional enrichment sources.
  • Trigger this workflow nightly using a Schedule node if you want to process batches instead of reacting to row updates.
  • Automatically send outreach emails to enriched leads using Gmail, Outlook, or Resend, after adding a safety check or approval step.
  • Export enriched contacts to CSV or Google Drive for easy sharing with other teams.
  • Add duplicate detection logic to avoid enriching the same contact multiple times.
  • Add a notification for “no enrichments found” so your team knows when Dropcontact fails to return details.

Email Verification and Enrichment from Airtable with AI, Hunter, and Dropcontact

This n8n workflow automates the process of verifying and enriching email addresses sourced from an Airtable base. It leverages AI for initial email validation, then uses Hunter.io and Dropcontact for comprehensive email verification and data enrichment, and finally sends a summary email.

What it does

  1. Triggers from Airtable: Listens for new or updated records in a specified Airtable base.
  2. Validates Email with AI: Uses an AI Agent (powered by an OpenAI Chat Model) to perform an initial check on the email address for basic validity.
  3. Filters Valid Emails: Routes only the emails deemed potentially valid by the AI to the next steps.
  4. Enriches and Verifies with Hunter.io (Placeholder): (Implied, but not explicitly present in the provided JSON) This step would typically use Hunter.io to verify the email's deliverability and find additional contact information.
  5. Enriches and Verifies with Dropcontact (Placeholder): (Implied, but not explicitly present in the provided JSON) This step would typically use Dropcontact for deep email verification and enrichment with company and contact data.
  6. Updates Airtable (Placeholder): (Implied, but not explicitly present in the provided JSON) Updates the original Airtable record with the verification status and enriched data.
  7. Sends Summary Email: Notifies a specified recipient via Gmail about the completion of the verification and enrichment process, including details of the processed emails.
  8. Waits (Optional): Includes a Wait node, which can be configured to pause the workflow for a specified duration, potentially to manage API rate limits or introduce a delay.
  9. Handles Invalid Emails: Routes invalid emails to a separate path, which could be used for logging or further processing.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance.
  • Airtable Account: Access to an Airtable base with records containing email addresses.
  • OpenAI Account: An OpenAI API key for the AI Agent.
  • Hunter.io Account: (Implied) An API key for Hunter.io (if this functionality is added).
  • Dropcontact Account: (Implied) An API key for Dropcontact (if this functionality is added).
  • Gmail Account: A configured Gmail credential in n8n for sending notification emails.

Setup/Usage

  1. Import the workflow: Download the JSON and import it into your n8n instance.
  2. Configure Airtable Trigger:
    • Set up your Airtable credential.
    • Specify the Base ID and Table Name from which to trigger the workflow.
    • Configure the trigger to listen for new records or updates to a specific field (e.g., an "Email" field).
  3. Configure AI Agent:
    • Set up your OpenAI credential.
    • Ensure the AI Agent is configured to process the email field from the Airtable input and return a boolean or string indicating validity.
  4. Configure Gmail Node:
    • Set up your Gmail credential.
    • Specify the recipient email address for notifications.
    • Customize the subject and body of the email to include relevant details from the workflow execution.
  5. (Optional) Configure Wait Node: Adjust the wait duration if needed.
  6. Activate the workflow: Once all credentials and configurations are set, activate the workflow. It will now automatically process records from your Airtable base.

Related Templates

Generate song lyrics and music from text prompts using OpenAI and Fal.ai Minimax

Spark your creativity instantly in any chat—turn a simple prompt like "heartbreak ballad" into original, full-length lyrics and a professional AI-generated music track, all without leaving your conversation. 📋 What This Template Does This chat-triggered workflow harnesses AI to generate detailed, genre-matched song lyrics (at least 600 characters) from user messages, then queues them for music synthesis via Fal.ai's minimax-music model. It polls asynchronously until the track is ready, delivering lyrics and audio URL back in chat. Crafts original, structured lyrics with verses, choruses, and bridges using OpenAI Submits to Fal.ai for melody, instrumentation, and vocals aligned to the style Handles long-running generations with smart looping and status checks Returns complete song package (lyrics + audio link) for seamless sharing 🔧 Prerequisites n8n account (self-hosted or cloud with chat integration enabled) OpenAI account with API access for GPT models Fal.ai account for AI music generation 🔑 Required Credentials OpenAI API Setup Go to platform.openai.com → API keys (sidebar) Click "Create new secret key" → Name it (e.g., "n8n Songwriter") Copy the key and add to n8n as "OpenAI API" credential type Test by sending a simple chat completion request Fal.ai HTTP Header Auth Setup Sign up at fal.ai → Dashboard → API Keys Generate a new API key → Copy it In n8n, create "HTTP Header Auth" credential: Name="Fal.ai", Header Name="Authorization", Header Value="Key [Your API Key]" Test with a simple GET to their queue endpoint (e.g., /status) ⚙️ Configuration Steps Import the workflow JSON into your n8n instance Assign OpenAI API credentials to the "OpenAI Chat Model" node Assign Fal.ai HTTP Header Auth to the "Generate Music Track", "Check Generation Status", and "Fetch Final Result" nodes Activate the workflow—chat trigger will appear in your n8n chat interface Test by messaging: "Create an upbeat pop song about road trips" 🎯 Use Cases Content Creators: YouTubers generating custom jingles for videos on the fly, streamlining production from idea to audio export Educators: Music teachers using chat prompts to create era-specific folk tunes for classroom discussions, fostering interactive learning Gift Personalization: Friends crafting anniversary R&B tracks from shared memories via quick chats, delivering emotional audio surprises Artist Brainstorming: Songwriters prototyping hip-hop beats in real-time during sessions, accelerating collaboration and iteration ⚠️ Troubleshooting Invalid JSON from AI Agent: Ensure the system prompt stresses valid JSON; test the agent standalone with a sample query Music Generation Fails (401/403): Verify Fal.ai API key has minimax-music access; check usage quotas in dashboard Status Polling Loops Indefinitely: Bump wait time to 45-60s for complex tracks; inspect fal.ai queue logs for bottlenecks Lyrics Under 600 Characters: Tweak agent prompt to enforce fuller structures like [V1][C][V2][B][C]; verify output length in executions

Daniel NkenchoBy Daniel Nkencho
601

Synchronizing WooCommerce inventory and creating products with Google Gemini AI and BrowserAct

Synchronize WooCommerce Inventory & Create Products with Gemini AI & BrowserAct This sophisticated n8n template automates WooCommerce inventory management by scraping supplier data, updating existing products, and intelligently creating new ones with AI-formatted descriptions. This workflow is essential for e-commerce operators, dropshippers, and inventory managers who need to ensure their product pricing and stock levels are synchronized with multiple third-party suppliers, minimizing overselling and maximizing profit. --- Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. --- How it works The workflow is typically run by a Schedule Trigger (though a Manual Trigger is also shown) to check stock automatically. It reads a list of suppliers and their inventory page URLs from a central Google Sheet. The workflow loops through each supplier: A BrowserAct node scrapes the current stock and price data from the supplier's inventory page. A Code node parses this bulk data into individual product items. It then loops through each individual product found. The workflow checks WooCommerce to see if the product already exists based on its name. If the product exists: It proceeds to update the existing product's price and stock quantity. If the product DOES NOT exist: An If node checks if the missing product's category matches a predefined type (optional filtering). If it passes the filter, a second BrowserAct workflow scrapes detailed product attributes from a dedicated product page (e.g., DigiKey). An AI Agent (Gemini) transforms these attributes into a specific, styled HTML table for the product description. Finally, the product is created in WooCommerce with all scraped details and the AI-generated description. Error Handling: Multiple Slack nodes are configured to alert your team immediately if any scraping task fails or if the product update/creation process encounters an issue. Note: This workflow does not support image uploads for new products. To enable this functionality, you must modify both the n8n and BrowserAct workflows. --- Requirements BrowserAct API account for web scraping BrowserAct n8n Community Node -> (n8n Nodes BrowserAct) BrowserAct templates named “WooCommerce Inventory & Stock Synchronization” and “WooCommerce Product Data Reconciliation” Google Sheets credentials for the supplier list WooCommerce credentials for product management Google Gemini account for the AI Agent Slack credentials for error alerts --- Need Help? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates How to Use the BrowserAct N8N Community Node --- Workflow Guidance and Showcase STOP Overselling! Auto-Sync WooCommerce Inventory from ANY Supplier

Madame AI Team | KaiBy Madame AI Team | Kai
600

Tax deadline management & compliance alerts with GPT-4, Google Sheets & Slack

AI-Driven Tax Compliance & Deadline Management System Description Automate tax deadline monitoring with AI-powered insights. This workflow checks your tax calendar daily at 8 AM, uses GPT-4 to analyze upcoming deadlines across multiple jurisdictions, detects overdue and critical items, and sends intelligent alerts via email and Slack only when immediate action is required. Perfect for finance teams and accounting firms who need proactive compliance management without manual tracking. 🏛️🤖📊 Good to Know AI-Powered: GPT-4 provides risk assessment and strategic recommendations Multi-Jurisdiction: Handles Federal, State, and Local tax requirements automatically Smart Alerts: Only notifies executives when deadlines are overdue or critical (≤3 days) Priority Classification: Categorizes deadlines as Overdue, Critical, High, or Medium priority Dual Notifications: Critical alerts to leadership + daily summaries to team channel Complete Audit Trail: Logs all checks and deadlines to Google Sheets for compliance records How It Works Daily Trigger - Runs at 8:00 AM every morning Fetch Data - Pulls tax calendar and company configuration from Google Sheets Analyze Deadlines - Calculates days remaining, filters by jurisdiction/entity type, categorizes by priority AI Analysis - GPT-4 provides strategic insights and risk assessment on upcoming deadlines Smart Routing - Only sends alerts if overdue or critical deadlines exist Critical Alerts - HTML email to executives + Slack alert for urgent items Team Updates - Slack summary to finance channel with all upcoming deadlines Logging - Records compliance check results to Google Sheets for audit trail Requirements Google Sheets Structure Sheet 1: TaxCalendar DeadlineID | DeadlineName | DeadlineDate | Jurisdiction | Category | AssignedTo | IsActive FED-Q1 | Form 1120 Q1 | 2025-04-15 | Federal | Income | John Doe | TRUE Sheet 2: CompanyConfig (single row) Jurisdictions | EntityType | FiscalYearEnd Federal, California | Corporation | 12-31 Sheet 3: ComplianceLog (auto-populated) Date | AlertLevel | TotalUpcoming | CriticalCount | OverdueCount 2025-01-15 | HIGH | 12 | 3 | 1 Credentials Needed Google Sheets - Service Account OAuth2 OpenAI - API Key (GPT-4 access required) SMTP - Email account for sending alerts Slack - Bot Token with chat:write permission Setup Steps Import workflow JSON into n8n Add all 4 credentials Replace these placeholders: YOURTAXCALENDAR_ID - Tax calendar sheet ID YOURCONFIGID - Company config sheet ID YOURLOGID - Compliance log sheet ID C12345678 - Slack channel ID tax@company.com - Sender email cfo@company.com - Recipient email Share all sheets with Google service account email Invite Slack bot to channels Test workflow manually Activate the trigger Customizing This Workflow Change Alert Thresholds: Edit "Analyze Deadlines" node: Critical: Change <= 3 to <= 5 for 5-day warning High: Change <= 7 to <= 14 for 2-week notice Medium: Change <= 30 to <= 60 for 2-month lookout Adjust Schedule: Edit "Daily Tax Check" trigger: Change hour/minute for different run time Add multiple trigger times for tax season (8 AM, 2 PM, 6 PM) Add More Recipients: Edit "Send Email" node: To: cfo@company.com, director@company.com CC: accounting@company.com BCC: archive@company.com Customize Email Design: Edit "Format Email" node to change colors, add logo, or modify layout Add SMS Alerts: Insert Twilio node after "Is Critical" for emergency notifications Integrate Task Management: Add HTTP Request node to create tasks in Asana/Jira for critical deadlines Troubleshooting | Issue | Solution | |-------|----------| | No deadlines found | Check date format (YYYY-MM-DD) and IsActive = TRUE | | AI analysis failed | Verify OpenAI API key and account credits | | Email not sending | Test SMTP credentials and check if critical condition met | | Slack not posting | Invite bot to channel and verify channel ID format | | Permission denied | Share Google Sheets with service account email | 📞 Professional Services Need help with implementation or customization? Our team offers: 🎯 Custom workflow development 🏢 Enterprise deployment support 🎓 Team training sessions 🔧 Ongoing maintenance 📊 Custom reporting & dashboards 🔗 Additional API integrations Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
93