Detrack
  • Features
  • Who uses Detrack
    • Logistics service providers
    • Retailers
    • Medical and Pharmaceutical
    • Furniture & home appliance distributors
    • Construction material distributors
    • Food & beverage distributors
    • 3PL providers
    • Businesses with delivery vehicles
  • Case Studies
  • Integrations
  • FAQs
  • Pricing
  • Log in
  • Try it free
Try it free
Select Page
Tutorials // Integrations // Zapier Integration For Google Sheets

Zapier Integration For Google Sheets

If you are currently using Google Sheets to manage your deliveries, you can consider automating the transfer of information from your Google Sheets into Detrack automatically, with the use of an easy Zapier integration (one time setup).

To begin, you will need to have:

  1. Have a Zapier account

Once you have the above, you are ready to start on the steps below.

  1. Create a new spreadsheet in Google Sheets, and give it a recognizable name (e.g. Zapier Test”).
  2. At the bottom left of the screen, provide a name to the worksheet (e.g. “Jobs”).
  3. In your Zapier account, create a new Zap.
  4. Select “Google Sheets”.
  5. Select “New Spreadsheet Row” for the Trigger Event.
  6. Click “Continue”.
  7. Choose the linked account where your spreadsheet is located, and find the spreadsheet/worksheet under Customize Spreadsheet Row.
  8. Select the Spreadsheet (e.g. “Zapier Test”) and Worksheet (e.g. “Jobs”) (from Steps 1 and 2).
  9. Click “Continue”.
  10. Click on the blue “+” button.
  11. Search for “Detrack”. Kindly use the latest version.
  12. Click “Continue”.
  13. Click “Sign in to Detrack”.
  14. Enter your Detrack API Key.
  15. Click “Yes. Continue” when done.
  16. Return back to the Zap, and click “Continue”.
  17. If necessary, you may edit your Detrack account to Zapier account by clicking on the “Edit Accounts”.
  18. Select “Create Job” for Action Event.
  19. Click “Continue”.
  20. Customize how the columns in the Google Sheets spreadsheets will be mapped to attributes of the Zapier Zap.

    The value of these fields can either be constants, or reference columns in the result of the New Spreadsheet Row trigger you specified in Step 1.
    To reference columns, click on the button to the right of each input field.

    The four required attributes are:
    1. Type
    2. DO Number
    3. Date
    4. Address
  21. For assigning values to other optional fields, you may select “Yes” under “Show All Data Fields”.
  22. Click “Continue” when done.
  23. Navigate to Settings and provide a name to the Zap.
  24. Return back to Home and Switch On the Zap.
  25. To test, navigate back to your Google Sheets and enter a row of job.

    If setup correctly, the zap should trigger, with the new Job on being created in your Detrack Dashboard on the specified date.

Steps

  1. In your GoogleSheet, create another worksheet (e.g. “Job Items”).
    This worksheet will be used to contain the entries for the “Item Details”.

     

  2. In the newly created “Job Items” worksheet, create the following columns:
      • DO Number – This column will be used to reference the DO number created in the “Jobs” spreadsheet.
      • SKU
      • Description
      • Quantity
  3. To create entries in the Item Details section, click on the “Plus” button.
  4. Select “Google Sheets” for the App, and “Find Many Spreadsheet Rows (With Line Item Support).
  5. Click “Continue” to proceed to the next step.
  6. Select your account.
  7. Click “Continue” to proceed to the next step.
  8. This step involves linking and referencing the information created in the “Job Items” worksheet to the information in the “Jobs” worksheet through the “DO Number” column.
  9. Click “Continue” when done.
  10. Navigate to the following Step in the Zap.
  11. Scroll down to the “Item” section.
    Select the data from the “Find Many Spreadsheet Rows (With Line Item Support)” section.
  12. Click “Continue” when done.
  13. Final view of the Zap.
  14. Switch On the Zap.
  15. To test, create a job in the “Job” spreadsheet with its respective item entries in the “Job Items” spreadsheet.

Note:

  • A maximum of 10 item entries can be saved to a single job. (Limitation of Google Sheets Integration with Zapier Platform.)
  • Every job must have at least one corresponding row in the “Job Items” worksheet, and Zapier will stop the workflow if there is an absent of row in the “Find Many Spreadsheet Rows” action.
  • Using this method, every single Job must have at least one corresponding row in the items worksheet, as Zapier will stop the workflow if no rows are found in the Find Many Spreadsheet Rows Action.
    At point of writing, Zapier does not offer “optional” or “failable” actions.
    You might need to create an additional yes/no column in the Jobs worksheet, then use branching in Zapier to either use a variant of the Create Job Action with no column references to the Items Worksheet to create a Job with no items, or a variant of the Create Job Action with references to the Items Worksheet to create a Job with items.
Back to all tutorials
  • Start your free trial

WHO USES DETRACK

  • WHO USES DETRACK
  • Logistics Service Providers
  • Retailers
  • Medical and Pharmaceutical Companies
  • Furniture & Home Appliance Distributors
  • Construction Material Distributors
  • F&B Distributors
  • 3PL Providers
  • Businesses with Delivery Vehicles

CASE STUDIES

  • CASE STUDIES
  • PAN Logistics’ customers get real-time proof of deliveries with Detrack
  • Teak & Mahogany solved its logistics problems with Detrack
  • Mansco’s deliveries went paperless with Detrack
  • SGS Logistics improved the customer experience using Detrack

DISCOVER DETRACK

  • DISCOVER DETRACK
  • High speed route optimization
  • Tap to track
  • Contactless Delivery
  • Who We Are
  • Countries & languages
  • Reviews
  • Security
  • App data usage

GET IN TOUCH

  • GET IN TOUCH
  • Schedule a call
  • Support overview
  • Tutorials
  • General enquiry
  • Ask us anything via chat
  • The Detrack Blog
  • FAQs
App store
Google play
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • © Detrack Systems Pte Ltd
  • Anti-spam
  • Privacy
  • Terms Of Use
  • Payment Terms
  • Data Retention
  • SLA
  • SaaS Agreement
Detrack is powerful delivery management software that lets you track your vehicles live on a map and capture electronic proof of delivery (e-POD) using our iOS or Android apps and an easy to use web dashboard for admins. Our apps have been translated into 26 languages and are being used daily around the world to complete millions of deliveries. Whether you’re looking for Delivery Management Software, a TMS System, Courier Software, Dispatch Software, or just an excellent Proof Of Delivery App, Detrack is the one to try. Sign up for a free Detrack account to get started. Or speak with our sales team today and we will get you up and tracking in no time.

The Capterra logo is a service mark of Gartner, Inc. and/or its affiliates and is used herein with permission. All rights reserved.