Latenode

Scrape competitors' affiliate data, analyze threats, sync to Sheets & Slack

This template runs twice a day, opens the affiliate URLs you list, scores each competitor from the commercial terms on the page, and writes a row to Google Sheets.

High-threat rows post to Slack; you can also email a short digest. Connect Google Sheets, Slack, and Gmail, then put the competitor URLs in the headless-browser start list.

Updated Sep 15, 2026Est. run: 21sEst. cost: $0.0013
How Latenode estimates time and cost

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how CPU seconds work →

Workflow preview

What this template does

  • Checks competitor affiliate offers on a schedule without manual copy-paste
  • Scores threat with ChatGPT from commission, cookie, AOV, and payout text
  • Writes every run to Google Sheets and posts only the high-risk rows to Slack
  • Keeps a scrape API key in JavaScript if you bring your own scraper

How it works

1
Trigger

Run twice daily

A schedule starts the scenario on the interval you set, for example twice a day.

2
Action

Scrape affiliate pages

A headless browser extracts commission, cookie duration, AOV, and payout terms from each competitor URL. If you already have a scrape API, call it from a JavaScript node instead and store that key there.

3
AI

Score threat

JavaScript turns the scrape into one object per competitor. ChatGPT returns a threat level and a one-line reason from those fields.

4
Action

Log to Google Sheets

Google Sheets appends competitor, metrics, score, and timestamp for every row.

5
Action

Alert on high threat

A router sends high-threat rows to a Slack channel. If you want a digest of the run, send it with Gmail after the sheet write.

Setup guide

1

List competitor URLs

Put the affiliate-program URLs in the headless-browser start list, or in a sheet that JavaScript reads first.

2

Connect Google Sheets and Slack

Add Google Sheets and Slack connections. Choose the dashboard spreadsheet and the channel for alerts.

3

Add ChatGPT for scoring

Ask ChatGPT for a threat score plus a one-line reason from the extracted terms. This is a Latenode AI node; you do not paste an OpenAI API key into it.

4

Connect Gmail if you want a digest

Add a Gmail connection and send the digest after the sheet write.

5

Set the schedule

Run the scenario twice daily. Test once on a single URL before enabling the cadence.

Requirements

Competitor affiliate URLs Latenode can open in a headless browser (or a scrape API key in JavaScript)
A Google Sheet Latenode can append to
A Slack channel for high-threat messages
A Gmail connection if you want a digest

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work. Plug-and-Play AI nodes are billed separately.