# Import JSON into Google Sheets

**URL:** <https://community.glideapps.com/t/import-json-into-google-sheets/30473>\
**Category:** Ask for Help\
**Tags:** custom-code\
**Created:** [August 14, 2021, 2:18pm UTC](https://community.glideapps.com/t/import-json-into-google-sheets/30473 "2021-08-14T14:18:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Iftach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/iftach/32/29848_2.png) [@Iftach](https://community.glideapps.com/u/Iftach)\
**Post date:** [August 14, 2021, 2:18pm UTC](https://community.glideapps.com/t/import-json-into-google-sheets/30473/1 "2021-08-14T14:18:36Z")

</div>

Hey, my question is not directly related to Glide, but I need your help. I’m working on a business directory and I want to use Google Places API (Google Maps) for opening hours, so I won’t need to update it manually and to keep it updated. I managed to use [https://maps.googleapis.com/maps/api/place/details/json?place\_id=PLACE\_ID&fields=opening\_hours&language=iw&key=API\_KEY](https://maps.googleapis.com/maps/api/place/details/json?place_id=PLACE_ID&fields=opening_hours&language=iw&key=API_KEY) to get this:

> **JSON**
>
> ```auto
> {
> "html_attributions" : [],
> "result" : {
> "opening_hours" : {
> "open_now" : true,
> "periods" : [
> {
> "close" : {
> "day" : 1,
> "time" : "0000"
> },
> "open" : {
> "day" : 0,
> "time" : "1200"
> }
> },
> {
> "close" : {
> "day" : 2,
> "time" : "0000"
> },
> "open" : {
> "day" : 1,
> "time" : "1200"
> }
> },
> {
> "close" : {
> "day" : 3,
> "time" : "0000"
> },
> "open" : {
> "day" : 2,
> "time" : "1200"
> }
> },
> {
> "close" : {
> "day" : 4,
> "time" : "0000"
> },
> "open" : {
> "day" : 3,
> "time" : "1200"
> }
> },
> {
> "close" : {
> "day" : 5,
> "time" : "0000"
> },
> "open" : {
> "day" : 4,
> "time" : "1200"
> }
> },
> {
> "close" : {
> "day" : 6,
> "time" : "0000"
> },
> "open" : {
> "day" : 5,
> "time" : "1200"
> }
> },
> {
> "close" : {
> "day" : 0,
> "time" : "0000"
> },
> "open" : {
> "day" : 6,
> "time" : "1200"
> }
> }
> ],
> "weekday_text" : [
> "יום ראשון: 12:00–0:00",
> "יום שני: 12:00–0:00",
> "יום שלישי: 12:00–0:00",
> "יום רביעי: 12:00–0:00",
> "יום חמישי: 12:00–0:00",
> "יום שישי: 12:00–0:00",
> "יום שבת: 12:00–0:00"
> ]
> }
> },
> "status" : "OK"
> }
> 
> ```

But now I don’t know how to import it to Google Sheets to be something like this (using the “weekday\_text” property, note that in my country Sunday is the first day of the week, and we use Right-to-Left):

```auto
╒═════════════════════╤═════════════════════╤═════════════════════╤═════════════════════╤═════════════════════╤═════════════════════╤═════════════════════╕
│ Saturday │ Friday │ Thursday │ Wednesday │ Tuesday │ Monday │ Sunday │
╞═════════════════════╪═════════════════════╪═════════════════════╪═════════════════════╪═════════════════════╪═════════════════════╪═════════════════════╡
│ 12:00 PM – 12:00 AM │ 12:00 PM – 12:00 AM │ 12:00 PM – 12:00 AM │ 12:00 PM – 12:00 AM │ 12:00 PM – 12:00 AM │ 12:00 PM – 12:00 AM │ 12:00 PM – 12:00 AM │
╘═════════════════════╧═════════════════════╧═════════════════════╧═════════════════════╧═════════════════════╧═════════════════════╧═════════════════════╛

```

By the end, I want to include it on my Glide app as a Basic Table element. Any tip will be helpful!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 14, 2021, 2:35pm UTC](https://community.glideapps.com/t/import-json-into-google-sheets/30473/2 "2021-08-14T14:35:23Z")

</div>

If you’re not scared of getting your hands dirty with a bit of Apps Script, then this is easy enough.

> [@Using App Script with a JSON API](https://community.glideapps.com/t/using-app-script-with-a-json-api/20051):
>
> Somebody who shall remain nameless (@SantiagoPerez - oops) asked me if I could put together a tutorial on working with API’s, so here it is. It’s my first tutorial, so please be gentle pray Whilst there is an app at the end of this, the app is not the main focus of the tutorial, so don’t expect to be impressed by that. The main focus is to give a gentle (?) introduction to Apps Script, and demonstrate how it can be used to interface with an API endpoint. I’ve tried to break down and explain t…