This workflow follows the HTTP Request → Postgres recipe pattern — see all workflows that pair these two integrations.
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": "Mercado Pago - Assinatura com init_point e Webhook",
"nodes": [
{
"parameters": {},
"id": "webhook-trigger",
"name": "Webhook - Criar Assinatura",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
250,
300
]
},
{
"parameters": {
"resource": "subscriptions",
"operation": "create",
"planId": "={{ $json.body.planId }}",
"payerEmail": "={{ $json.body.payerEmail }}",
"payerDocument": "={{ $json.body.payerDocument }}",
"subscriptionStatus": "={{ $json.body.subscriptionStatus || 'pending' }}",
"cardTokenId": "={{ $json.body.cardTokenId || '' }}",
"startDate": "={{ $json.body.startDate }}",
"trialPeriodDays": "={{ $json.body.trialPeriodDays || 0 }}"
},
"id": "mercado-pago-create-subscription",
"name": "Criar Assinatura",
"type": "n8n-nodes-mercadopago-flow.mercadoPago",
"typeVersion": 1,
"position": [
450,
300
],
"credentials": {
"mercadoPagoApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.status }}",
"value2": "pending"
}
]
}
},
"id": "check-status",
"name": "Verificar Status",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
650,
300
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "init-point",
"name": "initPoint",
"value": "={{ $json.initPoint }}",
"type": "string"
},
{
"id": "subscription-id",
"name": "subscriptionId",
"value": "={{ $json.id }}",
"type": "string"
},
{
"id": "status",
"name": "status",
"value": "={{ $json.status }}",
"type": "string"
},
{
"id": "message",
"name": "message",
"value": "Assinatura criada com sucesso! Use o init_point para completar o pagamento.",
"type": "string"
}
]
}
},
"id": "format-pending-response",
"name": "Formatar Resposta (Pending)",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
850,
200
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "subscription-id",
"name": "subscriptionId",
"value": "={{ $json.id }}",
"type": "string"
},
{
"id": "status",
"name": "status",
"value": "={{ $json.status }}",
"type": "string"
},
{
"id": "message",
"name": "message",
"value": "Assinatura criada e ativada com sucesso!",
"type": "string"
},
{
"id": "next-payment",
"name": "nextPaymentDate",
"value": "={{ $json.nextPaymentDate }}",
"type": "string"
}
]
}
},
"id": "format-authorized-response",
"name": "Formatar Resposta (Authorized)",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
850,
400
]
},
{
"parameters": {
"options": {
"responseCode": 200,
"responseBody": "={{ $json }}"
}
},
"id": "respond-webhook",
"name": "Responder Webhook",
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1,
"position": [
1050,
300
]
},
{
"parameters": {},
"id": "webhook-notification",
"name": "Webhook - Notifica\u00e7\u00e3o Mercado Pago",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
250,
600
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.body.type }}",
"value2": "subscription_preapproval"
}
]
}
},
"id": "check-notification-type",
"name": "Verificar Tipo de Notifica\u00e7\u00e3o",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
450,
600
]
},
{
"parameters": {
"resource": "subscriptions",
"operation": "get",
"subscriptionId": "={{ $json.body.data.id }}"
},
"id": "get-subscription-details",
"name": "Consultar Assinatura",
"type": "n8n-nodes-mercadopago-flow.mercadoPago",
"typeVersion": 1,
"position": [
650,
500
],
"credentials": {
"mercadoPagoApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.status }}",
"value2": "authorized"
}
]
}
},
"id": "check-if-authorized",
"name": "Status \u00e9 Authorized?",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
850,
500
]
},
{
"parameters": {
"method": "POST",
"url": "={{ $env.EMAIL_SERVICE_URL || 'https://seu-servico-email.com/send' }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "to",
"value": "={{ $json.payerEmail }}"
},
{
"name": "subject",
"value": "Assinatura Ativada com Sucesso!"
},
{
"name": "body",
"value": "Sua assinatura foi ativada com sucesso! ID: {{ $json.id }}"
}
]
},
"options": {}
},
"id": "send-email",
"name": "Enviar Email de Confirma\u00e7\u00e3o",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
1050,
400
],
"notes": "Opcional: Configure seu servi\u00e7o de email ou remova este n\u00f3"
},
{
"parameters": {
"operation": "update",
"resource": "database",
"table": "subscriptions",
"updateKey": "id",
"columns": {
"mappingMode": "defineBelow",
"value": {
"id": "={{ $json.id }}",
"status": "={{ $json.status }}",
"nextPaymentDate": "={{ $json.nextPaymentDate }}",
"updatedAt": "={{ $now.toISO() }}"
}
}
},
"id": "update-database",
"name": "Atualizar Banco de Dados",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.4,
"position": [
1050,
600
],
"notes": "Opcional: Configure seu banco de dados ou remova este n\u00f3"
},
{
"parameters": {
"options": {
"responseCode": 200
}
},
"id": "respond-webhook-notification",
"name": "Responder Webhook (Notifica\u00e7\u00e3o)",
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1,
"position": [
1250,
500
]
}
],
"connections": {
"Webhook - Criar Assinatura": {
"main": [
[
{
"node": "Criar Assinatura",
"type": "main",
"index": 0
}
]
]
},
"Criar Assinatura": {
"main": [
[
{
"node": "Verificar Status",
"type": "main",
"index": 0
}
]
]
},
"Verificar Status": {
"main": [
[
{
"node": "Formatar Resposta (Pending)",
"type": "main",
"index": 0
}
],
[
{
"node": "Formatar Resposta (Authorized)",
"type": "main",
"index": 0
}
]
]
},
"Formatar Resposta (Pending)": {
"main": [
[
{
"node": "Responder Webhook",
"type": "main",
"index": 0
}
]
]
},
"Formatar Resposta (Authorized)": {
"main": [
[
{
"node": "Responder Webhook",
"type": "main",
"index": 0
}
]
]
},
"Webhook - Notifica\u00e7\u00e3o Mercado Pago": {
"main": [
[
{
"node": "Verificar Tipo de Notifica\u00e7\u00e3o",
"type": "main",
"index": 0
}
]
]
},
"Verificar Tipo de Notifica\u00e7\u00e3o": {
"main": [
[
{
"node": "Consultar Assinatura",
"type": "main",
"index": 0
}
]
]
},
"Consultar Assinatura": {
"main": [
[
{
"node": "Status \u00e9 Authorized?",
"type": "main",
"index": 0
}
]
]
},
"Status \u00e9 Authorized?": {
"main": [
[
{
"node": "Enviar Email de Confirma\u00e7\u00e3o",
"type": "main",
"index": 0
},
{
"node": "Atualizar Banco de Dados",
"type": "main",
"index": 0
}
]
]
},
"Enviar Email de Confirma\u00e7\u00e3o": {
"main": [
[
{
"node": "Responder Webhook (Notifica\u00e7\u00e3o)",
"type": "main",
"index": 0
}
]
]
},
"Atualizar Banco de Dados": {
"main": [
[
{
"node": "Responder Webhook (Notifica\u00e7\u00e3o)",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"tags": [],
"triggerCount": 0,
"updatedAt": "2024-01-01T12:00:00.000Z",
"versionId": "1"
}
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.
mercadoPagoApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Mercado Pago - Assinatura com init_point e Webhook. Uses n8n-nodes-mercadopago-flow, httpRequest, postgres. Webhook trigger; 13 nodes.
Source: https://github.com/eliveutonsouza/n8n-nodes-mercadopago-flow/blob/main/exemplos/03-assinaturas-com-init-point.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
CMM. Uses httpRequest, postgres, redis. Webhook trigger; 90 nodes.
HTTP Request, Postgres, Redis
Scraping. Uses httpRequest, postgres, @apify/n8n-nodes-apify, respondToWebhook. Webhook trigger; 61 nodes.
HTTP Request, Postgres, @Apify/N8N Nodes Apify
Workflow B — AI Listing Engine. Uses httpRequest, postgres, errorTrigger. Webhook trigger; 47 nodes.
HTTP Request, Postgres, Error Trigger
LogSentinel Workflow. Uses postgres, emailSend, httpRequest. Webhook trigger; 44 nodes.
Postgres, Email Send, HTTP Request
Post-Prayer. Uses postgres, httpRequest. Webhook trigger; 44 nodes.
Postgres, HTTP Request