n8n recipe · orders

Shopify → Google Sheets → Gmail

Each new Shopify order becomes a Google Sheets row, and an email goes out from Gmail.

쇼피파이에 새 주문이 들어오면 구글 시트에 적고 지메일로 메일을 보내요.

Steps

  1. When when a shopify order is created — Shopify node
  2. Then add a row to google sheets — Google Sheets node
  3. Then send an email with gmail — Gmail node

Fields to fill (6)

The file has every node wired up. These are the blanks only you can fill (your form, your sheet, your words).

NodeWhat to do
Google Sheetsfill documentId (Document)
Google Sheetsfill sheetName (Sheet)
Google Sheetsfill columns (Columns)
Gmailfill sendTo (The email addresses of the recipients)
Gmailfill subject (Subject)
Gmailfill message (Message)

Accounts to connect (3)

In n8n, pick or add a credential on each node — one of the types below.

Get the n8n file

Download shopify-order-to-sheets-and-gmail.json

  1. Open a new, empty workflow in n8n.
  2. Open the workflow menu (⋯) and choose Import from File — or copy the JSON below and paste it onto the canvas (Ctrl/Cmd+V).
  3. Connect the accounts, fill the fields above, run one test, then turn the workflow on.
Or copy the JSON 
{
  "name": "Each new Shopify order becomes a Google Sheets row",
  "nodes": [
    {
      "id": "n1",
      "name": "Shopify Trigger",
      "type": "n8n-nodes-base.shopifyTrigger",
      "typeVersion": 1,
      "parameters": {
        "topic": "orders/create"
      },
      "position": [
        240,
        300
      ],
      "notes": "step: when a shopify order is created"
    },
    {
      "id": "n2",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,
      "parameters": {
        "resource": "sheet",
        "operation": "append",
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": []
        }
      },
      "position": [
        460,
        300
      ],
      "notes": "step: add a row to google sheets"
    },
    {
      "id": "n3",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2.2,
      "parameters": {
        "resource": "message",
        "operation": "send",
        "sendTo": "",
        "subject": "",
        "emailType": "html",
        "message": ""
      },
      "position": [
        680,
        300
      ],
      "notes": "step: send an email with gmail"
    }
  ],
  "connections": {
    "Shopify Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "active": false
}