The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Your CRM can't do math. This one couldn't either.
An insurance advisory firm pays its referral partners under four different commission rules. It was all tracked in an Excel sheet, and every partner needed an email with their total and the clients they referred.
GoHighLevel can't add up amounts across several opportunities on its own. The obvious fix, a Custom Code step, is a premium feature they don't have, and the script they had in mind used GHL's old v1 API, which is past end of support.
So I built it outside GHL:
→ A small scheduled job reads the Referral Payments pipeline every morning
→ It adds up each partner's Pending and Due cards, applying the right rule per group (including a tiered formula for one group)
→ It writes the total and client list onto the partner's contact, then reads it back to confirm it saved
→ Workflows send each partner one email using plain merge fields. No premium actions needed.
A few choices that matter:
• Totals are recalculated from the cards every run, not appended, so a cancelled sale drops out on its own and a paid partner resets to 0
• Manual runs are dry runs by default, so nothing changes by accident
• English and French partners each get their own formatting
• A heartbeat check means a missed run can alert the owner
Tested live on their account: a test card went from Pending to Due to Paid, and the partner's total followed it at every step, back to 0, verified each time. Plus 41 simulated checks on the edge cases.
While I was in there, an audit of their workflows found five bugs, like cards bouncing back to Pending 10 days after moving to Due, and a client's second sale being silently dropped. The fixes are built as drafts for the client to review, with nothing live touched.
If your CRM still needs a spreadsheet sitting next to it, that's usually fixable. Free 30-minute automation audit: cal.com/jubril-toheeb-rgh9vp/30min
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Most people open Google Sheets to handle monthly budgets, invoices, or attendance logs. I wanted to see if spreadsheet cells could work as an actual computer chip. That led to SSX Silicon 1, a working 32-bit computer processor built inside a single Google Sheets workbook. It runs with 32 registers, a 16-kilobyte memory space, 36 instructions, and a 32 by 32 pixel color display. The sheet does not use pre-recorded animations, placeholder numbers, or external file links. Every calculation runs through a five-stage pipeline: fetch, decode, execute, memory access, and writeback.
You can run the processor in two ways. With Google Sheets iterative calculation turned on, toggling a manual clock cell advances the machine cycle by cycle using native circular formulas. For continuous execution, an embedded Google Apps Script V8 engine powers interactive buttons and a custom top menu, running programs at hundreds of instructions per second. The 32-bit arithmetic logic unit handles numbers up to 4.29 billion across 36 instructions, covering arithmetic, division, bit shifting, logic gates, and subroutine branching. It also tracks four hardware status flags on every cycle: Zero, Carry, Sign, and Overflow.
The memory layout organizes a self-contained 16-kilobyte address space across dedicated sheets. This includes 4,096 words of program ROM, 4,096 words of read-and-write data RAM, system I/O registers, and a stack region starting at address 0x3FFF. Thirty-two registers handle active computation: R0 stays fixed at zero, R1 through R27 store math and variables, and R28 through R31 serve as pointers for the frame, stack, return address, and program counter. A dedicated video RAM block at 0x2400 maps directly to a 32 by 32 grid of 1,024 cells, using conditional formatting and a 16-color RGB palette to draw borders, crosshairs, and pixel graphics. I also wrote a Python two-pass assembler that turns human-readable .ssx assembly code into spreadsheet-ready CSV tables, along with interactive HTML architecture diagrams built with Archify.
To make sure the CPU calculates accurately, I tested every instruction against a Python reference emulator across five benchmark programs. The hardware self-test verifies all 32 arithmetic operations, memory reads, and stack frames in 77 cycles, leaving the golden signature 0xCAFEBABE in register R1. A 32-bit Fibonacci program generates 47 terms in RAM up to 1,836,311,903 without rounding or overflow. A prime number sieve finds all 25 primes under 100 using memory arrays, an integer matrix program calculates a 3x3 matrix product, and a graphics routine draws a multicolored geometric crest across 232 lit pixels. The project includes five PDF documents: an academic research paper, an instruction set manual, a microarchitecture specification, a verification report, and a beginner guide. Everything runs in a standard web browser.
For anyone who wants to open the processor in Google Sheets, check out the Python compiler, or read the manuals (including the step-by-step Beginner Guidebook and Research Paper), the full open-source release is available on my GitHub!
Inside the repo, you will find:
The ready-to-import Google Sheets CPU workbook (.xlsx)
The Python assembler & bit-exact reference emulator
Interactive HTML architecture & pipeline diagrams
All 5 PDF manuals and the 5 sample assembly programs
Hi everyone, I’m Dani from Innsbruck, Austria.
I’m a senior full-stack developer and technical consultant with experience in C#/.NET, PHP/Laravel/Symfony, TypeScript/Angular, APIs, SQL, e-commerce and AI integrations.
I enjoy turning business requirements into reliable applications, integrations and practical AI-assisted workflows. I’m currently available for remote freelance collaborations and happy to connect with other builders, founders and teams here on Contra.
Nice to meet you!
contra.com
Danijel Bumbar’s Work | Contra
View Danijel Bumbar’s work on Contra. The Independent-first, commission-free freelance marketplace shaping the future of work.
Nice!
An AI agent that asks before everything is a to-do list with extra steps. One that never asks is an apology email waiting to happen.
Built both for a concept invoice agent. Same 4 late clients, same $3,860. Which one gets to email your clients, A or B?
2 voted
67%
1 voted
33%
3 votes
Closed