Create a clean scorecard for repository quality
Start a focused scorecard from the Codacy data you want your team to review.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create sheet from JSON
Creates a spreadsheet and fills its first sheet with JSON data.
Why this helps
Useful quality signals are harder to discuss when they live in a crowded or inconsistent report.
- Create a dedicated spreadsheet for the scorecard.
- Present selected returned data in a consistent structure.
- Give review conversations a clear starting point.
Setup
Build it in a few focused steps.
- 1Connect Codacy and Google Sheets once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3Tell Notis which Codacy repository data to include and ask it to create a new spreadsheet with a concise scorecard.
- 4Choose a recurring schedule and a channel for run reports.
- 5Test with one repository and confirm the created spreadsheet has useful headers and values.
Questions about this workflow
Does this update an existing spreadsheet?
No. This action creates a new spreadsheet and populates its first worksheet from the supplied structured data.
Can the scorecard include data Codacy does not return?
No. Add any non-Codacy context yourself in the instruction or another source; the scorecard should not infer missing metrics.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Codacy to Google Sheets. A trigger fires from one place; an action lands in another.
Codacy triggers
Google Sheets actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Sheet to Existing Spreadsheet
Adds a grid sheet with rows and columns to an existing spreadsheet.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Aggregate Column Data
Find rows matching a column value and calculate results from another column.
Append Dimension
Adds empty rows or columns to the end of a sheet.
Batch get spreadsheet
Retrieves data from selected spreadsheet ranges.
Auto-Resize Rows or Columns
Automatically adjusts row heights or column widths to fit their contents.
Batch Update Values by Data Filter
Updates spreadsheet values in ranges that match data filters.
Clear Basic Filter
Removes the basic filter from a sheet.
Batch update spreadsheet (Deprecated)
Connect any two apps with Notis in the middle.
Codacy 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.