Skip to main content

Zapier Integration - Catching Hooks from Detrack x Google Sheet

Written by Jenny Goh

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 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.

Did this answer your question?