top of page
  • Writer's pictureSneha Shah

Build website content from googlesheet (Zapier)

Updated: Oct 6


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.

272 views0 comments
bottom of page