Posts

Showing posts from December, 2020

Read data from Google spreadsheet in Angular

Image
Mehul Kothari Dec 12, 2020 · 4 min read Github :  https://github.com/mehulk05/MyShop Demo Link:   https://mehulk05.github.io/MyShop/#/ If you’ve ever found yourself asking ‘how can I access Google Sheet spreadsheets with JavaScript?’, then you’re probably not alone. You only have to type something like ‘reading google sheets data using javascript’ into Google and you’ll be inundated with a bevy of solutions to this conundrum. The problem is, in my experience, they’re either   very complex and overblown, or quite difficult to get up and running with (e.g. poor documentation), or they’re just a bit too prescriptive with how they serve you those precious results. So that's why I am taking this opportunity to write a simple solution Firstly, is this right for my needs? The following blog allows for  reading only  from a publicly published Google Sheet. If your needs look like these, then it might be a great fit: You are able to publish your Google Sheet publicly You have a relativel