cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mr-dang
Level 10

Google Sheets: limited call volume

 

The connector to Google Sheets has two significant limits:

  • It can only handle 500 records like Excel on OneDrive and DropBox
  • There is apparently a quota on how many calls to data you can do.

 2017-05-13 (2).png

 

I just discovered the second limitation now. To put into perspective how tiny the quota is, I have only been using Sheets in the capacity of editing and testing out a basic app--I have not even released any apps with Google Sheets connectors to my users for heavier volumes of access. The quota makes the connection a useless datasource.

Microsoft Employee
@8bitclassroom
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Google Sheets: limited call volume

Hi Brian,

 

Thanks for reporting this.

It seems there is no related documentation mentioned the Google Drive API quota usage.

People shared that using the Google API console, the quota limits could be noticed.

What is the limit on Google Drive API usage

For the 500 record limits, I think that should be related with the delegation, as Google Sheet currently is not marked as the delegation supported.

Would it be available to switch Data Source to SharePoint list?

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Google Sheets: limited call volume

Hi Brian,

 

Thanks for reporting this.

It seems there is no related documentation mentioned the Google Drive API quota usage.

People shared that using the Google API console, the quota limits could be noticed.

What is the limit on Google Drive API usage

For the 500 record limits, I think that should be related with the delegation, as Google Sheet currently is not marked as the delegation supported.

Would it be available to switch Data Source to SharePoint list?

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

mr-dang
Level 10

Re: Google Sheets: limited call volume

Thank you for that link. I definitely did not get close to the 1,000,000 hits. It is much more likely I was writing too much per second and hit the quota. It likely took place when I was testing bulk writing. I think Google Sheets may not be suitable for ForAll() operations.

 

I'm a CDS user, but my students have Google accounts and don't have O365, so Sheets is the only option for them. So as long as I'm not using it, it should be okay for us.

Microsoft Employee
@8bitclassroom
luuminhvuong93
Level: Powered On

Re: Google Sheets: limited call volume

@mr-dang Hi Brian,

What doesGoogle considered a hit?

so if my user navigate between screens with a gallery list that has a Google sheet as data sources, does the hit increase?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,134)