Why am I Exceeding the Rate Limit While Creating File Subscriptions with the "Google Sheet > New Row Added" Trigger in the Development Stage?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

Hey! I keep getting this error in the development stage when I try to create a trigger for “Google Sheet > New Row Added.” I ran it three or four times, and they all failed. It seems like a bug because there shouldn’t be any limit issues since I only tried it three or four times.
“err”:{“name”:“Error”,“message”:“Rate limit exceeded for creating file subscriptions.”,“stack”:"Error: Rate limit exceeded for creating file subscriptions.

2

Hi , may I ask if your sheet had more than 100 rows?

3

No, just 3 rows

4

Are there any limitations on how many active triggers a sheet can have? It seems like the “New Row Added (Instant)” trigger does not allow two triggers. However, New Row Added does allow it.

5

Hi, I believe there is a limit for how many trigger is active at the same time for an account.

To verify this, could you try disable an existing Google Sheet source (under Pipedream source page) and try to create a new source again?

6

I use Connect. The triggers are created by users of my product. Therefore, they do not appear in the Sources view.

7

Oh I get it. Could you confirm if the rate limit error occurred for a single user or for all user? Could you try to use another Google account to see if you can create a source?

8

Or maybe for a different sheet? You can also disable or delete any active triggers via the API then try again.

9

Can you share the full error here?

10

I will check that. Meanwhile I get {“error”:“record not found”} when I call action “google_sheets-update-row”. Double checked all fields are correct. Is this related to trigger being created in both dev and prouction?

11

That sounds like a bad API call. Can you post the request you’re making here?

12

I cannot reproduce the issue anymore. I’m not sure what was wrong. I will post again if it happens again. Thanks for the replies!