Review carbon removal alongside changing metrics
When a watched Sheets aggregate changes, Notis can retrieve the current Ecologi carbon removal total and report the lookup for review.
Trigger
Aggregate Metric Changed
Triggers when an aggregate calculation in a spreadsheet changes.
Action
Get User Carbon Removal
View a user's total carbon removed from the atmosphere.
Why this helps
A changing business metric can prompt a review, but the related climate impact number may live in another app and be missed.
- Use an aggregate change as a timely prompt to check carbon removal.
- Retrieve the Ecologi permanent removal total without a separate manual lookup.
- Keep the metric change and impact result together in a run report.
Setup
Build it in a few focused steps.
- 1Connect Google Super and Ecologi once in the Notis portal.
- 2Create an automation in Automations, New Automation, and add its name and prompt.
- 3Ask Notis to report the new Sheets aggregate context with the Ecologi carbon removal total when the metric changes.
- 4Choose Aggregate Metric Changed as the trigger and select where run reports go.
- 5Test with one real metric change and check the result.
Questions about this workflow
Does the trigger tell Ecologi how much carbon was removed because of this metric?
No. The trigger reports a changed Sheets aggregate, while Ecologi returns the user's total carbon removal. The available action does not calculate attribution or a change from a prior Ecologi baseline.
Can I filter which metric changes activate the workflow?
The trigger supports monitoring an aggregate calculation and optionally filtering by a search column and value. Select the relevant monitored metric when setting up the trigger.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Ecologi. A trigger fires from one place; an action lands in another.
Google Super triggers
Ecologi actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get User Carbon Offset
View a user's total avoided carbon emissions.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get User Carbon Removal
View a user's total carbon removed from the atmosphere.
Aggregate Metric Changed
Triggers when an aggregate calculation in a spreadsheet changes.
Get User Habitat Restoration
View the habitat area restored by a user.
Attendee Response Changed
Triggers when an attendee accepts, declines, or tentatively responds to an invitation.
Get User Impact
View a user's combined environmental impact, including trees and carbon.
Cell Range Values Changed
Triggers when values change in a specified spreadsheet range.
Get User Trees
View the number of trees a user has funded.
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 Ecologi, 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 Ecologi.