Create a Sheets API in just 3 steps

published by Praveen M Mar 15, 2021

In this lab you will learn how to use your Google Sheets as a JSON API and also how to connect your HTML form to your sheets. This feature can be used in your portfolio website, where you can connect your contact form to a google sheet.

We here use SheetDB, an API management tool for performing the mentioned tasks.

Prerequisites:

VS Code / Any Text Editor
Google acc.

Discussion

Akash Kumar

@99Akki

Nov 10 '25

This is a great guide overall.

Shafique Mohammod Mostafaa

@b8b1c99946a0ada7423fd4e70b8b5247

Jun 22 '22

in submit button including window refresh at a time

Arpan Garg

@arpansac

Jan 27 '22

Very very useful @praveenm23

Overview

1. Creating the Sheets API

2. Creating the HTML form

3. POST data to the API

4. Queries