Add issuer context to payment records
When a BIN lands in your sheet, Notis can retrieve its brand, type, and country so the record has useful context.
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
BIN Lookup
Tool to look up bank information from a bank identification number. use after you have a bin to fetch issuer details (brand, type, country).
Why this helps
Payment logs with unexplained BIN values require a separate lookup and extra context switching.
- Retrieve issuer details for new BIN values
- Reduce manual lookup work
- Keep the returned context with the payment record
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Api ninjas once in the Notis portal.
- 2Create an automation in the portal or tell Notis from any channel.
- 3Ask Notis in one instruction to look up the BIN in each new row and record the returned issuer details beside it.
- 4Pick the New Rows in Google Sheet trigger.
- 5Choose a report channel, then test with one real row containing a BIN.
Questions about this workflow
What information does the lookup return?
The action retrieves bank information such as brand, card type, and country for a supplied BIN.
Should I include full card numbers in the sheet?
No. Use only the BIN value required for lookup and avoid storing sensitive payment card data in a spreadsheet.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Api ninjas. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Api ninjas actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Generate Barcode Image
Tool to generate a barcode image for specified text. use when you need a barcode image (png or svg) of custom data.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
BIN Lookup
Tool to look up bank information from a bank identification number. use after you have a bin to fetch issuer details (brand, type, country).
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 Bitcoin Price and Market Data
Tool to retrieve the latest bitcoin price and 24-hour market data. use when you need real-time bitcoin metrics in usd.
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.
Commodity Price
Tool to get real-time price for a commodity. use when you need the current market price by specifying the commodity name. example: "what is the current price of gold?"
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.
Crypto Price
Tool to get real-time price for a cryptocurrency pair. use when you need the current market price by symbol.
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.
Check Disposable Email
Tool to check whether an email address is from a disposable email provider. use when validating user emails prior to sending communications.
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.
DNS Lookup
Tool to retrieve dns records for a specified domain. use when you need dns record details for troubleshooting or validation.
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.
Earnings Calendar
Tool to fetch past and upcoming earnings results for a specified ticker. use when you need both historical earnings and upcoming earnings dates for a company.
Connect any two apps with Notis in the middle.
Google Sheets and Api ninjas, 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 Api ninjas.