No application can function without data, and sometimes your data lives in a spreadsheet. Let's see what can we do to change this sorry state of affairs and how can we move it into an actual database.
Why would you want to do that? Sometimes you just can't do the things you want to do inside Google Sheets, sometimes it's some external data you have no control over, or it might be that you just grew out of Sheets and want to build an application to make using the data easier.
In this article we'll be tackling the last case - we want to display some of our data inside a web application, so we'll be using Phoenix Framework and the Google Api Sheets together with the Google Api Drive packages.
You can also check out the example repository if you want to see the finished code.
continue reading on curiosum.com
⚠️ This post links to an external website. ⚠️
If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.