Is my customer data kept private in the AI interface?

By default, the skill is configured to redact email addresses and phone numbers in the terminal output to ensure privacy while providing a summary of the sync results.

Does this skill maintain a history of changes?

Yes, every time a record is added or updated, a snapshot is saved to a leads_history table to provide a full audit trail of your CRM data.

What happens if the synchronization fails mid-way?

The skill includes a sync_log table that records the failure status and specific error messages, allowing for easy troubleshooting and partial progress tracking.

How does the skill handle duplicate records?

The skill uses the Zoho Record ID as a primary key and compares the Modified_Time to determine whether to insert a new record or update an existing one.

Zoho CRM Lead Sync

Name: Zoho CRM Lead Sync
Author: brainqub3

bybrainqub3

•

Marketing Automation

Synchronizes Zoho CRM leads into a local SQLite database with automated change detection and full audit history.

The crm-sync skill automates the transfer of lead data from Zoho CRM to a local SQLite environment, facilitating offline analysis and custom business workflows. It intelligently handles data synchronization by performing upserts based on Zoho's modified timestamps, ensuring your local database remains current without redundant processing. Beyond simple data mirroring, the skill maintains a comprehensive audit trail in a history table and logs every sync session's metadata—including record counts and error states—while prioritizing data privacy through redacted reporting of sensitive lead information.

Key Features

01Privacy-Conscious Output: Automatically redacts sensitive fields like emails and phone numbers in command summaries.

0211 GitHub stars

03Automated Lead Synchronization: Fetches and mirrors Zoho CRM records to a local SQLite database.

04Intelligent Change Detection: Uses Zoho modified timestamps to perform efficient upserts and skip unchanged records.

05Detailed Sync Logging: Tracks operation metadata like start/end times, records processed, and detailed error messages.

06Full Audit History: Maintains a historical record of all lead changes including inserts, updates, and deletions.

Use Cases

01Lead Audit Tracking: Monitor how lead data changes over time for compliance or sales performance analysis.

02Business Intelligence Integration: Serve as a data bridge for local reporting dashboards and business automation scripts.

03Offline Lead Analysis: Query CRM data using local SQL tools without exhausting Zoho API limits.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brainqub3/brainqub3 crm-sync

For use in Claude.ai and ChatGPT