Skip to content
Notis

Start a build report from real pipeline data

Turn a structured build payload into a new spreadsheet that is ready for review and sharing.

Trigger

Webhook received

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

Action

Create sheet from JSON

Creates a spreadsheet and fills its first sheet with JSON data.

Why this helps

Starting a useful build report from raw pipeline details can take several manual steps and interrupt a focused task.

  • Create a report document from structured build data.
  • Give report columns headers based on the supplied fields.
  • Skip the manual setup of a basic results sheet.

Setup

Build it in a few focused steps.

  • 1Connect Codemagic and Google Sheets once in the Notis portal.
  • 2Create an automation in Automations, New Automation, and give it a name.
  • 3Tell Notis to create a spreadsheet from the structured build data in the incoming request, using its fields as column headers.
  • 4Pick the webhook trigger and choose where run reports should go.
  • 5Send one real structured build example and review the created spreadsheet.

Questions about this workflow

What format should the request contain?

The create sheet from JSON action needs non-empty structured data, and the first item's keys establish the headers. Provide build details in a consistent structure.

Does it update an existing report?

This action creates a new spreadsheet. Use an update or append action when you want to add data to an existing report.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Codemagic to Google Sheets. A trigger fires from one place; an action lands in another.

Codemagic triggers

Google Sheets actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Add Sheet to Existing Spreadsheet

Adds a grid sheet with rows and columns to an existing spreadsheet.

ActionInstant

Webhook trigger

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

TriggerInstant

Aggregate Column Data

Find rows matching a column value and calculate results from another column.

ActionInstant

Append Dimension

Adds empty rows or columns to the end of a sheet.

ActionInstant

Batch get spreadsheet

Retrieves data from selected spreadsheet ranges.

ActionInstant

Auto-Resize Rows or Columns

Automatically adjusts row heights or column widths to fit their contents.

ActionInstant

Batch Update Values by Data Filter

Updates spreadsheet values in ranges that match data filters.

ActionInstant

Clear Basic Filter

Removes the basic filter from a sheet.

ActionInstant

Batch update spreadsheet (Deprecated)

ActionInstant

Connect any two apps with Notis in the middle.

Codemagic and Google Sheets, 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 Google Sheets.