Save each new Amazon deal in Google Sheets

Never miss out on a deal again - keep track of all your Amazon bargains in one place with automatic updates.

  • Execute the task periodically
  • Get the next new product deal (amazon_lightning → search_deals)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)

Tracking Amazon deals can feel like a constant battle—refreshing product pages, worrying you'll miss out on limited-time Lightning Deals, and wasting hours compiling deals into a clunky spreadsheet (if you remember at all). It's tedious, error-prone work. And if you slip up or just can't keep up, you might miss saving big on business supplies or the latest gadgets, costing you both money and opportunities.

With this Botize formula, every new Amazon deal—whether it's Deal of the Day, Lightning, or Prime Early Access—is automatically captured and added as a row in your Google Sheet. The automation checks hourly (or on your schedule) and records crucial details like product title, price, percent off, direct link, and image. No more manual data entry or missed offers: just an up-to-date sheet ready for analysis, sharing, or immediate action. This is effortless deal-tracking that keeps you in control.

Ready to free up your time and never miss a deal again? Follow the quick step-by-step below to set up this formula for yourself, with flexible options for what deals you want and how often they're captured. If you want to get going right now, just use Botize’s ready-made automation and start transforming your Amazon deal tracking today.

Automate this task with 3 simple prompts

Copy and paste the following prompts into Botize's AI task editor

  1. 2

    Select the AI editing tool.

    AI Prompt Tool
  2. 3

    Create a step that makes the automation check for new deals on a regular basis.

    Copy and paste this prompt into the AI editing tool.

    Set up the automation to run automatically every hour. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Add a step to get the latest new product deals from Amazon, including best deals, lightning deals, Prime Early Access, and Deal of the Day offers.

    Copy and paste this prompt into the AI editing tool.

    Fetch the newest Amazon deals, making sure to include best deals, lightning deals, Prime Early Access deals, and Deal of the Day. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Create a step to save the details of the latest deal into a Google Sheets spreadsheet, filling out the relevant columns with product info.

    Copy and paste this prompt into the AI editing tool.

    Add a new row to a Google Sheet with the following details from the deal: ASIN, title, product URL, image URL, deal price, percent off, and current price. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Your automation is ready to use. Click the 'Save changes' button.

    Save changes

Effortlessly Save Amazon Deals to Google Sheets

Our system checks Amazon for deals every hour, then neatly logs them into your Google Sheets. It's like having a personal deals assistant always on the hunt.

Manual Botize
Searching for deals manually 30 minutes daily 0 Minutes
Entering data into sheets 15 minutes 0 Minutes
Making sense of scattered data 10 minutes 0 Minutes
Total 55 minutes 0 Minutes

You've just hit the sweet spot of deal tracking. Start automating your savings!


Daily Deals Tracker

A user needed to keep track of daily Amazon deal prices and effortlessly updated their sheets.

Save Time

Avoid endless scrolling, let our system do it for you.

Stay Updated

Get the freshest deals as they appear on Amazon.

Organize Effortlessly

Everything sorted and saved in your Google Sheets instantly.


Bargain Hunter's Dream

An avid shopper automated their deal hunting process, saving hours every week.

đź”–

⌾︎ You want to catch every Amazon deal with minimal effort.

⌾︎ You love organizing your savings in a clear, accessible format.

❌

âś• You prefer manual tracking and enjoy browsing for deals one by one.

âś• You're not interested in Amazon shopping.


âś“ Choose how frequently you want to check for deals.

âś“ Select specific deal types you want to track.

âś“ Organize your Google Sheets columns as you prefer.




Related automations