How to fetch JSON data from an API into Looker Studio (Google Data Studio)

In this video tutorial, we walk you through the process of bringing JSON data from an API into Looker Studio using a custom connector developed with Google Apps Script. Dive deep into the code's intricacies, understand each function's significance, and see the seamless integration in action.

Need help?
If you're looking for expert assistance with Google Apps Script projects or any custom solutions, contact us at Apptiva Software. We're here to help! 📩

Please send us an email: [email protected]
Code & Blog Post: https://apptivasoftware.com/blog/brin...
Our website: https://apptivasoftware.com

0:00 Introduction
1:12 Overview of the API Data
2:20 Creating a new Google Apps Script Project for our Connector
2:46 Editing the Manifest File
4:16 Overview of the basic methods of a Connector
6:50 Walkthrough of the actual code implementation
8:59 Assigning a Google Cloud Project to our Project
10:18 Deploying our Connector
10:54 Visiting our published Connector's page
11:33 Connecting our Connector to Looker Studio
14:13 Working with our Connector in Looker Studio