Why am I getting "too many requests" error for Google sheets after a single call clear?

Questions
1

Describe the problem/error/question

I keep running into issues where my automation errors and says Google Sheets is receiving too many requests from me, but I never have more than 100 rows and in some cases it errors at the first step of clearing the sheet, which only has a single input. Why is this happening? I don’t have simultaneous automations for the same sheet/file.

Upon closer look, the project name/number it gives me in the error isn’t in my google console. Some internet searching is suggesting that the project number belongs to n8n, not to me, and that I’m hitting the limit of n8n’s project quota. Is this true? I don’t see any data in my Google API Metrics, so that would make sense if it wasn’t my google project. But if so, that would mean I can’t request a quota increase to Google myself.

How do I fix this? Or, is the root cause something else?

What is the error message (if any)?

The service is receiving too many requests from you

Quota exceeded for quota metric ‘Write requests’ and limit ‘Write requests per minute’ of service ‘sheets.googleapis.com’ for consumer ‘project_number:498586711441’.

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.)
{
  "nodes": [
    {
      "parameters": {
        "resource": "databasePage",
        "operation": "getAll",
        "databaseId": {
          "__rl": true,
          "value": "95825303-adae-4a64-bc67-c949e8377349",
          "mode": "list",
          "cachedResultName": "Orders",
          "cachedResultUrl": "https://www.notion.so/95825303adae4a64bc67c949e8377349"
        },
        "returnAll": true,
        "filterType": "manual",
        "matchType": "allFilters",
        "filters": {
          "conditions": [
            {
              "key": "Tracking Number|rich_text",
              "condition": "is_empty"
            },
            {
              "key": "Shopify Status|status",
              "condition": "equals",
              "statusValue": "Unfulfilled"
            },
            {
              "key": "Confirmation Number (CN#)|rich_text",
              "condition": "is_not_empty"
            }
          ]
        },
        "options": {}
      },
      "id": "cbba9b11-9956-4fd8-b883-377e36e31669",
      "name": "Notion",
      "type": "n8n-nodes-base.notion",
      "typeVersion": 2.2,
      "position": [
        1360,
        448
      ],
      "credentials": {
        "notionApi": {
          "id": "g38iYLpgX4YeBdnY",
          "name": "Notion account"
        }
      }
    },
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 2
            }
          ]
        }
      },
      "id": "b89b2665-cd0d-424e-9578-354a7562e324",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        320,
        144
      ]
    },
    {
      "parameters": {
        "instructions": "Remove the text \" hours\" from the field \"property_hours_since_placed\" and convert into number.",
        "jsCode": "const items = $input.all();\n\nconst updatedItems = items.map((item) => {\n  const hoursString = item.json.property_hours_since_placed;\n  const trimmedName = item.json.property_ship_to_name.trim();\n\n  const hoursNumber = parseFloat(hoursString.replace(\" hours\", \"\"));\n\n  return {\n    ...item.json,\n    property_hours_since_placed: hoursNumber,\n    trimmed_ship_to_name: trimmedName,\n  };\n});\n\nreturn updatedItems;\n"
      },
      "id": "0d5b3318-944b-4b8b-bd0f-1dadbb45ddad",
      "name": "AI Transform",
      "type": "n8n-nodes-base.aiTransform",
      "typeVersion": 1,
      "position": [
        1552,
        464
      ]
    },
    {
      "parameters": {
        "operation": "clear",
        "documentId": {
          "__rl": true,
          "value": "1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ",
          "mode": "list",
          "cachedResultName": "Excelify",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": 1226359882,
          "mode": "list",
          "cachedResultName": "NotionFind",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit#gid=1226359882"
        },
        "keepFirstRow": true
      },
      "id": "14664515-44c2-4c1b-9e13-e3c55485355e",
      "name": "Clear NotionFind",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        640,
        272
      ],
      "executeOnce": true,
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "B3AtRAXzm8xNtPGY",
          "name": "Google Sheets account 2 (Jefflibsen)"
        }
      }
    },
    {
      "parameters": {
        "operation": "clear",
        "documentId": {
          "__rl": true,
          "value": "1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ",
          "mode": "list",
          "cachedResultName": "Excelify",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": 1226887332,
          "mode": "list",
          "cachedResultName": "2nd Zapier Find",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit#gid=1226887332"
        },
        "keepFirstRow": true
      },
      "id": "cbff672c-6401-4e62-8e9d-4a81476588b7",
      "name": "Clear 2nd ZapierFind",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        800,
        192
      ],
      "executeOnce": true,
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "B3AtRAXzm8xNtPGY",
          "name": "Google Sheets account 2 (Jefflibsen)"
        }
      }
    },
    {
      "parameters": {},
      "id": "c15b0e64-663d-4043-9cb9-0124e384170d",
      "name": "No Operation, do nothing",
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        1200,
        352
      ],
      "executeOnce": true
    },
    {
      "parameters": {
        "operation": "appendOrUpdate",
        "documentId": {
          "__rl": true,
          "value": "1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ",
          "mode": "list",
          "cachedResultName": "Excelify",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": 1226359882,
          "mode": "list",
          "cachedResultName": "NotionFind",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit#gid=1226359882"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "ID": "={{ $('Notion').item.json.property_order_id }}",
            "Order #": "={{ $json.name }}",
            "Address": "={{ $json.property_ship_to_address_1 }}",
            "Name": "={{ $json.property_ship_to_name }}",
            "Zip": "={{ $json.property_ship_to_zip }}",
            "#CN": "={{ $json.property_confirmation_number_cn }}",
            "Hrs Since Placed": "={{ $json.property_hours_since_placed }}",
            "Name Trimmed": "={{ $json.property_ship_to_name.trim() }}",
            "Would Fulfill?": "={{ $json.property_send_email_update }}",
            "First Name": "={{ $json.property_ship_to_first_name }}",
            "Last Name": "={{ $json.property_ship_to_last_name }}",
            "Trimmed ID": "="
          },
          "matchingColumns": [
            "ID"
          ],
          "schema": [
            {
              "id": "ID",
              "displayName": "ID",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Order #",
              "displayName": "Order #",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "displayName": "Name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Name Trimmed",
              "displayName": "Name Trimmed",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Address",
              "displayName": "Address",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Zip",
              "displayName": "Zip",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "#CN",
              "displayName": "#CN",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Hrs Since Placed",
              "displayName": "Hrs Since Placed",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Would Fulfill?",
              "displayName": "Would Fulfill?",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Tracking",
              "displayName": "Tracking",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Trimmed ID",
              "displayName": "Trimmed ID",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Value ID",
              "displayName": "Value ID",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "First Name",
              "displayName": "First Name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Last Name",
              "displayName": "Last Name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            }
          ]
        },
        "options": {}
      },
      "id": "925f7c7e-f5ac-45eb-a200-d14ff0532a09",
      "name": "Update NotionFind",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        1840,
        352
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "B3AtRAXzm8xNtPGY",
          "name": "Google Sheets account 2 (Jefflibsen)"
        }
      }
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ",
          "mode": "list",
          "cachedResultName": "Excelify",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": 1226887332,
          "mode": "list",
          "cachedResultName": "2nd Zapier Find",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit#gid=1226887332"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "ID": "={{ $json.ID }}",
            "Name": "={{ $json.Name }}",
            "Shipping: First Name": "={{ $json['Shipping: First Name'] }}",
            "Shipping: Last Name": "={{ $json['Shipping: Last Name'] }}",
            "Command": "UPDATE",
            "Line: Type": "FULFILLMENT LINE",
            "Fulfillment: Send Receipt": "=",
            "Tags": "={{ $json.Tags }}",
            "Tags Trimmed": "={{ $json['Tags Trimmed'] }}",
            "Full Name": "={{ $json['Full Name'] }}",
            "Name Trimmed": "={{ $json['Name Trimmed'] }}",
            "Address": "={{ $json.Address }}",
            "Zip": "={{ $json.Zip }}",
            "#CN": "=",
            "Hrs since placed": "=",
            "Would send Fulfill?": "="
          },
          "matchingColumns": [],
          "schema": [
            {
              "id": "ID",
              "displayName": "ID",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "displayName": "Name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Shipping: First Name",
              "displayName": "Shipping: First Name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Shipping: Last Name",
              "displayName": "Shipping: Last Name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Command",
              "displayName": "Command",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Line: Type",
              "displayName": "Line: Type",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Fulfillment: Send Receipt",
              "displayName": "Fulfillment: Send Receipt",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Fulfillment: Tracking Number",
              "displayName": "Fulfillment: Tracking Number",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Tags",
              "displayName": "Tags",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Tags Trimmed",
              "displayName": "Tags Trimmed",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Full Name",
              "displayName": "Full Name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Name Trimmed",
              "displayName": "Name Trimmed",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Address",
              "displayName": "Address",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Zip",
              "displayName": "Zip",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "#CN",
              "displayName": "#CN",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Hrs since placed",
              "displayName": "Hrs since placed",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Would send Fulfill?",
              "displayName": "Would send Fulfill?",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Tracking",
              "displayName": "Tracking",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "Value ID",
              "displayName": "Value ID",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {
          "useAppend": true
        }
      },
      "id": "872b7b5c-fa5c-4c09-ac9d-fe2256635cd3",
      "name": "Send to 2ndZapier Find",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        1152,
        80
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "B3AtRAXzm8xNtPGY",
          "name": "Google Sheets account 2 (Jefflibsen)"
        }
      }
    },
    {
      "parameters": {},
      "id": "3c79d2da-fa86-4564-8aee-5d05f2054572",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        400,
        432
      ]
    },
    {
      "parameters": {},
      "id": "27735355-409c-472a-aeda-323da540212b",
      "name": "No Operation, do nothing1",
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        512,
        192
      ]
    },
    {
      "parameters": {
        "amount": 1,
        "unit": "minutes"
      },
      "id": "0c5e757d-ecf1-4fce-b48f-12937cc512ad",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "typeVersion": 1.1,
      "position": [
        1680,
        384
      ],
      "webhookId": "2501564c-ba4e-44d0-b44b-f97c857203d3"
    },
    {
      "parameters": {
        "documentId": {
          "__rl": true,
          "value": "1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ",
          "mode": "list",
          "cachedResultName": "Excelify",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "ExportUpdate",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K3FJKfww2xUAWISB89f-6kdBzD6Hh9yqjbImzyBZeqQ/edit#gid=0"
        },
        "options": {}
      },
      "id": "b6a6a1d3-1786-4c60-a52f-0c446574308e",
      "name": "Get rows ExportUpdate",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        928,
        64
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "B3AtRAXzm8xNtPGY",
          "name": "Google Sheets account 2 (Jefflibsen)"
        }
      }
    }
  ],
  "connections": {
    "Notion": {
      "main": [
        [
          {
            "node": "AI Transform",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "No Operation, do nothing1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Transform": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clear NotionFind": {
      "main": [
        [
          {
            "node": "Clear 2nd ZapierFind",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clear 2nd ZapierFind": {
      "main": [
        [
          {
            "node": "Get rows ExportUpdate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "No Operation, do nothing": {
      "main": [
        [
          {
            "node": "Notion",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send to 2ndZapier Find": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "No Operation, do nothing1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "No Operation, do nothing1": {
      "main": [
        [
          {
            "node": "Clear NotionFind",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Update NotionFind",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get rows ExportUpdate": {
      "main": [
        [
          {
            "node": "Send to 2ndZapier Find",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "meta": {
    "instanceId": "d648db6b8110f5b935e1dbc5cabfa04f8e019b24c17592bbc87017825dc2657c"
  }
}

Share the output returned by the last node

In the errored node mentioned above, the expected output is a cleared sheet keeping the header row. The complete workflow should end with data in a different sheet in the same google sheets file.

Information on your n8n setup

  • n8n version: 1.113.3
  • Database (default: SQLite): managed by n8n Cloud
  • n8n EXECUTIONS_PROCESS setting (default: own, main): managed by n8n Cloud
  • Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
2

I am pretty new to N8N, but I ran into something very similar yesterday. Any time I use a get operation in a node for google sheets, I got the same error message. I fixed it by turning on executeonce in the settings of the node. I see you have executeonce on some of these, and I’m not familiar with all the operations in your flow. For me at least, it was specifically when I had a google sheet node with a getrows operation. As soon as I turned on execute once, it worked no problem.

3

hmm the only steps before the “clear sheet” node are a trigger and “do nothing",” but I’ll change them to “execute once” and see if that helps

4

Gotcha, I can’t remember every scenario I ran into this with. In terms of clearing sheets, I have a current working “clear all my sheets” workflow, and it’s just a manual trigger, then goes to clear sheet1 –> clear sheet 2, etc. Works well, but not sure if that helps here at all.

5

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