---
title: Setting Up Google Sheets Integration
description: Connect your Google Sheets to automatically populate Marq templates
---

[Skip to content](https://help.marq.com/setting-up-google-sheets-integration#main-content)

English

Show submenu for translations

<https://help.marq.com/kb-tickets/new?hsLang=en>

![marq.svg\]](https://help.marq.com/hubfs/Brand%20Logos/marq.svg)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- <https://help.marq.com/kb-tickets/new>
- [Projects](https://app.marq.com/documents#/documents)

[Projects](https://app.marq.com/documents#/documents)

 How can we help?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.marq.com/?hsLang=en)
2. [Integrations](https://help.marq.com/integrations?hsLang=en)
3. [Data integrations](https://help.marq.com/integrations?hsLang=en#data-integrations)

# Setting Up Google Sheets Integration

## Connect your Google Sheets to automatically populate Marq templates

Google Sheets integration allows your templates to pull live data directly from your spreadsheets. When you update your sheet, your templates automatically reflect the changes.

#### Before You Start

### Requirements

- **Google account** with access to your spreadsheet
- **Sharing permissions** set to "Anyone with the link can view" (minimum)
- **Clean data format** with headers in the first row

### Preparation Checklist

- Remove empty rows and columns from your sheet
- Ensure column headers are clear and descriptive
- Test that your sheet opens in an incognito browser window
- Have a unique identifier column (like ID numbers or email addresses)

**Estimated setup time: 5 minutes**

---

#### Step-by-Step Setup

### 1. Access Data Sources

1. Open any document in Marq
2. Click the **"Data Automation"** tab in the left sidebar
3. Select **"Connect Data Source"**
4. Choose **"Google Sheets"** from the options

### 2. Authenticate with Google

1. Click **"Connect with Google"**
2. Sign in to your Google account
3. Grant Marq permission to access your sheets
4. You'll be redirected back to Marq automatically

> **Privacy Note:** You can revoke Marq's access anytime from your [Google Account settings](https://myaccount.google.com/permissions)

### 3. Select Your Spreadsheet

1. Browse your available Google Sheets
2. Use the search bar to find specific sheets quickly
3. Click on the sheet you want to connect
4. If your sheet has multiple tabs, select the specific worksheet

### 4. Configure Data Settings

#### Set Your Primary Key

- Choose a column with **unique values** for each row
- Good examples: Employee ID, Email Address, Product SKU
- Avoid using names or descriptions that might change

#### Review Column Mapping

- Marq automatically detects your column headers
- Rename any columns that need clearer labels
- Uncheck columns you don't need to reduce loading time

### 5. Test Your Connection

1. Click **"Preview Data"** to see the first few rows
2. Verify all data appears correctly formatted
3. Check that your primary key column shows unique values
4. Click **"Save Data Source"** and give it a descriptive name

---

#### Using Your Connected Data

### Insert Smart Fields

1. Click on any text box in your template
2. Select the **data icon** \] from the toolbar
3. Choose your Google Sheets data source
4. Pick the specific field you want to insert

### Navigate Between Records

- Use the **navigation drop-down arrows** in the Data panel
- Jump to specific records using the dropdown
- Search for records by typing in the search box

### Auto-Generate Multiple Templates

- Create personalized versions for each row of data
- Perfect for generating employee profiles, product sheets, or client materials
- Each generated template can be customized individually

---

#### Best Practices

### Data Organization

- **Keep headers simple:** Use "first\_name" instead of "First Name (Preferred)"
- **Consistent formatting:** Same date format, phone number style, etc.
- **No merged cells:** Keep your data in a simple table format

### Performance Tips

- **Limit data size:** Under 1,000 rows for optimal performance
- **Remove unused columns:** Only include data you'll actually use
- **Regular cleanup:** Archive old data to keep sheets responsive

### Sharing Settings

Your Google Sheet needs proper sharing permissions:

1. Open your Google Sheet
2. Click **"Share"** in the top-right corner
3. Set to **"Anyone with the link can view"** (minimum)
4. For team sheets, add specific Marq users with view access

---

#### Common Issues & Solutions

### "Can't Access Spreadsheet" Error

**Cause:** Sharing permissions are too restrictive **Solution:**

1. Check your sheet's sharing settings
2. Ensure "Anyone with the link can view" is enabled
3. Test by opening the sheet link in an incognito window

### Data Not Updating in Templates

**Cause:** Connection may need refreshing **Solution:**

1. Go to your Data Sources list
2. Click the refresh icon next to your Google Sheets connection
3. Wait 1-2 minutes for sync to complete

### Some Columns Missing

**Cause:** Empty headers or special characters in column names **Solution:**

1. Check that all columns have headers in row 1
2. Remove special characters from header names
3. Reconnect your data source

---

#### Advanced Features

### Multiple Worksheets

- Connect different worksheets from the same Google Sheets file
- Each worksheet becomes a separate data source in Marq
- Useful for organizing different types of data

### Real-Time Sync

- Changes in Google Sheets appear in Marq within minutes
- Perfect for live dashboards and frequently updated content
- No manual refresh needed

### Conditional Formatting

- Use Google Sheets conditional formatting for data validation
- Marq will respect text colors and basic formatting
- Bold and italic text styling carries over to templates

---

#### Security & Privacy

### What Marq Accesses

- **Read-only access** to your spreadsheet data
- **No editing capabilities** - we never modify your sheets
- **No personal files** - only sheets you specifically connect

### Data Protection

- All connections use **encrypted HTTPS**
- Your data stays in Google's servers - we only reference it
- Disconnect anytime with no impact on your original sheets

---

#### Next Steps

- **[Learn about smart field mapping →](https://help.marq.com/link-to-smart-fields-article?hsLang=en)**
- **[Explore data mapping best practices →](https://help.marq.com/link-to-best-practices-article?hsLang=en)**
- **[Set up CSV integration →](https://help.marq.com/link-to-csv-article?hsLang=en)**

---

**Still need help?** Contact our support team:

- **Live chat:** Available 9 AM - 6 PM EST
- **Email:** [support@marq.com](mailto:support@marq.com)
- **Include:** Screenshot of any error messages and your Google Sheets sharing link

- [Intro to Marq](https://help.marq.com/intro-to-marq?hsLang=en#main-content)

    - [Getting started](https://help.marq.com/intro-to-marq?hsLang=en#getting-started)
    - [Tips and tricks](https://help.marq.com/intro-to-marq?hsLang=en#tips-and-tricks)
    - [Common issues](https://help.marq.com/intro-to-marq?hsLang=en#common-issues)
    - [Get support](https://help.marq.com/intro-to-marq?hsLang=en#get-support)
    - [Other resources](https://help.marq.com/intro-to-marq?hsLang=en#other-resources)
- [Content AI](https://help.marq.com/content-ai?hsLang=en#main-content)

    - [AI Assistant](https://help.marq.com/content-ai?hsLang=en#ai-assistant)
    - [AI Marqet](https://help.marq.com/content-ai?hsLang=en#ai-marqet)
    - [Brand Guardian](https://help.marq.com/content-ai?hsLang=en#brand-guardian)
- [Account setup and billing](https://help.marq.com/account-setup-and-billing?hsLang=en#main-content)

    - [Account settings](https://help.marq.com/account-setup-and-billing?hsLang=en#account-settings)
    - [Storage](https://help.marq.com/account-setup-and-billing?hsLang=en#storage)
    - [Billing and plans](https://help.marq.com/account-setup-and-billing?hsLang=en#billing-and-plans)
    - [Privacy and security](https://help.marq.com/account-setup-and-billing?hsLang=en#privacy-and-security)
- [Creating your design](https://help.marq.com/creating-your-design?hsLang=en#main-content)

    - [The Editor](https://help.marq.com/creating-your-design?hsLang=en#the-editor)
    - [Document and page settings](https://help.marq.com/creating-your-design?hsLang=en#document-and-page-settings)
    - [Templates](https://help.marq.com/creating-your-design?hsLang=en#templates)
    - [Images](https://help.marq.com/creating-your-design?hsLang=en#images)
    - [Text](https://help.marq.com/creating-your-design?hsLang=en#text)
    - [Shapes and graphics](https://help.marq.com/creating-your-design?hsLang=en#shapes-and-graphics)
    - [Layers and objects](https://help.marq.com/creating-your-design?hsLang=en#layers-and-objects)
    - [Elements](https://help.marq.com/creating-your-design?hsLang=en#elements)
    - [Video and interactive objects](https://help.marq.com/creating-your-design?hsLang=en#video-and-interactive-objects)
    - [Tables](https://help.marq.com/creating-your-design?hsLang=en#tables)
    - [Locking](https://help.marq.com/creating-your-design?hsLang=en#locking)
    - [Uploading](https://help.marq.com/creating-your-design?hsLang=en#uploading)
    - [Automation and other advanced features](https://help.marq.com/creating-your-design?hsLang=en#automation-and-other-advanced-features)
- [Exporting and sharing](https://help.marq.com/exporting-and-sharing?hsLang=en#main-content)

    - [Collaborate](https://help.marq.com/exporting-and-sharing?hsLang=en#collaborate)
    - [Export to social media](https://help.marq.com/exporting-and-sharing?hsLang=en#export-to-social-media)
    - [Embedding](https://help.marq.com/exporting-and-sharing?hsLang=en#embedding)
    - [Publishing](https://help.marq.com/exporting-and-sharing?hsLang=en#publishing)
    - [Printing](https://help.marq.com/exporting-and-sharing?hsLang=en#printing)
    - [Downloading](https://help.marq.com/exporting-and-sharing?hsLang=en#downloading)
    - [GIFs](https://help.marq.com/exporting-and-sharing?hsLang=en#gifs)
- [Admin settings and team management](https://help.marq.com/admin-settings-and-team-management?hsLang=en#main-content)

    - [Managing your team](https://help.marq.com/admin-settings-and-team-management?hsLang=en#managing-your-team)
    - [Licensing and roles](https://help.marq.com/admin-settings-and-team-management?hsLang=en#licensing-and-roles)
    - [Brand assets](https://help.marq.com/admin-settings-and-team-management?hsLang=en#brand-assets)
    - [User experience and workflows](https://help.marq.com/admin-settings-and-team-management?hsLang=en#user-experience-and-workflows)
    - [Settings and configuration](https://help.marq.com/admin-settings-and-team-management?hsLang=en#settings-and-configuration)
    - [Implementation resources](https://help.marq.com/admin-settings-and-team-management?hsLang=en#implementation-resources)
- [Integrations](https://help.marq.com/integrations?hsLang=en#main-content)

    - [Printer integrations](https://help.marq.com/integrations?hsLang=en#printer-integrations)
    - [Data integrations](https://help.marq.com/integrations?hsLang=en#data-integrations)
    - [Custom integrations](https://help.marq.com/integrations?hsLang=en#custom-integrations)
    - [Security and sign-on integrations](https://help.marq.com/integrations?hsLang=en#security-and-sign-on-integrations)
    - [Email integrations](https://help.marq.com/integrations?hsLang=en#email-integrations)
    - [Productivity and analytics integrations](https://help.marq.com/integrations?hsLang=en#productivity-and-analytics-integrations)
    - [Workflow Integrations](https://help.marq.com/integrations?hsLang=en#workflow-integrations)
    - [Salesforce](https://help.marq.com/integrations?hsLang=en#salesforce)
    - [MediaValet](https://help.marq.com/integrations?hsLang=en#mediavalet)
- [Training videos](https://help.marq.com/training-videos?hsLang=en#main-content)

    - [View](https://help.marq.com/training-videos?hsLang=en#view)
- [Courses](https://help.marq.com/courses?hsLang=en#main-content)

    - [View](https://help.marq.com/courses?hsLang=en#view)
- [Tutorials and resources](https://help.marq.com/tutorials-and-resources?hsLang=en#main-content)

    - [View](https://help.marq.com/tutorials-and-resources?hsLang=en#view)
- [Design services](https://help.marq.com/design-services?hsLang=en#main-content)

    - [View](https://help.marq.com/design-services?hsLang=en#view)
- [Events](https://help.marq.com/events?hsLang=en#main-content)

    - [View](https://help.marq.com/events?hsLang=en#view)
- [Analytics](https://help.marq.com/analytics?hsLang=en#main-content)

    - [Account Setup](https://help.marq.com/analytics?hsLang=en#account-setup)
    - [Basic Analytics](https://help.marq.com/analytics?hsLang=en#basic-analytics)
    - [Advanced Analytics](https://help.marq.com/analytics?hsLang=en#advanced-analytics)
    - [Navigating Reports](https://help.marq.com/analytics?hsLang=en#navigating-reports)
    - [Glossary of Terms](https://help.marq.com/analytics?hsLang=en#glossary-of-terms)
- [App Marketplace](https://help.marq.com/app-marketplace?hsLang=en#main-content)

    - [Workflow Connectors](https://help.marq.com/app-marketplace?hsLang=en#workflow-connectors)
- [Campaigns](https://help.marq.com/campaigns?hsLang=en#main-content)

    - [Getting Started](https://help.marq.com/campaigns?hsLang=en#getting-started)
    - [Connect to Facebook](https://help.marq.com/campaigns?hsLang=en#connect-to-facebook)
    - [Industry](https://help.marq.com/campaigns?hsLang=en#industry)
    - [Objectives](https://help.marq.com/campaigns?hsLang=en#objectives)
    - [Analytics](https://help.marq.com/campaigns?hsLang=en#analytics)
- [Creator Studio](https://help.marq.com/creator-studio?hsLang=en#main-content)

    - [Getting Started](https://help.marq.com/creator-studio?hsLang=en#getting-started)
    - [Studio FAQ](https://help.marq.com/creator-studio?hsLang=en#studio-faq)
- [Templates](https://help.marq.com/templates?hsLang=en#main-content)

    - [Getting Started](https://help.marq.com/templates?hsLang=en#getting-started)
    - [Advanced Features](https://help.marq.com/templates?hsLang=en#advanced-features)
    - [Team Management](https://help.marq.com/templates?hsLang=en#team-management)
    - [Troubleshooting](https://help.marq.com/templates?hsLang=en#troubleshooting)
- [CRM Integrations](https://help.marq.com/crm-integrations?hsLang=en)
- [DAM Integrations](https://help.marq.com/dam-integrations?hsLang=en)
- [Marq 2026 Packaging Updates](https://help.marq.com/marq-2026-packaging-updates?hsLang=en)
- [AI Brand Creations](https://help.marq.com/ai-brand-creations?hsLang=en)

[![Chill listening crop-3](https://help.marq.com/hubfs/Brand%20Logos/marq.svg "Chill listening crop-3")](https://help.marq.com?hsLang=en)

<https://www.facebook.com/marqhq> <https://twitter.com/marq_hq> <https://www.youtube.com/marqhq> <https://www.linkedin.com/company/marqhq>

Copyright © 2026, Marq