Google Sheet connection method
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 or layouts.
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 editor permission without changing the file to be accessed by anyone with a link.
Specify the sheet name if you're using anything other than "Sheet1". You may also provide multiple sheet names separated by commas. Please ensure that all specified sheets have the same column names and in the same order as in Sheet1. This is important to ensure accurate data mapping and 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.
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 or layouts.
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 editor permission without changing the file to be accessed by anyone with a link.
Specify the sheet name if you're using anything other than "Sheet1". You may also provide multiple sheet names separated by commas. Please ensure that all specified sheets have the same column names and in the same order as in Sheet1. This is important to ensure accurate data mapping and 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.
Updated on: 22/05/2025
Thank you!