AutomationFlowsData & Sheets › Appsignups

Appsignups

AppSignups. Uses googleSheets. Webhook trigger; 4 nodes.

Webhook trigger★★☆☆☆ complexity4 nodesGoogle Sheets
Data & Sheets Trigger: Webhook Nodes: 4 Complexity: ★★☆☆☆ Added:

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
{
  "updatedAt": "2026-05-10T00:08:24.470Z",
  "createdAt": "2026-01-04T00:37:36.306Z",
  "id": "ZIqLGdvpuQRGveHM",
  "name": "AppSignups",
  "active": true,
  "isArchived": false,
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "app_signups",
        "authentication": "headerAuth",
        "options": {}
      },
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2.1,
      "position": [
        0,
        80
      ],
      "id": "243d0681-9ad7-4e8a-8444-39f334ac59d2",
      "name": "Webhook",
      "credentials": {
        "httpHeaderAuth": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "1MeJFGNBPFgkfg5kIZg1q1fNL-iC3gKPHoWRowWwJcls",
          "mode": "list",
          "cachedResultName": "Megyk App Signups",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MeJFGNBPFgkfg5kIZg1q1fNL-iC3gKPHoWRowWwJcls/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "Sheet1",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MeJFGNBPFgkfg5kIZg1q1fNL-iC3gKPHoWRowWwJcls/edit#gid=0"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "email": "={{ $json.body.email }}",
            "event": "={{ $json.body.event }}",
            "date_signed_up": "={{ $now.format('y-MM-dd hh:mm a') }}",
            "utm_source": "={{ $json.body.utm.utm_source || '' }}",
            "utm_medium": "={{ $json.body.utm.utm_medium || '' }}",
            "utm_campaign": "={{ $json.body.utm.utm_campaign|| ''  }}",
            "utm_content": "={{ $json.body.utm.utm_content || '' }}",
            "utm_term": "={{ $json.body.utm.utm_term || '' }}"
          },
          "matchingColumns": [],
          "schema": [
            {
              "id": "email",
              "displayName": "email",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "event",
              "displayName": "event",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true,
              "removed": false
            },
            {
              "id": "utm_source",
              "displayName": "utm_source",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "utm_medium",
              "displayName": "utm_medium",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "utm_content",
              "displayName": "utm_content",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "utm_term",
              "displayName": "utm_term",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "utm_campaign",
              "displayName": "utm_campaign",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "date_signed_up",
              "displayName": "date_signed_up",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {}
      },
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,
      "position": [
        448,
        -48
      ],
      "id": "c8cd1d45-31f2-47fb-a9a2-f7a29febc553",
      "name": "Append row in sheet",
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "workflowId": {
          "__rl": true,
          "value": "qjvsvAd7YcchJ1eF",
          "mode": "list",
          "cachedResultUrl": "/workflow/qjvsvAd7YcchJ1eF",
          "cachedResultName": "EmailDrip"
        },
        "workflowInputs": {
          "mappingMode": "defineBelow",
          "value": {
            "email": "={{ $json.email || $json.body.email}}"
          },
          "matchingColumns": [
            "email"
          ],
          "schema": [
            {
              "id": "email",
              "displayName": "email",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "canBeUsedToMatch": true,
              "type": "string",
              "removed": false
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        },
        "options": {}
      },
      "type": "n8n-nodes-base.executeWorkflow",
      "typeVersion": 1.3,
      "position": [
        672,
        80
      ],
      "id": "d940cbc0-d9cc-437a-b34c-093911778888",
      "name": "Call 'EmailDrip'"
    },
    {
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true,
            "leftValue": "",
            "typeValidation": "strict",
            "version": 3
          },
          "conditions": [
            {
              "id": "843cff1d-bcac-45dc-800a-ba30d72fca0f",
              "leftValue": "={{ $json.body.event }}",
              "rightValue": "user_verified",
              "operator": {
                "type": "string",
                "operation": "equals"
              }
            }
          ],
          "combinator": "and"
        },
        "options": {}
      },
      "type": "n8n-nodes-base.if",
      "typeVersion": 2.3,
      "position": [
        224,
        80
      ],
      "id": "17412da7-b3b2-4278-b498-dc31e1ee671a",
      "name": "If"
    }
  ],
  "connections": {
    "Webhook": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append row in sheet": {
      "main": [
        [
          {
            "node": "Call 'EmailDrip'",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Call 'EmailDrip'",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1",
    "availableInMCP": false,
    "binaryMode": "separate"
  },
  "staticData": null,
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "versionId": "5fd3c443-3203-495e-8725-9dcf6cf3865d",
  "activeVersionId": "fe70f472-56ac-43b8-ae4c-ef1fa740877c",
  "triggerCount": 1,
  "shared": [
    {
      "updatedAt": "2026-01-04T00:37:36.319Z",
      "createdAt": "2026-01-04T00:37:36.319Z",
      "role": "workflow:owner",
      "workflowId": "ZIqLGdvpuQRGveHM",
      "projectId": "B7QJE85HA2Vij1it"
    }
  ],
  "activeVersion": {
    "updatedAt": "2026-03-30T15:10:11.000Z",
    "createdAt": "2026-03-30T15:10:00.906Z",
    "versionId": "fe70f472-56ac-43b8-ae4c-ef1fa740877c",
    "workflowId": "ZIqLGdvpuQRGveHM",
    "nodes": [
      {
        "parameters": {
          "httpMethod": "POST",
          "path": "app_signups",
          "options": {}
        },
        "type": "n8n-nodes-base.webhook",
        "typeVersion": 2.1,
        "position": [
          0,
          80
        ],
        "id": "243d0681-9ad7-4e8a-8444-39f334ac59d2",
        "name": "Webhook",
        "webhookId": "60f5c04f-4e0c-4da9-86f7-095cc2ba5449"
      },
      {
        "parameters": {
          "operation": "append",
          "documentId": {
            "__rl": true,
            "value": "1MeJFGNBPFgkfg5kIZg1q1fNL-iC3gKPHoWRowWwJcls",
            "mode": "list",
            "cachedResultName": "Megyk App Signups",
            "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MeJFGNBPFgkfg5kIZg1q1fNL-iC3gKPHoWRowWwJcls/edit?usp=drivesdk"
          },
          "sheetName": {
            "__rl": true,
            "value": "gid=0",
            "mode": "list",
            "cachedResultName": "Sheet1",
            "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MeJFGNBPFgkfg5kIZg1q1fNL-iC3gKPHoWRowWwJcls/edit#gid=0"
          },
          "columns": {
            "mappingMode": "defineBelow",
            "value": {
              "email": "={{ $json.body.email }}",
              "event": "={{ $json.body.event }}",
              "date_signed_up": "={{ $now.format('y-MM-dd hh:mm a') }}",
              "utm_source": "={{ $json.body.utm.utm_source || '' }}",
              "utm_medium": "={{ $json.body.utm.utm_medium || '' }}",
              "utm_campaign": "={{ $json.body.utm.utm_campaign|| ''  }}",
              "utm_content": "={{ $json.body.utm.utm_content || '' }}",
              "utm_term": "={{ $json.body.utm.utm_term || '' }}"
            },
            "matchingColumns": [],
            "schema": [
              {
                "id": "email",
                "displayName": "email",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true
              },
              {
                "id": "event",
                "displayName": "event",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true,
                "removed": false
              },
              {
                "id": "utm_source",
                "displayName": "utm_source",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true
              },
              {
                "id": "utm_medium",
                "displayName": "utm_medium",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true
              },
              {
                "id": "utm_content",
                "displayName": "utm_content",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true
              },
              {
                "id": "utm_term",
                "displayName": "utm_term",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true
              },
              {
                "id": "utm_campaign",
                "displayName": "utm_campaign",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true
              },
              {
                "id": "date_signed_up",
                "displayName": "date_signed_up",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "type": "string",
                "canBeUsedToMatch": true
              }
            ],
            "attemptToConvertTypes": false,
            "convertFieldsToString": false
          },
          "options": {}
        },
        "type": "n8n-nodes-base.googleSheets",
        "typeVersion": 4.7,
        "position": [
          448,
          -48
        ],
        "id": "c8cd1d45-31f2-47fb-a9a2-f7a29febc553",
        "name": "Append row in sheet",
        "credentials": {
          "googleSheetsOAuth2Api": {
            "id": "qJ5ck4AVx9Jx37Fr",
            "name": "Google Sheets account"
          }
        }
      },
      {
        "parameters": {
          "workflowId": {
            "__rl": true,
            "value": "qjvsvAd7YcchJ1eF",
            "mode": "list",
            "cachedResultUrl": "/workflow/qjvsvAd7YcchJ1eF",
            "cachedResultName": "EmailDrip"
          },
          "workflowInputs": {
            "mappingMode": "defineBelow",
            "value": {
              "email": "={{ $json.email || $json.body.email}}"
            },
            "matchingColumns": [
              "email"
            ],
            "schema": [
              {
                "id": "email",
                "displayName": "email",
                "required": false,
                "defaultMatch": false,
                "display": true,
                "canBeUsedToMatch": true,
                "type": "string",
                "removed": false
              }
            ],
            "attemptToConvertTypes": false,
            "convertFieldsToString": true
          },
          "options": {}
        },
        "type": "n8n-nodes-base.executeWorkflow",
        "typeVersion": 1.3,
        "position": [
          672,
          80
        ],
        "id": "d940cbc0-d9cc-437a-b34c-093911778888",
        "name": "Call 'EmailDrip'"
      },
      {
        "parameters": {
          "conditions": {
            "options": {
              "caseSensitive": true,
              "leftValue": "",
              "typeValidation": "strict",
              "version": 3
            },
            "conditions": [
              {
                "id": "843cff1d-bcac-45dc-800a-ba30d72fca0f",
                "leftValue": "={{ $json.body.event }}",
                "rightValue": "user_verified",
                "operator": {
                  "type": "string",
                  "operation": "equals"
                }
              }
            ],
            "combinator": "and"
          },
          "options": {}
        },
        "type": "n8n-nodes-base.if",
        "typeVersion": 2.3,
        "position": [
          224,
          80
        ],
        "id": "17412da7-b3b2-4278-b498-dc31e1ee671a",
        "name": "If"
      }
    ],
    "connections": {
      "Webhook": {
        "main": [
          [
            {
              "node": "If",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "Append row in sheet": {
        "main": [
          [
            {
              "node": "Call 'EmailDrip'",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "If": {
        "main": [
          [
            {
              "node": "Append row in sheet",
              "type": "main",
              "index": 0
            }
          ],
          [
            {
              "node": "Call 'EmailDrip'",
              "type": "main",
              "index": 0
            }
          ]
        ]
      }
    },
    "nodeGroups": [],
    "authors": "Gordan Kljajic",
    "name": "Version fe70f472",
    "description": "",
    "autosaved": true
  },
  "tags": []
}

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

AppSignups. Uses googleSheets. Webhook trigger; 4 nodes.

Source: https://github.com/adamhaley/megyk-automations/blob/40e3f39df81f4b9fb9eb23e3deaba682f206d706/workflows/AppSignups.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.

Data & Sheets

Track how many coffees your Jura E8 espresso machine makes — fully automated via webhook and Google Sheets.

Google Sheets
Data & Sheets

This workflow receives a document via a secure webhook, uploads it to Parseur for parsing, polls Parseur until the parsing completes or times out, and returns either the extracted JSON result or a str

N8N Nodes Parseur, Google Sheets
Data & Sheets

BARIN ALP - Inventory CRUD. Uses googleSheets. Webhook trigger; 9 nodes.

Google Sheets
Data & Sheets

Get Orders API. Uses googleSheets, errorTrigger. Webhook trigger; 8 nodes.

Google Sheets, Error Trigger
Data & Sheets

This workflow converts an exported CSV from Squarespace profiles into a Shopify-compatible format for customer import.

Google Sheets