Send Mercado Pago billing links and reminders with Google Sheets and Gmail
UnknownWhat this workflow does
This workflow has 17 nodes and runs on Google Sheets events (plus 2 other triggers). Along the way it connects Google Sheets, Gmail and Mercadopago (community).
How it runs
Trigger: On Google Sheets events (plus 2 other triggers).
- Filter: keeps only the items that match a condition
- Fetch Payment Information (HTTP Request): calls an HTTP API
- Read Unpaid Invoices List (Google Sheets): uses Google Sheets
- Batch Process Invoices (Loop Over Items (Split in Batches)): loops over the items in batches
- Verify Payment Success (If): checks a condition and branches into true / false
- Iterate Unpaid Invoices (Loop Over Items (Split in Batches)): loops over the items in batches
- Generate Payment Link (Mercado Pago): uses Mercado Pago
- Retrieve Matching Invoice (Google Sheets): uses Google Sheets
- Dispatch Payment Reminder (Gmail): uses Gmail
- Email Payment Link (Gmail): uses Gmail
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @mercadopago/n8n-nodes-mercadopago is verified or supports 3.0 (used in Generate Payment Link).
Nodes used (10)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Mercado Pago
@mercadopago/n8n-nodes-mercadopago.mercadoPago - Webhook
n8n-nodes-base.webhook - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Filter
n8n-nodes-base.filter - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow monitors a Google Sheets billing queue, creates Mercado Pago payment links for new invoices, emails customers via Gmail, and logs sent links back to Google Sheets, while also handling Mercado Pago webhook notifications to remove…