Catch nonsensical email addresses at contact intake
Check new addresses for gibberish as they enter your sheet, before they get mixed into a larger list.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Verify Gibberish Email
Tool to verify if an email address is gibberish. Use when filtering out nonsensical or invalid-looking emails.
Why this helps
Typos and nonsensical addresses can accumulate in a contact list when there is no quick review step at intake.
- Identify gibberish or invalid-looking email addresses.
- Run a focused check when new rows appear.
- Make contact list review easier to prioritize.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Clearout once in the Notis portal.
- 2Create an automation from Automations using New Automation and give it a name.
- 3Tell Notis to check new contact emails with Clearout Verify Gibberish Email.
- 4Choose New Rows in Google Sheet and select a report channel.
- 5Test with one real example row and review the result.
Questions about this workflow
What does gibberish verification check?
It checks whether an email address is gibberish.
Does this correct a typo automatically?
No. It verifies the address for gibberish; the described action does not correct it.
Does every new row need an email?
The action is intended to check an email address, so the test row should include one.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Clearout. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Clearout actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Autocomplete Company to Domain
Tool to autocomplete company names to probable domains with confidence scores. Use after obtaining a company name or URL to get suggestions.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Business Account Verify
Tool to check if an email belongs to a business/work account. Use when validating corporate emails before onboarding.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Catch-All Verify
Tool to check if an email domain is catch-all. Use after confirming email validity.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Verify Disposable Email
Tool to check if an email is from a disposable provider. Use after acquiring an email address.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Find Domain MX Records
Tool to retrieve MX records for a domain in priority order. Use when you need to find a domain's mail servers (e.g., for email routing setup).
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Fetch Domain WHOIS Information
Tool to fetch WHOIS record for a domain. Use when you need WHOIS data for a domain.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Bulk Email Finder
Tool to upload a CSV or XLSX contacts file for bulk email finding. Use when you need to find emails for a list of contacts in bulk.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Cancel Bulk Email Finder Job
Tool to cancel a running bulk email finder job. Use when you need to stop an in-progress list scan before completion.
Connect any two apps with Notis in the middle.
Google Sheets and Clearout, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Clearout.