I connected the resource but the dropdown list of sheets shows me a hodge podge of sheets, stuff that's been shared with my yesterday and years ago, but not the one sheet I want to display. I have access to it and it's not a permissions issue AFAICS
If you click the fx button and type in the spreadsheet id and run the query, do you get an error?
Are you authenticating with OAuth 2? Are you sharing credentials?
Does the list available spreadsheets endpoint have any other missing sheets?
If you need to connect this spreadsheet asap, you could try using the generic REST API integration with the Sheets API instead of our Google Sheets integration