top of page
  • Writer's pictureSneha Shah

Build website content from googlesheet (Zapier)

Updated: Oct 6, 2023


Objective:

Allow clients to update and add website contents via google sheet


Technology:

Google Sheet,

Wix Velo (repeater, collection, http-functions.js)

Zapier (3rd Party Integration Tool), webhooks


Limitation:

Cannot delete data as no real-time event handler is available on ZAPIER.




DemoLinks:




DEMO Video



STEP 1: Create google sheet via your Gmail account

Key Setup: Grant public readonly permissions






STEP 2 Create Collection via content manager

STEP 3 : Create Repeater and connect it to dataset

STEP 4 : Define put_ method in http-functions.js

STEP 5 Create ZAP on ZAPIER (note your webhook)

Fellow full stack developers, kindly leave a comment as how this was helpful. This will surely encourage DiTAPS to build more such blogs.

2 Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
Joshua Vonderheide
Joshua Vonderheide
Feb 10

Incredibly helpful. Thank you SO much!!

Like
Guest
Feb 13
Replying to

Thanx for kind words. regards sneha shah

Like
bottom of page