crm-writer

What problem does it solve?

Enables reliable, auditable reads and writes to the agency CRM so teams can keep lead records, outreach logs, and pipeline stages synchronized without manual spreadsheet edits or inconsistent formats.

Core Features & Use Cases

• Multi-backend support: Operates against Google Sheets using a Google Apps Script webhook or the Google Sheets API with service account credentials.
• CRUD operations: Supports READ, APPEND, UPDATE, and CREATE_TAB with logical-to-physical tab mapping from agency.config.json.
• Data safety & validation: Validates required columns, checks for duplicates by email or URL, enforces header consistency, rate limits writes, and retries on transient errors.
• Use Case: Bulk-ingest scored leads into the "Hawk Leads" sheet via webhook while preventing duplicates and adding timestamps to each row.

Quick Start

Log these 5 scored leads to the Hawk Leads tab in the CRM using the crm-writer skill.