Articles on: Shopify

Google Sheet connection method

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


  1. 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.


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


  1. 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 editor permission without changing the file to be accessed by anyone with a link.



  1. 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.



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


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


Updated on: 31/03/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!