Turn new lead rows into timely Customer.io broadcasts
When a lead lands in your sheet, let Notis prepare the Customer.io broadcast with the personalization details you provide.
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
Trigger Broadcast
Tool to manually trigger a broadcast. use when you need to override the default audience and provide personalization data after confirming the broadcast id.
Why this helps
New leads can sit in a spreadsheet while someone remembers to start the right campaign and add context.
- Reduce delay between a lead arriving and campaign follow-up.
- Reuse row details as broadcast personalization data.
- Keep a clear run report for each triggered broadcast.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Customer.io once in the Notis portal.
- 2Create an automation in Automations by choosing New Automation and adding a name and prompt.
- 3Tell Notis which new lead rows should trigger a Customer.io broadcast and what row details to use as personalization data.
- 4Choose New Rows in Google Sheet as the trigger and select a report channel.
- 5Test with one real lead row and confirm the Customer.io broadcast ID is available.
Questions about this workflow
Does this workflow create a Customer.io broadcast?
No. It triggers an existing broadcast, so provide the broadcast ID and any needed personalization instructions in your prompt.
What starts the automation?
A new row detected in the selected Google Sheet.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Customerio. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Customerio actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Suppress Customer Profile
Tool to suppress a person. use when you need to permanently delete a customer's profile and prevent them from being re-added.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Integrations
Tool to retrieve a list of integrations in your workspace. use when you need to discover configured integrations.
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.
Get Messages
Tool to retrieve a list of messages sent from your workspace. use when you need paginated delivery metrics for messages, e.g., list email messages delivered between two timestamps.
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 Segment Details
Tool to retrieve details of a specific segment. use after identifying the segment id from list segments.
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 Segment Membership
Tool to retrieve people in a specific segment. use when you need to page through segment membership after identifying segment id.
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 Segments
Tool to retrieve a list of segments in your workspace. use when you need to fetch all segments after configuring segment rules.
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.
Get Trigger
Tool to retrieve details about a specific trigger. use after triggering a broadcast to confirm its status and metadata.
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.
Get Triggers
Tool to retrieve a list of triggers for a specific broadcast. use after identifying broadcast id to inspect associated triggers.
Connect any two apps with Notis in the middle.
Google Sheets and Customerio, 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 Customerio.