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