Bridgecore

Ready-made 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 only reads
  2. Then add a row to google sheets — Google Sheets node can be undone
  3. Then send an email with gmail — Gmail node can’t be undone

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.

Need something slightly different? Same engine, your own words:

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 · reversibility: read-only"
    },
    {
      "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 · reversibility: reversible"
    },
    {
      "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 · reversibility: irreversible"
    }
  ],
  "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
}