Back

Export my data from any platform into a sheet

Orders, transactions, contacts, or followers pulled from an account that hides the export

OpsEAsAnalystsFoundersEveryone
Prompt

Log into my [platform, e.g. Amazon, Etsy, PayPal, Venmo, Airbnb, Instagram, my bank] account and export [what I need, e.g. all orders since January, every transaction last year, my full contact or follower list] into a Google Sheet. Use the platform's own export or report feature if one exists. If it does not, or it caps the range, page through the account screens and read the records directly. Capture every field the page shows for each record and keep the platform's own IDs so I can cross-reference later. Handle pagination and infinite scroll until you have covered the whole range, deduplicate, and format dates as YYYY-MM-DD and amounts as numbers. Read-only: change no settings, cancel nothing, buy nothing. Finish with the row count, the date range actually covered, and anything you could not read.

Works withsheets.google.com