A good influencer tracking spreadsheet has one row per gift: creator, date sent, cost, whether they posted, the post link, discount code and revenue, with a formula for ROI. Download the free template below and open it in Google Sheets or Excel.
Choose your columns, check the preview, then download the CSV or copy it and paste it into cell A1 of a blank Google Sheet. Total cost and ROI are real spreadsheet formulas, so they calculate as soon as you enter numbers.
The example row uses made-up placeholder values to show how the formulas work.
18 columns on the Gifts tracker, 12 on the Content log.
Google Sheets: File, then Import, then upload the CSV and choose Insert new sheets. Excel opens the CSV directly. Neither file is sent anywhere: it is built in your browser.
| Creator handle | Platform | Date gifted | Product(s) sent | Product cost | Shipping cost | Total cost | Tracking number | Delivered? | Posted? | Post URL | Post date | Discount code | Orders using code | Revenue from code | ROI (net revenue ÷ cost) | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| @example_creator | creator@example.com | 2026-11-02 | Example product | 12 | 5 | 17 | EXAMPLE123 | Yes | Yes | https://example.com/post | 2026-11-12 | EXAMPLE10 | 3 | 90 | 4.29 | Example row: delete me | |
| (formula) | (formula) | ||||||||||||||||
| (formula) | (formula) |
Showing the first rows of 25. Column H (Total cost) and column Q (ROI) are formulas.
| Row label | Formula | What it shows |
|---|---|---|
| Total gifts | =COUNTA(A2:A26) | Rows with a creator handle. |
| Total spend | =SUM(H2:H26) | Product cost plus shipping across all gifts. |
| Posts | =COUNTIF(K2:K26,"Yes") | Gifts where Posted? is Yes. |
| Post rate | =IFERROR(B30/B28,"") | Posts divided by gifts. 0.4 means 40 percent. |
| Cost per post | =IFERROR(B29/B30,"") | Total spend divided by posts. |
| Revenue from codes | =SUM(P2:P26) | Revenue recorded against creator discount codes. |
| Orders from codes | =SUM(O2:O26) | Orders recorded against creator discount codes. |
| Overall ROI | =IFERROR((B33-B29)/B29,"") | (Revenue minus spend) divided by spend. 1 means you earned back double. |
The summary sits two rows below your last data row. If you add more rows than 25, extend the ranges.
The template is two CSV files that become two tabs in Google Sheets. Keep gifts and content separate: one gift can produce several posts, or none. For a fair engagement figure to put in the content log, use the engagement rate calculator.
| Tab | What goes in it | Formulas |
|---|---|---|
| Gifts tracker | One row per gift: who, what you sent, what it cost, delivery, whether they posted, the code and the revenue. | Total cost, ROI per row, and summary totals underneath. |
| Content log | One row per post: link, date, format, views, likes, comments, shares, saves and link clicks. | Interactions divided by views, per post. |
| Summary (optional) | A third sheet you make yourself, if you want a dashboard that pulls from the two above. | Point it at the summary rows under the Gifts tracker. |
A spreadsheet is the right tool for your first few dozen gifts. It stops being right when keeping it up to date costs more than the gifts. Common signs: you are retyping addresses and product choices into Shopify, you chase creators by DM for their details, or nobody can say which gifts are still in transit.
Seed handles the first half of that: creators apply through your branded link, and each application becomes a real $0 draft order in your Shopify admin. You keep the sheet, or drop it, for the part after shipping: posts and revenue. Read how it works in the guide to Shopify influencer gift orders, or work out what each gift costs with the gifting ROI calculator.
Keep one row per gift: creator handle, date sent, product and shipping cost, tracking number, whether they posted, the post link and any discount code. Update it weekly. The totals then show your spend, post rate and cost per post, which is what you need to decide whether to repeat the gifts.
At least the creator, what you sent and what it cost, whether it was delivered, whether they posted and where. Add a discount code with its orders and revenue if you want ROI. A second sheet for post metrics such as views, likes and saves helps you compare creators fairly.
Download the CSV, open Google Sheets, choose File then Import, upload the file and pick Insert new sheets or Create new spreadsheet. Check the formulas calculated. If they appear as plain text, use the copy button instead and paste into cell A1. Excel opens the CSV directly.
Give each creator a code, then record the orders and revenue from your Shopify discount code report. ROI here is revenue minus total cost, divided by total cost. It undercounts, because not every sale a creator drives uses their code, and revenue is not profit, so treat it as a floor.
The template is generated in your browser from the options you choose. There is no data behind it: the example row uses made-up placeholder values and the column choices are Seed's own suggestions.
total cost = product cost + shipping cost
ROI = (revenue from code − total cost) ÷ total cost
post rate = posts ÷ gifts
cost per post = total spend ÷ posts
ROI here counts only sales made with the creator's code, so it is a floor, and revenue is not profit. We could not verify how every spreadsheet app handles CSV formulas on import, so check that the formulas calculated after you import, and use the copy-and-paste button if they did not.
Sources checked
Last updated: October 29, 2026
Build a gifting agreement in under a minute — deliverables, posting window, usage rights, and FTC disclosure. Copy it or save as PDF. Free, no email.
The same contract generator, pre-set for an Instagram deliverable: in-feed post plus story.
The same contract generator, pre-set for a TikTok deliverable.
A content-licensing agreement for UGC, not a posting agreement. Usage rights and deliverables only.
For unpaid product-gifting sends specifically: the gift, deliverables, and usage rights.
Send personalized bulk Instagram DMs to creators without copy-pasting one message at a time. Built for outreach at volume.
The Chrome extension behind the DM assistant above. Install it, connect your Seed account, send from your own session.
Put in your product cost, shipping, and creator count, and get your real cost per piece of content, including your own hours. Ungated.
How much should you pay an influencer? Enter views and a CPM to get a fair cash range, and see if your gifted product alone is a fair trade.
Work out a creator's engagement rate on Instagram, TikTok or YouTube, by followers and by views. Average up to 12 posts. Free, no email.
Build an influencer media kit with stats, audience, past collabs and rates. Live preview, three layouts, save as PDF. Free, no signup.
A UGC or influencer rate card with deliverables, usage rights, whitelisting and bundles. Preview it, then save as PDF. Free, no signup.
Three ready-to-send pitch emails (cold, warm, follow-up) for creators asking brands for PR packages or collabs. Free, no signup.
What can you actually earn on TikTok? Sponsored-post rate by tier, Creator Rewards eligibility, and a TikTok Shop affiliate estimate. Free, no signup.
Sponsored feed post, Reel and Story rate ranges by follower tier, plus an affiliate-earnings estimate. Free, no signup.
Score a creator's video against your brief in about two minutes. Free, no login.
Enter how many posts you want and get the number of creators to contact and gift, using your own acceptance and post rates.
Plan a gifting campaign budget: product, packaging and shipping cost by lane, total cost and cost per creator.
Compare the cost per 1,000 views and per content piece of influencer gifting against Meta and TikTok ads, with your own numbers.
Answer six questions to find the right influencer deal type for a creator: gifting, a flat fee, or affiliate commission.
Build a free influencer gifting application form with the exact fields to ask, then copy it or run it live on Shopify.
A free outreach CRM template with statuses, follow-up dates and notes. Download the CSV for Google Sheets or Excel.
Generate a one-page influencer brief: product, key messages, dos and don'ts, disclosure and deadlines. Free, no signup.
Generate a short outreach DM or email offering influencers a gifted product, in your own tone and language.
Score your influencer outreach subject lines against a transparent checklist, and get better variants.
Pick a niche and platform for a hand-written hashtag set, mixed broad to niche. No made-up volume numbers.
Get a recommended monthly influencer budget, split across gifting, paid posts and UGC, from your revenue and stage.
Estimate the real cost of a PR package: product, box, inserts, packing materials and shipping.
Calculate what the content from your gifting campaign would cost to buy from an agency or UGC creators instead.
Estimate fair UGC rates from experience level, deliverables and usage rights, for brands and creators, sources linked.
Estimate fair YouTube sponsorship rates from a channel's average views, format and usage rights, sources linked.
Estimate expected reach for a creator's post, Reel or Story from follower count, using published benchmarks.
Calculate follower growth rate over any period and flag suspicious spikes between two checkpoints.
Enter a follower count to see its influencer tier under three published definitions, with typical CPM ranges.
Create $0 influencer orders in Shopify, tag them, and calculate the real COGS and shipping cost of every gift.
Generate hundreds of unique influencer discount codes from a prefix and download a CSV, ready for a Shopify bulk-codes app or the API.
Per-creator code conversion plus an estimate of the halo sales promo codes miss, with every assumption editable.
Paste your landing page and a list of creators and get one tagged UTM link per creator in bulk, as a CSV.
Price usage rights for creator content in ads: duration, channels and exclusivity, with editable percentages. Free, no signup.
Add the creator fee to your media spend to get blended CPM and CPA for TikTok Spark Ads or Meta partnership ads.
Turn a creator's fee and post stats into CPM, cost per engagement and cost per view, and compare with your own benchmark.
Estimate EMV from views, likes, comments and shares using values you set, plus an honest look at why EMV isn't revenue.
Find the most you can pay to acquire a customer through influencers, from your margin, repeat orders and target LTV:CAC ratio.
Find the highest affiliate commission you can pay influencers from your order value, costs and the profit you want to keep.
Build a tiered ambassador commission ladder from your margin, a starting rate and sales thresholds. Copy it or download CSV.
Work out ROI, ROAS and break-even revenue for a paid or gifted influencer campaign from your costs, commission and margin.
Get a step-by-step gifting campaign plan with dates and creator counts, from your goal, product and budget.
Score how well a creator fits your brand on a transparent, weighted checklist before you reach out.
Pick a launch date or holiday and get backward-planned recruit, ship and posting-window dates for 2026 and 2027.
See whether import VAT and duty likely apply when gifting product abroad, for the EU, UK, Switzerland and Norway, with official sources.
The regulator, required label and gifted-product rule in 10 countries, each with an official source. Not legal advice.
What the IRS, HMRC, CRA, ATO and other tax authorities say about gifted product as creator income, with sources. Not tax advice.
Seed turns each creator application into a $0 Shopify draft order, so your tracker only needs the results.