Catalog 60+ Physical Items with Gemini and a Whiteboard Grid
Apps it uses
My mother recently moved into a retirement suite, which meant downsizing her possessions. We ended up with dozens of physical items she no longer had space for, and we wanted her children and grandchildren to have an opportunity to sign up for the family items they loved before anything was donated. I needed a way to catalog everything quickly, share the information remotely, and verify that we weren't accidentally giving away items of significant value.
I tested a physical-to-digital workflow using Gemini. Instead of putting the items in a pile or typing out endless lists, I drew a numbered grid on a large whiteboard, placed one item in each square, and took a few photos. Gemini identified the objects by grid position, categorized them, estimated their market values, and built a ready-to-use spreadsheet with a signup column.
The physical staging took about 30 to 45 minutes, depending on how many items were on that particular board. The entire digital workload—including cataloging, valuing, formatting, and creating the spreadsheet—took under 10 minutes. The process turned an overwhelming chore into something manageable and produced an end product that was easy for everyone to use.
Step-by-step
- I drew a simple grid on a whiteboard, numbered each box, and placed one item in each square before taking photos.
- I uploaded the photos to Gemini and prompted it to identify every item by its board name and grid number.
- I asked Gemini to classify each item into logical groups, such as Glassware, Ceramics, and Woodcraft, and provide quick, realistic resale-market valuations based on visual condition.
- I asked Gemini to generate a downloadable Excel file formatted as a signup catalog, with columns for Item ID, Grid Number, Description, Category, Estimated Value, and a blank "Claimed / Signed Up By" column for family members to enter their names.
- I uploaded the file to Google Drive, converted it to Google Sheets, and added a note at the top explaining how tie-breakers would work if two family members wanted the same item.
- Industry
- Personal & Lifestyle
7 comments
Have a question about this workflow, or a way to improve it?
Log in to comment Create a free accountThis is such a clever low-tech-to-high-tech bridge, the numbered grid doing all the identification work in one photo. Turning a hard family moment into something manageable in under an hour is genuinely lovely! Thanks for sharing this!
I love this so much, brilliant. Brainstorming how I could use a similar approach to create a photo book of family heirlooms or collections and the stories that go along w them. Instead of physical whiteboard staging, though, I’ll try using the FrameMagic app on my phone which has an easy numbered grid option where users can add up to 25 pics. Might be a big timesaver! I’m curious if there’s a reason the physical staging worked best in your case, though. And how you all agreed to break a tie!
I wish my task were so simple. My father passed almost two years ago, in another state, and there's been nothing but problems. He lives in a fairly isolated town, and merely driving there, staying a day, and driving back is 4-5 days. I had decided to bring everything here to handle it, which is still slowly progressing. I had almost 500 photos, both from before when I'd seen something interesting, and after. I identified the photos, out of the thousands I have, by using the GPS data in the photos, and fed the photos into Claude, telling it to identify all distinct non-consumable items. I spent several days on the first batch of about 50 photos, one of which was a panorama. I added columns, merged columns, tried to figure out what room I was looking at (I have one group of photos I've called "yarn room" since I haven't figured out what room it really is), had a column redone when Claude forgot to update it, etc. It took a couple of weeks to get the first list. I spent another couple of weeks manually cleaning the results, by merging duplicates, fixing descriptions and locations, etc., trying to identify the origin of more interesting items, etc., resulting in a list of about 800 items. And I'm sure there's hundreds more items I don't know about or that AI missed; there were many I simply told it to consider a single collection. He had already sold many items, so I still need to identify what I brought / am bringing here, and what's not present. I'm now at the phase of having family (who live even further days away) decide what items they want me to take to them, and I'll sell the rest. I need to go through the wills (you'd think there's only one will; that's one of the problems) and identify everything mentioned. I'd like to be able to make a web page with photos and descriptions for them to look at, but since it's a one-shot, I don't want to pay for something.
I wish that I had this when my mother-in-law was moving into assisted living. What a great idea. One question: How did you place large items (like a painting or furniture) on your whiteboard grid? Did you stick a photo of the object in its place?
Posting guidelines