FFAIR - Zapier Set Up

  1. Sign up on zapier Automate without limits | Zapier

  2. Go to Zap

     
    f6722944-0789-4ac7-b6ea-37c30719ccbe
  3. Add zapier webhook as trigger

     
    01ad7682-83e3-417d-bf89-3a8a21003213
  4. Choose Catch hook

     
    5a687956-3d15-4847-9d54-01d01ad7d62c
  5. Nothing here

     
    110f5f17-d2c0-467b-a242-8f28019e6ff7
  6. Copy hook url

     
    32986291-448e-44e4-95b6-77699bc95697
     
  7. Paste here and click Test

     
    c62b0d95-5cc8-47c2-a652-7ad3f8c102fd
  8. Click Test trigger and Continue with selected record

     
    e0883931-6ce8-48fa-a40e-f54c77b62291
     
  9. Create google sheet with needed headers (ID is require, others are about your goal)

  10. Choose google sheets as action

     
    1a613381-abbd-4e8e-8b56-c2c0eb4fd690
     
  11. Set up google account and choose Update Spreadsheet row

     
    e1882727-7be2-443a-b6d1-4794f2bd5cc2
  12. Choose needed Drive, Spreadsheet, and Worksheet. Click at + Add search step and add it

     
    3a57d790-9fa1-419e-b604-cc30cbfb3268-1
  13. Set up searching step (Lookup column = ID as Lookup value)

     
    71aedb78-c608-47f1-8cab-e8a13acfad64-1
  14. 🥊🥊🥊 Click at Create Google Sheets ... and map fields from request and headers of your google sheet

     
    dd573abf-90ad-4ce1-a2e1-290ca7ebfc18
  15. Test step and continue

    c299bba8-deaa-4069-9052-62a31e5d71eb
  16. Test 3rd step and publish