Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Google Sheets Connector Stuck on Excecuting

(0) ShareShare
ReportReport
Posted on by

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

slow_google_connector.png

time_analysis.png

ezcrev_1-1687974560943.png

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics