Google Sheets
Choose the connection type as Google Sheets.
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 for anything other than Sheet 1. Or you can also choose multiple Sheets separated by a comma. 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 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.
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 for anything other than Sheet 1. Or you can also choose multiple Sheets separated by a comma. 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 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: 12/12/2024
Thank you!