1. Choose the connection type as Read from Google Sheets
2. Fill up the Shared Link with the URL of your feed file
3. How to get the Shared Link, please refer below
4. You can also 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 you are 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...
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.