Look up contact details after a tracked row changes
When a tracked contact row changes, use its email to check for associated name, phone, and address details.
Trigger
Spreadsheet Row Changed
Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row appears, or when the row disappears.
Action
Append Reverse Email Lookup
Tool to perform reverse email lookup and retrieve contact information. Use when you need to find the name, phone, and address associated with an email address. Returns personal identifiers, contact details, and address components.
Why this helps
A contact row can change while related information remains scattered across other places.
- Use the email from a changed tracked row as a lookup input.
- Retrieve associated name, phone, and address details when available.
- Bring a contact review into focus after a meaningful row update.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Data247 once in the Notis portal.
- 2Create an automation and tell Notis to reverse look up the email on the tracked contact row.
- 3Pick the Spreadsheet Row Changed trigger and choose where run reports should go.
- 4Test with one real row found by a query value and containing an email.
Questions about this workflow
How does the trigger locate the row?
It searches for a query value within a user-specified range and fires when the row changes, appears, or disappears.
What does the reverse email lookup return?
It can return a name, phone, and address associated with the email address.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Data247. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Data247 actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Append Email by Name and Address
Tool to find email addresses associated with name and postal address. Use when you need to discover the email address for a contact given their name and residential or business address.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Append Gender by First Name
Tool to determine a person's probable gender based on their first (given) name. Use when you need to infer gender from a first name with confidence percentage.
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.
Append Name (CNAM Lookup)
Tool to get CNAM (Caller Name Delivery) data for a phone number. Use when you need to find the registered owner name associated with a phone number from carrier-grade telco data.
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.
Append Phone to Contact
Tool to append phone numbers to contact records using name and address. Use when you need to find phone numbers (business or residential) associated with a person's name and address. Returns primary phone with type classification and additional phone numbers if available.
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.
Append Property Data
Tool to retrieve comprehensive property data including home stats, ownership information, financials and foreclosure data. Use when you need detailed property information for any US address.
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.
Append Reverse Email Lookup
Tool to perform reverse email lookup and retrieve contact information. Use when you need to find the name, phone, and address associated with an email address. Returns personal identifiers, contact details, and address components.
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.
Append Reverse Phone Lookup
Tool to perform reverse phone lookup and retrieve name and address information. Use when you need to find the contact details associated with a phone number. Returns personal identifiers, address components, and demographic data.
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.
Append Reverse Zipcode Lookup
Tool to get formatted address components from a zipcode. Use when you need to retrieve city, state, county, congressional district, timezone, and other location data for a given 5 or 9 digit zipcode.
Connect any two apps with Notis in the middle.
Google Sheets and Data247, 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 Data247.