Articles on: Shopify

Setting Up Two-Way Sync Between Google Sheets and Shopify

To achieve two-way syncing between Google Sheets and Shopify, you must set up two separate feeds in Stock Sync. Each feed handles one direction of the sync.


Important: Choose the direction carefully. An Update Feed reads Google Sheets and writes to Shopify; an Export Feed reads Shopify and writes to Google Sheets. Running the wrong feed can overwrite correct quantities with outdated values from the other system.


1. Google Sheets → Shopify (Update Feed)

Use an Update Feed when you want your Google Sheets data to update Shopify inventory. This feed pulls values from your sheet and applies them to your store.


Configure the Update Feed


  1. Create an Update Feed and choose the standard Google Sheets connection method.
  2. Paste the Google Sheet URL, including the #gid for the tab when applicable.
  3. Share the sheet with stock-sync@appspot.gserviceaccount.com. Viewer permission is sufficient for importing data.
  4. Select the correct sheet tab and ensure its name matches the tab name exactly.
  5. In Matching Column (Step 2), map the Product Identifier to the exact column containing the SKU, Barcode, Variant ID, or other identifier used by the feed.
  6. Confirm the header-row and skipped-row settings, then map the inventory quantity column.


Key points:


  • Ensure the sheet header row is correct and skip the appropriate number of rows. For example, if your first row contains product data instead of column names, set Skip Rows to 1.
  • Trigger manually on the Free Plan, or schedule automation with a paid plan. Manual updates may take a few minutes to process depending on queue time.


2. Shopify → Google Sheets (Export Feed)

Use a Write to Google Sheets Export Feed when you want Shopify inventory changes (including sales) to update your Google Sheet.


Configure the Export Feed


  1. Create a separate Export Feed using Write to Google Sheets and point it to the same sheet if needed.
  2. Share the sheet with stock-sync@appspot.gserviceaccount.com as Editor permission so Stock Sync can write data.
  3. In Matching Column (Step 2), use a column index or letter (such as 1, 2, A, or B), rather than a column name.
  4. Set Create new line according to whether new products should be appended, and review Replace all is defined because enabling it clears the sheet before writing.


Key points:


  • This feed exports Shopify product or inventory data directly into your Google Sheet.
  1. In Source Host, paste the URL of the Google Sheet.
  2. Share the entire spreadsheet or the specific sheet tab with stock-sync@appspot.gserviceaccount.com and grant Editor access. View access is not sufficient because the feed must write to the sheet.
  3. In Step 2 > Matching Column, use a column index such as 1, 2, 3 or A, B, C. Column names are not supported for export feeds. Map the product identifier, such as SKU, as needed.
  4. Keep Create new line enabled so new products can be appended and existing products updated. Enable Replace all only if the sheet should be cleared before the export.
  5. Map the Shopify fields to the correct Google Sheet columns, such as SKU and Quantity, then run the feed to test it.
  6. To run it automatically, open Set automation, enable the schedule, and choose the required update frequency. Automation requires a paid plan; on the Free Plan, run the feed manually.


This feed exports Shopify product or inventory data directly into your Google Sheet. It must be created as a separate feed and pointed to the same Google Sheet if needed.


  • The two feeds cannot run at the exact same time. They must be scheduled at different intervals to avoid data conflicts.
  • Two-way syncing is therefore possible, but each direction runs independently.
  • Two-way sync does not support syncing multiple products that share the same SKU. Duplicate SKU inventory linking is not supported. For an Update Feed alone, enable Update duplicate products with the same product identifier under Matching Column (Step 2) to update all matching products; this option is not supported for two-way synchronization.
  • On the Free Plan, both feeds must be triggered manually; automation requires a paid plan.


How It Works Together


  • When inventory is changed in Google Sheets, the Update Feed sends it to Shopify.
  • When inventory changes in Shopify (such as after a sale), the Export Feed sends updated values back to the Google Sheet.


This setup provides two-way data flow between Google Sheets and Shopify as long as both feeds are configured and run separately.

Updated on: 21/08/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!