Check new spreadsheet entries against indexed history
Catch related history as rows arrive, without pausing to repeat the same search by hand.
Trigger
New Rows in Google Sheet
Triggers when new rows are added to a spreadsheet.
Action
Query Index
Searches an Elasticsearch index for documents.
Why this helps
New entries can be overlooked when checking them requires a separate search across historical records.
- Find related indexed records as new rows appear.
- Make row review faster with summarized matches.
- Keep useful context in the run report.
Setup
Build it in a few focused steps.
- 1Connect Google Super and Elasticsearch once in Notis.
- 2Create an automation in Notis and give it a clear name.
- 3Tell Notis to search a specified Elasticsearch index using meaningful values from each new row and summarize relevant matches.
- 4Choose New Rows in Google Sheet as the trigger and select where run reports go.
- 5Test with one real new row.
Questions about this workflow
Does this calculate trends across the spreadsheet?
No. This workflow searches Elasticsearch for related records. The available actions do not analyze or update Google Sheets.
What if a row has no useful search terms?
Tell Notis which row values are meaningful for the search. Results depend on those values and the documents in the selected index.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Elasticsearch. A trigger fires from one place; an action lands in another.
Google Super triggers
Elasticsearch actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get Index Schema
View the structure and field mappings of an index.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
List Indices
Lists available Elasticsearch indices.
Aggregate Metric Changed
Triggers when an aggregate calculation in a spreadsheet changes.
Query Index
Searches an Elasticsearch index for documents.
Attendee Response Changed
Triggers when an attendee accepts, declines, or tentatively responds to an invitation.
Ping Cluster
Pings the cluster to check its connectivity and health.
Cell Range Values Changed
Triggers when values change in a specified spreadsheet range.
Comment Added (Docs/Sheets/Slides)
Triggers when someone adds a comment to a document, sheet, or presentation.
Conditional Format Rule Changed
Triggers when spreadsheet conditional formatting rules are added, changed, or removed.
Data Validation Rule Changed
Triggers when spreadsheet data validation rules change.
Connect any two apps with Notis in the middle.
Google Super and Elasticsearch, 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 Elasticsearch.