Coda-Based Integrated CRM for Clinic Operations
Centro de Psicología Sandra Ribeiro — Systems Architect
As the clinic grew, managing patient sessions, therapist coordination, billing, documentation, and communications across disconnected platforms became unsustainable and error-prone.
The clinic needed a scalable, fully integrated CRM solution to consolidate administrative, therapist, and management workflows, while ensuring data security, operational efficiency, and seamless integration with external services.
- Designed and built a multi-role CRM system entirely in Coda, supporting psychologists, administrative staff, management, and communications.
- Integrated external platforms including Google Calendar, Google Drive, the internal signature system, and Slack into operational workflows.
- Developed modules for patient intake, therapy session scheduling, session notes, payment tracking, invoicing, supervision tracking, and HR management.
- Implemented role-based access permissions to ensure patient confidentiality and operational clarity.
- Established automated workflows for session reminders, document management, and team communications.
- Led full team training and onboarding to ensure rapid adoption and minimal disruption.
- Centralized all clinic operations into a single, easily accessible platform, reducing administrative time and errors.
- Achieved seamless data flow between therapy sessions, billing, HR processes, and communication tools.
- Enabled real-time operational tracking for management without breaching patient confidentiality.
- Increased therapist and administrative staff satisfaction by reducing manual and duplicated tasks.
Personal Productivity System with Gamification and Workflow Automation
Freelancer — Systems Architect
To manage ADHD-related executive function challenges and maintain sustainable productivity, I designed and implemented a modular, gamified productivity system that evolved into a fully automated behavioral tool.
Traditional productivity tools (planners, calendars, to-do apps) failed to drive consistent engagement or match fluctuating energy levels.
The opportunity was to design a self-regulating, gamified system that would make task completion intrinsically motivating — using automation to remove friction and decision fatigue.
- Designed a point-based RPG system to reward tasks based on effort, urgency, and long-term impact.
- Created task categories and streak mechanics to drive daily consistency and long-term progression.
- Automated score updates, habit tracking, and daily reset logic using Coda formulas and button-based logic.
- Developed iOS Shortcuts to push screenshots from Goodnotes directly into the system for task parsing.
- Integrated AI-assisted classification to extract tasks from notes and update the task database automatically.
- Iterated weekly challenge mechanics, status effects (energy, focus), and milestone rewards to reinforce behavior loops.
- Significantly increased consistency in task execution, especially on high-cognitive-load or ambiguous tasks.
- Reduced friction in daily planning through fully automated pipeline from notes to tasks.
- Demonstrated the ability to design closed feedback systems that drive user behavior over time.
- Built a reusable architecture for productivity gamification that mirrors user engagement frameworks in commercial products.
Coda-Based Accounting System with Multi-Table Sync and Automation
Centro de Psicología Sandra Ribeiro — Systems Architect
As the clinic scaled, financial tracking became fragmented across spreadsheets, invoices, and session logs.
There was an urgent need for a unified accounting system to track revenue and expenses across therapists, session types, and payment sources — while ensuring data integrity and auditability.
Existing tools couldn’t connect session records, payments, invoices, and supervision tracking into a coherent, flexible financial overview.
Manual entry created duplication risk, poor traceability, and no real-time visibility into financial health.
The opportunity was to design a live, low-maintenance, auditable accounting system built entirely in Coda.
- Designed the system architecture to consolidate financial data from multiple service lines and workflows into a single source of truth.
- Implemented automated logic to sync and categorize income and expenses based on operational activity.
- Built custom interfaces to allow the administrative team to manage finances with minimal manual input or duplication.
- Ensured traceability between financial records and their operational origin (sessions, supervisions, payroll, etc.).
- Structured the system to support accurate forecasting, tax preparation, and performance reporting.
- Replaced fragmented financial tracking with a unified, real-time accounting system.
- Reduced manual workload and error rates in financial reporting.
- Enabled strategic oversight of the clinic’s revenue streams, costs, and category-level performance.
- Created a scalable foundation for further automation (e.g., invoicing, digital signatures, external integrations).