# How to use Zapier to sync Google Sheets data

## How to create a new Zapier token

Learn how to create a new Zapier token [here](/guide-using-zapier-with-databox).

## How to prepare your Google Sheet

To create Zaps based off of data in a Google Sheet, your Sheet must be configured in a specific way. If your Google Sheet is incorrectly configured, your Zaps may be compromised.

[Zapier's documentation](https://zapier.com/help/google-sheets/#how-setup-your-google-spreadsheet-work-zapier) outlines the way you will need to format your Google Sheet in order to work with Zapier.

## How to initially format your Google Sheet

- The first row of your Sheet must have column headers in any column you want to sync data from with your Zap.
- The second row of your Sheet must have data entered in any of the columns that you want to be able to sync data from with your Zap.
- All other rows should be copied to another Worksheet and deleted from the original Worksheet. When creating up a Zap, only the first two rows of the Google Sheet should be populated. All other rows can be copied back to the original Worksheet once the Zap is successfully configured.
- You must have a Date column that specifies the date the data should be synced to. This will determine the Date Ranges when the data will be visible in Databox. A timestamp can be added in these cells, but it is not required.
To format your Date column in your Google Sheet, click **Format > Number > Date Time**.
Each entry in the Date column must be unique. If you have multiple entries with the same date, it will be necessary to include a timestamp to differentiate between these entries.


## How to update your Google Sheet

- When you copy and paste data from another program into a Google Sheet, the original formatting is saved, which may cause an issue with your Zap(s).
To ensure your Zaps are able to successfully execute, it's recommended that you either manually enter your data in the Sheet or copy your data to an unformatted program before adding them to your Google Sheet.
- Editing your Google Sheet while a Zap is already live is not recommended. To edit your Google Sheet, it's recommended that you turn off your Zap first.


## How to create a Zap for a Standard Metric

In our example, we will create a Zap to access data from our Google Sheet to track  **Closed Won Amount**.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_1.8e7c0c405f42f06878427198b0ef29205e9df346e3bb15d6e02cc5c8dc861016.4783b0ec.png)

Each unique Metric that we want to sync with Databox will need to be accessed through a different Zap. Once we have one Zap built, we can duplicate it and make minimal changes to update it to sync different data from the Google Sheet.

To start, we want to create a Zap that syncs "Closed Won Amount" from our Google Sheet to Databox.

1. When creating new Zaps, our Google Sheet must be formatted in a specific way. To start, we can only have the first two rows of the Sheet populated.
To ensure we don't lose any data that is already on our Sheet, we'll copy the original Worksheet and store the duplicated version for future use. Now we can delete all entries below row 2 from our original Worksheet and create our first Zap.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_2.134095b52b1c76c70a097034edc7ed836bcd0f6edd062b82b01c6899317e0599.4783b0ec.gif)

1. Navigate to your **Home** page in Zapier. Click the orange**+ Create Zap**button


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_3.90b6e56deba586ca6b98d47d4996890bb1333d3719d71917aab04e419daf8afd.4783b0ec.png)

1. **CHOOSE APP & EVENT:** Select **Google Sheets** from the **App event** list


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_4.7457a59b0184a79e3302c490604d72898f62cbede426604ffd1c87f84073df9a.4783b0ec.gif)

1. Select an **Event** (Trigger **)** from Google Sheets. The Event determines what will initiate a data sync with Databox.


- New Spreadsheet Row: The trigger will be initiated when a new row is added to your Google Sheet.
- New or Updated Spreadsheet Row: The trigger will be initiated when a new row is added or an existing row is updated in your Google Sheet.


For our example, we'll select **New or Updated Spreadsheet Row** as the **Event**. This gives us more flexibility and ensures that any changes made to our Google Sheet will be reflected in Databox.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_5.4b811a80ae0762d6baee21db41c5e42bec976ba7dd17fd2f8b3914ad42f97c5d.4783b0ec.png)

Click the blue **Continue** button.

1. **CHOOSE ACCOUNT:**Here we must select a Google Sheets Account.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_6.5b1511d70a28c975424859c9a1455a6d0723197017c06157ea2678baeddf52c3.4783b0ec.gif)
If you don't have Google Sheets connected, click **+ Create a new Account** at the bottom in the dropdown. This will open a window where you can select the Google Sheets Account that you want to sync data from.

Click the blue **Continue** button.

1. Next, we have to tell Zapier exactly which Google Sheet, Worksheet, and Trigger Column to sync data from.


For our example, we'll choose **Q1 Sales** **Data** as the **Google Sheet**, **Q1 Sales** as the **Worksheet**, and **Deal Amounts** as the **Trigger** **Column**.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_7.12e6c4afef24cb4052bba84502e42ac4d8f6566d1c16586509a1d11f87876ead.4783b0ec.gif)

1. It's best practice to test our current setup. When we click on the drop-down arrow, we can validate that we're seeing data from the correct cell in our Google Sheet.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_8.6ac36b399c78dee70a365690a7c46250b3d46dfcb8a1bb816b0b7cd33c9e1816.4783b0ec.gif)

1. We now have to define the Action that will happen as a result of the Trigger. To start, we'll select **Databox** as the **Action App**


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_9.adaec879939ea6516673b5011017c63b6ec3741798854777c6c038ae070fc339.4783b0ec.gif)

1. We must select a  **Databox Action**. Databox Actions define how the data is tracked.


- Increase Counter: Every Action that is triggered in a Zap will count as 1 event. This means that Databox will increment the current value by 1 each time the Zap is triggered.
- Push Custom Data: Every Action that is triggered in a zap will sync as custom data with Databox.


We want to track the specific Deal Amounts that are entered in our Google Sheet, so increasing a counter will not be sufficient for our use case. Instead, we'll select  **Push Custom Data**so the Deal Amounts are synced with Databox.

1. Here we must select a Databox Account. If you don't have Databox connected, click Create an Account. This will open a window where you can enter the push token that was generated for Zapier.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_10.097697fe6b1e6aa6b88d8bc6dc4199f47e87933cfe5770dfd49f6e5df2501e7d.4783b0ec.gif)

1. Rather than pushing custom data to a Metric that already exists in our Databox Account, we want to create a completely new Zapier Metric to track this data.


To do that, we'll select  **Use a custom value (advanced)**from the **Metric** drop-down list. This will reveal another field called  **Custom Value for Metric ID**. This is where we'll enter the name for our Metric. This is the Metric name that we'll select in the Designer in Databox.

For our example, we'll enter  **Closed Won Amount**as the Custom Value for Metric ID.

On the same page, we'll select  **Deal Amount** from the  **Value** drop-down list.

**Titles** are the same as  **Dimensions,** and essentially recategorizes the selected Metric Value based on a specific field. When creating a Zap for a Standard Metric, we do not select a Title.

From the  **Date/ Timestamp** drop-down list, we'll select the  **Date** column from our Google Sheet. After confirming that each row is unique, we'll click  **Continue**.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_11.404f33bff17ac86667275f908b678705dfa4aa97b255351fa5ec031e51ced946.4783b0ec.gif)

1. We can now send test data to Databox to confirm everything is working as expected


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_12.96b84ad4efd7ebb830de3e4827d53dc0570d1c0da9d7c5b062415e0e4058d63b.4783b0ec.gif)

1. Click  **Finish** to complete the Zap


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_13.9502ba97b4f472a569d80e6b3b73662a2f9571b93e32633d1dee05d937428aaf.4783b0ec.gif)

1. Enter a name for the Zap. We'll name our Zap **Q1 Sales: Closed Won Amount.**Click the toggle to turn the Zap on.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_14.d35a44e4ca34a27a19ed860075877a88ef3900c1d718496b91a72fd20afb053d.4783b0ec.gif)

1. Finally, we must trigger the Zap so the Action is performed. We can do this by adding the rows from our duplicated Worksheet back to our original Worksheet.


Copy all rows with data into the original Worksheet, including the first row with data (row 2). In your Google Sheet, the entries in rows 2 and 3 will be identical. Only row 3 will be synced with Databox, since row 2 was used while creating the Zap for testing purposes.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_15.3b6effefca8eb951f416f1c726a4d135e5e02b2b95ced6b2ca252f0808e5bc10.4783b0ec.gif)

## How to create a Zap for a Dimensional Metric

In our example, we will create a Zap to access data from our Google Sheet to track  **Closed Won Amount by Deal Name**.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_16.8e7c0c405f42f06878427198b0ef29205e9df346e3bb15d6e02cc5c8dc861016.4783b0ec.png)

Each unique Metric that we want to sync with Databox will need to be accessed through a different Zap. Once we have one Zap built, we can duplicate it and make minimal changes to update it to sync different data from the Google Sheet.

To start, we want to create a Zap that syncs "Closed Won Amount by Deal Name" from our Google Sheet to Databox.

1. When creating new Zaps, our Google Sheet must be formatted in a specific way. To start, we can only have the first two rows of the Sheet populated.
To ensure we don't lose any data that is already on our Sheet, we'll copy the original Worksheet and store the duplicated version for future use. Now we can delete all entries below row 2 from our original Worksheet and create our first Zap.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_17.134095b52b1c76c70a097034edc7ed836bcd0f6edd062b82b01c6899317e0599.4783b0ec.gif)

**2.** Navigate to your **Home**page in Zapier. Click the orange **Make a Zap!** button

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_18.9021c4812b5f1dc1050701f397e9624712f1b7dec5b1dd4a1b8501efe758bfde.4783b0ec.gif)

1. Select **Google Sheets** as the **Trigger App.** ![](/assets/how-to-use-zapier-to-sync-google-sheets-data_19.691d39df08e0bde49006494deb79838a63d3fc1f260f636f10a09f7d6d621797.4783b0ec.gif)


Select a **Trigger** from Google Sheets. The trigger determines what will initiate a data sync with Databox.

- New Spreadsheet Row: The trigger will be initiated when a new row is added to your Google Sheet.
- New or Updated Spreadsheet Row: The trigger will be initiated when a new row is added or an existing row is updated in your Google Sheet.


For our example, we'll select **New or Updated Spreadsheet Row** as the **Trigger**. This gives us more flexibility and ensures that any changes made to our Google Sheet will be reflected in Databox.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_20.2cd3ff7f6aa07ebdf36e50ed42e3b68f04780d76d3d023e5dfc404fbb67f535a.4783b0ec.gif)

1. Here we must select a Google Sheets Account. If you don't have Google Sheets connected, click  **Create an Account**. This will open a window where you can select the Google Sheets Account that you want to sync data from.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_21.067b9848cae5831b6226d2992f2f990f35ffd4867cc632838ca855cf8e9790f1.4783b0ec.gif)

1. Next, we have to tell Zapier exactly which Google Sheet, Worksheet, and Trigger Column to sync data from.


For our example, we'll choose **Q1 Sales** **Data** as the **Google Sheet**, **Q1 Sales** as the **Worksheet**, and **Deal Amounts** as the **Trigger** **Column**

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_22.12e6c4afef24cb4052bba84502e42ac4d8f6566d1c16586509a1d11f87876ead.4783b0ec.gif)

1. It's best practice to test our current setup. When we click on the drop-down arrow, we can validate that we're seeing data from the correct cell in our Google Sheet.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_23.e4fbd5fa3efec63270cd27b431e500d673bb837d76f42f9725cbc17b32ee75a3.4783b0ec.gif)

1. We now have to define the Action that will happen as a result of the Trigger. To start, we'll select **Databox** as the **Action App**


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_9.adaec879939ea6516673b5011017c63b6ec3741798854777c6c038ae070fc339.4783b0ec.gif)

1. We must select a  **Databox Action**. Databox Actions define how the data is tracked.


- Increase Counter: Every Action that is triggered in a Zap will count as 1 event. This means that Databox will increment the current value by 1 each time the Zap is triggered.
- Push Custom Data: Every Action that is triggered in a zap will sync as custom data with Databox.


We want to track the specific Deal Amounts that are entered in our Google Sheet, so increasing a counter will not be sufficient for our use case. Instead, we'll select  **Push Custom Data**so the Deal Amounts are synced with Databox.

1. Here we must select a Databox Account. If you don't have Databox connected, click  **Create an Account**. This will open a window where you can enter the push token that was generated for Zapier in Databox.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_10.097697fe6b1e6aa6b88d8bc6dc4199f47e87933cfe5770dfd49f6e5df2501e7d.4783b0ec.gif)

1. Rather than pushing custom data to a Metric that already exists in our Databox Account, we want to create a completely new Zapier Metric to track this data.


To do that, we'll select  **Use a custom value (advanced)**from the **Metric** drop-down list. This will reveal another field called  **Custom Value for Metric ID**. This is where we'll enter the name for our Metric. This is the Metric name that we'll select in the Designer in Databox.

For our example, we'll enter  **Closed Won Amount by Deal Name**as the Custom Value for Metric ID.

On the same page, we'll select **Deal Amount** from the **Value** drop-down list.

"Titles" are the same as "Dimensions," and essentially recategorize the selected Metric Value based on a specific field. For Dimensional Metrics, we must select a Title.

For our example, we want to split up Closed Won Amounts based on the Deal Name. So, we will select **Deal Name** from the **Title**drop-down list.

From the **Date/ Timestamp** drop-down list, we'll select the  **Date** column from our Google Sheet. After confirming that each row is unique, we'll click **Continue.**

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_11.404f33bff17ac86667275f908b678705dfa4aa97b255351fa5ec031e51ced946.4783b0ec.gif)

1. We can now send test data to Databox to confirm everything is working as expected.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_24.10f5288031f2e16ad27d8b24781e2f694bdfb6b0920e4ada72dc4b8f859d7e63.4783b0ec.gif)

1. Click  **Finish** to complete the Zap.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_25.87cfb0f3ba0bd2519650b1d36f69586bd5d596c33048ef931ac49400cbc6978f.4783b0ec.gif)

1. Enter a name for the Zap. We'll name our Zap **Q1 Sales: Closed Won Amount by Deal Name.**Click the toggle to turn the Zap on.


![](/assets/how-to-use-zapier-to-sync-google-sheets-data_26.d9b7ac8e54ab222f9904e58038ff50cf665155a6ce1761dc789fc59ce3e78188.4783b0ec.gif)

1. Finally, we must trigger the Zap so the Action is performed. We can do this by adding the rows from our duplicated Worksheet back to our original Worksheet.


Copy all rows with data into the original Worksheet, including the first row with data (row 2). In your Google Sheet, the entries in rows 2 and 3 will be identical. Only row 3 will be synced with Databox, since row 2 was used while creating the Zap for testing purposes.

![](/assets/how-to-use-zapier-to-sync-google-sheets-data_15.3b6effefca8eb951f416f1c726a4d135e5e02b2b95ced6b2ca252f0808e5bc10.4783b0ec.gif)

## How to build a Databoard using Zapier data

Learn how to build a Databoard using Zapier data [here](/guide-using-zapier-with-databox).

## How to troubleshoot your Zaps

In this section, we'll walk through some of the most common cases that may arise as you use Zapier with Databox.

## "My Zap stopped running"

You can view a log of your data syncs in Zapier by navigating to the Task History Page. This can help identify where the issue lies.

If your Zap stops running, it may be because Zapier thinks it has reached the end of your Sheet. Check your Google Sheet to ensure there are no blank rows in your Sheet. Zapier recognizes blank rows as the end of the document and will not sync data from new rows.

## "I'm not seeing the correct Values in Databox"

If your Google Sheet has hundreds of rows that you're attempting to sync with Databox, it's possible that rows were not accounted for when the Zap was triggered. This is due to limitations in Zapier that prevent you from syncing too much data at once.

To resolve this, it's recommended that you sync smaller batches of data at a time (100 rows max).

## "I need to make updates"

If you are trying to delete or rename existing entries in your Google Sheet, it's recommended that you first turn off your Zap. You can turn it back on after the changes are made.

If you are trying to make changes to the Zap itself, it's recommended that you duplicate the existing Zap and make the changes to the copied version. You will need to follow the standard configuration process of removing rows from your Google Sheet, customizing the Zap, etc.