Cannot clear a Google Sheet

Questions
1

Describe the problem/error/question

Google Sheets node Clear sheet throws “The service is receiving too many requests from you”

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • **n8n version: 1.50.1
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system:

I have a sheet with just the first header row filled, and want to do a “Clear Whole Sheet” before appending new rows. I have tried clearing a range, specific columns, etc. I have tried with the “Keep Top Row” on and with it off.

1 Like
2

hello @Mike_Z

Can you share the workflow?

It seems that the node is being executed multiple times, thus throwing a throttle error. You can set the “Execute Once” option in node settings to prevent multiple executions.

2 Likes
3

So it’s probably executing the sheet clear for every preceding item. I’ll change the process order, or try the “execute once” option that I didn’t realize was there. Thanks for the fast reply!

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.