Hey @Lalit_sah, is there an API that these sheets can be fetched from? That could alleviate the problem of having to manually feed the collection run information.
One possible workflow that I can think of is as follows:
- Fetch all the required sheets from initial requests in CSV format.
- Convert the CSV data using the inbuilt
csv-parselibrary to convert the data to a JSON format. - Stringify the arrays of objects obtained from each sheet, save them to environment variables.
- Set up an iteration over these saved arrays using
postman.setNextRequestin order to achieve complex iterations.