---
title: "How do I sync Google Sheets contacts with Sarbacane Contacts?"
description: "Automatically send the rows of a Google Sheets sheet to a Sarbacane list, with Zapier."
url: https://help.sarbacane.com/en/articles/329-how-do-i-sync-google-sheets-contacts-with-sarbacane-contacts
updated: 2026-11-19
language: en
alternates: [fr, es]
---

# How do I sync Google Sheets contacts with Sarbacane Contacts?

Automatically send the rows of a Google Sheets sheet to a Sarbacane list, with Zapier.

To automatically add the contacts from a Google Sheets sheet to a Sarbacane Contacts list, use Zapier. Each row added or changed in the sheet reaches your list within a few minutes, with no manual import. Setup takes thirteen steps: four in Sarbacane, nine in Zapier.

## Prerequisites

-   A Zapier account.
    
-   A Google account with access to the sheet.
    
-   A sheet whose first row contains the column names, including a column of email addresses.
    
-   Sarbacane Contacts, included with Sarbacane Campaigns, with a Premium subscription or higher to create an API key.
    
-   The Sarbacane contact list that will receive the rows, already created.
    

## Steps

1.  In the left menu of Sarbacane Contacts, click **Settings**, then **API & Webhooks**.
    
2.  In the **API** tab, write down the **Account ID** shown at the top of the page.
    
3.  On the **Add a new API key** line, click **Create**.
    
4.  In **Description**, enter “Zapier”, then click **Save**. Copy the key that appears in the list.
    
5.  Open [the Zapier page for Google Sheets and Sarbacane](https://zapier.com/apps/google-sheets/integrations/sarbacane). The Google Sheets connector in Sarbacane Contacts also leads to this page.
    
6.  Log in to your Zapier account.
    
7.  As the trigger, choose Google Sheets, then the **New or Updated Spreadsheet Row** event. It covers both added and changed rows.
    
8.  Connect your Google account, then choose the file in **Spreadsheet** and the tab in **Worksheet**.
    
9.  Test the trigger: Zapier retrieves a sample row from your sheet.
    
10.  As the action, choose Sarbacane, then **Add Subscriber**.
     
11.  Connect your Sarbacane account with the Account ID and API key you noted in steps 2 and 4.
     
12.  Choose the destination list, then match each column of the sheet to the corresponding Sarbacane field (email, phone, last name, first name…).
     
13.  Test the action, then publish the Zap.
     

## Expected result

The test adds the sample row to your Sarbacane list. From then on, each row added or changed in the sheet reaches the list within a few minutes. If a row's email and phone match a contact already in the list, that contact is updated. Otherwise, a new contact is added.

**Note**: a row deleted from the sheet stays in your Sarbacane list.

**Best practice**: create one API key per tool, named after the tool. You can then delete it without cutting off your other connections.

## Troubleshooting

### A contact added to the sheet does not appear in my list

Check in this order: the Zap is published and turned on in Zapier, it watches the right file and the right tab, and the email column is matched to the Sarbacane email field. Then wait a few minutes, as Zapier does not send rows instantly.

### A changed contact appears twice in my list

A contact is only updated if both its email and its phone are identical. If either one has changed in the sheet, Sarbacane adds a new contact. Delete the old one from the list ([how to delete contacts](https://help.sarbacane.com/en/articles/444.md)).

### Zapier cannot connect to Sarbacane

Check the Account ID and API key copied in steps 2 and 4. If you restricted the key to certain IP addresses, remove that restriction or create an unrestricted key for Zapier.

### A contact deleted from the sheet is still in my list

This is expected: the sync never deletes anything. Delete the contact directly in Sarbacane ([how to delete contacts](https://help.sarbacane.com/en/articles/444.md)).

## Related articles

-   [How do I create an API key in Sarbacane Campaigns?](https://help.sarbacane.com/en/articles/448.md)
    
-   [How do I sync contacts with my CRM in Sarbacane Contacts?](https://help.sarbacane.com/en/articles/349.md)
    
-   [How do you export, duplicate or delete contacts in Sarbacane Contacts?](https://help.sarbacane.com/en/articles/444.md)
