Connecting to Google Drive

In this tutorial, we’ll use Anvil to build a simple web app that stores its data in a Google Sheet.

We’ll use a Google Sheet full of data from my library to drive an app that showcases a random book in the library. We’ll start from a blank page, and we’ll build up an app that uses:

• A Google Sheet with library book information
• HTTP API queries to the OpenLibrary covers database

And we’ll do it all with nothing but Python!

The final app will look something like this:

Click the link to clone the finished app and explore it in the Anvil editor.

The techniques you’ll learn in this tutorial are fundamental to building any Anvil app, and mastering them will give you a good understanding of how Anvil works.

Chapters

Get More Details

Our docs cover everything about using Google Drive (including Sheets, uploaded images, CSVs and more!) in your Anvil apps. If you prefer to read docs rather than follow a tutorial, take a look!