Discuss a project

DL-011 · Case study

Google Sheets automation for a bookkeeping company

Ridge Paragon downloaded Seller Central and Ads reports by hand for every client. We built a data system that aggregates SP-API and Ads API data into Google Sheets dashboards.

Client
Ridge Paragon
Location
USA
Industry
Amazon Bookkeeping
Capabilities
03Build
01

Challenge

  • Reports downloaded manually per client from Seller Central and the Ads console.
  • Data from multiple Amazon accounts was not integrated in one place.
  • Hours lost every month for every client.
02

Environment

  • Bookkeeping firm for marketplace sellers on Amazon, eBay, Shopify, Etsy and Walmart.
  • Team and clients work in Google Sheets.
  • Settlement, storage fee, returns, listings and order reports, plus Sponsored Ads data.
03

Intervention

  • Data connector on AWS Lambda fetching SP-API and Ads API data asynchronously.
  • Data warehouse on AWS RDS and PostgreSQL.
  • Core server in NodeJS, NextJS and TypeScript to aggregate and modify data.
  • Google Sheets dashboard (ReactJS) and a Dashboard Manager for refreshes and onboarding.
04

Outcome

  • Manual report collection from SP-API and Ads API automated.
  • New clients onboarded through the Dashboard Manager.
SP-API and Ads API reports are fetched by a Lambda connector into a PostgreSQL warehouse; a core server aggregates the data into Google Sheets dashboards, refreshed by a Dashboard Manager.storerefreshSP-APISettlement / FBA / ordersADS APISponsored adsDATA CONNECTORAWS LambdaWAREHOUSERDS PostgreSQLCORE SERVERNode.js / Next.jsSHEETS DASHBOARDReact in SheetsDASHBOARD MANAGERNext.js / DynamoDB
  1. 01SP-APISettlement / FBA / ordersDATA CONNECTORAWS Lambda
  2. 02ADS APISponsored adsDATA CONNECTORAWS Lambda
  3. 03DATA CONNECTORAWS LambdaWAREHOUSERDS PostgreSQLstore
  4. 04WAREHOUSERDS PostgreSQLCORE SERVERNode.js / Next.js
  5. 05CORE SERVERNode.js / Next.jsSHEETS DASHBOARDReact in Sheets
  6. 06DASHBOARD MANAGERNext.js / DynamoDBSHEETS DASHBOARDReact in Sheetsrefresh
Fig. 12Multi-client reporting systemSP-API and Ads API reports are fetched by a Lambda connector into a PostgreSQL warehouse; a core server aggregates the data into Google Sheets dashboards, refreshed by a Dashboard Manager.Scale NTS

Results, as published.

90%
Time saved compared to manual process
50+
Ridge Paragon's clients
7+
Amazon SP-API and Ads reports

Stack and services.

Stack11

  • Amazon SP-API
  • Amazon Ads API
  • AWS Lambda
  • AWS RDS
  • PostgreSQL
  • NodeJS
  • NextJS
  • TypeScript
  • ReactJS
  • DynamoDB
  • Google Sheets

Services used01

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