--- title: Data Automation Troubleshooting Guide description: Quick solutions to common data connection issues --- [Skip to content](https://help.marq.com/data-automation-troubleshooting-guide#main-content) English Show submenu for translations ![marq.svg\]](https://help.marq.com/hubfs/Brand%20Logos/marq.svg) Open main navigation Close main navigation - English Show submenu for translations - - [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) # Data Automation Troubleshooting Guide ## Quick solutions to common data connection issues #### Quick Diagnostics ### Is Your Issue Here? - **[Data not appearing in templates](https://help.marq.com/data-automation-troubleshooting-guide#data-not-appearing)** - **[Images not loading](https://help.marq.com/data-automation-troubleshooting-guide#images-not-loading)** - **[Connection keeps dropping](https://help.marq.com/data-automation-troubleshooting-guide#connection-drops)** - **[Only partial data syncing](https://help.marq.com/data-automation-troubleshooting-guide#partial-data-sync)** - **[Primary key errors](https://help.marq.com/data-automation-troubleshooting-guide#primary-key-issues)** - **[Performance problems](https://help.marq.com/data-automation-troubleshooting-guide#performance-issues)** --- #### Data Not Appearing {#data-not-appearing} ### Symptom Smart fields show placeholder text or are completely blank in your templates. ### Most Common Causes #### 1. Column Header Mismatch **Problem:** Your data source column names don't exactly match your smart field names. **Solution:** 1. Go to your **Data Sources** tab 2. Check the exact spelling of your column headers 3. In your template, ensure smart fields match exactly (including capitalization) 4. **Example:** If your column is "first\_name", your smart field must be exactly "first\_name", not "First Name" #### 2. Primary Key Not Set **Problem:** No unique identifier selected for your data rows. **Solution:** 1. Edit your data source settings 2. Choose a column with unique values (ID numbers, email addresses, etc.) 3. Ensure every row has a value in this column 4. **Avoid:** Using names or descriptions that might duplicate #### 3. Data Source Connection Expired **Problem:** Authentication has expired (common with Google Sheets). **Solution:** 1. Go to **Data Sources** 2. Look for warning icons next to your connections 3. Click **"Reconnect"** and re-authenticate 4. Test with a simple template to verify the fix ### Quick Test Create a new text box, insert a smart field, and check if any data appears. If nothing shows up, the issue is with your data connection, not your template. --- #### Images Not Loading {#images-not-loading} ### Symptom Image placeholders appear but actual images don't load in templates. ### Common Causes & Solutions #### 1. Private or Protected URLs **Problem:** Image URLs require login or special permissions to access. **Solution:** 1. **Test your URLs:** Open each image URL in an incognito browser window 2. **Make images public:** Change sharing settings to "Anyone with the link can view" 3. **Use direct links:** Link to image files (.jpg, .png) not gallery pages 4. **Example:** Use `https://drive.google.com/uc?id=FILE_ID` for Google Drive images #### 2. Incorrect URL Format **Problem:** URLs point to web pages instead of image files. **Solution:** 1. **Right-click images** and select "Copy image address" 2. **Use direct file URLs** ending in .jpg, .png, .gif, or .svg 3. **Test format:** Paste URL in browser - you should see only the image, not a webpage #### 3. Large File Sizes **Problem:** Images are too large to load quickly. **Solution:** 1. **Optimize images:** Keep under 2MB each for best performance 2. **Use web formats:** JPG for photos, PNG for graphics with transparency 3. **Compress images:** Use tools like TinyPNG or built-in image compression #### 4. Broken or Moved Links **Problem:** Image files have been deleted or moved. **Solution:** 1. **Check each URL individually** 2. **Update broken links** in your data source 3. **Use stable hosting:** Avoid temporary file sharing links --- #### Connection Keeps Dropping {#connection-drops} ### Symptom Data source works initially but stops syncing or shows connection errors. ### For Google Sheets Connections #### Re-authenticate Your Account 1. Go to **Data Sources** 2. Find your Google Sheets connection 3. Click **"Reconnect"** 4. Sign in again and grant permissions 5. Test the connection with a template #### Check Sharing Permissions 1. Open your Google Sheet 2. Click **"Share"** → **"Change to anyone with the link"** 3. Set permission to at least "Viewer" 4. Copy the new sharing link if it changed ### For CSV URL Connections #### Verify URL Accessibility 1. **Test URL:** Open in incognito browser - should download the CSV file 2. **Check hosting:** Ensure the hosting service is reliable 3. **Verify format:** URL should end with .csv or have proper headers #### Update Connection Settings 1. Re-enter the CSV URL in your data source 2. Test different update frequencies (try "Manual" first) 3. Check if your hosting provider changed access requirements --- #### Partial Data Sync {#partial-data-sync} ### Symptom Some data appears correctly, but other fields are blank or missing. ### Diagnosis Steps #### 1. Check All Required Fields **Problem:** Some template fields aren't mapped to data columns. **Solution:** 1. List all smart fields in your template 2. Verify each has a corresponding column in your data source 3. Map any unmapped fields in your data source settings #### 2. Verify Data Completeness **Problem:** Your source data has empty cells in important columns. **Solution:** 1. **Review your data:** Check for blank cells in critical columns 2. **Fill missing data:** Use "N/A" or appropriate defaults 3. **Identify patterns:** Are certain rows or columns consistently empty? #### 3. Primary Key Uniqueness **Problem:** Duplicate primary key values confuse the data sync. **Solution:** 1. **Check your primary key column** for duplicate values 2. **Choose a different column** if duplicates exist 3. **Clean your data:** Ensure each row has a unique identifier --- #### Primary Key Issues {#primary-key-issues} ### What is a Primary Key? A primary key is a column that uniquely identifies each row of data. It's essential for Marq to know which data belongs to which template. ### Common Primary Key Problems #### 1. Duplicate Values **Problem:** Multiple rows have the same primary key value. **Solution:** 1. **Identify duplicates:** Sort your data by the primary key column 2. **Choose a different column:** Use ID numbers, email addresses, or SKUs 3. **Create unique values:** Add row numbers or modify existing data #### 2. Empty Primary Key Cells **Problem:** Some rows don't have a value in the primary key column. **Solution:** 1. **Fill empty cells:** Add unique values for each row 2. **Remove incomplete rows:** Delete rows that can't have unique identifiers 3. **Use auto-numbering:** Add a simple ID column (1, 2, 3, etc.) #### 3. Primary Key Changes Over Time **Problem:** The values in your primary key column change when you update your data. **Solution:** 1. **Use stable identifiers:** Choose columns with values that never change 2. **Avoid names or descriptions:** These might be edited over time 3. **Create permanent IDs:** Add an ID column that never changes ### Best Primary Key Options - **Employee ID numbers** - **Email addresses** (if they don't change) - **Product SKUs** - **Account numbers** - **Auto-generated row IDs** --- #### Performance Issues {#performance-issues} ### Symptom Data loads slowly, templates take a long time to update, or the interface feels sluggish. ### Optimization Solutions #### 1. Reduce Data Size **Large datasets slow everything down.** **Solutions:** - **Limit rows:** Keep under 1,000 rows when possible - **Remove unused columns:** Only include data you actually use - **Archive old data:** Move historical data to separate files #### 2. Optimize Data Format **Clean, well-formatted data loads faster.** **Solutions:** - **Consistent formatting:** Same date format, number format, etc. - **Remove special characters:** Keep text simple and clean - **Standardize text length:** Very long text fields slow loading #### 3. Connection Settings **Adjust how often data syncs.** **Solutions:** - **Manual sync:** For data that doesn't change often - **Reduce sync frequency:** Daily instead of hourly - **Use CSV uploads:** For static data instead of live connections --- #### Getting More Help ### Before Contacting Support Try these quick fixes: 1. **Refresh your browser** and try again 2. **Test in incognito mode** to rule out browser issues 3. **Try a different template** to isolate the problem 4. **Check our status page** for any known issues ### When You Contact Support Include this information for faster resolution: **For All Issues:** - Description of what you were trying to do - Exact error message (screenshot if possible) - Data source type (Google Sheets, CSV, etc.) - Browser and operating system **For Google Sheets Issues:** - Sharing link to your Google Sheet - Number of rows and columns in your data **For CSV Issues:** - Sample of your CSV file (first 5-10 rows) - File size and number of rows - Where the CSV is hosted (if using URL method) **For Image Issues:** - Direct links to 2-3 problem images - Image file sizes and formats ### Contact Option - **Email:** [support@marq.com](mailto:support@marq.com) (response within 4 hours) --- #### Preventing Future Issues ### Data Source Maintenance - **Regular cleanup:** Remove old or unused data monthly - **Monitor connections:** Check data source status weekly - **Keep backups:** Save copies of important data sources - **Document changes:** Note when and why you modify data structures ### Template Best Practices - **Test with sample data** before rolling out to teams - **Use descriptive names** for data sources and smart fields - **Create template documentation** for team members - **Regular template audits** to ensure all data connections work --- #### Related Articles - **[Google Sheets Integration Setup →](https://help.marq.com/link-to-google-sheets-article?hsLang=en)** - **[CSV File Integration Setup →](https://help.marq.com/link-to-csv-article?hsLang=en)** - **[Data Mapping Best Practices →](https://help.marq.com/link-to-best-practices-article?hsLang=en)** - **[Smart Fields Guide →](https://help.marq.com/link-to-smart-fields-article?hsLang=en)** --- **Still stuck?** Our support team is here to help with personalized troubleshooting for your specific situation. - [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) Copyright © 2026, Marq