I read an API with Google Sheets and want to get results similarly to this: But the API is a bit strange and puts always a header row into response. With it, the response of the first formula looks like: and the second formula (=MyApiFormula(A3)) doesn’t work at all – sure, because it is forced to write into cells with