I need a working bridge between my Amazon account and Google Sheets so I can stop exporting CSVs and start working from live data. Using Google Apps Script (or another lightweight approach you recommend), the script should authenticate through Amazon’s Selling Partner API, pull the reports I choose—whether that ends up being orders, inventory, products, or advertising metrics—and place the results into dedicated tabs inside one spreadsheet. Key expectations • Secure OAuth flow and token refresh handled automatically so it can run unattended. • A trigger I can switch between manual run and scheduled updates (hourly or daily). • Data written cleanly: overwrite a staging tab or append to a history tab without duplications. • Clear in-sheet controls or simple configuration area where I can change marketplace, date range, or endpoint. • Brief setup notes or loom-style walkthrough so I can maintain the solution myself. Once the sheet reliably fetches and refreshes the chosen data set, the job is done. I’m available for quick answers on developer credentials and will grant test access as soon as we start.