Back

Export my Amazon order history into a sheet

Your full order history in one sheet with spend totals by month and category

OpsEAsEveryone
Prompt

Go through my Amazon order history for [time range, e.g. the last 12 months] and export every order into a Google Sheet. Page through the full history — don't stop at the first page. One row per item: order date, item name, price, quantity, order total, and order link. Handle returns and refunds by marking them in a Status column rather than deleting the row. Then add a small summary tab: total spend for the range, spend by month, and your best guess at spend by category (household, electronics, books, etc.) with anything uncertain bucketed as other. Tell me the final order count and flag any orders that wouldn't load so I know how complete the export is.

Works withamazon.comdocs.google.comsheets.google.com