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.
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.
In the left menu of Sarbacane Contacts, click Settings, then API & Webhooks.
In the API tab, write down the Account ID shown at the top of the page.
On the Add a new API key line, click Create.
In Description, enter “Zapier”, then click Save. Copy the key that appears in the list.
Open the Zapier page for Google Sheets and Sarbacane. The Google Sheets connector in Sarbacane Contacts also leads to this page.
Log in to your Zapier account.
As the trigger, choose Google Sheets, then the New or Updated Spreadsheet Row event. It covers both added and changed rows.
Connect your Google account, then choose the file in Spreadsheet and the tab in Worksheet.
Test the trigger: Zapier retrieves a sample row from your sheet.
As the action, choose Sarbacane, then Add Subscriber.
Connect your Sarbacane account with the Account ID and API key you noted in steps 2 and 4.
Choose the destination list, then match each column of the sheet to the corresponding Sarbacane field (email, phone, last name, first name…).
Test the action, then publish the Zap.
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.
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 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).
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.
This is expected: the sync never deletes anything. Delete the contact directly in Sarbacane (how to delete contacts).