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.
Hello, I tried following your example and explanation and I am missing something. How is the zap built? I see it is Sheets to Webhook, but the rest of the details are not there... I did use the PUT but What URL should I use? What should I put in the rest of the required information? Would really appreciate more information. Been trying to do this for over a week! :) TIA
Incredibly helpful. Thank you SO much!!