1. Install Add-on for Google Sheets
2. Choose Template
Create a new Google Sheet
Add-ons -> Sheet2Site -> Choose Template
Please wait for 20 seconds until a template will finish to copying
3. Share your Google Sheet
To be able to make your website work you need to share your sheet with a link. Anyone with a link a see it (if you will share the link), but no one can edit it. Also it can not be found through Google search.
- Share (top right corner)
- Get shareable link
- Anyone with a link can view
4. Publish your website
Press "Update Website" green button in the top-left corner. This link will not change, so you can save it. Data will be changed it 30 secs.
5. Edit your website
Change a text in a "Header" tab in the bottom of the spreadsheet to understand how it works.
6. Push changes to your website
Press "Update Website" again or open the link that you saved it previusly. Data will will be updated in 30 sec.
7. Advanced Settings
Add-ons -> Sheet2Site -> Show Advanced Settings.
More tabs will appear with all advanced settings like Layout, Filters, Subpages etc.
Embed to your existing website
If you already have a website and want to embed your spreadsheet data in a visual way you can easily do it by adding a code snippet
Sheet2Site Embed support all major website builders such as Squrespace, Wix, WordPress, Weebly. It aslo support custom website build with code.
It will keep your logo, navigation bar footer. It will be on a separete page like: example.com/directory
How to embed Sheet2Site to your webiste?
Here is how you can create your own embed site with your own data:
- Sheet2Site Google Sheet add-on must be installed
- Template must be created
- Menu Add-ons -> Sheet2Site -> Embed in your website
- Copy code snippet
- Paste it into your website builder as embedded code. Let me know if you need any help.
Once you done all of steps above, you can read documentation about what you can do with Sheet2Site