In this article, we'll show you how to embed your Google Sheet into your Wix website
If you have an existing website made in Wix you probably want to embed your Google Sheet data to one of the pages.
For example you have an inventory list in a Google Sheet:
And you want to embed to your Wix site:
You can manage the data in your data source sheet and it will be updated automatically on the website.
Once you will install the add-on you need to select a template: Table
You can hide all unnecessary elements in the Layout tab, because your website already has a header, a navbar, a footer etc.
If you don't have a data source sheet you can skip this step and add your data directly to Sheet2Site sheet, Cards tab.
If you have already a datasource sheet with all, there are 2 things that you can do:
If you want to manage everything from your datasoure sheet you can import your data to the sheet2site sheet using import formula (see below). It will auto update the data on your website one you make any change in your data source sheet. This step might be useful if you are feeding your data source sheet from different sources.
If you don't care, you can just copy all of your data to Sheet2Site sheet, Cards tab and manage everything from there.
Open Cards tab and put cursor on A2. Import data from your data source sheet using ImportRange formula:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1dDnNRlqZex4z1FJMPNu1Z6YViHkBeG5mzfm3SCEKSrQ/edit?ts=5e3dbd7f#gid=149855706","Active Inventory!A:Z")
First time it will request access. Press Allow Access:
Let's create a new Wix page:
Go to Menu & Pages. Site Menu. Add Page. Let's call it Inventory.
And press publish the page:
This method requires 2 things:
If you done all of above please do the following actions:
The problem with the you are required to have a Wix plan that has Analytics & Tracking feature. And that's not the cheapest one. Also it's required to connect a custom domain.
If for any reason you can't follow this two requirements there is an alternative way to embed your Google Sheet into your Wix website. The only different is that you will need adjust the height manually:
Instead of step 4 follow this steps:
https://sheet2site.com/api/v3/index.php?key=1pafwTXUxqSbVpO0bjjwjiGCxyokUK_Je6JLqEjaW8ls
We want to make out embed site as native as possible. First thing that indentifing that our site is embed is a background color. Our Wix website have a white background, but our embed site have a gray background. Let's fix it.
It will change the default background color of the embed website to white.
If you have done everything correctly you will see perfect, clean, embed sheet in your Wix website:
If you need any help about embeding Google Sheet to Wix website please message me in the chat in the right corner and I will be happy to help you.