Pepsico Portal Data Extractor.

I need a small utility—either a straight-forward C# console app or a PowerShell script—that signs in to my Pepsico web portal with the credentials I will supply, discovers whatever REST or JSON endpoints the site exposes (you can confirm them quickly through Chrome DevTools), pulls every available data set returned once authenticated, and drops the raw response into a clean XLSX workbook.

It should not open chrome browser and no UI steps. Everything should happen in backend.

A few specifics to keep in mind:
• Authentication happens through the live portal, so the code should reproduce whatever token, cookie, or header sequence Chrome shows.
• No filtering or sorting is required on my side; simply fetch all records the endpoint offers.
• The final step writes everything to an Excel file—not CSV or TXT—ideally by using ClosedXML, EPPlus, or the native Interop classes in .NET, whichever you’re most comfortable with in the time frame.

I’d like to see well-commented source code, a brief README outlining how to run it, and a quick hand-off once you verify the export works on your end. I’m on a tight timeline, so if you already have experience with web-scraped API calls or cookie-based login flows, you’ll finish this quickly.