How to Connect Amazon to Google Sheets (Automated Reports)

Why sellers still use Google Sheets

Despite all the dashboards and analytics tools available, Google Sheets remains the backbone of most Amazon businesses. And for good reason: it's free, infinitely customizable, shareable with your team and accountant, and everyone knows how to use it.

The problem isn't Sheets itself. It's the manual work of getting Amazon data into Sheets. Most sellers spend 30-60 minutes every week downloading CSV reports from Seller Central, cleaning the data, copying it into their tracking spreadsheet, and updating formulas. That's 26-52 hours per year spent on data entry that could be automated.

Sheets also excels at things dashboards can't do: ad-hoc what-if analysis ("What if I raise price by $2?"), custom formulas specific to your business, pivot tables that slice data exactly how you need, and the ability to annotate data with notes ("launched PPC campaign here" or "competitor went OOS"). These human-judgment additions make spreadsheets irreplaceable for strategic analysis.

Traditional methods (and their problems)

Manual CSV exports: Download reports from Seller Central → open in Excel → clean and format → copy to your master Sheet. Works, but it's tedious, error-prone, and the data is always at least a day old by the time you use it. Nobody enjoys "Spreadsheet Monday." Worse, manual processes break when you're on vacation or busy — and that's when you need data most.

Google Sheets add-ons (Gorilla ROI): Gorilla ROI lets you pull Amazon data using custom formulas directly in Sheets (e.g., =GORILLA_UNITS("B09KX7",7) for last 7 days of units sold). It's clever, but you're limited to the data points they support, complex analyses still require manual formula building, and the formulas can be slow to refresh with large product catalogs.

Amazon SP-API + Google Apps Script: For technical sellers, you can build a custom integration using Amazon's Selling Partner API and Google Apps Script. Powerful but requires development skills and ongoing maintenance when APIs change. Budget 20-40 hours for initial development and 2-5 hours/month for maintenance. See our SP-API guide for details on what this involves.

Zapier/Make workflows: Middle ground — use a no-code automation tool to connect Amazon data to Sheets. More flexible than add-ons, less technical than API integration. However, Amazon data sources have limited Zapier triggers, and complex data transformations are difficult to build in visual workflow tools.

The automated approach (Jarvio): Ask Jarvio what data you want in your spreadsheet and when. It formats the data, adds conditional formatting, and pushes it to your Sheet on a schedule. Zero manual work after setup. Zero maintenance when APIs change.

What to track in your Amazon spreadsheet

A well-structured Amazon spreadsheet should have these tabs:

Daily Sales Dashboard: ASIN, product name, units, revenue, sessions, conversion rate, Buy Box %. Updated daily for quick morning reviews. Include 7-day and 30-day trailing averages so you can spot trends, not just react to daily noise.

Weekly P&L: Revenue, COGS, Amazon fees (broken down by type), PPC spend, refunds, net profit, margin %. This is your true performance tracker. Break Amazon fees into referral fees, FBA fulfillment, storage, and other fees — they behave differently and need separate monitoring. Read more about building a proper P&L.

PPC Performance: Campaign name, spend, sales, ACoS, TACoS, impressions, clicks, CPC, conversion rate. Filter by campaign type (Sponsored Products, Brands, Display) and track trends week-over-week. Include a "search term" sub-tab with your search term report analysis.

Inventory Tracker: ASIN, current stock, daily velocity, days of stock remaining, restock threshold, reorder quantity, supplier lead time, estimated stockout date. Color-code by urgency: red (<7 days), yellow (7-14 days), green (>14 days). See our inventory management guide for threshold formulas.

Competitor Monitor: Competitor ASINs, their price, your price, their review count, their rating, Buy Box status, their estimated monthly sales. Updated weekly to spot competitive shifts before they impact your sales.

Spreadsheet architecture for Amazon sellers

Professional Amazon spreadsheets separate raw data from analysis. This prevents formula errors and makes updates clean:

Layer 1 — Raw Data tabs (hidden): These are the tabs that receive automated data pushes. They contain unformatted, unfiltered data exactly as it comes from Amazon. Never manually edit these tabs. Name them with a "RAW_" prefix (RAW_Sales, RAW_PPC, RAW_Inventory).

Layer 2 — Analysis tabs: These reference the raw data tabs using formulas (VLOOKUP, INDEX/MATCH, SUMIFS). This is where you calculate margins, trends, and derived metrics. Separating analysis from raw data means you can refresh the raw data without breaking your formulas.

Layer 3 — Dashboard tabs: The tabs you actually look at daily. They pull from analysis tabs and present key metrics with charts, conditional formatting, and summary KPIs. Keep these clean and scannable — no more than 15-20 metrics per dashboard tab.

This architecture means automated data pushes only touch Layer 1. Your custom formulas in Layer 2 and dashboards in Layer 3 update automatically without risk of overwriting your work.

Essential formulas and calculations

These formulas are the backbone of Amazon spreadsheet analysis:

• True margin: =(Revenue - COGS - Referral Fee - FBA Fee - Storage Fee - PPC Spend - Refunds) / Revenue. Most sellers forget to include PPC and refunds, inflating their apparent margins by 5-15%.
• Break-even ACoS: =(Revenue - COGS - Amazon Fees) / Revenue × 100. This tells you the maximum ACoS your PPC can have before you lose money on ad-driven sales.
• Days of stock: =Current Inventory / AVERAGE(last 14 days unit sales). Use 14-day average to smooth out daily variance. Multiply by 1.3 for safety buffer.
• Reorder trigger: =IF(Days_of_Stock < Supplier_Lead_Time + 14, "REORDER NOW", "OK"). The +14 gives you buffer for shipping delays and demand spikes.
• Week-over-week change: =(This Week - Last Week) / Last Week. Apply conditional formatting: green for positive, red for negative, bold if absolute change exceeds 15%.
• Contribution margin per unit: =(Selling Price - COGS - Per-Unit FBA Fee - Per-Unit Referral Fee). This is the money each organic sale puts in your pocket before fixed costs.

Automating with Jarvio

Jarvio connects to the Google Sheets API and pushes formatted Amazon data on any schedule you set. The setup is conversational: tell the agent what data you want, which columns, and when to update. It handles formatting, conditional highlighting, and even summary calculations.

Common automations sellers set up:

• Monday 9am: Weekly P&L by SKU with margin highlighting
• Daily 8am: Yesterday's sales summary with trend arrows
• Friday 5pm: Inventory health report with restock alerts
• 1st of month: Monthly financial summary for your accountant
• Wednesday 10am: PPC performance with search term analysis

For financial reporting, Jarvio can create sophisticated monthly P&L breakdowns:

Advanced analysis techniques

Cohort analysis by launch date: Group products by the month they launched. Track how each cohort's revenue, margin, and review count evolve over time. This reveals whether your product selection and launch strategy is improving or degrading. Products launched in Q1 2026 should outperform Q1 2025 launches at the same age if your strategy is improving.

SKU profitability quadrant: Plot each SKU on a 2x2 matrix: revenue (X-axis) vs. margin (Y-axis). Top-right quadrant (high revenue, high margin) are your stars — protect and expand them. Bottom-left (low revenue, low margin) are candidates for discontinuation. This visualization instantly shows where your catalog needs attention.

PPC efficiency frontier: For each product, plot ACoS against total sales. Identify which products convert PPC spend efficiently (low ACoS, high sales) versus which are PPC-dependent money pits (high ACoS, modest sales). Reallocate budget accordingly. See our ACoS optimization guide for detailed strategies.

Seasonal demand curves: Using 12+ months of data, chart each product's monthly unit sales. Overlay with your inventory planning to ensure you're stocking up 8-12 weeks before seasonal peaks, not reacting to them.

Sharing with your team and accountant

Google Sheets' sharing model is perfect for Amazon businesses. Create role-specific views:

• Accountant view: Share a "Monthly Financials" tab with revenue, fees, COGS, and net profit. Use the IMPORTRANGE function to pull summary data into a separate workbook they own. This gives them what they need without exposing your full operational data.
• VA view: Share inventory and customer service tabs. Protect formula cells so VAs can input data (COGS updates, supplier lead times) without accidentally breaking calculations.
• Partner/investor view: A high-level dashboard tab with monthly trends, growth rates, and profitability metrics. No SKU-level detail, no COGS, no supplier information.

Use Google Sheets' "Protected ranges" to lock formula cells and raw data tabs. This prevents accidental edits while allowing input in designated cells. For Amazon businesses with VAs or team members, this is essential.

Spreadsheet templates to start with

If you're building your spreadsheet from scratch, start with these essentials: a summary tab that rolls up key metrics (total revenue, total profit, average margin, top 5 and bottom 5 SKUs by profit), a raw data tab that Jarvio or your automation populates, and analysis tabs with pivot tables and charts for trend visualization.

The most important thing: keep it simple. A spreadsheet you actually use every week is worth more than a complex one you abandon after a month. Start with 3 tabs (sales, PPC, inventory), automate the data entry, and expand from there. You can always add complexity later — you can never get back the time spent on a spreadsheet nobody opens.

Template structure recommendation:

• Tab 1 — Dashboard: 10-15 top-level KPIs with sparkline charts. This is your "open the spreadsheet and immediately know how the business is doing" tab.
• Tab 2 — Product P&L: Every SKU with full cost breakdown. Sort by margin to quickly find your best and worst performers.
• Tab 3 — PPC Summary: Campaign-level performance with week-over-week trend columns. Highlight campaigns above your target ACoS.
• Tab 4 — Inventory Status: Current stock, velocity, days remaining, and reorder status. Conditional formatting makes stockout risks immediately visible.
• Tab 5 — Monthly Archive: Roll up each month's totals for year-over-year comparison. This becomes invaluable for seasonal planning and goal-setting.

Common spreadsheet mistakes

Tracking revenue without tracking profit: Revenue is vanity, profit is sanity. A $50K/month revenue line means nothing if your margin is 5% after all fees and PPC. Always track net profit per SKU, not just revenue.

Using 1-day data for decisions: Daily sales fluctuate wildly. A single bad day doesn't mean a product is failing. Always use 7-day or 14-day rolling averages for trend analysis. React to trends, not daily noise.

Not including PPC in profitability: Many sellers calculate "margin" as revenue minus COGS minus Amazon fees. But if you're spending $500/month on PPC for that product, your real margin is significantly lower. TACoS (Total Advertising Cost of Sales) is the true measure. See our TACoS guide.

Manual data entry: If you're still copying numbers from Seller Central into a spreadsheet, you're wasting hours and introducing errors. Automate data entry and spend that time on analysis and action instead.

No version history discipline: Google Sheets has version history, but it's not a substitute for monthly snapshots. At the start of each month, duplicate your main sheet as "Archive — March 2026" so you always have a clean historical record that can't be accidentally modified.