Discuss a project

DL-008 · Case study

Custom software for tracking prices and BuyBox winners

Bolt About needed current lowest-price data for 500 ASINs on Amazon. We built a scheduled data connector between Google Sheets and the Keepa API that keeps the sheet up to date.

Client
Bolt About
Location
USA
Industry
Amazon Seller
Capabilities
03Build
01

Challenge

  • Track lowest prices and BuyBox winners for hundreds of ASINs.
  • Pricing decisions needed fresh market data, not occasional manual lookups.
02

Environment

  • Avila Beach, CA company specialising in electric bike and scooter rentals.
  • Editable ASIN list kept in a Google Sheets document.
  • Price history available through the Keepa API.
03

Intervention

  • Data connector that periodically reads every ASIN from Google Sheets.
  • Determines each ASIN's lowest price over the past 30 days via Keepa.
  • Writes prices back to the sheet; run frequency adjustable from 1 to 24 hours.
  • Built on AWS Lambda, NodeJS and TypeScript.
04

Outcome

  • Lowest-price and BuyBox tracking automated for 500+ ASINs.
  • Timely data for pricing decisions; client reports increased sales.
On a schedule of 1 to 24 hours, the connector reads ASINs from Google Sheets, fetches 30-day lowest prices from the Keepa API and writes them back to the sheet.triggerASINspriceswrite backSCHEDULE1-24 hGOOGLE SHEETSASIN listKEEPA APIPrice historyDATA CONNECTORAWS Lambda / Node.jsGOOGLE SHEETS30-day lowest price
  1. 01SCHEDULE1-24 hDATA CONNECTORAWS Lambda / Node.jstrigger
  2. 02GOOGLE SHEETSASIN listDATA CONNECTORAWS Lambda / Node.jsASINs
  3. 03KEEPA APIPrice historyDATA CONNECTORAWS Lambda / Node.jsprices
  4. 04DATA CONNECTORAWS Lambda / Node.jsGOOGLE SHEETS30-day lowest pricewrite back
Fig. 09Scheduled price connectorOn a schedule of 1 to 24 hours, the connector reads ASINs from Google Sheets, fetches 30-day lowest prices from the Keepa API and writes them back to the sheet.Scale NTS

Results, as published.

10%
Increase in sales
500+
ASINs tracked
24/7
Monitoring

Stack and services.

Stack05

  • AWS Lambda
  • NodeJS
  • TypeScript
  • Keepa API
  • Google Sheets API

Services used02

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project