Automating Daily Postman Reports

Possibly a dumb question from somebody who uses Postman but only at a very surface level. In my job, we use Postman to pull daily reports on transactions run in our system on a date range basis. I.E., everything from 2025-03-10 will pull info from the 10th to the last transaction ran in the system up to the 11th. We have to manually run the report with an API, save the info into an excel file, and then copy paste into ANOTHER excel file to build a continuous archive of transactions. The problem is this is extremely time consuming and has a LOT of room for human error.

What im trying to figure out is if theres some kind of… plug in(?) Or something that clould be used to automatically run the report daily at a set time and then place and sort that info into something like PowerBI or even in Excel for the time being. We’d really like to automate this as much as possible.

Thanks.

1 Like

You can configure a monitor to run every day at a specific time. This will run a collection of your choice, but it won’t do everything you’re asking for.

Getting something to update an existing excel file is where things get tricky. If you have it in the cloud, you might be able to use the Google Sheets API to pull the excel file, add the information, and update it, but that’s easier said than done.

It sounds like you’re describing a custom integration to me rather than a feature in Postman, but we can try to work out some details if you’d like.

1 Like