Website Form to Google Sheet

In this tutorial, we'll show you how to connect a web form directly to your Google Sheet spreadsheet.

When users submit the form, their data will be automatically saved to your spreadsheet - no backend coding required!

format_list_numbered 1. Prepare your Spreadsheet

For the Spreadsheet you're going to connect to sheet2api, the first row (1) must only contain column names.
All the other rows may contain data, in whatever format you'd like (symbols, numbers, dates, words, etc).

For example:

	A	B	C	D	E
1	Name	Favourite Thing	Image
2	Bugs Bunny	Carrots	Bugs.png
3	Elmer Fudd	Chasing Rabbits	Elmer.png
4

You may add multiple worksheets such as 'Looney Tunes', 'The Simpsons' to seperate different categories of data.
sheet2api will create an API endpoint for each of these automatically.

add_circle 2. Create Spreadsheet API

As per the video below:

1. Share & Copy the link to your Google Sheet.
2. Create a Spreadsheet API using that link.
3. Proceed to the next step.

code 3. Create Website Form

Follow these steps to create your form:

1. Go to Your Account
2. Under your Spreadsheet click "Website Form to Sheet"
3. Copy the HTML snippet
4. Paste the HTML into your web page