Starbase / 02 RecipeAgents

RecipeAgents / Recipes / Ops

Ops recipe

Alert when a supplier changes a price

Supplier invoices quietly creep up. This compares each new invoice line with the last price you paid and flags increases.

InputParsed invoice lines (see the invoice recipe)
ToolsGoogle Sheets, Make, an AI step (optional)
TimeSetup about 30 minutes, once invoices are already in a sheet.

Download it

The n8n file has three nodes (trigger, AI step, output) plus a read-me note. We check that its JSON structure is valid, but we haven't run every file in a live n8n instance, so test it with sample data before you switch it on.

Steps

  1. After an invoice row is added, look up the last price for the same item code.
  2. If the new price is more than 3% higher, send a Slack or email alert.
  3. Optional AI step: draft a polite query to the supplier.

The prompt

Draft a short, polite email to {{supplier}} asking about the price change on {{item}} from {{old}} to {{new}} between {{date_old}} and {{date_new}}. Under 70 words.

Sample run

Example input (written for illustration)
Item PAPER-A4: 4.20 → 4.65 EUR
Example output (shows the format, not a real log)
Hi, I noticed A4 paper went from €4.20 to €4.65 between our September and October invoices. Could you confirm whether that's a new list price, or whether our usual rate still applies? Thanks, Andrius
SPONSOR SLOT · AVAILABLEFeature your product here

Where it breaks

  • Item names change. Match on item code, not description, where possible.
  • Anything customer-facing or money-related. Keep a human approval step until you've watched a few dozen runs and trust it.

Tool names and pricing change often, so check each tool's current docs before you build. Times on this page are estimates, not measurements.

More ops recipes

All collections · Full inbox-triage walkthrough

Newsletter

One small automation every Friday

Each Friday email has one recipe, the prompt for it, and the way it broke when we wrote it up. It's free, and every email has an unsubscribe link.