Google Sheets template

Google Sheets Price Monitor

Track competitor prices and stock in a sheet. Paste product pages, get the price every day, and an email when it drops.

Set up in four steps.

About two minutes from copy to first results.

  1. 1

    Copy the sheet

    Make your own copy in Google Drive. Nothing is shared back with us.

  2. 2

    Get a free API key

    Sign up for Geekflare: 500 free credits a month, 500 price checks, no card needed.

  3. 3

    Add your key

    In the sheet, open Price Monitor → Set API key and paste it.

  4. 4

    Add products and schedule

    Paste product URLs in column A, then Price Monitor → Check daily at 6 AM. Turn on email alerts from the same menu.

What every run logs.

Each check updates the product's row and adds a line to the History tab, so you can chart any product's price over time.

ProductThe product name, read from the page.
Price, CurrencyThe lowest price you can buy at now. With a Variant set, the price of that size, colour or SKU.
Previous price, ChangeLast check's price and the difference, drops in green and rises in red.
In stockWhether any matching variant can be bought.
StatusOK, or the error. A failed check keeps the last good price.
History tabDate, product, price, currency and stock for every check, ready for a line chart.

What it costs to run.

1 credit per price check, on the same credits as every Geekflare API. Failed price checks cost nothing.

Free$0/mo

500

price checks a month

500 credits

Starter$19/mo

10,000

price checks a month

10,000 credits

Growth$69/mo

100,000

price checks a month

100,000 credits

Business$349/mo

1,000,000

price checks a month

1,000,000 credits

Questions

Before you copy it.

Yes. The sheet reads each product page with the Geekflare Web Scraping API, at 1 credit a check. A free account includes 500 credits a month with no card required.

Most online stores, including Shopify and WooCommerce shops, with no selectors to set up. Pages where no product is found show “No product found on this page”. Check any page first with the free Product Data Extractor.

Write it in the Variant column, as a SKU or words from the variant name, such as Black 10. Every word has to match. Left empty, the sheet tracks the lowest price on the page.

Turn them on with Price Monitor → Email me price drops. After each check you get one email listing products that dropped in price, fell below the price in “Alert below”, or came back in stock. It goes to your Google account's address only.

Yes. Every check adds a row to the History tab. Filter it to one product and insert a line chart of Date against Price.

Copy it, add your key, and start monitoring.

500 free credits a month. No card required.