1. Choose the connection type as Read from Google Sheets
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 a comma. It's also supported as a sheet index, you can write it as 0,1,2,3...
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.