Process specific cache cleanup requests from Sheets
Track cache cleanup requests in a filtered range and let Notis send a specific cache deletion request to Codemagic.
Trigger
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.
Action
Delete Specific Cache
Tool to delete a specific cache from an application. Use when a cached build artifact needs to be removed. The deletion is performed asynchronously and returns immediately with a 202 Accepted status.
Why this helps
Cache cleanup requests can be overlooked or require someone to search for the right application and cache before acting.
- Use a monitored request range for cache cleanup work.
- Pass the requested application and cache identifiers to Codemagic.
- Reduce manual searching before a cleanup request.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Codemagic once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3Tell Notis to delete the specific Codemagic cache described by a matching request, using the supplied application and cache identifiers.
- 4Pick the Filtered Range Values Changed trigger and choose where run reports should go.
- 5Test with one real cache request and valid application and cache identifiers.
Questions about this workflow
Does this clear every cache for the application?
No. This workflow uses the action for deleting a specific cache. Codemagic also has a separate action for deleting all application caches.
What details does the request need?
Provide the relevant application identifier and specific cache identifier in the data Notis can use.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Codemagic. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Codemagic actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Application from Private Repository
Tool to create an application from a private repository using SSH key authentication. Use when you need to add a new private repository to Codemagic with SSH credentials.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add New Application
Tool to add a Git repository to the applications list in Codemagic. Use when you need to add a new application to Codemagic from a repository URL.
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 Meta Information
Tool to get metadata about Codemagic including public IP addresses in use (in CIDR notation). Use when you need to retrieve IP blocks for whitelisting build machines or simulator network requests.
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 Variable Group Information
Tool to retrieve information about a specific variable group including its name and configuration settings. Use when you need to get details for a variable group by its ID.
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.
Update Variable Group
Tool to change a variable group's name and security settings. Use when you need to update an existing variable group by its ID. Returns success confirmation on 204 No Content response.
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.
Delete All Application Caches
Tool to delete all caches for a specific application. Use when clearing all cached data for an app. The deletion process is asynchronous and will complete after the API response is returned.
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.
Delete Specific Cache
Tool to delete a specific cache from an application. Use when a cached build artifact needs to be removed. The deletion is performed asynchronously and returns immediately with a 202 Accepted status.
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 Account Info for Over-the-Air Updates
Tool to retrieve account information for over-the-air updates. Use when you need to check the account status (enabled/disabled/pending) and associated team identifier.
Connect any two apps with Notis in the middle.
Google Sheets and Codemagic, 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 Codemagic.