How to create Google Sheets and Adobe Campaign connection

  1. Overview
  2. How to
  3. How to create Google Sheets and Adobe Campaign connection

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

Prerequisites

Make sure you have the following:

  • Service Account JSON*

  • Adobe Campaign credentials:

    • Tenant ID

    • Client ID

    • Client Secret

Step 1: Create a New Connection

  1. Log in to the sysConnector.

  2. Click Create Connection.

image.png

If your app is missing, click Request Integration to notify the sysConnector team.

Step 2: Configure Google Sheets as the Source

Select Google Sheets

  1. Choose Google Sheets from the app list

  2. Click Next

image.png

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

image.png
How to Create Service Account JSON

1. Create a Google Cloud Project

  • Go to Google Cloud Console

  • Click Select Project → New Project

  • Enter a project name (e.g., Sheets Integration Project)

  • Click Create

2. Enable Google Sheets API

  • Go to APIs & Services → Library

  • Search for Google Sheets API

  • Click Enable

(Optional: Enable Google Drive API for file access)

3. Create a Service Account

  • Go to APIs & Services → Credentials

  • Click Create Credentials → Service Account

  • Enter Name: Sheets Connector Account

  • Click Create and Continue

  • Skip optional roles → Click Done

4. Generate Service Account JSON Key

  • Open the created Service Account

  • Go to Keys tab

  • Click Add Key → Create New Key

  • Select JSON

  • Click Create

A JSON file will automatically download. This is your Service Account JSON. Keep this file secure and use it in sysConnector

Select Spreadsheet and Worksheet

  1. Enter the Spreadsheet ID

  2. Click Load Sheets

  3. Select the Worksheet (tab) containing your data

  4. Click Next

image.png

Important Note

Make sure your Google Sheet is shared with the email indicated in the Service Account JSON (client_email).
Without this, sysConnector will not be able to access your sheet.

Step 3: Configure Adobe Campaign as the Destination

  • Select Adobe Campaign as the Destination App.

image.png

  1. Enter a Destination Account Name
    Example: Adobe Campaign Client Staging or Adobe Prod.

  2. Enter required credentials:

    • Tenant ID

    • Client ID

    • Client Secret

  3. Click Connect to Adobe Campaign Standard to verify access.

image.png

Step 4: Define Connection Settings

  1. Connection Name
    Use a clear, descriptive name such as:
    Google Sheet Contacts 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.

image.png

Projects act like folders inside sysConnector.

  • Select an existing Project, or

  • Leave it as Unassigned if no structure exists yet

This is especially useful for:

  • Separating marketing vs sales workflows

  • Organizing by region or business unit

  • Controlling user access permissions

Step 5: Field Mapping and Data Transformation

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

5.1 Basic Field Mapping

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

Process:

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

  • Map it to the corresponding Adobe Campaign field on the right.

Example:

  • Google Sheet field Name → Adobe Campaign field First Name

  • Google Sheet field Email → Adobe Campaign field Email

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

image.png

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 Adobe Campaign 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.

image.png

5.3 Custom Transformations (Merging and Formatting)

Custom transformations allow you to manipulate or enhance data before it reaches Adobe Campaign, 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 Adobe Campaign 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 Adobe Campaign (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.

image.png

5.4 Data Type Conversion

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

Example:

  • Google Sheet sends a value as Text

  • Adobe Campaign requires an Integer

How sysConnector Handles This:

  • During testing, sysConnector automatically detects mismatched data types.

  • Since Adobe Campaign 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.

image.png

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 Adobe Campaign and confirm the test record appears correctly.

Activation is blocked until testing passes.

image.png

Step 6: Testing and Activation

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

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

  3. Click Save and Activate to begin live syncing.

image.png

Managing Your Connection

Monitoring

Go to Reports to view:

  • Successful lead transfers

  • Failed sync attempts

  • Logs from the last 24 hours to 30 days

image.png

Was this article helpful?