How-to guides
How to Make a Group Buy Order Sheet from Screenshots
Group buys fall apart in the details. Someone sends a screenshot, someone else sends a voice note, and you end up cross-referencing three chat threads to figure out who ordered what. Making a group buy order sheet that everyone can trust starts with a single structured file — one that shows the product, the price, and who owes what, without you retyping everything by hand.
snapNsheet reads product screenshots and outputs an Excel file with embedded photos, names, quantities, and prices already filled in. That gives you a solid base to build per-person columns on top of, rather than starting from a blank spreadsheet.
Step 1: Decide What Goes Into the Order
Before collecting anything from members, agree on a cut-off. Group buys get messy when people keep adding items after you have already started compiling. Set a deadline, specify which shop or platform the order is from, and ask everyone to send you screenshots of exactly what they want — not links, not product names typed in a message, but actual screenshots of the product page or cart. This single rule saves more time than any tool can.
Step 2: Collect Screenshots from Every Member
Ask each person to screenshot their chosen products clearly. The image should show the product name, the selected variant (size, colour, quantity), and the price. Screenshots cropped too tightly or taken at low brightness can make prices hard to read. If someone sends a cart screenshot with multiple items, that works too — snapNsheet handles up to 10 screenshots per conversion and up to 75 products in total, so a cart with several items is fine. Keep the files organised by person before you upload: a simple naming convention like 'anna-cart.png' or 'ben-item1.jpg' goes a long way.
Step 3: Upload the Screenshots to snapNsheet
Go to snapnsheet.com and start a new conversion. Upload the screenshots — PNG, JPG, or WEBP files up to 8 MB each. You do not need to connect any store account or log into any shop; the app reads the images directly. Once processed, snapNsheet shows you every detected product row on screen before you download anything. Check that the names, quantities, and prices look right. If a price was partially cut off in a screenshot, it will not appear — that is worth catching before you build the rest of the sheet.
Step 4: Download the Excel File and Review the Base Sheet
Download the .xlsx file. Each row contains the cropped product photo embedded in a cell, the product name, quantity, unit price, line total, and a grand-total formula at the bottom. This is your master product list — the raw material for the group buy order sheet. Open it in Excel or Google Sheets. At this point you have a clean, photo-illustrated record of every item in the order, which is already more useful than a text list copied from a chat.
Step 5: Add Per-Person Columns
Insert a column for each member to the right of the existing data. Label each column with the person's name. In each cell, enter the quantity that person wants of that product — zero if they did not order it. Add a formula in a totals row at the bottom of each person's column to sum their quantities, and a separate formula to calculate their individual cost based on unit price. Keep the grand-total formula that snapNsheet already built; it gives you the full order value at a glance, which is useful when you need to confirm the combined order amount before placing it.
Step 6: Handle Shipping and Fees
Group buys often involve a shared shipping cost or a small handling fee for the person coordinating the order. Add a dedicated row below the product list for shipping. Divide it proportionally — either equally across members or weighted by order value, depending on what the group agreed. A simple formula dividing the shipping cell by the number of members works for equal splits. Document the method in a note cell so there is no ambiguity when it is time to collect payment.
Step 7: Share the Read-Only Link
Once the sheet is ready in snapNsheet, your saved list is stored for 90 days in My Lists. You can share it with a read-only link — useful for letting members verify their own rows without editing anything. Send the link to the group so everyone can confirm their items and amounts before you place the order. This step catches mistakes early: a wrong size, a quantity that got doubled, a price that changed since the screenshot was taken.
Step 8: Keep a Record After the Order Is Placed
After the group buy goes through, save the final Excel file somewhere the group can access it. It serves as a receipt — who ordered what, at what price, and what they owe. Because the product photos are embedded directly in the cells, there is no ambiguity about which item is which, even weeks later when people have forgotten the details. If you run group buys regularly, the 90-day save window in My Lists means recent orders stay accessible without any extra archiving effort on your part.
Frequently asked questions
Can I upload screenshots from different shops in one conversion?
You can upload up to 10 screenshots per conversion regardless of source, but results are most reliable when all images come from one shop and one order. Mixing stores in a single upload can make the output harder to organise. Better to run separate conversions and then combine the sheets manually.
What if a member's screenshot shows a price in a different currency?
snapNsheet recognises EUR, USD, and GBP. If a member sends a screenshot with a price in a different currency, that figure may not be read correctly. Ask those members to screenshot a version of the page that displays a supported currency, or enter their prices manually in the downloaded sheet.
How do I handle products where the price was cut off in the screenshot?
Prices that are hidden or cropped out of the image cannot be read. The product row will still appear, but the price cell will be empty. You can fill it in manually in the downloaded Excel file before building the per-person columns.
Is the shared read-only link visible to anyone with the URL?
Yes — anyone who has the link can view the list. It is read-only, so viewers cannot edit anything, but the link itself is not password-protected. Share it only with the people in your group buy.