how do i pull json from api then transform that into a table form which is human readable at fixed interval

This page summarizes the projects mentioned and recommended in the original post on reddit.com/r/excel

Our great sponsors
  • Scout APM - Less time debugging, more time building
  • SonarLint - Clean code begins in your IDE with SonarLint
  • SaaSHub - Software Alternatives and Reviews
  • MongoDB

    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

  • ImportJSON

    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.

  • Scout APM

    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.

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.

Suggest a related project

Related posts