---
title: "Bringing JSON Data from an API into Looker Studio with Google Apps Script"
author: "Martin Hawksey"
date: 2023-09-14T21:04:04+00:00
modified: 2023-10-18T19:28:59+00:00
canonical_url: https://pulse.appsscript.info/p/2023/09/bringing-json-data-from-an-api-into-looker-studio-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2023/09/bringing-json-data-from-an-api-into-looker-studio-with-google-apps-script.md
categories:
  - "Beginner"
  - "Looker Studio"
  - "Solutions"
tags:
  - "@dpaxinos"
  - "apptivasoftware.com"
  - "dimitrispaxinos"
featured_image: https://pulse.appsscript.info/files/2023/09/1n1lLp9cTIYcXKV9sparMlA.png
description: "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.  "
---

# Bringing JSON Data from an API into Looker Studio with Google Apps Script

![Bringing JSON Data from an API into Looker Studio with Google Apps Script](https://pulse.appsscript.info/files/2023/09/1n1lLp9cTIYcXKV9sparMlA.png)

> [https://medium.com/@dpaxinos_35980/bringing-json-data-from-an-api-into-looker-studio-50ed2f6cbefc](https://medium.com/@dpaxinos_35980/bringing-json-data-from-an-api-into-looker-studio-50ed2f6cbefc)
> 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.

Source: *[Bringing JSON Data from an API into Looker Studio*](https://apptivasoftware.com/blog/bringing-json-data-from-an-api-into-looker-studio/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/09/bringing-json-data-from-an-api-into-looker-studio-with-google-apps-script/](https://pulse.appsscript.info/p/2023/09/bringing-json-data-from-an-api-into-looker-studio-with-google-apps-script/)*