Skip to content
Notis

Resolve team details from a changed spreadsheet row

Keep team profiles aligned with the latest sheet inputs.

Trigger

Spreadsheet Row Changed

Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row appears, or when the row disappears.

Action

Get Teams

Tool to retrieve available teams. use when filtering teams by id, name, league, season, country, code, venue, or search before fetching detailed team data.

Why this helps

Team names and identifiers change in planning sheets, causing stale research elsewhere.

  • Reduces duplicate team research
  • Keeps profiles current
  • Flags ambiguous team names

Setup

Build it in a few focused steps.

  • 1Connect Google Super and Api sports in Notis once.
  • 2Create an automation named Changed sheet row team lookup.
  • 3Tell Notis to read the changed row, find the matching team, and summarize its available identity and venue details.
  • 4Pick Spreadsheet Row Changed as the trigger, then choose where reports go.
  • 5Test it with one changed team row.

Questions about this workflow

Can it search by country or league?

Yes. Ask Notis to use those details to disambiguate the team search.

What happens when multiple teams match?

Tell Notis to list the candidates and request clarification rather than choosing silently.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

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

Google Super triggers

Api sports actions

Recurring trigger

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

TriggerScheduled

Get Coaches

Tool to fetch coaches and their career history. use when you need coach info by id, team filter, or name search.

ActionInstant

Webhook trigger

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

TriggerInstant

Get Countries

Tool to fetch available countries for league queries. use when filtering by name, code, or search string before retrieving leagues.

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 Fixtures

Tool to retrieve football fixtures/matches. use when filtering fixtures by id, date, league, season, team, or date ranges to get upcoming or past matches.

ActionInstant

Attendee Response Changed

Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.

TriggerPolling

Get fixtures events

Tool to get events (goals, cards, substitutions, var, etc.) from a fixture. use when you need detailed event data after confirming the fixture id.

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 Head-to-Head Fixtures

Tool to get head-to-head fixtures between two teams. use after determining team ids to compare their direct match history.

ActionInstant

Comment Added (Docs/Sheets/Slides)

Triggers when a new comment is added to Google Docs, Sheets, or Slides.

TriggerPolling

Get Fixture Lineups

Tool to retrieve starting xi and substitutes for a fixture. use after confirming fixture id; optionally filter by team, player, or section (startxi/substitutes). lineups appear ~20-40 minutes before kickoff for supported competitions.

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

Get fixtures players

Tool to get player statistics from a fixture. use when you need detailed per-player stats for a specific match. optionally filter by team.

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

Get Fixtures Rounds

Tool to get the rounds for a league or cup. use after confirming league and season to retrieve available round identifiers (optionally with dates) for filtering fixtures.

ActionInstant

Connect any two apps with Notis in the middle.

Google Super and Api sports, 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 Api sports.