📄 Google Sheets (Service Account) – Destination Setup in AudienceSync

🧠 Overview

⚠️ Important: Google Sheets is ideal for lightweight, non-critical syncs due to platform limitations.

📏 Google Sheets Limitations

🛑 Exceeding any of these may result in sync failures. For large datasets, consider alternate destinations.

✅ Prerequisites

• A Google Cloud Platform (GCP) account

• Access to Google Sheets (owner or editor)

• Admin access to configure Google APIs and Service Accounts

🔧 Destination Setup Steps

1. Create a Service Account

• Go to: Google Cloud Console → Service Accounts

• Choose an existing project or create a new one

• Click + Create Service Account
• Enter a name and description
• Click Create and Continue

• Assign the Editor role

• Click Done

2. Generate a Service Account Key

• Go to: API Console → Credentials

• Select the email of the service account

• Under the Keys tab:
• Click + Add Key → Create new key
• Choose JSON format
• Download the JSON key file

3. Enable the Google Sheets API

• Visit: API Console → Library

• Ensure the correct project is selected

• Search for and select Google Sheets API

• Click ENABLE

4. Grant Access to Your Spreadsheet

• If your sheet is shared via link, no action needed.

• Otherwise, share the spreadsheet with your service account’s email address (found in the JSON file).

5. Configure in AudienceSync

• In the Destinations section, click Add Destination

• Select Google Sheets

• Upload your Service Account JSON key

• Provide:
• Spreadsheet ID (from the Google Sheets URL)
• Worksheet name(s) (each becomes a stream)

📤 Output Behavior & Schema Notes

• Each worksheet = stream in AudienceSync

• All values are coerced to strings

• Nested data must be flattened before analysis

• Charts, images, and formulas are not supported