Create your own website (business system) using Google Sheets

In Google Sheets, create a sheet with name products.

Put some data with the following column names. You can put any data you want but ensure to have these exact columns.

id	sku	name	description	quantity	price
1	sku001	product 1	product 1 description	1	1.01
2	sku002	product 2	product 2 description	2	2.02

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.

Go to this Github link. You will see a Code.gs file there. Copy the codes in that file and replace everything in your Code.gs.

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

There’s one more file you need to copy. Create an index.html file.

Name it index.

You now have a new index.html file.

Back to the same Github link. Copy the code in 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 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 made a web app using google sheets and google apps script.