I am attempting to use a sheet from my google drive but it wont recognize the files within my drive. Meaning when I click on the icon and click continue nothing comes up. I have already made sure that permissions were added but nothing. any ideas how to fix this issue?
I had the same issue with a file which was register in XLSX instead of Googe Sheets format … After conversion it worked …
Is it your case ?
Could be, I haven’t tried converting to a sheet. I honestly dont know where i would start with that, but i will google it and see if i can’t convert it and then try again.
For example this one is an .xlsx (as mentionned in the green rectangle with the warning) and if I go in “File”, I have an option to “register in Google Sheets format”