sheet2api logo Sign in

Google Sheet to Website

Website list from Google Sheet. No coding required.

In just a few minutes we're going to discover how to list information from your Google Sheet spreadsheet straight to your web page. No coding required.

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
Looney Tunes
The Simpsons
Sheet3

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.

2. Create Spreadsheet API

As per the video below:

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

3. List Spreadsheet data on your website

As per the video below:

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

launchTry out this on Codepen


It's as easy as that 🎉.

If you need help, please feel free to send a message via the contact page.

Start using sheet2api now

Be up & running in seconds.