Validate & Create LEDGERS Contacts from Google Sheets - n8n Workflow | Neura Market
Validate & Create LEDGERS Contacts from Google Sheets
Automates contact creation in LEDGERS from Google Sheets with name, email, mobile validation, error notifications, and audit trail.
This workflow triggers on new or updated rows in a Google Sheets document every minute, validating contact data before creating records in LEDGERS CRM. It checks for missing names, invalid email/mobile formats using custom code, formats mobile numbers, and routes dynamically: valid data proceeds to LEDGERS API creation; invalid data triggers Gmail error notifications. Extended fields like GSTIN, addresses, and business details can be mapped flexibly.
Benefits include ensured data quality, reduc
Platform
n8n
Category
IT & Development
Price
$19.99
Creator
BestWorkflows
n8n
Google Sheets
LEDGERS
CRM Automation
Data Validation
Error Handling
API Integration
Contact Management
Gmail Notifications
Audit Trail
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.