Instead of following your way, try below way,
- First extract the data from browser which contains multiple pages, to extract multiple pages there is one toggle you need to enable that was Extract data from multiple pages. find below screenshot.
3.After completing extract now use excel activities to write the data.
you can simply use write range workbook activity to write the data into excel or if you want use modern activities,
- Use Excel process scope
- inside that use use excel file
- inside of this use write datatable to excel
This will you good structure for development and for your debugging purpose also it can help you
Happy Automation!!