Gear Page Helper

One-click extraction of product info from any Amazon page into a Google-Sheets-ready row. Drag the orange button below to your browser's bookmarks bar, then click it from any Amazon product page.

Step 1 — Install the Bookmarklet

  1. Show your bookmarks bar (Chrome/Edge: Cmd/Ctrl + Shift + B · Safari: View → Show Favorites Bar · Firefox: View → Toolbars → Bookmarks Toolbar).
  2. Drag the orange button below onto your bookmarks bar. It'll show up as "Gear Grabber".
  3. You only do this once. After that, the button stays in your bookmarks forever.

Drag this onto your bookmarks bar

Gear Grabber
If dragging doesn't work in Chrome: Chrome sometimes refuses to drag javascript: URLs to the bookmarks bar.
  1. Click the "Copy bookmarklet URL" button below to copy the full URL to your clipboard.
  2. Right-click the bookmarks bar → "Add page..." (or press Cmd/Ctrl + D, then click "More" to expose the URL field).
  3. Name it "Gear Grabber" and paste the URL into the URL field. Save.
Quick test: after installing, click the bookmark while on this page first. You should see a yellow toast saying "Open an Amazon product page first, then click the Gear Grabber bookmark." — that confirms the bookmark is installed and the JavaScript is running. If you see NOTHING, the bookmark URL didn't save properly; redo the install steps above.

Step 2 — Add a Product

  1. Browse to any Amazon product page (e.g., a spray gun, sander, PPE).
  2. Click the "Gear Grabber" bookmark on your bookmarks bar.
  3. A panel pops up on the right side of the Amazon page with the extracted data already filled in: title, image, price, rating, review count.
  4. Pick a Module (B2, B3, etc.) and optionally a Ribbon (Instructor's Pick, Class Required, Flagship). Fill in the Product Type field (e.g., "Spray Gun") so the auto-badges work.
  5. Click the big orange "Copy Row" button. The row is now in your clipboard as a tab-separated line.
  6. Open your Gear Google Sheet, click the first empty cell of a new row, paste (Cmd/Ctrl + V). Google Sheets automatically splits it into the right columns.
  7. Done! The gear page will refresh within an hour (or instantly in an incognito window).
Column order pasted into Sheets:
title  ·  description  ·  module  ·  imageUrl  ·  amazonUrl  ·  ribbon  ·  active  ·  order  ·  productType  ·  price  ·  rating  ·  reviewCount
The bookmarklet leaves the order column blank — fill it in manually so you control the display sequence.

Troubleshooting

  1. Bookmark doesn't drag? Some browsers block dragging links labeled "javascript:". Right-click the orange button → "Add to bookmarks" or "Add to Reading List" if dragging fails. Then edit the bookmark's URL to the address shown when you hover over the orange button.
  2. Panel never appears? Make sure you're on an actual Amazon product page (URL contains /dp/ or /gp/product/). The bookmarklet checks the hostname and refuses to run on non-Amazon pages.
  3. Some fields are blank? Amazon's page layout occasionally changes. The bookmarklet falls back to multiple extraction strategies but may miss new layouts. Just type the missing value manually in the panel before copying.
  4. Copy button does nothing? Your browser may need to grant clipboard permission once. The bookmarklet also includes a textarea-fallback, so the copy should still work on older browsers.
Show bookmarklet source code (for transparency)