Add person context when a contact enters your sheet
A new contact row can prompt a person lookup, so research can move forward while the lead is already in view.
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
Reverse Lookup Person by Email
Tool to retrieve a person’s profile from an email address. Use when you want to enrich a valid email with associated person details.
Why this helps
New leads can stay as names and email addresses until someone remembers to search for more context.
- Retrieve person profile information associated with an email.
- Reduce manual profile searches during lead intake.
- Keep the lookup tied to a new-row event.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Clearout once in the Notis portal.
- 2Create an automation under Automations using New Automation and name it.
- 3Tell Notis to use Clearout Reverse Lookup Person by Email for new contact rows.
- 4Choose New Rows in Google Sheet and choose a report channel.
- 5Test with one real row containing an email address and review the run report.
Questions about this workflow
What input does person lookup require?
It retrieves a person's profile from an email address, so provide the email in the new row.
Does this validate the email first?
This workflow runs person reverse lookup. It does not include a separate email verification action.
Will every email return a profile?
The action retrieves associated person details when available; the description does not guarantee a match for every address.
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.