Start a Bettercontact lead search when your sheet changes
Update the planning range in your spreadsheet and have Notis start a prospect search from the criteria you specify.
Trigger
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.
Action
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.
Why this helps
Prospecting plans change in spreadsheets, but launching the matching search becomes another task to remember.
- Kick off lead discovery when monitored spreadsheet values change.
- Describe company and people criteria in plain language to Notis.
- Reduce the delay between updating a prospecting plan and starting a search.
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.
- 3Tell Notis what company and people criteria to use for the Bettercontact Lead Finder search.
- 4Choose the Cell Range Values Changed trigger, specify the monitored range, and select where run reports should go.
- 5Test with one real range change and confirm the search request starts.
Questions about this workflow
What starts the search?
A change to values in the specified Google Sheets A1 range starts the workflow.
How does Notis know which prospects to search for?
Describe the company and people criteria in the automation instruction. The Lead Finder supports criteria such as job titles, departments, seniority, company size, industry, and technology stack.
Does this action return the lead results immediately?
No. Create Lead Finder Search starts a search. Use Get Lead Finder Results with the resulting search request to retrieve results.
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.