I need a clean, reliable connection between Amazon’s Selling Partner API (SP-API) and Google Sheets so that every new order appears in my spreadsheet the moment it is placed. The task is limited to pulling order details only; no product listings or inventory data are required. The solution must: • Authenticate with SP-API using the standard AWS + Login With Amazon flow, refresh tokens automatically, and stay within rate limits. • Query the Orders endpoints, paginate when necessary, and push the parsed JSON into a designated Google Sheet in real-time—no manual refresh or triggers on my side. • Include clear setup instructions and well-commented code (Apps Script, Python, or another serverless approach that keeps costs minimal is fine). • Demonstrate the feed working live with test orders before hand-off. I’ll provide credentials once the framework is ready; you return the finished script, a one-page deployment guide, and a short video or Loom proving real-time updates are functioning.