Turn new spreadsheet leads into useful research profiles
Add a lead once. Get the company and contact context you need to decide what to do next.
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 Person or Company
Enrich person or company data using LinkedIn URLs, emails, domains, or names. Returns enriched data including: contact information, LinkedIn profiles, company details, work experience, education, phone numbers (with phoneFull), and company metrics. Input types: LinkedIn profile URL (~100% success), email (~60% success), name+company (~90% success), company domain/name, or SIREN number (French companies).
Why this helps
New prospects land in a sheet, but researching each one by hand delays follow-up and fragments your focus.
- Get available contact and company details alongside each new lead.
- Reduce manual research before deciding whether a lead is relevant.
- Keep lead research moving from the spreadsheet you already use.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Datagma once in the Notis portal.
- 2Create an automation by telling Notis in plain language from any channel, or in the portal under Automations, New Automation.
- 3Describe the outcome in one instruction: enrich each new lead's person or company using the details available in its row, then summarize the result.
- 4Pick New Rows in Google Sheet as the trigger and choose where run reports go.
- 5Test with one real example row and review the report.
Questions about this workflow
What information can Datagma use to enrich a lead?
Datagma can use available inputs such as a LinkedIn URL, email, domain, or name. The row needs to contain enough identifying information for the lookup.
Does this update my spreadsheet automatically?
This workflow runs Datagma's enrichment action and summarizes the result. It does not promise a spreadsheet write-back.
What happens if Datagma cannot find a match?
Notis can report the returned result, including when useful data is unavailable, so you can decide whether to follow up manually.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Datagma. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Datagma actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Detect Job Change
Tool to detect if a contact changed jobs. Use when verifying a contact’s current employment details by email.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Enrich Person or Company
Enrich person or company data using LinkedIn URLs, emails, domains, or names. Returns enriched data including: contact information, LinkedIn profiles, company details, work experience, education, phone numbers (with phoneFull), and company metrics. Input types: LinkedIn profile URL (~100% success), email (~60% success), name+company (~90% success), company domain/name, or SIREN number (French companies).
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.
Find Work Email
Find verified work email address for a person using their name and company. Returns a professionally verified email address with validation metadata including SMTP checks and MX records. Requires either fullName or firstName+lastName, plus company domain or LinkedIn company slug.
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 Credits
Get the current credit balance for the authenticated Datagma API account. Use this to check how many API credits remain before making enrichment calls.
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 Twitter Profile By Email
Retrieve Twitter account information associated with an email address. This action looks up Twitter username and display name for a given email address using Datagma's enrichment database. Returns Twitter username, display name, and the queried email if a match is found, or status 'NOT_FOUND' if no Twitter account is associated with the email. Use this when you need to: - Find someone's Twitter handle from their email address - Verify if an email has an associated Twitter account - Enrich contact data with social media information
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.
Get Twitter Profile by Username
Enrich Twitter profile data using Datagma's database. Returns contact information (email), social media profiles (LinkedIn, Facebook, GitHub), and professional details (skills, interests, industry) associated with a Twitter username. Note: Not all usernames are in Datagma's database. A 'not found' response (code 5) indicates the username hasn't been indexed yet.
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.
Reverse Phone Lookup
Tool to reverse-lookup information associated with a phone number. Use when you have a phone number and need associated details (e.g., carrier, location).
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.
Search Phone Numbers
Find mobile phone numbers using email address and/or LinkedIn profile URL. Returns list of phone numbers with confidence scores and optional WhatsApp verification. Best results when both email and LinkedIn URL are provided.
Connect any two apps with Notis in the middle.
Google Sheets and Datagma, 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 Datagma.