The finds sheet standard

How to lay out a finds spreadsheet so NinjaBuy reads every product, with its picture, name, price and link.

Making a finds spreadsheet? Build it this way and every product in it opens on NinjaBuy as a card with your picture, your name and your price, ready to buy. Shoppers paste your sheet's link into our search bar (see Shop from a Google Sheet), so a sheet that follows this page works for everyone who opens it on NinjaBuy.

You don't have to follow it to the letter. We read most sheets as they are. But a sheet built this way reads perfectly.

The short version

  1. Share the sheet with Anyone with the link.
  2. Put one product on each row.
  3. Use four columns in this order: Picture, Name, Price, Link.
  4. Make the link a real, clickable link to the product page.
  5. Use one tab per category.

Sharing

In Google Sheets, open Share, set General access to Anyone with the link, and keep the role as Viewer. We can't read a private sheet.

  • Turning off downloading, printing and copying is fine. We still read the sheet.
  • A sheet published with File → Share → Publish to web works too.
  • Opening a sheet on NinjaBuy never changes it.

One product per row

Give every product its own row, with its own link. The link is what turns a row into a product: everything in the row describes the item that link opens.

Start the table with a header row, such as:

PictureNamePriceLink
(the product's picture)Nike Dunk Low Panda¥189LINK
(the product's picture)Carhartt Detroit Jacket¥248LINK

We recognize a header row by words like Picture, Image, Name, Item, Price, Link, QC or Notes, and never mistake it for a product. Repeating the header at the top of each section is fine.

Banner rows above the table and category rows between sections are fine too.

Extra columns. Every cell in the row can show up on the card, up to four short lines. Put anything else (sizing advice, a batch name, a rating) after the link and keep it short, or leave it out.

List each product once per tab. For several colors of one listing, use one row and name the colors in the Name cell.

The link is the most important cell in the sheet.

  • Make it clickable. Select the cell and press Ctrl+K (⌘K on a Mac) to insert a link, or paste the full address and let Google turn it blue. Text that only looks like an address is not read as a link.
  • Link straight to the product page: a Taobao, Tmall, Weidian or 1688 item, or the same item on another shopping agent (Kakobuy, CNFans, MuleBuy and the like). All of them open as the product on NinjaBuy.
  • Use full links, not short links. Shortened addresses take longer to open, and shoppers who aren't signed in don't see them at all.
  • The link's text can be "LINK", "Buy" or an agent's name; we treat those as a button. If you write the product's name as the link's text instead, it becomes the card's name.
  • A cheaper version of the same item goes in a column headed Budget, or in a link labelled "Budget LINK". It stays with the main product instead of becoming a card of its own.
  • Links to the same item on several agents can sit in the same row. They open as one product.

These are not products and are left out: shop pages, Yupoo and QC photo albums, sign-up or referral links, Discord invites and links to other websites. You can keep them in the sheet. Links to your other tabs and to other Google Sheets keep working as navigation.

The Picture column

  • Insert pictures in the cell: Insert → Image → Insert image in cell. This is the most reliable way.
  • A picture placed over the cells works when its top-left corner sits inside the product's row. A picture that starts in a gap row or a row away from its product goes missing.
  • With =IMAGE(), click Allow access when Google asks. Until you do, the cell shows an error instead of the picture.
  • Use JPEG, PNG, WebP or GIF pictures under 5 MB. SVG pictures are not read.
  • Don't put the only link on a picture. A product reached only by clicking its picture isn't found. Keep the link in its own cell.

A small icon you repeat on every row (a flag, a logo) is fine. We skip pictures shared by several products and show each product's own.

The Name column

  • Keep it short: the first 120 characters show on the card.
  • Use words: a cell with only emoji or a dash is skipped.
  • Give it its own cell, not merged into the price or the link.

The Price column

Write only the price in the cell, with its currency:

  • ¥189, CN¥189, 189元, 189 yuan
  • $28, US$28, €25, £22
  • a range: ¥80-120

Add anything else ("with shipping", "per pair") in another cell. A price with extra words in the same cell shows as a note, not as the price.

We show your price as you wrote it, without converting it. The price a shopper pays is the live price on the product page.

Tabs

  • One category per tab (Shoes, Tops, Bags…), named after the category. Tab names become the sections of your sheet on NinjaBuy.
  • An intro tab first is fine. A link without a tab opens on the first tab that has products.
  • Hidden tabs and hidden columns are not read. Don't hide the Link column.
  • Big tabs are fine. We read every row however long the tab is, and load products in pages of 200.

Layouts that read less well

These still open, but parts of them can go missing or land on the wrong card. If your sheet uses one, the fix next to it brings it back to the standard.

LayoutWhat can go wrongFix
Several products side by side in one rowA price or name lands on the neighbouring productOne product per row, or at least two empty columns between products
One product spread over several rowsThe rows split into extra cards or lose their pictureOne row per product; if you merge cells, merge no more than 6 rows and include the link's row
Empty spacer rows with pictures in themThe picture misses its productPut the picture in the product's own row
Two different products' links in one cellBoth cards share one name and pictureOne product per row
A formula error such as #REF!The error shows on the cardFix or clear the cell

Check your sheet

Paste your sheet's link into the NinjaBuy search bar while signed in. Each product should show as a card with its picture, name and price. Switch to Sheet to compare with your layout, and look at the count of links we couldn't open at the top of the page.

Changed the sheet after it was first opened on NinjaBuy? We may still be showing the earlier version. Contact us and we'll refresh it.