Verify generic business emails across multiple domains with EmailListVerify and Google Sheets
Who is this template for?
Growth teams and SDR targeting small companies.
In small companies, it is common for the founder to monitor the contact@ email, so generic emails can give you good results.
What problem does this workflow solve?
Get from a list of domain names to a list of email addresses.
This workflow allows you to choose which email pattern you are looking for. So you can use it to find function emails like hr@ or accounting@. This is a great way to get in touch with your ICP.
What this workflow does
Think workflow will:
- Generate email candidates based on the domain name and root you are providing
- Check if those email addresses are valid using EmailListVerify
Requirement
This template uses: Google Sheet to handle input and output data EmailListVerify to discover email (from $0.05 per email)
Setup (10 minutes)
1: Make a copy of the GoogleSheet template 2: In "[Input] pattern" sheet, write the root email you want to check, like contact or accounting 3: In "[Input] domain", put the domain for which you want to find email addresses. Write the domain without http or www in front. 4: Add your EmailListVerify API key to setting to the 3rd step 5: Update Google Sheet node to point to your copy of the template 6: Trigger the workflow
Verify Generic Business Emails Across Multiple Domains
This n8n workflow provides a framework for verifying business emails across multiple domains. It's designed to be a starting point for integrating with an email verification service, reading data from Google Sheets, and processing it.
What it does
This workflow outlines the following steps:
- Manual Trigger: The workflow is initiated manually, allowing for on-demand execution.
- Google Sheets Integration: It includes a Google Sheets node, indicating an intention to read email data from or write verification results to a Google Sheet.
- HTTP Request: An HTTP Request node is present, suggesting an external API call will be made, likely to an email verification service (e.g., EmailListVerify, as hinted by the directory name).
- Merge Data: A Merge node is included, implying that data from different sources or different stages of the verification process will be combined.
- Sticky Note: A sticky note is included for documentation or instructions within the workflow.
Prerequisites/Requirements
To use this workflow effectively, you will need:
- n8n Instance: A running n8n instance.
- Google Sheets Account: Configured with credentials in n8n.
- Email Verification Service: An account and API key for an email verification service (e.g., EmailListVerify, ZeroBounce, Hunter.io, etc.). The HTTP Request node will need to be configured with the specific API endpoint and authentication details for your chosen service.
Setup/Usage
- Import the workflow: Import the provided JSON into your n8n instance.
- Configure Google Sheets:
- Add your Google Sheets credentials to the "Google Sheets" node.
- Specify the Spreadsheet ID and Sheet Name from which you intend to read emails or where you want to write results.
- Configure HTTP Request:
- Edit the "HTTP Request" node.
- Set the
URLto the endpoint of your chosen email verification service. - Configure the
Method(e.g., GET, POST) andHeaders(e.g.,Authorizationwith your API key) as required by the service's API documentation. - Map the email addresses from the Google Sheets output to the request body or query parameters as needed by the email verification API.
- Configure Merge (if needed): Adjust the "Merge" node's settings based on how you want to combine the original Google Sheets data with the verification results.
- Extend the workflow: This workflow is a starting point. You will likely want to add nodes for:
- Data transformation: To extract email addresses from your Google Sheet data before sending them to the verification service.
- Error handling: To manage failed API calls or invalid email responses.
- Writing results back: To update your Google Sheet with the verification status (e.g., valid, invalid, risky).
- Filtering: To process only certain types of emails or verification results.
- Execute the workflow: Click the "Execute workflow" button to run it manually.
Related Templates
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.
Daily cash flow reports with Google Sheets, Slack & Email for finance teams
Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us
Client review collection & sentiment analysis with HighLevel, GPT-4o, Gmail & Slack
📘 Description: This automation streamlines client review collection and sentiment summarization for Techdome using HighLevel CRM, Azure OpenAI GPT-4o, Gmail, Slack, and Google Sheets. It starts by pulling recently won deals from HighLevel, then generates and sends AI-written HTML review request emails with built-in Google Review and feedback form links. After waiting 24 hours, it fetches the client’s reply thread, summarizes the sentiment using GPT-4o, and posts a clean update to Slack for team visibility. Any failures—API errors, empty responses, or data validation issues—are logged automatically to Google Sheets for full transparency and QA. The result: a fully hands-free Client Appreciation + Feedback Intelligence Loop, improving brand perception and internal responsiveness. ⚙️ What This Workflow Does (Step-by-Step) ▶️ When Clicking ‘Execute Workflow’ (Manual Trigger) Allows on-demand execution or scheduled testing of the workflow. Initiates the fetch for all newly “Won” deals from HighLevel CRM. 🏆 Fetch All Won Deals from HighLevel Retrieves all opportunities labeled “won” in HighLevel, gathering essential client details such as name, email, and deal information to personalize outgoing emails. 🔍 Validate Deal Fetch Success (IF Node) Checks each record for a valid id field. ✅ True Path: Moves ahead to generate AI email content. ❌ False Path: Logs the event to Google Sheets under the error log sheet. 🧠 Configure GPT-4o Model (Azure OpenAI) Initializes the GPT-4o engine that powers all language-generation tasks in this workflow—ensuring precise tone, correct formatting, and safe structured HTML output. 💌 Generate Personalized Review Request Email (AI Agent) Uses GPT-4o to create a tailored, HTML-formatted email thanking the client for their business and requesting feedback. Includes two clickable CTA buttons: ⭐ Google Review Link: 📝 Internal Feedback Form: Google Form link for in-depth feedback Each email maintains Techdome’s friendly, brand-consistent voice with clean inline CSS styling. 📨 Send Review Request Email to Client (Gmail Node) Automatically sends the AI-generated email to the client’s registered address through Gmail. Ensures timely post-service communication without manual follow-ups. ⏳ Wait for 24 Hours Before Next Action Pauses the workflow for 24 hours to give clients time to read and respond to the review request. 📥 Retrieve Email Thread for Response (Gmail Node) After the waiting period, fetches the Gmail thread associated with the initial email to capture client replies or feedback messages. 🧠 Configure GPT-4o Model (Summarization Engine) Prepares another GPT-4o instance specialized for summarizing client replies into concise, sentiment-aware Slack messages. 💬 Summarize Client Feedback (AI Agent) Analyzes the Gmail thread and produces a short Slack-formatted summary using this structure: 🎉 New Client Review Received!Client: <Name> Feedback: <Message snippet> Sentiment: Positive / Neutral / Negative Focuses on tone clarity and quick readability for internal teams. 📢 Announce Review Summary in Slack Posts the AI-generated summary in a designated Slack channel, keeping success and support teams instantly informed of client sentiments and feedback trends. 📊 Log Errors in Google Sheets Appends all failures—including fetch issues, missing fields, or parsing errors—to the Google Sheets “error log sheet,” maintaining workflow reliability and accountability. 🧩 Prerequisites HighLevel CRM OAuth credentials (to fetch deals) Azure OpenAI GPT-4o access (for AI-driven writing and summarization) Gmail API connection (for sending & reading threads) Slack API integration (for posting summaries) Google Sheets access (for error logging) 💡 Key Benefits ✅ Automates personalized review outreach after project completion ✅ Waits intelligently before analyzing responses ✅ Uses GPT-4o to summarize client sentiment in human tone ✅ Sends instant Slack updates for real-time visibility ✅ Keeps audit logs of all errors for debugging 👥 Perfect For Client Success and Account Management Teams Agencies using HighLevel CRM for project delivery Teams aiming to collect consistent client feedback and reviews Businesses wanting AI-assisted sentiment insights in Slack