Google Sheets

Modified on Thu, 25 May 2023 at 05:05 PM

1. Choose the connection type as Google Sheets.

2. Fill up the Shared Link with the URL of your feed file.

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

4. Please add stock-sync@appspot.gserviceaccount.com with editor permission without changing the file to be accessed by anyone with a link.

5. Specify the Sheet name if referring to anything other than Sheet 1. Or you can also choose multiple Sheets separated by a comma. It's also supported as a sheet index. You can write it as 0,1,2,3...

Kindly be informed that if you have multiple sheets, the column mapping should correspond to Sheet 1.

For example:

If your sheet name consists of a wildcard or any specific date, you can use it as a sheet index so that no need to change the name frequently. You can write it as 0 or 0,1,2,3.. because its support is separated by a comma.