A Gemini Gem That Writes FF&E Specifications from Spec Sheets

1. List your schedule columns in order, for example: Tag, Item, Manufacturer, Model, Material, Finish or color name, Dimensions as published, Notes, Spec sheet source.
2. Decide what the Gem should do when a field is blank: write "not stated on sheet".
3. Decide whether the Gem outputs a table row or one labeled line per field. A table row is easiest to paste into a spreadsheet.

What you should see: A short list of columns with a rule for blanks. Troubleshooting: If your schedule has columns that are not on any spec sheet (location, quantity, status), leave them out of the Gem and fill them in yourself.

1. Go to gemini.google.com and sign in.
2. Open the sidebar and look for "Gems."
3. Choose the option to create a new Gem.

What you should see: A form with a name field, an instructions field and, in some versions, a place for knowledge files. Troubleshooting: Button names vary by version and account type. If you cannot find Gems, check your account's Gemini help pages. Your Workspace administrator may control access.

Name it "FF&E spec writer". Paste the text below into the instructions field, replacing the column list with your own.

You write one FF&E schedule entry at a time for an interior designer.
Input: text copied from a manufacturer's spec sheet for a single item.
Output: one table row with these columns, in this order: Tag, Item, Manufacturer, Model, Material, Finish or color name, Dimensions as published, Notes, Source.
Rules:
- Every value must come from the pasted spec text. Copy wording and units exactly as printed.
- If the text does not state a value, write "not stated on sheet". Never guess or fill a blank from general knowledge.
- Do not convert units, round numbers or combine dimensions.
- Never state or imply that an item meets a building code, accessibility standard or fire rating requirement. If the spec text mentions a rating or test, quote it in Notes and add "verify with manufacturer documentation".
- If I paste text for more than one item, ask me to send one item at a time.
- After the row, list any fields marked "not stated on sheet".

What you should see: The Gem name and instructions in the editor. Troubleshooting: If the Gem later adds commentary or opinions, add "No commentary. Only the row and the list of missing fields."

1. Save the Gem.
2. Open it and paste the spec text for one item you already know well.
3. Compare its row with the real sheet.

What you should see: A single row with your columns filled and gaps marked. Troubleshooting: If it fills a field the sheet never states, tighten the rule: "A value that does not appear in the pasted text is always 'not stated on sheet'."

This is a required step, not an optional one.

1. Open the manufacturer's spec sheet next to the Gem's row.
2. Check each field: model number, finish name, dimensions and units, material.
3. Correct anything that differs and note the sheet's date or revision if it has one.
4. Do not rely on the Gem for any code, accessibility, fire rating or compliance question. Those go to the architect or engineer of record and the local code official, using the applicable code text and the manufacturer's own documentation.

What you should see: A row you have personally confirmed. Troubleshooting: If you find errors in more than one field, stop using the Gem on that product line and paste text more carefully. Poorly extracted PDF text is a common cause.

1. Paste one item's spec text per message.
2. Copy each verified row into your schedule.
3. Start a fresh chat after about ten items so the conversation stays clear.

What you should see: A schedule you built row by row, with sources recorded. Troubleshooting: If the Gem merges two items, send them separately.