Influencer gifting without the spreadsheet: sizes, addresses and tracking that scale

Where the spreadsheet breaks

A spreadsheet is a fine way to start. At ten boxes, it is faster than any tool. The trouble starts when the same sheet has to carry a list, a size chart, addresses, shipping status, tracking numbers and post links, edited by three people, fed by DMs.

From packing and shipping gift boxes for brands, these are the failures we see most:

• Wrong size. The size was asked in a DM, written down from memory, or guessed. A wrong size is two boxes and an awkward message.
• Bad address. A missing apartment number or a typo in the zip code. The parcel comes back two weeks later, after the launch.
• Double gifting. The same person gets the same product twice because two people worked from two copies of the list.
• Lost tracking. Labels were bought in one tool, tracking numbers never made it back to the sheet, and nobody knows what was delivered.
• Invisible posts. Someone has to scroll every profile to see who posted. Most teams give up after week two.
• Privacy drift. Home addresses sit in a shared sheet forever, visible to anyone with the link.

The principle: one record per gift

Every fix below follows one rule. Each gift is one record that holds the person, the product, the size, the address, the shipment, the tracking and the posts. Data is entered once, by the person who knows it, and everything downstream reads from that record.

That sounds like software, and at scale it is. But you can apply the principle with any tools: one source of truth, no copying.

Sizes: let people choose from what you have

Asking "what size are you?" invites a free-text answer you then have to interpret. Show the actual size and variant options in stock and let the person pick.

• Use your real size chart and link to it from the claim step.
• Hide sold-out sizes so nobody claims something you cannot send.
• For apparel and footwear, ask for usual size in one or two reference brands. It catches people between sizes.
• Save the answer. Next time you gift the same person, you should not need to ask again.

Comms keeps a size passport for each talent: they enter their sizes once, and any brand gifting through Comms sees the right size at claim. They can still change it per gift.

Addresses: collected by the recipient, checked, and kept private

The person receiving the gift should type their own address into a form that validates it. You should not be copying addresses out of DMs.

• Validate the address before the label is bought, and flag anything a carrier will reject.
• Ask only for what shipping needs: name, address, and a phone number if the carrier requires it.
• Say how the address will be used, who can see it, and when it will be deleted.
• Limit who on your team can see full addresses. Most people only need the city.
• Offer a private option where labels are printed for the brand without the brand ever seeing the street address.

There is more on privacy obligations in our seeding compliance checklist.

Approvals: decide before anything ships

If talent can request a gift, someone needs to approve it, and that decision should happen on the same record. For agencies, the client may need to approve too. Build that step in, rather than forwarding screenshots for sign-off.

Two guards save real money: a cooldown that warns you when someone was gifted recently, and a cap on how many boxes a drop can approve. See how agencies run client approvals on Comms for agencies.

Shipping: generate it from the record

Once a gift is approved, the shipment should be created from the stored size and address, not retyped. There are two clean patterns:

1. Buy labels directly on your carrier account and print them in a batch. Good for in-house packing.
2. Push the gift as a $0 order to Shopify, ShipStation or your 3PL, so it ships alongside regular orders with the right SKU and size.

Either way, the tracking number should be written back to the gift record automatically. Comms supports both patterns: labels on your own UPS, FedEx or DHL account at your negotiated rates, or $0 orders to Shopify or ShipStation, with tracking coming back on its own.

Tracking and posts: close the loop

Delivery status tells you when to send the check-in message. Posts tell you whether the gift worked. Both belong on the gift record.

• Send one check-in when tracking shows delivered.
• Log every post against the gift that caused it, with a link and the date.
• Value posts with one consistent method. See how to measure product seeding ROI.

Comms finds posts automatically for connected talent and values them in In-Market Reach, In-Market Value and ROI, so nobody has to scroll profiles on a Friday afternoon.

If you are staying on a spreadsheet for now

That is reasonable under about 25 boxes a month. Make it hold up:

• One sheet, one owner, one row per gift. Never copies.
• A form for size and address that writes into the sheet, so nobody retypes.
• Dropdowns for sizes and status instead of free text.
• A column for the date last gifted, and a rule to check it before inviting.
• Tracking numbers pasted in the same day labels are bought.
• Addresses removed from the sheet once the parcel is delivered.
• A weekly 20-minute pass to log posts.

When that weekly pass starts taking an afternoon, it is time to move. You can try the guided demo to see the one-record workflow end to end.

Questions people ask