First row keeps getting cleared even though it's set to keep?

Help me Build my Workflow
1

Describe the problem/error/question

My flow connects to a google sheet. It’s set to clear the whole sheet but the box is checked to keep the first row. Multiple times now the header row has also been cleared and I have to re-paste the header row. Why is this happening? I’m updated to the current version of n8n.

What is the error message (if any)?

none

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
      ],
      "executeOnce": true
    },
    {
      "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": [
        672,
        304
      ],
      "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": [
        720,
        128
      ],
      "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['Shipping: First Name'] }} {{ $json['Shipping: Last Name'] }}",
            "Name Trimmed": "={{ $json['Name Trimmed'] }}",
            "Address": "={{ $json.Address }}",
            "Zip": "={{ $json['Shipping: 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
      ],
      "executeOnce": true
    },
    {
      "parameters": {},
      "id": "27735355-409c-472a-aeda-323da540212b",
      "name": "No Operation, do nothing1",
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        512,
        192
      ],
      "executeOnce": true
    },
    {
      "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": {
    "templateCredsSetupCompleted": true,
    "instanceId": "d648db6b8110f5b935e1dbc5cabfa04f8e019b24c17592bbc87017825dc2657c"
  }
}

Share the output returned by the last node

Information on your n8n setup

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