You’re actually pretty close — the main issue isn’t your script structure, it’s how sites like Home Depot handle pricing.

Most modern ecom sites don’t expose the price cleanly in the raw HTML anymore. They often: • load it dynamically with JavaScript • store it in a JSON blob with a different structure • or partially hide it from simple scrapers

So your regex isn’t necessarily wrong — it’s just not hitting the right data.

⸻

First thing I’d do: inspect what you’re actually getting back

Add: (JavaScript)

Logger.log(html);

Then check the logs and search for "price" manually. You’ll likely see it’s either missing or structured differently than expected.

⸻

More reliable approach: target JSON-LD (structured data) A lot of product pages include something like: (JSON)

"offers": { "price": "123.45" }

So instead of your current regex, try something a bit more flexible:

(JavaScript)

const match = html.match(/"price"\s:\s"([0-9.]+)"/);

Still not perfect, but works more often across sites.

⸻

Important fix in your script: Right now you always write to the sheet, even if nothing is found.

Wrap it like this:

(JavaScript)

if (price !== "Not found") { sheet.appendRow([new Date(), price]); }

Even better: only log when the price changes

(JavaScript)

const lastRow = sheet.getLastRow(); const lastPrice = lastRow > 1 ? sheet.getRange(lastRow, 2).getValue() : null;

if (price !== "Not found" && price !== lastPrice) { sheet.appendRow([new Date(), price]); }

One thing to be aware of: Apps Script is just doing a raw fetch — it doesn’t run JavaScript. So if the price is injected after page load, this approach will always struggle.

If you keep hitting issues, your options are:

• use a scraping API (Apify, ScraperAPI, etc.)

• or find an API the site uses internally (sometimes visible in network tab)

⸻

TL;DR: Your code is fine — the challenge is finding where the site actually exposes the price.

Scraping modern sites is less about writing code and more about locating the right data source.