Let’s create a Student Records Web Application using Google Sheets

In Google Sheets, create a sheet named students. The sheet name, not the spreadsheet name. See the image below.

Put these exact headers (can be in any order you want), starting from row 1 column A.

• id
• last_name
• first_name
• middle_name

Example:

Click Extensions > Apps Script.

You will see a screen like this. This is a Code.gs file where we can put Apps Script codes.

Copy the code from this Code.gs file and replace everything in your Code.gs.

Your Code.gs file will now look something like this.

Create an index.html file.

Name it index.

You now have a new index.html file.

Now, copy the code from this index.html file and paste it in the index.html file you’ve created. Take note to replace the existing code.

On the upper right, click Deploy > New deployment.

On the pop-up window, click the gear icon, then select Web app.

Enter any Description you like and keep everything as is (Execute as as Me, Who has access as Only myself), then click Deploy.

Wait for the deployment to finish, then click Authorize access.

Login to your Google account. Take note that the title of your Apps Script project will show here.

Click Advanced.

Click Go to <project-name> (unsafe).

Take note that the above is fine even if it says not verified or unsafe. It’s your apps script, so it’s fine.

Read the permissions that you will allow (might not be the same as the screenshot) before proceeding. Then click Allow.

If you encounter any error, just try to deploy again.

When successful, you’d get your URL. Click it to open your new web app.

If all is well, congratulations! You now have a student records web application.