Connect Wix Database to Google Sheets

Wix and Google Sheets

Wix Google Sheets Integration | Connect Google Sheets to Wix

Velo Code Solution

Some customers find it not agile enough to update content on Wix sites through the content manager. One of the possible ways to improve could be using the Google Sheets spreadsheet as a database for storing the content of the Wix site. The established connection is live, and updates made in Google Sheets documents reflect on-site immediately.

There are numerous scenarios of use Google Sheets in Wix. Some of them are:

Use Google sheets documents as storage of all content on site that can be added/changed/deleted in a few clicks in the Google Sheets app on your phone or laptop.
Use multiple Google Sheets own integrations/plugins to get data into it (from forms etc), which is then immediately available live on the Wix site for interaction.
Using Google Sheets with various fulfilment / CRM / contacts software that can then be fed on site.

Benefits are:

Easy to update information from any device where Google Sheets can be installed/launched.
Changes go live immediately.
Storage is virtually unlimited.
Google Sheets is free to use.

Disadvantages are:

If Google Sheets is down, the content will disappear from the website until it is back to work.
Google Sheets is not really built to store photos and especially videos. Therefore, the solution is more oriented for text content.

BOOK A FREE CONSULTATION

Tools

Wix Velo Code,Google Sheets

Example Code

frontend

backend

import { getValues } from '@velo/google-sheets-integration-backend';

import wixSecretsBackend from 'wix-secrets-backend';

async function getSecretSheetId() {

const id = await wixSecretsBackend.getSecret('sheetId');

return id;

}

export async function getValuesWrapper(range) {

try {

validateRange(range);

try {

const sheetId = await getSecretSheetId();

const result = await getValues(sheetId, range);

const response = result.data.values;

return response;

} catch (err) {

return Promise.reject('Get values failed. Info: ' + err);

}

} catch (validationError) {

return Promise.reject(validationError.toString());

}

export async function insertValuesOnSheet(firstName, lastName, memberId, email, phone, homeCourse, paid, paidDate, dateAdded, password, course, role, value1, value2) {

let len = await getLen()

let values = [firstName, lastName, memberId, email, phone, homeCourse, paid, paidDate, dateAdded, password, course, role, value1, value2];

const res = await appendValuesWrapper(values, `A${await len.toString()}:N${await len.toString()}`);

}

export async function removeValuesOnSheet(id) {

const res = await clearValuesWrapper(`A${id}:${id}`);

}

More Velo Integrations

Dropshipping in Wix

Master the art of integrating dropshipping into your Wix website using Velo with our comprehensive guide. Learn step-by-step how to seamlessly connect your site with top dropshipping providers, automate order processing, manage real-time inventory, and enhance your online store's functionality for a successful e-commerce business

Wix Azure Integration: Elevating Your Site with Microsoft Azure Cloud Capabilities

Discover how to connect Microsoft Azure services to your Wix website for improved scalability, authentication, and cloud data handling.

Integrating ShipStation with Wix: Enhancing E-commerce Operations

Connect ShipStation with Wix to streamline shipping and order management. Enhance customer satisfaction with smooth, efficient delivery solutions