A short video showing you how to convert your Google Sheet into a web app with a frontend. You can quickly add CRUD functionality to create a custom user interface on top of your Google Sheets data.

This tutorial will help if you’re somewhat technical and want to build user interfaces with actions on top of your Google Sheets data. We’ll walk through a simple app for managing emails using Google Sheets as a contact list database.

We build this quick web app using Retool which you can try for free at:
https://retool.com

0:00 Start
0:25 Overview
1:30 Create the app
2:15 Build the UI
4:20 Get data from Google Sheets
7:00 Link Sheets data to an email form
8:45 Add your GMail account
11:00 Send an email from the app
12:00 Write inline JavaScript to customize the email

References:
If you have 2 factor authentication turned on for your Gmail account you may need to use an app password for your SMTP connection. More here: https://support.google.com/mail/answer/185833?hl=en