AutomationFlowsEmail & Gmail › 2088

2088

2088. Uses googleSheets, gmail. Scheduled trigger; 12 nodes.

Cron / scheduled trigger★★★★☆ complexity12 nodesGoogle SheetsGmail
Email & Gmail Trigger: Cron / scheduled Nodes: 12 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #2088 — we link there as the canonical source.

This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "meta": {
    "templateId": "2088"
  },
  "nodes": [
    {
      "id": "0e4c65ce-95e9-4a32-bc5c-0461cb339764",
      "name": "Filter Status (Waiting for sending)",
      "type": "n8n-nodes-base.filter",
      "position": [
        1670,
        1110
      ],
      "parameters": {
        "options": {
          "looseTypeValidation": true
        },
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "401b79a0-a079-4ea0-805b-a963d9206031",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.Status }}",
              "rightValue": "Waiting for sending"
            },
            {
              "id": "74ec18c7-e4cc-4d82-ba05-0ec4781cbb9f",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.Title }}",
              "rightValue": ""
            },
            {
              "id": "6e293a16-48cd-40bb-9882-09b456a97d58",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.Subject }}",
              "rightValue": ""
            },
            {
              "id": "a02d2518-e979-4a17-ab00-dda6723d9945",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.Email }}",
              "rightValue": ""
            },
            {
              "id": "bea4e49e-cf8a-4f05-bd6f-bdce0c5d8533",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.Name }}",
              "rightValue": ""
            },
            {
              "id": "e33eb064-34c6-4dea-b454-10f4fb7fe630",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.Date }}",
              "rightValue": ""
            },
            {
              "id": "1abe48e3-ba4d-4318-900d-fd58097d55ec",
              "operator": {
                "type": "dateTime",
                "operation": "equals"
              },
              "leftValue": "={{ DateTime.fromFormat($json[\"Date\"], 'yyyy/MM/dd').startOf('day')}}",
              "rightValue": "={{ $now.startOf('day')}}"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "27f33448-a016-4ac8-aea3-2ca267fb1628",
      "name": "Set data",
      "type": "n8n-nodes-base.set",
      "position": [
        2290,
        1090
      ],
      "parameters": {
        "fields": {
          "values": [
            {
              "name": "email",
              "stringValue": "={{ $json.Email }}"
            },
            {
              "name": "name",
              "stringValue": "={{ $json.Name }}"
            },
            {
              "name": "ID",
              "stringValue": "={{ $json.ID }}"
            }
          ]
        },
        "include": "selected",
        "options": {}
      },
      "typeVersion": 3.2
    },
    {
      "id": "badf1d45-21e0-40a5-bcc4-c434f43c04d4",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        390,
        250
      ],
      "parameters": {
        "width": 922.8914139860617,
        "height": 1171.2381808131183,
        "content": "# \ub178\ub4dc \uc124\uba85\n\n## \uace0\uac1d \uba54\uc2dc\uc9c0 \ub370\uc774\ud130 \uac80\uc0c9 (Google Sheets \ub178\ub4dc):\n**\ubaa9\uc801 \ubc0f \uc0ac\uc6a9 \uc0ac\ub840:**\n\uc774 \ub178\ub4dc\uc758 \uc8fc\uc694 \ubaa9\uc801\uc740 \uace0\uac1d \uba54\uc2dc\uc9c0\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud3ec\ud568\ud55c Google Sheets \ubb38\uc11c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc740 \ub2e4\uc591\ud55c \uc2dc\ub098\ub9ac\uc624\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:\n\n- \uc544\uc6c3\ub9ac\uce58 \ucea0\ud398\uc778\uc744 \uc704\ud55c \uace0\uac1d \uc5f0\ub77d\ucc98 \ubaa9\ub85d\uc744 \ucef4\ud30c\uc77c\ud558\ub294 \uacbd\uc6b0.\n- \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \uc800\uc7a5\ub41c \ud53c\ub4dc\ubc31\uc774\ub098 \uc751\ub2f5\uc744 \uc218\uc9d1\ud558\ub294 \uacbd\uc6b0.\n- \uace0\uac1d \uae30\ub85d \uc5c5\ub370\uc774\ud2b8\ub098 \ud1b5\uc2e0 \ucd94\uc801 \ud504\ub85c\uc138\uc2a4\ub97c \uc790\ub3d9\ud654\ud558\ub294 \uacbd\uc6b0.\n\n## \ud604\uc7ac \ub0a0\uc9dc \uae30\uc900 \ud56d\ubaa9 \ud544\ud130\ub9c1 \ub178\ub4dc:\n- **\ubaa9\uc801:** \uc785\ub825 \ud56d\ubaa9\uc744 \ud604\uc7ac \ub0a0\uc9dc\uc640 \ube44\uad50\ud558\uc5ec \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.\n- **\ub9e4\uac1c\ubcc0\uc218:**\n  - **JavaScript \ucf54\ub4dc:** \ud56d\ubaa9 \ub0a0\uc9dc\ub97c \ud604\uc7ac \ub0a0\uc9dc\uc640 \ube44\uad50\ud558\uc5ec \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.\n- **\uae30\ub2a5\uc131:** \ud604\uc7ac \ub0a0\uc9dc\uc640 \uc77c\uce58\ud558\ub294 \ud56d\ubaa9\ub9cc \uc804\ub2ec\ub418\ub3c4\ub85d \ud569\ub2c8\ub2e4.\n\n### \uc8fc\uc758: \ub0a0\uc9dc \ud615\uc2dd\uc740 (\ub144/\uc6d4/\uc77c) \ud615\ud0dc\ub85c \ud574\uc57c \ud569\ub2c8\ub2e4.\n\n## Gmail \ub178\ub4dc:\n- **\ubaa9\uc801:** \ud544\ud130\ub9c1\ub41c \ud56d\ubaa9\uc744 \uae30\ubc18\uc73c\ub85c Gmail\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774\uba54\uc77c\uc744 \ubcf4\ub0b4\ub294 \uac83 \uac19\uc2b5\ub2c8\ub2e4.\n- **\ub9e4\uac1c\ubcc0\uc218:**\n  - **\ubc1b\ub294 \uc0ac\ub78c:** \uc785\ub825 \ub370\uc774\ud130\uc5d0\uc11c \ucd94\ucd9c\ub429\ub2c8\ub2e4.\n  - **\uc81c\ubaa9:** \uc785\ub825 \ub370\uc774\ud130\uc5d0\uc11c \ucd94\ucd9c\ub429\ub2c8\ub2e4.\n  - **\uc774\uba54\uc77c \ub0b4\uc6a9:** \uc785\ub825 \ub370\uc774\ud130\uc5d0\uc11c \ucd94\ucd9c\ub429\ub2c8\ub2e4.\n\n## \uba54\uc2dc\uc9c0 \uc0c1\ud0dc \uc5c5\ub370\uc774\ud2b8 (Google Sheets \ub178\ub4dc):\n- **\ubaa9\uc801:** Google Sheets \ubb38\uc11c\uc758 \ud2b9\uc815 \uc5f4\uc744 \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4.\n- **\ub9e4\uac1c\ubcc0\uc218:**\n  - **\uc791\uc5c5:** \uc5c5\ub370\uc774\ud2b8 \ubaa8\ub4dc.\n  - **\uc5f4:** \uc785\ub825 \ub370\uc774\ud130\uc758 \uac12\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc5c5\ub370\uc774\ud2b8\ud560 \uc5f4\uc744 \uc815\uc758\ud569\ub2c8\ub2e4.\n\n## \uc0c1\ud0dc \ud544\ud130\ub9c1 (\uc804\uc1a1 \ub300\uae30) \ub178\ub4dc:\n- **\ubaa9\uc801:** \ud2b9\uc815 \uc0c1\ud0dc \uae30\uc900\uc5d0 \ub530\ub77c \ud56d\ubaa9\uc744 \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.\n- **\ub9e4\uac1c\ubcc0\uc218:**\n  - **\uc870\uac74:** \uc0c1\ud0dc, \uc81c\ubaa9, \uc8fc\uc81c, \uc774\uba54\uc77c, \uc774\ub984 \ubc0f \ub0a0\uc9dc\ub97c \uae30\ubc18\uc73c\ub85c \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.\n\n## \ub370\uc774\ud130 \uc124\uc815 \ub178\ub4dc:\n- **\ubaa9\uc801:** \uc785\ub825 \ub370\uc774\ud130\uc5d0\uc11c \ucd94\ucd9c\ub41c \uac12\uc73c\ub85c \uc9c0\uc815\ub41c \ud544\ub4dc\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.\n\n## \ud544\ub4dc \ubcd1\ud569 \ub178\ub4dc:\n- **\ubaa9\uc801:** \uc704\uce58\uc5d0 \ub530\ub77c \ub2e4\ub978 \uc18c\uc2a4\uc758 \ud544\ub4dc\ub97c \ubcd1\ud569\ud569\ub2c8\ub2e4.\n\n\uc774 \uc138\ubd80 \uc124\uba85\uc744 \ud65c\uc6a9\ud558\uc5ec \uc6cc\ud06c\ud50c\ub85c\ub97c \ub354 \uc798 \uc774\ud574\ud558\uace0 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "0f1cd01b-4cf0-4998-9c51-02c2c9c4aa2b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1330,
        870
      ],
      "parameters": {
        "width": 1386.7301333853884,
        "height": 539.317352764935,
        "content": "# \uc6cc\ud06c\ud50c\ub85c"
      },
      "typeVersion": 1
    },
    {
      "id": "421b47fd-4707-41ec-97e4-7256be22b75d",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        240
      ],
      "parameters": {
        "color": 7,
        "width": 2358.9018586668417,
        "height": 1194.0044652590357,
        "content": "\ud55c\uad6d\uc5b4 \ubc88\uc5ed \uacb0\uacfc\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uc785\ub825 \ud14d\uc2a4\ud2b8\uac00 \uc5c6\uc73c\ubbc0\ub85c \ubc88\uc5ed\ud560 \ub0b4\uc6a9\uc774 \uc5c6\uc2b5\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "dfb3d998-14fc-4d2a-af9e-19c7da8060f9",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1330,
        255
      ],
      "parameters": {
        "width": 342.9710297084147,
        "height": 601.2740375761717,
        "content": "## \uc774 \ud15c\ud50c\ub9bf\uc744 \ubcf5\uc0ac\ud558\uc5ec \uc2dc\uc791\ud558\uc138\uc694:\n- [Google \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8](https://docs.google.com/spreadsheets/d/1efCCzfeUX0AETz2wsULQN90OBCOKK-gBoDaptzcBHdE/edit?usp=sharing)\n\n## \uc6cc\ud06c\ud50c\ub85c \ub178\ub4dc \ubb38\uc11c:\n\n1. [\uc2a4\ucf00\uc904 \ud2b8\ub9ac\uac70](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.scheduletrigger/)\n2. [\ud604\uc7ac \ub0a0\uc9dc\ub85c \ud56d\ubaa9 \ud544\ud130\ub9c1](https://docs.n8n.io/nodes/n8n-nodes-base.code.html)\n3. [Gmail](https://docs.n8n.io/nodes/n8n-nodes-base.gmail.html)\n4. [Google \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8](https://docs.n8n.io/nodes/n8n-nodes-base.googleSheets.html)\n5. [\uc0c1\ud0dc \ud544\ud130 (\ubcf4\ub0b4\uae30 \ub300\uae30)](https://docs.n8n.io/nodes/n8n-nodes-base.filter.html)\n6. [\ub370\uc774\ud130 \uc124\uc815](https://docs.n8n.io/nodes/n8n-nodes-base.set.html)\n7. [\ud544\ub4dc \ubcd1\ud569](https://docs.n8n.io/nodes/n8n-nodes-base.merge.html)"
      },
      "typeVersion": 1
    },
    {
      "id": "4ed5a195-fd49-465e-9a14-fa64cd96056b",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1690,
        250
      ],
      "parameters": {
        "width": 1024.157503378047,
        "height": 602.8437691253422,
        "content": "## \uc6cc\ud06c\ud50c\ub85c \uac1c\uc694:\n\n\uc6cc\ud06c\ud50c\ub85c\ub294 \"Google Sheets Trigger\" \ub178\ub4dc\uc5d0\uc11c \uc2dc\uc791\ub418\uba70, \uc774 \ub178\ub4dc\ub294 \uc9c0\uc815\ub41c Google Sheet\uc5d0\uc11c \uc0c8 \ud589 \ucd94\uac00\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud569\ub2c8\ub2e4. \uc0c8 \ud589\uc774 \uac10\uc9c0\ub418\uba74, \uc6cc\ud06c\ud50c\ub85c\ub294 \"Filter Status (Waiting for sending)\" \ub178\ub4dc\ub85c \uc9c4\ud589\ub418\uba70, \uc774\uacf3\uc5d0\uc11c \ud56d\ubaa9\ub4e4\uc774 \ud2b9\uc815 \uc870\uac74\uc5d0 \ub530\ub77c \ud544\ud130\ub9c1\ub429\ub2c8\ub2e4.\n\n\uc774\ud6c4, \uc6cc\ud06c\ud50c\ub85c\ub294 \"Filter Items by Current Date\" \ub178\ub4dc\ub85c \uc774\ub3d9\ud558\uba70, \uc774 \ub178\ub4dc\ub294 \ud56d\ubaa9\ub4e4\uc744 \ud604\uc7ac \ub0a0\uc9dc\uc5d0 \ub530\ub77c \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4. \ud604\uc7ac \ub0a0\uc9dc\uc640 \uc77c\uce58\ud558\ub294 \ud56d\ubaa9\ub4e4\uc740 \ucd94\uac00\ub85c \ucc98\ub9ac\ub429\ub2c8\ub2e4.\n\n\ud544\ud130\ub9c1\ub41c \ud56d\ubaa9\ub4e4\uc740 \"Gmail\" \ub178\ub4dc\ub85c \uc804\ub2ec\ub418\uba70, \uc774\uacf3\uc5d0\uc11c Google Sheet \ub370\uc774\ud130\ub97c \uae30\ubc18\uc73c\ub85c \uac1c\uc778\ud654\ub41c \uc774\uba54\uc77c\uc774 \uc791\uc131\ub418\uace0 \uc218\uc2e0\uc790\uc5d0\uac8c \ubcf4\ub0b4\uc9d1\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc6cc\ud06c\ud50c\ub85c\ub294 \"Google Sheets\" \ub178\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcf4\ub0b8 \uc774\uba54\uc77c\uc758 \uc0c1\ud0dc\uc640 \uae30\ud0c0 \uad00\ub828 \uc815\ubcf4\ub97c Google Sheet\ub97c \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4."
      },
      "typeVersion": 1
    },
    {
      "id": "d156f0da-53e7-499b-b652-5ca0c3c9e237",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1350,
        1110
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 1
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "e398e809-b00f-4edb-af94-d236cfb80703",
      "name": "Retrieve Customer Messages Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1510,
        1110
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/126qQdkEWt_4Vkxvu6G80rBeFdIp_a8ISMz-898fa2D4/edit#gid=0",
          "cachedResultName": "Page"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "126qQdkEWt_4Vkxvu6G80rBeFdIp_a8ISMz-898fa2D4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/126qQdkEWt_4Vkxvu6G80rBeFdIp_a8ISMz-898fa2D4/edit?usp=drivesdk",
          "cachedResultName": "Copy of Sending Messages to Customers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "6de55876-3924-4fdc-aae7-b901a2ce72be",
      "name": "Update Message Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2490,
        1090
      ],
      "parameters": {
        "columns": {
          "value": {
            "ID": "={{ $json.ID }}",
            "Status": "Sent successfully"
          },
          "schema": [
            {
              "id": "ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Subject",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "ID"
          ]
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/126qQdkEWt_4Vkxvu6G80rBeFdIp_a8ISMz-898fa2D4/edit#gid=0",
          "cachedResultName": "Page"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "126qQdkEWt_4Vkxvu6G80rBeFdIp_a8ISMz-898fa2D4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/126qQdkEWt_4Vkxvu6G80rBeFdIp_a8ISMz-898fa2D4/edit?usp=drivesdk",
          "cachedResultName": "Copy of Sending Messages to Customers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "0401bfe7-de72-407a-a7f7-70b7da52e9c9",
      "name": "Send a message (Gmail)",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1900,
        980
      ],
      "parameters": {
        "sendTo": "={{ $json.Email }}",
        "message": "={{ $json.Subject }}",
        "options": {},
        "subject": "={{ $json.Title }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "name": "<your credential>"
        }
      },
      "notesInFlow": false,
      "typeVersion": 2.1,
      "alwaysOutputData": false
    },
    {
      "id": "94ff4e81-41c6-479e-bcb5-c9786935a954",
      "name": "Merge fields",
      "type": "n8n-nodes-base.merge",
      "position": [
        2110,
        1090
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combinationMode": "mergeByPosition"
      },
      "typeVersion": 2.1
    }
  ],
  "connections": {
    "Set data": {
      "main": [
        [
          {
            "node": "Update Message Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge fields": {
      "main": [
        [
          {
            "node": "Set data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Retrieve Customer Messages Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message (Gmail)": {
      "main": [
        [
          {
            "node": "Merge fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Retrieve Customer Messages Data": {
      "main": [
        [
          {
            "node": "Filter Status (Waiting for sending)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Status (Waiting for sending)": {
      "main": [
        [
          {
            "node": "Merge fields",
            "type": "main",
            "index": 1
          },
          {
            "node": "Send a message (Gmail)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

2088. Uses googleSheets, gmail. Scheduled trigger; 12 nodes.

Source: https://github.com/n8nKOR/n8n-shared-workflow/blob/62a671327e906c22a40d290b339ff6d2373f8d75/workflows/n8nworkflows/marketing/2088.json — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Email & Gmail

YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.

Gmail, Google Drive, Google Sheets +1
Email & Gmail

Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google

Google Sheets, HTTP Request, WhatsApp +1
Email & Gmail

This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store.

Google Sheets, HTTP Request, Gmail
Email & Gmail

This n8n template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.

Google Sheets, HTTP Request, Google Drive +1
Email & Gmail

The workflow is triggered automatically every day at 12:00 PM using a Cron node.

RSS Feed Read, Google Sheets, Gmail +1