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 [email protected] 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 comma. Its also supported as sheet index, you can write it as 0,1,2,3...

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