CRM with Deals, Tickets & Campaigns – Google Apps Script

A full CRM running on Google Sheets — leads, deals, accounts, contacts, quotations, support tickets and campaigns — with a Kanban pipeline you drag deals across and a permission matrix you edit yourself. Install it by copying the sheet and deploying the script; there is no server and no subscription.

Permissions without touching code

The part that usually needs a developer is the part you control here. Open Roles and you get a grid: every role down one side, every module across the other, with view, add, edit and delete checkboxes. Give a sales representative view access to automations and it appears in their login; take edit rights off a manager and it disappears from theirs. Changes save to the sheet quietly in the background — no redeploy, no code edit.

The sales flow

A lead arrives and sits in the table or on the Kanban board. Convert it and the system creates the account, contact and deal together, carrying the details across. The deal opens into a panel with its line items, activities, notes and a full history — created, assigned, moved to stage, expected close date — and you drag it between stages as it progresses, or mark it won. Quotations generate straight from a deal, print or download as PDF, and carry a sent / accepted / rejected status.

Highlights

• Email and WhatsApp sent directly from an account or contact row
• Activities with follow-up calls, due dates and today / overdue / this-week filters
• Support tickets with priority, category, assignment, tags and reopen
• Campaigns with budgeted versus actual cost, expected revenue and bulk member adding
• Daily activity and ticket reminders, plus a daily pipeline digest email, on triggers you install from settings
• Editable email templates for lead follow-up, quotation sent, result and onboarding
• Branding, colours, currency, timezone, date format, rows per page and fiscal year start all configurable

Who it is for

Small sales teams and agencies who want a real pipeline with roles and automation, but whose data belongs in a sheet they own rather than in a per-seat SaaS they rent.