3 things:
- is there are particular reason you need to get the data specifically into Google Sheets?
- generally if you’re going to be hitting an iNat API, it should be the current /v1 version of the API (https://api.inaturalist.org/v1/), not the older API (which is mostly deprecated at this point).
- there limits to the number of records returned via the API. this goes over the main points: https://forum.inaturalist.org/t/code-to-extract-annotations-from-exported-json/31950/27.