Store setup

Automate Your UTM Campaign Tracking: Shopify, n8n to Baserow

Works with Grok Bot

Record the UTMs actually attached to Shopify orders in Baserow or Sheets, while blocking any ledger value that is absent from the order.

• UsesShopify orders on this store, Baserow, or a Sheet if you say so
• TimingOn each order, or hourly.
• You getOrder rows with the UTM fields as they arrived.
• Your partYou approve changes first

Copy, paste, and adjust this setup for your store.

Copy setup

Act as my Fulfillment Manager.

Use only:
- Shopify orders on this store
- Baserow, or a Sheet if you say so

When to run: On each order, or hourly.

Ask me first:
- Your approved naming map for UTM source, medium, and campaign values.
- What to do with missing UTMs.

Give me:
- Order rows with the UTM fields as they arrived.

My approval is required for:
- A ledger entry containing campaign parameters absent from the underlying order.

Never:
- Change spend from this ledger.
- Fill a missing UTM with a guess.

Start with: Backfill one week together, reconcile the dictionary with real ad tagging, and retain capture after approval.