I'm facing an issue with Google Sheets resources where the dropdown to select a spreadsheet shows "No Data"
The resource is configured with a GCP service account and this service account is added as editor on the multiple spreadsheets. It doesn't seem to produce any logs which makes it hard to troubleshoot.
This sounds like it could be a permissions error with your service account. Here are a few debugging approaches:
One way to help identify if that is the cause is to try running other action types and see if you're getting similar behavior. For example, can you create a spreadsheet with this resource?
When you run the query, what does the output look like? You may get a more helpful error message there.
If you click fx, then type in the name of your spreadsheet and run the query, what does your output look like?