-
Sign up on zapier
Automate without limits | Zapier -
Go to
Zap
-
Add zapier webhook as trigger

-
Choose
Catch hook
-
Nothing here

-
Copy hook url

-
Paste here and click
Test
-
Click
Test triggerandContinue with selected record
-
Create google sheet with needed headers (
IDis require, others are about your goal) -
Choose google sheets as action

-
Set up google account and choose
Update Spreadsheet row
-
Choose needed
Drive,Spreadsheet, andWorksheet. Click at+ Add search stepand add it
-
Set up searching step (
Lookup column=IDasLookup value)
-
🥊🥊🥊 Click at
Create Google Sheets ...and map fields from request and headers of your google sheet
-
Test step and continue

-
Test 3rd step and publish