Validate and create LEDGERS contacts from Google Sheets with error handling
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 14 nodes and runs on Google Sheets events. Along the way it connects Google Sheets, Gmail and Ledgers Cloud (community).
How it runs
Trigger: On Google Sheets events.
- Contact Name Validation (If): checks a condition and branches into true / false
- Email & Mobile Format Checker (Code): runs custom JavaScript code
- Contact Name Error Mail Trigger (Gmail): uses Gmail
- Email & Mobile Validator (If): checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Email/Mobile Error Mail Trigger (Gmail): uses Gmail
- Mobile Formatter (Code): runs custom JavaScript code
- Ledgers: uses Ledgers
- Contact Creation Validator (If): checks a condition and branches into true / false
- Get Created Time (Code): runs custom JavaScript code
…plus 2 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 @ledgers/n8n-nodes-ledgers-cloud is verified or supports 3.0 (used in LEDGERS).
Nodes used (8)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Ledgers
@ledgers/n8n-nodes-ledgers-cloud.ledgers - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Before Using this Template first search LEDGERS in the nodes list and Update! The workflow automates contact creation in LEDGERS from a Google Sheets document, while performing validation checks on contact data to ensure data quality. Key Features: ✅ Google…