Skip to content
Notis

Answer application inventory requests from Sheets

Keep inventory requests in Sheets and let Notis retrieve the Codemagic application list when one is added.

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

Retrieve All Applications

Tool to retrieve all applications added to Codemagic. Use when you need to list or browse all applications in the Codemagic account.

Why this helps

Application inventory can take time to assemble when project and build information is spread across systems.

  • Respond to new inventory requests with the current application list.
  • Reduce manual browsing through Codemagic.
  • Keep request handling and run reports in a familiar workflow.

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 retrieve the Codemagic applications list for each new inventory request and summarize it in the run report.
  • 4Pick the New Rows in Google Sheet trigger and choose where run reports should go.
  • 5Test with one real inventory request row.

Questions about this workflow

Does this return applications across the account?

The action retrieves all applications added to the authenticated Codemagic account.

Can it add an application?

No. This workflow retrieves the list. Adding an application requires a separate Codemagic action.

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.

TriggerScheduled

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.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

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.

ActionInstant

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.

TriggerPolling

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.

ActionInstant

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.

TriggerPolling

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.

ActionInstant

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.

TriggerPolling

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.

ActionInstant

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.

TriggerPolling

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.

ActionInstant

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.

TriggerPolling

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.

ActionInstant

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.

TriggerPolling

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.

ActionInstant

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.