The app provides a simple way to connect a spreadsheet and use cell values from it within your site as text elements. It's a really simple way to sync data from a sheet and always keep your website up-to-date just by modifying a Google Sheet.
If you need a more complex data output in your site, like a table, consider using the app Google Sheets Table instead.
If you already have a widget on your site and need to add another one, the simplest way is to select it
Then duplicate it using ctrl+c, and ctrl+v as if you would copy/paste text. The cloned widget will have the same setup as its original copy.
Otherwise, if you are in the Wix Editor, you can add it by using the + button, and then scrolling down, and adding it again from App Widgets.
In order to change the Google Sheet, you will need to upgrade to a premium subscription. In case you upgrade and find out that this app is not what you are looking for, we will offer a full refund, no questions asked. Until you are ready to upgrade, you can use the connected spreadsheet Test Spreadsheet. In this spreadsheet there are cells with data that you can use - for example: A1, B2, B5 etc. Check out point 3. on how to modify the cell location. This spreadsheet has only read access, and you cannot change it - please do not ask for share permission!
Once you've upgraded, click on the Change Google Sheet Button.
Your Google Sheet must be shared with View access with the email [email protected]
!!! Important: Make sure that your spreadsheet does not contain confidential data. The Google Sheet should only contain data that can be displayed on your site. If you need a solution for displaying data that may be confidential, please contact us on support for further help.
If you shared the spreadsheet correct, once you click on Save Google Sheet, the new spreadsheet will be connected.
A cell in a spreadsheet is defined by two items, for example:
a) The Sheet where the cell is located, in our case this is Sheet2. A Google Sheet can have multiple Sheets/Tab, so be careful what you select. Also, note that the Sheet Name cannot be changed. If it's changed, it will cause a read error.
b) The actual cell location, in our image above, the cell would be C5.
Once you have identified your cell, change it in the Settings and save it. For any future, reloads it will automatically pull the latest value of this cell.
If this field is switched OFF
Then the value of the Cell will be displayed directly in both Editor and Live website.
If you want to use the Cell value within your own custom text, enable the switch and write your text in the input below.
Using this display, you will not see the value of the cell in the editor. The real value will replace {val} placeholder in the Preview or in your Live site. To test this feature, please Save, then switch to the Preview.
The refresh time should be almost instant and there shouldn't be a loading delay compared to other text elements on your site!
a) Make sure to not change the Sheet name, otherwise you will need to connect the Google Sheet again to retrieve the new Sheets.
b) After you edit a Google Sheet cell, make sure to click enter so that the value is actually saved in the cell. If you are currently editing the cell, that value is not entered in the sheet.
c) In some cases, Google Sheet may only return the changed cell value in 1-2 minutes. This usually happens for new Google Sheets. Make sure to refresh the page and check again.
Yes! Here is how:
$w.onReady(async function () {
// Change cell position.
await $w('#cellValue1').changeCell('B2', 'Sheet1');
// Get current value of the cell.
let currentCellValue = await $w('#cellValue1').getCellValue();
});
Please use the blue chat bubble from the bottom-right of the page to talk to us.
Please consider adding a review for the app where you mention how it has helped to achieve your goals. We prioritize adding features to an app based on how many reviews it's getting. Thank you for your help! ❤️