How to provide credentials to Google Sheet connector in Logic Apps

Question

Hi,

We're trying to automate ingestion of data from Google sheets. We created a workflow and used the Google Sheet connector. The connection was established during the design time, but we don't know where that information is stored. Is there a way to provide the credentials at run time so we can rotate the password as per the company security policy?

Thanks,

Ljubo

Answer 1

Hello @Ljubo Jurkovic - Thanks for reaching out & posting on the MS Q&A! The connection you created during design time, known as API Connection, is a separate Azure resource definition apart from your Logic Apps resource. Upon creation, they are encrypted and stored in a secure managed Azure environment and are only accessible by your client Logic Apps. Once you've gone through the OAuth flow and granted necessary permission and created the API Connection resource, Logic Apps will automatically refresh the underlying access token upon expiration, provided that the other service, which in your case is Google Sheets, allows such a mechanism. For more info, please review: Connection creation, configuration, and authentication As for your second question:

Is there a way to provide the credentials at run time so we can rotate the password as per the company security policy?

It isn't possible to create the API Connection resource during runtime at this time. This is actually one of the most-sought features for Logic Apps and there are quite a bit of feature request submissions on it: https://feedback.azure.com/d365community/search/cb47c115-7926-ec11-b6e6-000d3a4f032c?q=dynamic+connection I hope this helps, please let me know if you have any further questions.