API data extraction to Excel

(Not for full time job ! In the mobile version I was not able to click on the „not for full time button“) We are a small team of 2 and in the middle of a project. Sadly we are stuck just because we are not able to extract data out of a data pool using an API. It worked fine until now, but at the moment we try to pull a lot of data into one excel sheet and it always says „too many requests“. We already tried to Programm some macros that excel is going from line to line to make sure it requests not everything at the same time but it didn’t work. It has to be in one excel sheet. We are pulling financial data out of Financial modeling prep. Approximately 200 items in one api formula and that for approximately 7000 company’s. It’s a quite simple task because it’s just two formulas to pull the data but we are not able to do it because it says „too many request“ We would highly appreciate if somebody could help us.