Google AppSheet Databases

Recently, Google AppSheet released a new feature called AppSheet Databases. Normally, when you create apps in Google AppSheet, you would either use a Cloud Based Database(Google Sheets) or you would use a SQL database.

With the new update, Google AppSheet provides integrated first party native databases. This does not require any other data source as the database is integrated with the AppSheet app.

In the blog, we will be taking a look at this new feature by building a basic expense tracking App using the new in-built database feature in Google AppSheet. This is similar to one of my previous blogs where we had created an expense tracking App using Google Sheets. Check out the link below.

Create a Simple Expense Tracking App Using Google AppSheet Part1

Create a Simple Expense Tracking App Using Google AppSheet — Part 2

Database in AppSheet

We are going to start of by accessing Google AppSheet by going to appsheet.com.Or you can directly go to the databases in AppSheet by clicking here.

If you click on the second you will be taken directly to the Database section of the app.

Here you can see at the top you have the option to either switch to your Apps or go to your Databases.Currently, I have not created any databases but lets go ahead and create our first database. To do that follow these steps.

To create the database, click on New database.

On clicking New database, you will see that a database has successfully bean created.For this article will be building an expense tracking using the in-built database feature.

The AppSheet database provides us with a lot of features such as setting the data type of particular column, having different styles of views for your data and many more.

We are going to be transferring our expense tracking data that we had in the Google Sheet into the Google AppSheet Database. After transferring the data into the AppSheet Database, it will look something like this.

This is what the AppSheet Database will look. To get a better understanding of how I converted my Google Sheet database into this Google AppSheet database, check out the YouTube video given below.

Create the App

Now that the database is ready and good to go, lets go ahead and create the app. To create the app, follow these steps:

1. Click on the Apps button, in the top right corner of the page.

2. On clicking Apps, you will be given an option to create a new AppSheet App using the database we just created.

On execution, you can see that the App has been created successfully. To customise the look and feel of the app check out YouTube links given below.

Conclusion

This was just a short introduction to Google AppSheet databases. We will be covering more features of Google AppSheet Databases in the coming articles. I hope you have understood how to use Google AppSheet Databases to creates apps in AppSheet.

You can check out the official documentation/announcement for Google AppSheet, by clicking on the link below.

What is an AppSheet database?

Feel free to reach out if you have any issues/feedback at aryanirani123@gmail.com.