In my Power Automate flow, I'm using a Google connector that grabs rows every minute from a Google Sheets document and inserts them into a table in my Excel document. Google Forms is being used for the Google Sheets entry. The reason for this is because of external access limitations from Microsoft Forms within our company. I have a trigger that is set to run the flow every minute.
My issue is that occasionally the flow will get locked up on the "Get Rows (Google Sheets)" step. 4/5 times this step is performed within a second or two, as it should. However, sometimes it takes several minutes, sometimes ~20 to complete. I'm wondering why this is the case. If it is grabbing more rows than necessary, then this wouldn't explain why it completes quickly most of the time.
I have attached some screenshots for proof of the slow Google connector speed. The first one shows some successfully executed runs but with one being a 15-minute delay, the other is a time analysis of each step showing that the Get Rows step is dramatically slower than the other ones, and the third one is an overview of my flow.
Is this an issue with Google's API? Anyone else experiencing this problem? This is an issue for me because in order to gather the data submitted to the Google Sheets ASAP, it should be checking any changes made to the Google Sheet once every minute.
Let me know if anyone has any suggestions or questions.
Thanks!
Ethan