Skip to main content
Nova Analytics
Try for free

How do I automatically export Amazon sales and ad data into Google Sheets?

To export Amazon sales and ad data into Google Sheets automatically, create a scheduled export in Nova and paste its link into an IMPORTDATA formula: Nova rebuilds the file every 3 hours behind a link that never changes, so the sheet stays current. Nova's MCP connector also lets Claude, ChatGPT and other assistants read the same sales, ad spend and profit per product, so the assistant can design the tables with you first and return them ready to paste.

Updated

Connect your AI Copy the playbook

The playbook

Every step calls a Nova tool that reads your live Amazon data, so paste this into Claude, ChatGPT or any assistant connected to Nova's MCP server. Run it once to design the sheet, then let a Nova scheduled export keep it current.

This needs an assistant connected to Nova. Start the 14-day free trial, then connect your assistant.

Use Nova to build the daily sales and advertising tables I will keep in Google Sheets, and tell me how to keep them updated.

Period: the last 14 complete days. If I name other dates, use those.

Scope: all my Seller Central accounts unless I name some.

1. List the accounts. Call Nova's list_accounts. Give each account's marketplaces and channel. Say if an account is Vendor Central: scheduled exports do not cover Vendor Central yet.

2. Read the daily totals. Call Nova's query_metrics with groupBy "day", excludeUnfinished true, and the metrics netSales, units, adSpend, sponsoredSales, organicSales, sponsoredTacos and netProfit. One row per day.

3. Read each product by day. Call Nova's query_metrics with groupBy "childAsin", timeGrain "day", limit 50, and the same metrics. Lay it out long: one row per day and product, with the date, the child ASIN, then one column per metric.

4. Read the campaigns. Call Nova's query_advertising with groupBy "campaign", the metrics spend, sales, orders, clicks and acos, sorted by spend, limit 50, for the same period.

5. Format the tables for Google Sheets. Give each one as CSV in its own block: one header row, dates as YYYY-MM-DD, numbers without currency symbols or thousands separators, and the currency code Nova returns in its own column.

6. Tell me how to keep it current. Map the columns of steps 2 and 3 to a Nova scheduled export: the metrics to pick in the Sales, PPC and Profitability groups, Time grain Daily, Split by Child ASIN, and a rolling date range. Then give me the IMPORTDATA formula to paste in the sheet, with the export link left as a placeholder.

Rules: never add amounts of different currencies. Campaign figures from query_advertising use Amazon's attribution windows and never add up with adSpend from query_metrics, so keep them on a separate tab. Relay every notice Nova returns, such as cogsNotice, adsHistoryNotice, marketplaceNotice and currencyNotice, before the figures it qualifies. A day with no ad data before the account's ads history is missing, not zero. You cannot create the scheduled export or write to my sheet: give me the settings and I set them up.

Raw markdown

How Nova customers use this

Real requests from Nova customers, names removed.

  • “Every day, add the new days of sales per SKU for each marketplace to our sales sheet, with month to date and the last 7 days against the 7 before.”

    What the assistant did

    A recurring daily run: it read the new days of sales per SKU for each marketplace, then month-to-date and last month's totals and the last 7 days against the 7 before, for the seller's own sheet.

    Nova tools used (1)
    1. query_metrics

  • “Weekly snapshot for the client's workbook: sellable, incoming and 30-day units per SKU, then last week against the week before and campaign spend.”

    What the assistant did

    It read FBA sellable and incoming units with the last 30 days of units per SKU, compared last week's sales by product with the week before, and pulled the prior week's campaign spend to set beside the user's own ads export.

    Nova tools used (3)
    1. query_inventory
    2. query_metrics
    3. query_advertising

  • “Compare this month's closed-day sales per product with the daily targets in our plan sheet.”

    What the assistant did

    It read daily sales and units per child ASIN up to the last complete day, checked the account totals for the same days, set them against the plan, then read stock on the products furthest behind.

    Nova tools used (4)
    1. list_accounts
    2. list_metrics
    3. query_metrics
    4. query_inventory

  • “Fill in the missing unit costs on our stock reconciliation sheet from the costs in Nova.”

    What the assistant did

    It read the received quantities on the shipments in question, then the unit cost of each SKU on the sheet from Nova's cost worksheet.

    Nova tools used (2)
    1. query_inbound_shipments
    2. get_cogs_worksheet

How do I set up the export that updates by itself?

1. Create the export

Where

Nova, Integrations, Scheduled Exports, New report

What you do

Pick the metrics, a rolling date range, Time grain Daily and Split by Child ASIN, in CSV

2. Copy the link

Where

The export's row, Copy link

What you do

The link never changes, so you set it up once

3. Paste the formula

Where

Any cell of your Google Sheet

What you do

Type =IMPORTDATA("your export link") and the table fills in

4. Build on it

Where

Other tabs of the sheet

What you do

Point your charts and formulas at the imported tab, never at a pasted copy

Nova rebuilds the file every 3 hours, and the refresh icon in Last refresh rebuilds it now. Nova does not email exports. The scheduled export guide lists every option, and connect your data covers Excel and BI tools.

Which Amazon data can go in the sheet?

Sales

Examples

Orders, units, sales, net sales, returned units

Split by

SKU, Child ASIN, Parent ASIN, Marketplace, Account

PPC

Examples

Ad spend, ad sales, ACOS, TACoS, ROAS, impressions, clicks

Split by

SKU, Child ASIN, Parent ASIN, Marketplace, Account

P&L line items and profitability

Examples

Amazon fees, cost of goods, gross profit, net profit

Split by

SKU, Child ASIN, Parent ASIN, Marketplace, Account

Traffic and reviews

Examples

Sessions, conversion rate, Buy Box percentage, reviews, rating

Split by

Child ASIN or coarser

Ranking

Examples

Best Sellers Rank with its category

Split by

Child ASIN or SKU

Inventories

Examples

FBA available, reserved and incoming units, sales velocity

Split by

SKU, Child ASIN, Parent ASIN, Marketplace, Account

Subscribe and Save figures are in the export too. Campaign, keyword and search term tables are not: for those, ask the assistant, and step 4 of the playbook returns the campaign table.

How to read the result

netProfit higher than you expect

What it usually means

Some units sold have no product cost in Nova

What to do

Enter the missing costs, then rebuild the export

Ad spend missing on the first days

What it usually means

The period starts before the account's ads history

What to do

Start the range later, or read those days as missing

Campaign spend differs from adSpend

What it usually means

Campaigns use Amazon's attribution windows, adSpend is allocated to products

What to do

Keep the two on separate tabs

Totals higher than one Amazon screen

What it usually means

The account adds several marketplaces

What to do

Add Split by Marketplace, or filter the marketplaces

Yesterday lower than the days before

What it usually means

The day is still filling as orders and ad reports arrive

What to do

Read it again after the next export rebuild

Limits

  • Nova rebuilds a scheduled export every 3 hours. Google Sheets then reads the link on its own schedule.
  • Vendor Central accounts are not in scheduled exports yet. An assistant connected to Nova can still read them and return the tables.
  • Sessions, conversion rate and reviews cannot be split by SKU. Use Child ASIN.
  • Anyone who has the export link can download the file. Keep it inside your team.
  • The assistant reads Nova. It does not create exports or write to your spreadsheet.

Questions sellers ask

Can Nova email the export every week?

No. Nova does not email exports. Create the export with Last week and Weekly, copy the link, and read it from Google Sheets or Excel, which always gets the latest file.

Who can open the export link?

Anyone who has the link can download the file, without a login. Keep it inside your team. Regenerate link in Nova disables the old link, and every sheet reading it then needs the new one.

Does it work with Vendor Central?

Not yet in scheduled exports. An assistant connected to Nova's MCP server can read Vendor Central and return the same kind of table to paste into the sheet.