---
title: How to import JSON data from API to a Google Sheet
tags: lowcode, data, googlesheet
robots: noindex, nofollow
author: Julien Noyer
---

# How to import JSON data from API to a Google Sheet


## Introduction

The Google Sheets integration makes it easy for you to visualize data you have stored in Google Sheets.

It has quickly become one of Databox's most popular integrations. One of the reasons for this is that Google makes it relatively easy to sync data from other platform's APIs into a Sheet.

Thanks to generous developers posting code samples online, you only need to make minor edits to this code so it's syncing the appropritate data.

In order to import JSON data to Google Sheets, follow the steps below.

<br>

## Tutorial

- Create a new Google Sheet
- Select **Tools > Script Editor**
- Delete the placeholder content
- Copy and paste the code from [**this script**](https://gist.githubusercontent.com/paulgambill/cacd19da95a1421d3164/raw/047b04a1c321b697533adad5828e6df8748b5e54/import_json_appsscript.js) to the Script Editor
- Select **File > Save**
- Name your code **"ImportJSON"**
- Close the Script Editor and navigate back to your Google Sheet
- In cell A1, type **ImportJSON("{{URL}}")**. Replace **{{URL}}** with your API endpoint (be sure to keep the quotes and parenthesis)
- Press enter. Your Google Sheet should now populate with your JSON data

<br>

## Ressources

- https://gist.github.com/paulgambill/cacd19da95a1421d3164
- https://docs.google.com/spreadsheets/d/1AB6LGU9P_nq52wKihBLzfgy-KTVvktU73hzrJRA46iY/edit?usp=sharing
- https://help.databox.com/