# Zapier integration example – moving the latest tracks into Google Sheet

**URL:** https://community.mycartracks.com/t/zapier-integration-example-moving-the-latest-tracks-into-google-sheet/102
**Category:** Integrations & API
**Tags:** api, integrations, zapier, google
**Created:** 2026-04-16T08:29:31Z
**Posts:** 1

## Post 1 by @MyCarTracks_support — 2026-04-16T08:29:32Z

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 move all new tracks for the selected vehicle into Google Sheet. If you need to learn how to request certain data for a vehicle/driver see [Zapier integration example – request selected tracks into Google Sheet.](https://community.mycartracks.com/t/zapier-integration-example-request-selected-tracks-into-google-sheet/103)

Before you start [click here and follow the steps](https://community.mycartracks.com/t/where-to-get-your-api-credentials/59) to get Client ID and Secret that will be needed for connecting Zapier with MyCarTracks.

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

1. [Go to Google Sheets](https://docs.google.com/spreadsheets/) and login if you’re not already.
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. To create header drag the horizontal line right above the “1” column and drag it under the “2”.

 ![Google Sheet example](https://community.mycartracks.com/uploads/default/original/1X/a09ecaf591ec6824d4b100623043e2458c38b7cc.png)

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 top edit and name your zap.
4. Into **Choose App & Event** search box enter **MyCarTracks** and select it.
5. Click on the **Tracks** event and click CONTINUE.

 ![Zap Tracks event](https://community.mycartracks.com/uploads/default/original/1X/0c7b563d48b6fd9e6503fa305ba1be9691549bb8.png)…  
6. 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.  
7. Now on the Customize Tracks, you can select or enter filtering details. You can select the Driver, Vehicle, and other filtering options. We recommend you set also Start time filter to get only the latest tracks. After you’re satisfied with the filter click the CONTINUE button.

 ![filtering options](https://community.mycartracks.com/uploads/default/original/1X/2f7c77cb8ffbedb28c3926ada2e8d0e0f7bda899.png).  
8. Now click the **Test trigger** button. Zapier will download and example of data based on the filter. Click CONTINUE.  
9. Now you’re going to set the second **Do this …** step. Into Choose App & Event search for **Google Sheets** and select it.  
10. Click on the **Create Spreadsheet Row** option and click **CONTINUE**.

 ![Google Sheet create row](https://community.mycartracks.com/uploads/default/original/1X/9832469b8aa3d830cf07fd71af2db7203c8525f1.png).  
11. Now you need to sign in to Google Sheets with the Sign-in button – click it and follow the instructions.  
12. After you’re connected search the Spreadsheet (MCT mileages) that you created following the instructions above.  
13. 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 Sheet MCT match columns](https://community.mycartracks.com/uploads/default/original/1X/c6ac6b1bb8bedc8bf160820004ea6c9cf7c8e1d4.png).  
14. Click on the **CONTINUE** button.  
15. 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.

 ![Test ZAP success](https://community.mycartracks.com/uploads/default/original/1X/32f8049b6b6f7130252eda1213deb7e41106f764.png).  
16. Click on the **TURN ON ZAP** button. Now the zap is running and downloading data when a new track is available.

These instructions are just a simple solution on how to automatically get the latest data from MyCarTracks into other SaaS tools that you use.

### 

#### What next?

- If you need to know [How to add KML, CSV or GPX export from each track read here.](https://community.mycartracks.com/t/zapier-integration-how-to-add-kml-csv-or-gpx-export-from-each-track/104)

* * *

Source: [Zapier integration example – moving the latest tracks into Google Sheet](https://community.mycartracks.com/t/zapier-integration-example-moving-the-latest-tracks-into-google-sheet/102)