Sales CRM - Email Sent

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 →

{
  "name": "Sales CRM - Email Sent",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "sales-dashboard/email-sent",
        "responseMode": "responseNode",
        "options": {}
      },
      "id": "c1a2b3c4-d5e6-f7a8-b9c0-d1e2f3a4b5c6",
      "name": "Webhook - Email Sent",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2,
      "position": [
        240,
        300
      ]
    },
    {
      "parameters": {
        "operation": "appendOrUpdate",
        "documentId": {
          "__rl": true,
          "value": "1DEmE-3aiDhQlMNcFct4KbUQDOnNBJRUo-vPYhw6VpUY",
          "mode": "list",
          "cachedResultName": "Lead Gen Master Sheet"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=924549057",
          "mode": "list",
          "cachedResultName": "enriched_leads",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DEmE-3aiDhQlMNcFct4KbUQDOnNBJRUo-vPYhw6VpUY/edit#gid=924549057"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "lead_id": "={{ $json.body.lead_id }}",
            "email_status": "={{ $json.body.email_status }}",
            "pipeline_status": "={{ $json.body.pipeline_status }}",
            "tracking_id": "={{ $json.body.tracking_id }}",
            "email_sent_at": "={{ $json.body.email_sent_at }}",
            "sent_from_domain": "={{ $json.body.sent_from_domain }}"
          },
          "matchingColumns": [
            "lead_id"
          ],
          "schema": [
            {
              "id": "lead_id",
              "displayName": "lead_id",
              "required": false,
              "defaultMatch": true,
              "canBeUsedToMatch": true,
              "type": "string"
            },
            {
              "id": "email_status",
              "displayName": "email_status",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": false,
              "type": "string"
            },
            {
              "id": "pipeline_status",
              "displayName": "pipeline_status",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": false,
              "type": "string"
            },
            {
              "id": "tracking_id",
              "displayName": "tracking_id",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": false,
              "type": "string"
            },
            {
              "id": "email_sent_at",
              "displayName": "email_sent_at",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": false,
              "type": "string"
            },
            {
              "id": "sent_from_domain",
              "displayName": "sent_from_domain",
              "required": false,
              "defaultMatch": false,
              "canBeUsedToMatch": false,
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "id": "a1b2c3d4-e5f6-a7b8-c9d0-e1f2a3b4c5d6",
      "name": "Update Lead - Sent",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        460,
        300
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "respondWith": "json",
        "responseBody": "={{ JSON.stringify({ success: true, message: 'Lead updated', lead_id: $json.body.lead_id }) }}"
      },
      "id": "b2c3d4e5-f6a7-b8c9-d0e1-f2a3b4c5d6e7",
      "name": "Respond Success",
      "type": "n8n-nodes-base.respondToWebhook",
      "typeVersion": 1.1,
      "position": [
        680,
        300
      ]
    }
  ],
  "connections": {
    "Webhook - Email Sent": {
      "main": [
        [
          {
            "node": "Update Lead - Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Lead - Sent": {
      "main": [
        [
          {
            "node": "Respond Success",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "tags": [],
  "meta": {
    "templateCredsSetupCompleted": false
  }
}

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.

• googleSheetsOAuth2Api

About this workflow

Sales CRM - Email Sent. Uses googleSheets. Webhook trigger; 3 nodes.

Source: https://github.com/Jacksass22/defiant-integrations/blob/1bef8b5f5119b2611e4c86136277ca520177b044/n8n-workflows/sales-crm-email-sent.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

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