Articles on: Shopify

Google Sheet connection method

For the Google Sheets connection method, follow the steps outlined below.

Choose the connection type as Google Sheets.

To connect multiple Google Sheets, each sheet must have identical column headers in the same order. Stock Sync does not support multiple sheets with different column names.

Fill out the Shared Link with the URL of your feed file.

How to get the link, please refer below

Use the link end with #gid for the current sheet https://docs.google.com/spreadsheets/d/14foqrEPqyHjbctDNyI/edit#gid=1443929246

Please add stock-sync@appspot.gserviceaccount.com with Viewer permission for import/update feeds. Stock Sync only requires viewer access to retrieve data and will never edit the sheet. For Export feeds, however, the service account must be granted Editor permission so Stock Sync can write data into the sheet.

Select the sheet(s) corresponding to your data. Ensure all selected sheets share the same column names and order as Sheet1 for accurate data processing.

If your sheet name consists of a wildcard or any specific date, you can only input the sheet name.

In the File Setting section, there is an option to skip specific feed rows. You can indicate which feed rows to skip.

The first row is the header, enable it when the feed's first row has a header.

Troubleshooting

If you see errors such as "Can't load sheets from this file" or the feed not loading values, double‑check that the sheet name you selected matches exactly with the tab name in Google Sheets.
Ensure the file is explicitly shared with stock-sync@appspot.gserviceaccount.com. Some cases require Editor permission instead of Viewer. Sharing the file only as "Anyone with the link (Read)" may still cause loading issues.
If the file was uploaded or converted, try using "Save as Google Sheets" to ensure it is in native Google Sheets format.
If the sheet was working before but suddenly stopped, re‑verify that the share settings have not changed and that the correct sheet name is still selected.

Updated on: 08/07/2026

Was this article helpful?

Thank you!