Zapier integration example – request selected tracks into Google Sheet

Zapier is a platform where you can automate workflows with the use of world-known tools like Google Docs, Slack, Airtable, and more than 2000 other integrations.

In this example, we will create a workflow that will obtain and move tracks for the selected vehicle and time interval into Google Sheet. We will use the Chrome Zapier Push extension therefore you need to use the Chrome browser and install the Push by Zapier plugin.

Before you start you also need to click here and follow the steps to get Client ID and Secret that will be needed for connecting Zapier with MyCarTracks.

After you have your API credentials and plugin installed, follow these instructions to create an empty Google Sheet for later use:

  1. Go to Google Sheets and, if you’re not already, log in.
  2. Create a new blank spreadsheet – for this purpose name it MCT mileages.
  3. You must add header – Enter column names in the first row, for this example we will add items as on the image below.
    Google Sheet example

Now we are ready to create the Zap

  1. Log into or create your Zapier account.
  2. Click on Make a Zap button.
  3. On the top edit, “Name your zap” and name your zap – put an identifier that will help you to recognize this zap.
    Zap name
  4. In Choose App & Event search for “Push” and select Push by Zapier.
    Push by Zapier
  5. Select the New Push With Fields trigger and click CONTINUE.
    New Push with Fields
  6. In Customize Push enter two Form Fields: Start Date, End Date and click CONTINUE.
    Customize push
  7. Now you need to connect with the Chrome plugin. You should see the Zapier plugin in your extensions bar on the top in your Chrome browser. Click on it and then click on the one labeled TESTING.
    Testing push plugin
  8. Enter the Start and End date. Put it in format YEAR-MONTH-DAY HOUR:MINUTE:SECOND, see the image below. Enter a start and end date that you know there are some existing tracks for the vehicle we want data from. This is just for testing but you need to cover existing data. Later you will be able to set any date you want data for.
    Push plugin dates example
    Click the Send button. It should show a green successful test.
  9. Now back in the Zapier integration click on the Test trigger button. It will show a successful notification that it found the data. Click the CONTINUE button.
    Successful plugin test
  10. Now you will be asked to select the Do this… action. Search for MyCarTracks and select it.
  11. Select the Find Tracks action and click CONTINUE.
    Find tracks
  12. Click the Sign in to MyCarTracks button. A new window pops up where you need to enter Client ID and Client Secret that you should have when you followed the instructions mentioned above. Enter them here and connect. After a successful connection click the CONTINUE button.
    Please note that if you already created any MyCarTracks integration you can just select the existing account.
  13. On the Customize Track step select the Driver or Vehicle for which you will be obtaining the tracks.
    In the Start Time field search for start time and select the Fields Start Date.
    Start Date select
  14. Repeat the same for the end time but search and select the Fields End Date.
  15. You can also use other filtering options if you need them or leave them empty. Click CONTINUE.
    Customize Track Filter setup
  16. Now click on the TEST & CONTINUE button. It should search for existing tracks in MyCarTracks and show you a message that a track was found.
    MyCarTracks Zap get tracks success
  17. Now click on the blue + to add the next step after the MyCarTracks step. Search for Google Sheets and select it.
  18. Click on the Create Spreadsheet Row(s) option and click CONTINUE.
    Google Sheet Create Spreadsheet rows
  19. Now you need to select existing Google connection or sign in to Google Sheets with the Sign-in button – click it and follow the instructions.
  20. After you’re connected search the Spreadsheet (MCT mileages) that you created following the instructions above.
  21. Now you need to match the columns from the header with the data from MyCarTracks. Click on each entry and select the correct match as on this image:
    Google Sheets map to columns
  22. Click on the CONTINUE button.
  23. Now click on the TEST & CONTINUE button – you will see that a test entry was sent into the Google Sheet. You can remove this entry.
    Google Sheets data successfully sent
  24. Click on the TURN ON ZAP button. Now the zap is running and downloading data when a new track is available.

What next?

Was this article helpful?

Related Articles