Our great sponsors
-
ImportJSON
Discontinued Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
However you are at least in Python territory here and have it dump to a database like MongoDB and use that DB as your source for PQ if you want it in Excel
But the main gist is to use a custom function called IMPORTJSON to grab your api data and convert it into table format, and just have it refresh at a specific interval via AppScript.
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a more popular project.
Related posts
- I'm just starting to learn coding and wanted to do a small profit spreadsheet with some API stuff as a project. Can someone link a spreadsheet or guide on how to actually use the TFT API?
- March Madness 2023 in Google Sheets!
- Reducing load with IMPORTXML
- Software til afstemning af budget?
- Help importing NBA data from the online api URL/file .json