Detrack

Create a new worksheet in Google Sheet, and give it a name, e.g. DetrackHooks.

Provide a name to the worksheet, e.g. Jobs.

In your Zapier account, create a new Zap.

Select Webhooks by Zapier for Choose App; and Catch Hook for Choose Trigger Event.

Copy out the generated Custom Webhook URL (for entering into your Detrack account); and enter data for Pick off a Child Key.

Navigate to Settings &gt; Webhook.

- Enter the copied Webhook URL – e.g. <a href="https://hooks.zapier.hooks/catch/650040/o13bgtz" target="_blank" rel="nofollow noopener noreferrer">https://hooks.zapier.hooks/catch/650040/o13bgtz</a> into the Webhook URL field.
- Select the necessary triggers, e.g. Completed, Partially Completed etc..
- Select JSON for Content Type.
- Click Save when done.

Create a dummy job in your Detrack account to test.

Return back to your Zap, and click Test &amp; Continue.

Select Google App for Choose; and Create Spreadsheet Row (or Update Spreadsheet Row) for Choose Action Event.

Select and map the fields from PUSH notification to your Google Sheet columns. For example:

If the Zap is successful, a new row will be created in your Google Sheet.

You may extend or hook the zap with any other apps available in Zapier.

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 &gt; Webhook. 
 
 
 - Enter the copied Webhook URL – e.g. <a href="https://hooks.zapier.hooks/catch/650040/o13bgtz" target="_blank" rel="nofollow noopener noreferrer">https://hooks.zapier.hooks/catch/650040/o13bgtz</a> 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. 
 
 
10. Return back to your Zap, and click Test &amp; Continue.
11. Click on the + button
12. to add another action.
13. Select Google App for Choose; and Create Spreadsheet Row (or Update Spreadsheet Row) for Choose Action Event. 

14. Click Continue.
15. Select your Google Sheet account. 

16. Click Continue.
17. Select and map the fields from PUSH notification to your Google Sheet columns. For example: 

18. Click Continue.
19. Click Test &amp; Continue. 

20. If the Zap is successful, a new row will be created in your Google Sheet. 

21. You may extend or hook the zap with any other apps available in Zapier.