Google sheet credentials (use same credentials for all sheets)

[Jbrunson09]

All,

Ive seen some topics regarding the google sheet connector and issues in regards to constantly needing to re input credentials.

What I'm trying to determine is if there is a way that I can use the same credentials for multiple sheets? Currently im trying to connect to 100 sheets and it keeps asking me to enter my credentials (presumably for each workbook) before conneting to the new sheet. Is there not a way to log in once and use the same credntials across all of the workbooks?

Thank you,

[danextian]

Hi @Jbrunson09 ,

I tried this myself  using a  Google Spreadsheet with links to multiple other worksheets. Although I was able to query each link as another spreadsheets, they did aske me to enter my credentials for each.  I would raise that as an idea. That or a Google Drive folder connectio -https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=ad6025a8-ee2a-ee11-a81c-6045bdc01a5d 

[Jbrunson09]

Thanks for the response danextian. I justed voted it up but yea, a connection to google drive folders would be great.