Google Sheets integration guide

Connect Google Sheets spreadsheets hosted on Google Drive to MyContentLab to synchronize custom KPI models, bespoke sales spreadsheets, and influencer campaign trackers on recurring background schedules.

Overview and key benefits

Google Sheets is the standard tool for custom marketing calculations. Integrating Google Sheets allows you to:

• Automated scheduled ingestion: Pull fresh rows from your client's Google Sheet on an hourly, daily, or weekly schedule without manual CSV exports.
• Dynamic range mapping: Specify sheet tabs, custom header rows, and cell coordinate ranges.
• Custom metric blending: Blend proprietary client spreadsheets directly alongside native Meta, TikTok, and Google Ads metrics in unified dashboards.

Prerequisites

1. An active MyContentLab client workspace.
2. A Google Account with Viewer or Editor access to the target Google Spreadsheet.

Step-by-step connection walkthrough

1. Open connections hub

1. In the client workspace, open Connections.
2. Click Connect on the Google Sheets card.

2. Authenticate and select sheet

1. Sign in with your Google Account and authorize read access to Google Drive and Google Sheets.
2. Paste the public or shared Google Sheet URL (or select from your Drive picker).

3. Configure mapping and schedule

1. Select the specific Worksheet Tab name.
2. Verify the Header Row (default row 1).
3. Map columns to standard metrics (Date, Impressions, Spend, Conversions, Revenue).
4. Set the Sync Cadence (Hourly, Daily at midnight, or Weekly).
5. Click Save & Start Synchronization.

Next steps

Related modules

• CSV import wizard - For one-time manual spreadsheet uploads.
• Airtable integration - Connect relational Airtable databases.