This website pulse.appsscript.info/p/2023/09/bringing-json-data-from-an-api-into-looker-studio-with-google-apps-script/ is currently offline. Cloudflare's Always Online™ shows a snapshot of this web page from the Internet Archive's Wayback Machine. To check for the live version, click Refresh.
Learn how to seamlessly integrate JSON data from an API into Looker Studio using a custom connector built with Google Apps Script.
This post is a useful reminder of that Google Apps Script can be used to make a data connector for Google online visualisation and reporting tool, Looker Studio. The post by Dimitris Paxinos covers all you need to know about integrating a third-party API as a data source, exposing configuration settings and deploying the connector. All the code is on Github and is a great boilerplate if you have other APIs you are interested in integrating.
