API integration

[Sharath_S]

Anyone here know how to get data from third party sites to g sheets through API(I suppose)

[Darren_Murphy]

Yes.

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…

[Sharath_S]

Excellent, Thank you