The MongoDB Database
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
Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
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.
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
Impossible to fetch character list from third party website
2 projects | reddit.com/r/pathofexiledev | 10 Jul 2022
In Google Sheets, how can I output an array of IMPORTJSON() calls using a column as reference?
1 project | reddit.com/r/sheets | 7 Jul 2022
importxml error "could not fetch url" even when url is from Google.
1 project | reddit.com/r/sheets | 4 May 2022
Made a spreadsheet to show if fish fillets are worth upgrading or not, feedback welcome
1 project | reddit.com/r/Guildwars2 | 14 Apr 2022
MLB Standings Import Tracking
1 project | reddit.com/r/sheets | 10 Apr 2022