If you're interested in using Google Sheets as your data hub but are unsure where to start, consider asking ChatGPT! I asked it to "Write me a Google Apps Script that pulls in API data displays it in columns". With just a few tweaks I was up running in minutes