When data is being looped, there may be Google Sheets request limit issues.

[Stanley-baby]

Describe the bug Is there a request limit for Google Sheets? If so, what are the limitations and how can they be overcome?

To Reproduce Steps to reproduce the behavior:

• When using Google Sheets for data looping, this situation may occur.

Expected behavior When Google Sheets has request limitations, I hope there can be better solutions.

Screenshots Attachment

Desktop (please complete the following information):

• OS: [e.g. Apple M1 14.0]
• Browser: [e.g. edge]
• Extension Version: [e.g. 1.28.17]

Additional context An additional request, hoping to have more relevant tutorials. Currently there are too few tutorials. As a popular automation plugin, this is very incredible.

[Kholid060]

There are several ways you can overcome this limit:

1. Moving your Google Sheets block outside the loop, and accessing those Google Sheets values like {{googleSheets.referenceKey}} inside the loop.
2. Using the Google Sheets (GDrive) block
3. Add an error fallback to the Google Sheets block like the below image

[Stanley-baby]

I am operating automation software for the first time. Can you make a video tutorial on these operations? Thank you very much!