1. Install Add-on for Google Sheets
Create a new Google Sheet
Add-ons -> Sheet2Site -> Choose Template
Please wait for 20 seconds until a template will finish to copying
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
Copy the link of your Google Sheet:
And paste it here 👇
Your website will be open in a new window.
Please save the link will not change.
Change a text in a "Header" tab in the bottom of the spreadsheet to understand how it works.
6. Push changes to your website
Open the link that you saved it previusly. Data will will be updated in 30 sec.
Add-ons -> Sheet2Site -> Show Advanced Settings.
More tabs will appear with all advanced settings like Layout, Filters, Subpages etc.
8. 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