IMPORTJSON Function - Google Sheets Tutorial - How to Import JSON feed to Spreadsheets

Learn how to import JSON data from API to Google Sheets using user defined IMPORTJSON function.

Get the function script here

Google Sheets

Company Page

[cameronwheatley]

Amazing, have been looking for a system that does this easily for HOURS. This is the simplest and easiest to implement (and the only one that has actually worked). Thanks!!

[mostafanabil]

You saved me a LOT of time with this short yet awesome tutorial.

[leeworthington]

Thank you! This was incredibly helpful

[pufslvp]

You were my today's savior! Thank you so much!!

[BryMajor]

I'm now using the function to import stock options data into my spreadsheet. It works! TY.

[cho.gath]

Most helpful tutorial. Thanks so much!

[ILuvlearn]

Great video and very helpful. Thanks!

[AxleWebTechnologies]

Great Tutorial, really helpful. Thank you

[gmanova]

thanks, that's elegant and extremely helpful!

[DigitalMediaCanada]

Exactly what I was looking for. thanks!

[BeeJayVC]

This helps so much. Holy christ. Thank you

[fercomerci]

Hey! this video was really helpful!

I was trying to fix a spreadsheet that used a lot of IMPORTXML Functions to load data and used conditional format with those values.

It was working fine, but having the "loading data" problem as there were over 200 requests with that IMPORTXML functions


So i could get an API key of the website and with your video i manage to solve that problem, but now all the conditional formatting in those cells are not working anymore.. any idea how i can solve this or what could be causing it?

[mirkoobkircher]

Can you share required script amendments that allow to pull multiple values within arrays? (instead of static xpath string)? Many Thanks

[nikhilawleshiya]

Good explanation, can you tell me what will happen if I will have date in the retes and bases on dates I will have multiple country rates in rates ?

[kimjongkook]

Hello, i want each 5 mins update json data, how i to do it? Thank you

[visiedo]

Thanks for the video. Is it possible to keep the pre-existing data in the spreadsheet if the API call fails? I am thinking in the scenario of auto-refreshing the data periodically. If any of the calls fails, all the previous existing data is lost and you just get an error. It would be useful to still be able to operate with the previous (cached) data

[KoteKhutsishvili]

Thanks for the video. Is it possible to import data from the API that needs key header parameter to access? If yes, how should I write the query in the cell?

[nickb]

how to display the data in the api which is changing in the spreadsheet?

[PCgmesforever]

would this work even if the Json object contains a list (i think it could be called array, not sure what is correct therminology) that contains objects. Can I somehow quarry each first item of objects contained in the list ?

[petrinnn]

Thanks for this video!

I got this message: Node Not Available

Any idea?