Free influencer gifting tracker template for Google Sheets

Why gifting comes first

Product seeding is usually the first step in building long-term creator relationships. You send product out for free and watch what happens: who actually tries it, who likes it enough to share with their audience, and who could become a real partner. The goal isn't squeezing out one post — it's finding the people who genuinely like the product and keep talking about it when you're not pushing them.

This tracker keeps that organized. Handled well, it's not a log of shipments — it's your first filter for who's worth building with.

The full tracker, with example rows

Here is the whole tracker. Copy the header row into a blank sheet, freeze row one, and set the dropdowns noted below. The two rows show the shape once it's in use.

The free tracker in Google Sheets — Status color-coded green for Posted, red for No-show.

Dropdowns to set: Platform (Instagram / TikTok / YouTube), Status (the ladder below), Posted? (Y / N), Gift again? (Y / N). Everything else is free text or numbers.

👉 The copied Google Sheet has these columns and dropdowns pre-built on the first tab, plus a second Summary tab with the formulas below already wired up.

Your weekly workflow and metrics

The sheet only works if updates happen on a rhythm. Run it weekly:

• Monday — source and contact. Add new creators as Sourced, send DMs/emails, move replies to Contacted → Agreed. Collect the shipping address the moment someone agrees.
• On agree — ship. Place the order, paste the exact SKU into Product sent and your cost (not retail) into Product cost, add the Tracking #, set Status Shipped.
• Midweek — check delivery. Update Delivered date from the carrier and move Status to Delivered. This is the step everyone skips; it's why Posted? sits wrong.
• Friday — capture posts. For anything delivered, check for a post. Paste Post link, set Posted? = Y, Status Posted. If the window has passed with nothing, Status No-show.
• ~7 days after a post — log numbers. Fill Views and Engagement once the post has settled, then set Gift again?

The one rule that keeps the sheet honest: never fill Gift again? from memory. Leave it blank until Status is Posted or No-show and the post link is in the row (or confirmed absent).

Status ladder (set as the Status dropdown, in order): Sourced → Contacted → Agreed → Shipped → Delivered → Posted, plus No-show (delivered, window passed, no post) and Skip (declined / not a fit).

Metrics — drop these into a summary row or second tab so the sheet totals itself:

Total product spent:   =SUM(J2:J)              // Product cost column
Posts landed:          =COUNTIF(G2:G,"Posted")
Post rate:             =COUNTIF(G2:G,"Posted")/COUNTIF(G2:G,"Delivered")
Cost per post:         =SUM(J2:J)/COUNTIF(G2:G,"Posted")

Pro tips

Once the sheet is live, a few ways to make it more useful:

• Color-code with conditional formatting. Turn rows green where Status = Posted and red where Status = No-show. Progress becomes scannable at a glance — who to gift again, who to drop.
• Save a "posted" filter view. Filter to Posted? = Y. The creators who actually posted are your shortlist for affiliate or ambassador offers later — this sheet is where you find them.
• Keep the product-spend total visible. The running Total product spent is your ROI denominator; pin it to the top of the Summary tab so the cost of gifting is never a surprise.
• Capture context in Notes. "Loved the packaging," "asked for kids' sizing," "slow to reply" — small lines that make the next pitch personal instead of generic.

💡 Start small. You don't need every field filled on day one. Begin with 5–10 creators and the operational columns; add views, engagement, and the Gift again? discipline as the batch grows. Add structure as the program does — not before.

A completed campaign

Here is a finished spring batch, trimmed to the columns that carry the decision:

Read across: two creators earned a repeat gift, one got product and never posted (drop from the next batch), one is still inside the post window so the decision stays blank. Four rows, $180 of product, a clear next action for each. Post rate 2 of 3 delivered; cost per post $65. That is the whole job of the sheet.

Stay in Sheets or move to Sift?

The sheet isn't the problem — it's a genuinely good starting point while the batch is small and one person owns every update. It gets shaky for one predictable reason: every field is something a human has to notice and type. Addresses land across DMs and email and get pasted in the wrong row; tracking numbers go un-pasted; delivered packages are never checked; post links depend on someone remembering to look a week later; the same creator gets pitched twice because the earlier reply lived in a DM. Each miss is small and cumulative — one dropped post is a creator who held up their end and got cut.

Stay in the sheet if: one person owns every update, you're under ~15 active creators per batch, addresses come in one channel, and Gift again? still reflects reality without re-checking creators by hand.

Move to Sift when: two or more people edit it, addresses arrive across DMs and email, you've mailed product to a wrong or stale address, or you no longer trust Gift again? without re-opening each creator's profile.

Import the same sheet into Sift

When maintaining the sheet becomes the work, move one live campaign — not your whole history — into Sift. Upload the exact Google Sheet or CSV above and it becomes creator profiles with full history. From there the manual fields fill themselves: creators enter their own addresses via a link, shipping status syncs from the carrier, and posts are captured with their numbers when they go live. Gift again? stops being a memory test.

It's $39/mo for up to 100 active creators — about the cost of one gifted package — month-to-month, no demo call. Use the spreadsheet for free; import it into Sift when you need outreach, gifting, posts, and creator history to stay current without manual updating. It works with creators you found anywhere, and when your list grows past what you can vet by hand, AI vetting is one toggle away.