How we connect Google Sheets
When establishing a connection with a new Google Sheets data source, we are actually connecting to a specific Google Spreadsheet. Specifically, we utilize this API endpoint filtered by Spreadsheet files to retrieve all the Spreadsheets that you have access to with the Google Account you have selected as your Credentials. It's important to note that a Spreadsheet is the primary object in Google Sheets and can contain multiple sheets within it.
If you want to use your Google Sheets data source within, for example, Connectors, you will be prompted to select the specific Sheet that the Connector should cover.