Articles on: Shopify

Google Sheet connection method

Connect your Google Sheets spreadsheet to Stock Sync to automatically import, update, or export catalog and inventory data using private service account sharing or published links.


Available on: ✔️ Add | ✔️ Update | ✔️ Export



How to Set Up Google Sheets Connection


Go to App → Feed Settings → Connection Method


  1. Choose Connection Method: Select Google Sheets from the connection list.
  2. Enter Shared Link: Paste the URL of your Google Sheets document into the Shared Link field.
  3. Configure Sharing Access: Add stock-sync@appspot.gserviceaccount.com to your Google Sheet's sharing permissions, or use a published sheet link.
  4. Select Sheet Tabs: Choose the specific sheet tab(s) containing your product data.
  5. Adjust File Settings: Set header recognition and configure rows to skip if applicable.


Use a link ending with #gid= (for example, https://docs.google.com/spreadsheets/d/14foqrEPqyHjbctDNyI/edit#gid=1443929246) to point Stock Sync directly to the intended worksheet tab.



Google Sheets Smart Settings



Stock Sync supports both standard private Google Sheets links via service-account sharing and Google Sheets published web links.


Google Sheets are private by default. Pasting a private URL alone is not sufficient; you must explicitly share access with the Stock Sync service account.


Connection Method

Setup Requirement

Supported Operations

Standard Google Sheet Link

Paste your spreadsheet URL and grant access to the service account. Share with stock-sync@appspot.gserviceaccount.com

Import (Add), Update, Export

Google Sheet Published Link

Supported directly in this connection. If using a published sheet, ensure the sheet is published to the web (File → Share → Publish to web).

Import (Add), Update


2. Service Account Sharing Configuration


To allow Stock Sync to read or write to private sheets, assign permissions to our official service account:


  1. Open your document in Google Sheets.
  2. Click Share in the top-right corner.
  3. In the text field, add stock-sync@appspot.gserviceaccount.com.
  4. Set permission to Viewer for Add or Update feeds.
  5. Set permission to Editor if you are configuring an Export feed to write data back to Google Sheets.
  6. Uncheck Notify people and click Share.


Editor access is not required for reading or importing data. It is only required when configuring an Export feed that writes data back to Google Sheets.


Do not change the sheet sharing to "Anyone with the link". Sharing the file only as "Anyone with the link (Read)" may still trigger connection errors.


3. Multi-Sheet Selection & Tab Matching


You can import data from a single sheet or merge multiple sheets into a single feed.



To connect multiple Google Sheets tabs, every selected sheet must have identical column headers in the exact same order. Stock Sync cannot process multiple tabs with mismatched column names.


If there are mismatched column names across tabs, Stock Sync will only process the tabs with matching headers; any tabs with mismatched columns will be skipped and neglected during the sync.


If your sheet tab name consists of a wildcard or a dynamic date pattern, enter the sheet name manually in the input box.


4. File Settings & Row Skipping


Configure how Stock Sync parses rows from your sheet.



  • First row is header: Enable this option if row 1 of your spreadsheet contains column headers (e.g., SKU, Price, Quantity).
  • Skip rows: Specify any starting rows to ignore if your sheet contains introductory notes, banners, or metadata before the actual product records.



Key Rules & Technical Details


  • Permission Requirements: Feeds running Add or Update require Viewer permission. Feeds running Export require Editor permission.
  • Published Link Compatibility: Published links are supported directly in this connection. If selecting standard Google Sheets instead of Google Sheets Published prevents saving, verify service-account sharing and sheet-tab selection.
  • File Format: The file must be a native Google Sheet. If your file was uploaded from an .xlsx or .csv file, open it in Google Drive and select File → Save as Google Sheets.
  • Multi-Tab Header Uniformity: All selected worksheet tabs must share exact column headers and sequence. Mismatched tabs are ignored automatically, and only conforming tabs are synced.



Troubleshooting Steps


  • Issue: Error "Can't load sheets from this file" or blank feed values → Solution: Verify that the selected sheet name in Stock Sync matches the exact tab name in Google Sheets, including spacing and casing.
  • Issue: Connection fails when using a private sheet link → Solution: Confirm that stock-sync@appspot.gserviceaccount.com is added with Viewer permission (or Editor for Export feeds).
  • Issue: Certain sheet tab data is missing after syncing multiple tabs → Solution: Check that the missing tab's column names and ordering match the primary sheet tab exactly. Tabs with mismatched column names are skipped automatically.
  • Issue: Feed worked previously but suddenly stopped processing → Solution: Re-verify share settings, ensure the sheet still contains active product rows, and confirm the sheet tab was not renamed.
  • Issue: Saving fails when using standard Google Sheets instead of published links → Solution: Re-check service account permissions, verify the sheet tab selection, or switch to the published link method.



Good Articles to Continue


Updated on: 29/10/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!