Zapier Integration – Catching Hooks from Detrack x Google Sheet

This article is an example integration consisting of the following:

• setting up webhook PUSH notifications from Detrack
• catching the information in Zapier (using Hooks)
• updating the information in GoogleSheet*

Note:

• You may replace GoogleSheet* with other systems / apps for integration.

Steps

1. Create a new worksheet in Google Sheet, and give it a name, e.g. DetrackHooks.
   
2. Provide a name to the worksheet, e.g. Jobs.
   
3. In your Zapier account, create a new Zap.
   
4. Select Webhooks by Zapier for Choose App; and Catch Hook for Choose Trigger Event.
   
5. Click Continue.
6. Copy out the generated Custom Webhook URL (for entering into your Detrack account); and enter data for Pick off a Child Key.
   
7. Log into your Detrack account.
8. Navigate to Settings > Webhook.
   
   • Enter the copied Webhook URL – e.g. https://hooks.zapier.hooks/catch/650040/o13bgtz into the Webhook URL field.
   • Select the necessary triggers, e.g. Completed, Partially Completed etc..
   • Select JSON for Content Type.
   • Click Save when done.
9. Create a dummy job in your Detrack account to test. Refer to How To Add A Delivery.
10. Return back to your Zap, and click Test & Continue.
11. Click on the + button to add another action.
12. Select Google App for Choose; and Create Spreadsheet Row (or Update Spreadsheet Row) for Choose Action Event.
    
13. Click Continue.
14. Select your Google Sheet account.
    
15. Click Continue.
16. Select and map the fields from PUSH notification to your Google Sheet columns. For example:
    
17. Click Continue.
18. Click Test & Continue.
    
19. If the Zap is successful, a new row will be created in your Google Sheet whenever the PUSH is triggered from Detrack.
    
20. You may extend or hook the zap with any other apps available in Zapier.