Review Codacy account context for a new spreadsheet
Start a new tracking sheet with a quick view of the authenticated Codacy account details, ready for your setup notes.
Trigger
New Spreadsheet Created
Triggers when a new Google Spreadsheet is created. This trigger monitors Google Spreadsheets and fires when new spreadsheets are detected. Uses timestamp filtering to efficiently detect newly created spreadsheets.
Action
Get Account Details
Tool to retrieve details of the authenticated user's account. use when confirming authentication before user-level operations.
Why this helps
A new tracking spreadsheet can be ready before anyone confirms which Codacy account is connected.
- Confirm which Codacy account is connected when a spreadsheet is created.
- Put account context in a run report for setup follow-up.
- Avoid a separate manual account lookup.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Codacy once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3In one instruction, ask Notis to retrieve Codacy account details when a spreadsheet is created and summarize the returned details in its run report.
- 4Pick New Spreadsheet Created as the trigger, then choose where run reports go.
- 5Test by creating one real spreadsheet.
Questions about this workflow
Does this verify every Codacy permission?
No. It retrieves the account details returned by Codacy and does not audit permissions.
Will it write the details into the spreadsheet?
No. The available action retrieves account details; the workflow can summarize them in the Notis run report.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Codacy. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Codacy actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create API Token
Tool to create a new api token for the authenticated user's account. use after authenticating when you need to generate a fresh token for integrations.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete API Token
Tool to delete a specific api token from the authenticated user's account. use after confirming the token id.
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 Account Details
Tool to retrieve details of the authenticated user's account. use when confirming authentication before user-level operations.
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 Organization Repositories
Tool to list all repositories under a specific organization and provider. use when you need to enumerate organization-scoped repositories.
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.
Get User Organizations
Tool to list all organizations the authenticated user belongs to. use after authenticating and need to discover accessible organizations.
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.
List Projects
Tool to list all projects accessible to the authenticated user. use when you need a list of repositories after confirming api token validity.
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.
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.
Connect any two apps with Notis in the middle.
Google Sheets and Codacy, 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 Codacy.