Enrich new Google Sheets leads with Bettercontact
Add a lead to your sheet and let Bettercontact find the contact details your team needs for follow-up.
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
Enrich Leads
Tool to create a lead enrichment request for work emails and direct phone numbers. Uses waterfall enrichment across multiple data providers for higher accuracy. Supports batches of 1-100 leads.
Why this helps
New leads sit in a spreadsheet while someone manually copies each record into an enrichment tool.
- Reduce repetitive copying between your sheet and enrichment tools.
- Use Bettercontact's waterfall enrichment for work emails and direct phone numbers.
- Start enrichment as soon as a new row is detected.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Bettercontact once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name and prompt.
- 3Describe how Notis should submit new lead rows to Bettercontact for enrichment.
- 4Choose the New Rows in Google Sheet trigger and select where run reports should go.
- 5Test with one real lead row and confirm the enrichment request starts.
Questions about this workflow
What starts this workflow?
The workflow starts when the Google Sheets New Rows in Google Sheet trigger detects a newly added row.
Does this workflow return enriched data to the spreadsheet?
No. The selected action submits an enrichment request. Retrieving results requires a separate Get Enrichment Results action.
What information does Bettercontact enrich?
The Enrich Leads action is for work emails and direct phone numbers, using waterfall enrichment across providers.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Bettercontact. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Bettercontact actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Check Credits Balance
Tool to check the remaining credits balance for a BetterContact account. Use when you need to verify available credits before making API requests that consume credits.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Lead Finder Search
Tool to create a new Lead Finder search to discover leads based on company and people criteria. Use when you need to find prospects matching specific job titles, departments, seniority, company size, industry, or technology stack.
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.
Enrich Leads
Tool to create a lead enrichment request for work emails and direct phone numbers. Uses waterfall enrichment across multiple data providers for higher accuracy. Supports batches of 1-100 leads.
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.
Get Enrichment Results
Tool to retrieve enrichment results for a specific request ID. Use when you need to check the status and get enriched lead data including email addresses, contact information, and summary statistics for a submitted enrichment request.
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.
Get Lead Finder Results
Tool to retrieve results from a submitted Lead Finder search. Returns comprehensive lead and company data including contact information, LinkedIn profiles, job titles, company details, and enrichment data.
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.
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.
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.
Connect any two apps with Notis in the middle.
Google Sheets and Bettercontact, 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 Bettercontact.