• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Quota exceeded for quota metric

My workflow "PNL CS 建立新聯絡人 - Xero to Sheet"
I received the below task error message, what is the details about this?



Code:
{
    "error > code": 429,
    "error > message": "Quota exceeded for quota metric \u0027Write requests\u0027 and limit \u0027Write requests per minute per user\u0027 of service \u0027sheets.googleapis.com\u0027 for consumer \u0027project_number:1011300378975\u0027.",
    "error > status": "RESOURCE_EXHAUSTED",
    "error > details > 0 > @type": "type.googleapis.com/google.rpc.ErrorInfo",
    "error > details > 0 > reason": "RATE_LIMIT_EXCEEDED",
    "error > details > 0 > domain": "googleapis.com",
    "error > details > 0 > metadata > quota_limit": "WriteRequestsPerMinutePerUser",
    "error > details > 0 > metadata > service": "sheets.googleapis.com",
    "error > details > 0 > metadata > quota_limit_value": "60",
    "error > details > 0 > metadata > quota_location": "global",
    "error > details > 0 > metadata > quota_metric": "sheets.googleapis.com/write_requests",
    "error > details > 0 > metadata > consumer": "projects/1011300378975",
    "error > details > 1 > @type": "type.googleapis.com/google.rpc.Help",
    "error > details > 1 > links > 0 > description": "Request a higher quota limit.",
    "error > details > 1 > links > 0 > url": "https://cloud.google.com/docs/quota#requesting_higher_quota"
}
 

Supreme

Well-known member
Staff member
Code:
Code:
{
    "error > code": 429,
    "error > message": "Quota exceeded for quota metric \u0027Write requests\u0027 and limit \u0027Write requests per minute per user\u0027 of service \u0027sheets.googleapis.com\u0027 for consumer \u0027project_number:1011300378975\u0027.",
    "error > status": "RESOURCE_EXHAUSTED",
    "error > details > 0 > @type": "type.googleapis.com/google.rpc.ErrorInfo",
    "error > details > 0 > reason": "RATE_LIMIT_EXCEEDED",
    "error > details > 0 > domain": "googleapis.com",
    "error > details > 0 > metadata > quota_limit": "WriteRequestsPerMinutePerUser",
    "error > details > 0 > metadata > service": "sheets.googleapis.com",
    "error > details > 0 > metadata > quota_limit_value": "60",
    "error > details > 0 > metadata > quota_location": "global",
    "error > details > 0 > metadata > quota_metric": "sheets.googleapis.com/write_requests",
    "error > details > 0 > metadata > consumer": "projects/1011300378975",
    "error > details > 1 > @type": "type.googleapis.com/google.rpc.Help",
    "error > details > 1 > links > 0 > description": "Request a higher quota limit.",
    "error > details > 1 > links > 0 > url": "https://cloud.google.com/docs/quota#requesting_higher_quota"

This error, "error > code: 429" indicates that you've exceeded the quota for the 'Write requests' metric in the Google Sheets API. Specifically, you've reached the limit for 'Write requests per minute per user' for this service.

Google Sheets API has usage limits of per user basis. In the error shown, your rate limit for adding rows of data to Google Sheets has been exceeded.


1699960627358.png


Please incorporate a Delay action step prior to the Google Sheets action step in order to extend the processing interval.

1699960700276.png
 

Attachments

  • 1699960627169.png
    1699960627169.png
    127.3 KB · Views: 57
This error, "error > code: 429" indicates that you've exceeded the quota for the 'Write requests' metric in the Google Sheets API. Specifically, you've reached the limit for 'Write requests per minute per user' for this service.

Google Sheets API has usage limits of per user basis. In the error shown, your rate limit for adding rows of data to Google Sheets has been exceeded.


View attachment 34116

Please incorporate a Delay action step prior to the Google Sheets action step in order to extend the processing interval.

View attachment 34117
Thanks a lot. BTW, do you know how to format my current date?

1700014378666.png
 

Supreme

Well-known member
Staff member
Please format the "Date" column in your Google Sheets as "Plain Text" and then attempt the task once more.

1700112665247.png
 
Top