How do I run a GET API to get data from pages 1-100 automatically? Workflow Pagination

How can I set up the API Connector to retrieve data from numerous pages? I have a total of 10,000 products I’m trying to retrieve broken up into sets of 100, so I want to run the connector about 100 times without having to do it manually. How do I set the parameters to get pages 1-100. How is this done, is it through workflows?