Extract products from a URL using Google Chrome, process them with GPT, filter only new items, and save them to Google Sheets
Stop wasting time copying product details by hand. Instantly grab the latest products (and deals!) from any shop page and feed them straight into Google Sheets with zero hassle.
Manually collecting and tracking new products from websites like Amazon eats up hours—but worse, you’re left cross-checking, reformatting, and still risking missed launches or duplicate entries. For users managing product catalogs, price tracking, or deal updates, the grind of revisiting the same pages, copying product details, and checking Google Sheets becomes a never-ending, error-prone slog. If you don’t automate, you’re losing valuable time, risking outdated data, and missing chances to capitalize on new listings—while important updates might slip by unnoticed.
This Botize formula solves it all by automatically visiting your chosen product URL with Google Chrome, extracting the relevant product details (like name, price, savings, image, and links), and letting GPT filter and structure everything perfectly for you. It then cross-checks for new products—excluding anything you’ve already processed—so only fresh entries are added to your Google Sheet, avoiding clutter and duplicate work. You control how often it runs (every hour, or tweak as needed), which data points to capture, and can precisely focus extraction for maximum relevance: all hands-free, precise, and always up-to-date.
Ready to transform painful product tracking into set-and-forget bliss? Follow the step-by-step Botize guide to set up automated product extraction and Google Sheets updates—or jump straight in using the ready-to-go formula linked next. Empower your workflow, never miss a new product, and let automation do the heavy lifting!
Automate this task with 6 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Set up a trigger so the automation runs on a regular schedule.
Copy and paste this prompt into the AI editing tool.
Schedule this automation to run automatically every hour. ⤵
Click the 'Apply this task' button to confirm.
-
4
Open the specified product page in Chrome and gather all the items from the product list.
Copy and paste this prompt into the AI editing tool.
Use Google Chrome to visit the provided URL with a list of products, and extract the section containing all product items and their details. Focus only on the products list to avoid unrelated page content. ⤵
Click the 'Apply this task' button to confirm.
-
5
Send the extracted page contents to GPT to organize the product information in a clear, consistent format.
Copy and paste this prompt into the AI editing tool.
Send the extracted product list from the previous step to GPT and ask it to generate a structured list of products with the following fields for each: product name, current price, discount or savings, image URL, and product URL. Make sure the result is structured for easy further processing. ⤵
Click the 'Apply this task' button to confirm.
-
6
Pull out only the products data from GPT’s structured response.
Copy and paste this prompt into the AI editing tool.
From the GPT output, extract just the products array, so it contains only the list of products with their details. ⤵
Click the 'Apply this task' button to confirm.
-
7
Filter the product list so only new products are kept and already-seen products are removed.
Copy and paste this prompt into the AI editing tool.
Compare the list of extracted products to previous entries. Filter out any products that have already been processed in the last 30 days, and keep only those that are new. ⤵
Click the 'Apply this task' button to confirm.
-
8
Add the new products to a Google Sheets file, one product per row, with all their details in the correct columns.
Copy and paste this prompt into the AI editing tool.
Take the final filtered list of new products and add each one as a new row in the specified Google Sheet. Fill in the name, price, discount, image URL, and product URL columns for each product. ⤵
Click the 'Apply this task' button to confirm.
-
9
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Turn Any Product Page Into Your Personal Tracker—Automatically
Here's the magic: Pop in any URL from a product listing (think Amazon, eBay, or your favorite shop), and our friendly Chrome extension scoops up every item on the page. GPT comes next, sorting the mess into a neat list: names, prices, discounts, images, links — the whole works. But it doesn’t stop there: old products won’t sneak in again. It remembers what you’ve seen and only adds what’s new, and you’ll see it all appear instantly in your chosen Google Sheet. One link, and your sheet stays fresh, forever.
| Manual | Botize | |
|---|---|---|
| Open product page and find new products | 10 minutes | 0 Minutes |
| Copy product info, images, prices, and links | 20 minutes | 0 Minutes |
| Compare with previous spreadsheet and eliminate duplicates | 15 minutes | 0 Minutes |
| Format and paste data into Google Sheets | 10 minutes | 0 Minutes |
| Total | 55 minutes | 0 Minutes |
Hey! If you’re tired of missing new products or spending hours updating a spreadsheet by hand, you’ve landed exactly where you need to be. This is not another clunky Zapier or Make scenario—this actually understands product pages.
Amazon Category Scraping
You want to keep tabs on the latest phones, kitchen gadgets, or books as soon as they appear on Amazon. This automation grabs every new listing and logs it straight into your database, with prices, images, and links attached.
Save Hours
No more manual copy-paste or endless scrolling—your future self will thank you.
Never Miss Out
Get notified about only the new stuff, so every deal or arrival lands in your hands first.
Zero Guesswork
It’s so simple, your dog could almost do it. Goodbye configuration headaches.
Online Retail Surveillance
You resell sneakers or limited edition gear. Pop in your trusted product page and get every new drop the minute it’s published, no more missed opportunities or copy-paste nightmares.
⌾︎ Perfect if you track price drops, new arrivals or inventory for business or shopping.
⌾︎ A lifesaver for resellers, deal hunters, product managers, or anyone who updates catalogues.
✕ Not for you if you never browse product pages or spreadsheets are your nemesis.
✕ Won’t help if your shop only updates once a year—this is for real-time enthusiasts.
✓ Choose which fields to extract for each product (eg. ratings, reviews, or only discounts).
✓ Fine-tune the Chrome extension to focus only on what's important (skip ads, banners, or unrelated info).
✓ Configure how often the automation runs, from every hour to once a day, so you never miss a beat.
This automation uses the free Google Chrome extension to access a product URL (for example, an Amazon category page) and extract all its content. It then uses GPT to process the result and generate a structured list of products, including fields such as name, current price, discount, image URL, and product URL. Next, the task filters the results to keep only new products, excluding those that have already been processed in previous executions. The remaining products are then added to your Google Sheets as new rows. You will need to provide the URL of the product page (it should be a page containing a list of products) and the URL of your Google Sheets file. Optionally, you can customize which data you want to extract from each product. It is also recommended to optimize the Chrome extraction step to focus only on the product list, excluding any other elements that may introduce noise or unnecessary information for GPT.
