How to create Google Sheets and Brevo connection

This guide walks you through the complete process of connecting Google Sheets (Source) to Brevo (Destination) using the sysConnector platform. Once configured, data from Google Sheets will sync automatically into Brevo.

Step 1: Create a New Connection

1. Log in to the sysConnector.

2. Click Create Connection.

Step 2: Configure Google Sheets as the Source

Select Google Sheets

1. Choose Google Sheets from the app list

2. Click Next

Upload Service Account JSON

1. Enter an Account Name

   • Example: Google Sheets Marketing Data

2. Paste the Service Account JSON file you downloaded earlier

3. Click Connect to Google Sheets

4. Once the connection is successful, click Next

Select Spreadsheet and Worksheet

1. Enter the Spreadsheet ID

2. Click Load Sheets

3. Select the Worksheet (tab) containing your data

4. Click Next

Step 3: Configure Brevo as the Destination

• Select Brevo as the Destination App.

1. Enter a Destination Account Name
   Example: Brevo Marketing or Brevo CRM Prod.

2. Enter required credentials:

   • API Key

3. Click Connect to Brevo to verify access.

Step 4: Define Connection Settings

1. Connection Name
   Use a clear, descriptive name such as:
   Google Sheet Leads 2026

2. Project Selection
   Choose an existing Project (folder) or use Unassigned.

3. Sync Frequency
   Select Event Space to enable real-time syncing when a lead is submitted.

Step 5: Field Mapping and Data Transformation

This step defines exactly how data collected in Google Sheet is translated, formatted, and delivered into Brevo. Proper configuration here ensures clean data, accurate reporting, and successful automation.

5.1 Basic Field Mapping

This section establishes a direct relationship between Google Sheet fields (source) and Brevo fields (destination).

Process:

• For each data point, select the Google Sheet field on the left.

• Map it to the corresponding Brevo field on the right.

Example:

• Google Sheet field Name → Brevo field First Name

• Google Sheet field Email → Brevo Email

If a required Brevo field is not mapped, records may fail to sync or be rejected.

5.2 Using Custom Text

The Custom Text feature allows you to send a fixed value that does not exist in the Google Sheet itself.

Common Use Case:

• Create a field in Brevo called Lead Source

• Use Custom Text to automatically populate it with Google Sheet for every lead coming through this connection

This is especially useful for campaign tracking, reporting, and segmentation.

5.3 Custom Transformations (Merging and Formatting)

Custom transformations allow you to manipulate or enhance data before it reaches Brevo, which is useful when the data structures between systems do not align perfectly.

Merge Fields

• You can select multiple Google Sheet fields and combine them into a single Brevo field.

• You may apply a divider (comma, dash, pipe, etc.) between values for readability.

Example:
If your Google Sheet contains separate columns for First Name and Last Name, you can merge them into a single Full Name field in Brevo (e.g., John Doe).

Prefix and Postfix

You can add text before (prefix) or after (postfix) a value.

Example:

• Prefix: GS-

• Result: GS-john.doe@email.co

This is useful for tagging, internal labeling, or adding context to incoming data.

5.4 Data Type Conversion

In some cases, Google Sheet sends data in a format that does not match the required data type in Brevo.

Example:

• Google Sheet sends a value as Text

• Brevo requires an Integer

How sysConnector Handles This:

• During testing, sysConnector automatically detects mismatched data types.

• Since Brevo field types are fixed, you must adjust the Source Type in sysConnector to match the destination field.

This ensures records are accepted and processed correctly.

5.5 Mandatory Testing and Validation

Before a connection can be activated, mapping must be tested successfully.

Process:

1. Enter sample test data for every mapped field.

2. Click Test Mapping.

3. The system validates formatting (e.g., email fields must contain valid email formats).

4. After a successful test, log in to Brevo and confirm the test record appears correctly.

Activation is blocked until testing passes.

Step 6: Testing and Activation

1. Enter sample test data and click Test Mapping.
   This step is mandatory before activation.

2. Log in to Brevo and confirm the test data was received correctly.

3. Click Save and Activate to begin live syncing.

Managing Your Connection

Monitoring

Go to Reports to view:

• Successful lead transfers

• Failed sync attempts

• Logs from the last 24 hours to 30 days