Import JSON into Google Sheets

[Darren_Murphy]

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

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 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…