Need an api call creating with data depositing in Google sheets

I am looking to create an automation creating to connect data from the Endole API to Google sheets. We have credentials for Endoles API, and would like certain elements of data collecting and placing on a Google sheet. I've had a go, but can't seem to figure out where to enter credentials and key etc.

Basic overview of project =

We have a list of UK company incorporations numbers in csv. We'd like to place an API call that pulls in around 6-8 standard fields data in to a Google sheet. Happy for you to use zapier or n8n, preferably our own account.