Google Sheet Trigger

Hello community, and special thanks to who have created this great product. I’m a marketer who are interested in workflow automation. I currently have an google sheet with some fields column like : name, email and phone and the leads continually import to these rows of the Google Sheet. I have no-code experience so i don’t know how to write workflow to automatically import the name and email in google sheet to the mautic contact or segment each time the lead is filled to the sheet. Hope someone here have written code for me. Really appreciate your helps !

@HM.Anh welcome to the community.

To achieve this you will need the Google Sheet Trigger and we do not have it yet. We already have a Mautic node that would do the mautic work. I can make this post a feature request so that people can vote. The more votes the more chances the node to be developed.

I’ve shared this code, you can try here https://n8n.io/workflows/636 or copy code below

{
  "nodes": [
    {
      "parameters": {
        "sheetId": "1jKYwPE9DMFOYf1AeDuTvQ3GSM2GqaEJhGYNoisxSLpM",
        "range": "Data!A:P",
        "options": {
          "valueRenderMode": "FORMATTED_VALUE"
        }
      },
      "name": "GS Read Data2",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 1,
      "position": [
        240,
        750
      ],
      "credentials": {
        "googleApi": "n8n API"
      }
    },
    {
      "parameters": {},
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "email": "={{$node[\"GS Read Data2\"].json[\"email\"]}}",
        "firstName": "={{$node[\"GS Read Data2\"].json[\"firstname\"]}}",
        "additionalFields": {
          "mobile": "={{$node[\"GS Read Data2\"].json[\"mobile\"]}}"
        },
        "options": {}
      },
      "name": "Mautic",
      "type": "n8n-nodes-base.mautic",
      "typeVersion": 1,
      "position": [
        450,
        750
      ],
      "notesInFlow": false,
      "credentials": {
        "mauticApi": "MauticAPI"
      }
    },
    {
      "parameters": {
        "sheetId": "1jKYwPE9DMFOYf1AeDuTvQ3GSM2GqaEJhGYNoisxSLpM",
        "range": "Data!A:P",
        "options": {
          "valueRenderMode": "FORMATTED_VALUE"
        }
      },
      "name": "GS Read Data2",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 1,
      "position": [
        240,
        750
      ],
      "credentials": {
        "googleApi": "n8n API"
      }
    },
    {
      "parameters": {
        "triggerTimes": {
          "item": [
            {
              "mode": "everyX",
              "value": 5,
              "unit": "minutes"
            }
          ]
        }
      },
      "name": "Cron",
      "type": "n8n-nodes-base.cron",
      "typeVersion": 1,
      "position": [
        40,
        750
      ]
    }
  ],
  "connections": {
    "GS Read Data2": {
      "main": [
        [
          {
            "node": "Mautic",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Cron": {
      "main": [
        [
          {
            "node": "GS Read Data2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
2 Likes

Thank you so much!
Best regards