This topic was automatically generated from Slack. You can find the original thread here.
The Spreadsheet selector in the Google Sheets integration is currently broken for me. It is only showing 3 spreadsheets that I haven’t updated in months, and clicking load more does not retrieve any new data.
Are you using a pre-built trigger or action? If so, can you try first refreshing the page then reconnecting your Google Sheets account?
I just checked on my end and I’m not having any issues listing Sheets in my account
hey – apologies, the issue seems to be that there’s no way to add spreadsheets from a shared drive. I’ve been using a shared drive for all of my projects, and the Google Sheets integration is only showing sheets on my personal drive
Which trigger or action are you using?
Add Multiple Rows on google sheets
Do you see the optional
Drive prop? It defaults to
My Drive but you should be able to select that, then select a Shared Drive that you have access to
Compliance here are Shared Drives
So if I select one of them, then the Spreadsheets that are listed via
async options() are from that drive
Ahh thank you very much! What a newbie mistake on my part.
No problem! If it wasn’t obvious to you, you’re likely not alone.