Affiliate Performance Dashboard: A Notion and Sheets Template

A food-content creator in Izmir used to spend 4 hours every month copying Stripe screens and thMenu affiliate panel rows into Excel. After switching to a Notion + Sheets template, that number dropped to zero; the saved hours now go straight into new Reels production.

Notion Home Page Layout

The top row holds five metric cards: monthly conversions, strongest content source (TikTok/YT/Blog), current tier (Bronze/Silver/Gold/Platinum), refunds in the last 30 days, and projected MRR. Each card pulls from a linked Sheets database — no manual updates ever.

Below the cards sit two gallery views: "Top 10 Content (90 days)" and "Pending Payouts". The second one syncs with the superadmin queue; when an admin marks a payout as released, the card flips status automatically within a minute.

Sheets Raw Data and Pivots

The first tab is "raw": daily rows with commission_id, restaurant_slug, plan_type, gross_amount, commission_amount, status (held/released/refunded), and utm_source. Apps Script pulls this from thMenu's CSV export every night at 04:00 local time — no human in the loop.

• Pivot 1: Source × Month → commission totals (which channel earns)
• Pivot 2: Plan type × Status → refund rate (yearly-plan risk)
• Pivot 3: Restaurant × Month → early churn signal (3 declining months)

Gemini Weekly Summary

A =GEMINI() cell in Sheets generates a plain-English digest: "12 new conversions this week, 80% from TikTok, refund rate 3.2% (down from 5.1%), suggestion: scale TikTok spend". Every Monday at 09:00 a webhook pushes the digest into the Notion home page so the creator opens one screen.

Once published as a public template link, other creators can duplicate it in one click, paste their own affiliate_id, and be fully wired in five minutes. The Izmir creator shared it in a Discord and saw 80+ duplicates within a week.

FAQ

Do I have to pull CSV exports manually? No — Apps Script can call the thMenu affiliate API nightly with UrlFetch; grab the API key from Dashboard Settings.

Do I need a paid Notion plan? The free plan is enough; keep historical raw data in Sheets and use Notion only for summaries to stay under the block limit.

Is the Gemini formula safe? The cell contents are sent as the prompt, so as long as you avoid PII it is fine. Hash restaurant names in a helper column if needed.

Found this helpful? Share it.