How to Sync Shopify Metafields to Google Sheets using FlexSync 

The FlexSync app makes it easy to sync Shopify metafields to Google Sheets, allowing you to manage complex product data without leaving your spreadsheet. 

This documentation explains how to set up and sync custom metafields with bi-directional updates, so any changes you make in Shopify or Google Sheets will automatically update in both places.

Configuring FlexSync for Metafield Sync #

Once metafields are defined and populated, simply include them in FlexSync for sync.

Steps: #

1. Navigate to the FlexSync Dashboard and click Edit Columns to continue.

2. Navigate to Column Settings
3. Locate the list of available fields
4. Identify your metafields (typically labeled with namespace.key)
5. Check/select the metafields you want to sync
6. Save & sync

Syncing Data to Google Sheets #

After configuration:

• FlexSync will automatically include selected metafields in the next sync cycle
• Data will appear as columns in your connected Google Sheet
• Each metafield maps to a dedicated column

Supported Metafield Types for Sync #

When configuring metafields in your Shopify store for syncing with Google Sheets via FlexSync, the following field types are supported:

Text Types #

• Text
• Multi-line text
• Single line text
• Email (Single line text)
• URL

Numeric Types #

• Number
• Integer
• Decimal
• ID
• Money

Measurement Types #

• Measurements (support may vary depending on unit type configuration)

Date & Time Types #

• Date
• Date and time

Other Types #

• True or false (Boolean)
• Color

How to Create Metafields in Shopify #

If you need to sync data that doesn’t exist in Shopify yet, you must first define the metafield within the Shopify Admin. 

To define metafields:

1. Navigate to Shopify Admin
2. Click Settings (bottom-left corner)
3. Select Metafields and Metaobjects from the menubar

4. Choose the relevant resource:
   • Products → for product-level metafields
   • Variants → for variant-level metafields
5. Click Add Definition

Configuration Fields #

When creating a metafield definition, provide:

• Name: Human-readable label (e.g., “Material Type”)
• Namespace and Key: Auto-generated or custom identifier
• Type: Data type (critical for compatibility)

Click Save once configured.

Adding Metafield Values to Products or Variants #

After defining metafields:

1. Go to Products in Shopify Admin
2. Open a specific product
3. Scroll to the Metafields section
4. Enter values for the newly created fields
5. Save changes

Repeat for variants if applicable.

Notes #

• Some measurement-based metafields may have limited support depending on Shopify configuration.
• Always ensure metafield definitions match supported types to avoid sync issues.
• Unsupported or complex reference types may not sync correctly to Google Sheets.