Bol. Com API integration to google sheets , partly web scraping , partly API

For our E-commerce business, we want the data about competitors and our position in the selling system of bol.com. We want the data in this output format: https://docs.google.com/spreadsheets/d/12GgshUnILCdGTTm79FAKZp5vnvqYm1-QwSmRBGjzNRU/edit#gid=664209816 This is [login to view URL] API Documentation: Retailer API: [login to view URL] Open API: [login to view URL] It should probably be a combination between scraping and calling the api. But maybe even 100% possible by calling the api.