-
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 trigger
andContinue with selected record
-
Create google sheet with needed headers (
ID
is 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 step
and add it -
Set up searching step (
Lookup column
=ID
asLookup 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