Google Sheets + Apps Script: the Senegalese SME's secret weapon in 2026

The most underrated tool in the African market

Everyone talks about Airtable, Notion, Bubble. But the most used tool by SMEs we meet in Dakar, Saint-Louis and Thiès remains Google Sheets. Free (or bundled in Workspace at ~ 4,000 FCFA / user / month), familiar, accessible from any phone, it also has a superpower few use seriously: Apps Script.

Apps Script is a programming language (JavaScript-based) bundled for free into the entire Google suite. With a few dozen lines, you turn Sheets into a mini-ERP, automate PDF quote sending, scrape data, alert your sales reps on WhatsApp. All without paying an extra subscription.

At Kolonell we've deployed it at 9 SMEs in 18 months — measured results below.

Why it still beats premium no-code in 2026

Critical point: your team ALREADY knows Google Sheets. No training, no change resistance. It's the default-adopted tool in Senegal after WhatsApp.

6 scripts ready to deploy in a Senegalese SME

Script 1: Automatic PDF quote from Sheets

A "Quotes" sheet with columns (client, amount, date). A "Generate PDF" button → Apps Script copies a Google Doc template, fills the fields, exports to PDF, saves to Drive, and emails the client. Time saved: 20 minutes per quote.

Script 2: WhatsApp alert via API on new lead

A Google Form fills a sheet. onFormSubmit trigger → call WhatsApp Cloud API → notification to the right sales rep in under 10 seconds. Cost: 0 FCFA if you stay under 1,000 messages / month (Meta free tier).

Script 3: Bidirectional sync with Wave Business

Wave webhook → Apps Script (deployed as Web App) receives the payload → updates the "Payments" sheet → recomputes monthly total → sends a Sunday-night recap to the manager.

Script 4: Graduated overdue invoice reminders

Every day at 7am, a trigger walks the "Invoices" sheet and automatically sends the right reminder email based on overdue age. Uses MailApp.sendEmail (limited to 100 emails / day on free, 1,500 on Workspace).

Script 5: Weekly report in a Google Slides deck

Every Monday at 6am: Apps Script reads weekly KPIs, updates a Google Slides template's charts, exports to PDF, sends to leadership. One logistics SME replaced 3 weekly hours of manual reporting with this script.

Script 6: Smart CRM anti-duplicate

When a new lead arrives, the script checks by normalised phone number (handling +221 prefixes, spaces, dashes) whether the contact already exists. Catches duplicates Sheets misses by default.

Real total cost for a 10-person SME

• Google Workspace Business Starter: ~ 4,000 FCFA / user / month × 10 = 40,000 FCFA / month
• Apps Script: 0 FCFA (included)
• Initial setup (audit + 6 scripts): 350,000 to 800,000 FCFA with a serious integrator
• Quarterly maintenance: 75,000 FCFA / quarter

Compare with an equivalent Airtable + Make stack at 120,000 to 250,000 FCFA / month.

Real case: Dakar consulting firm

22 collaborators, ~ 80 client engagements / year. Before: Excel + emails + Trello = chronic loss of visibility. We deployed in 3 weeks:

• A "Pipeline" sheet with Kanban automation via filters
• Auto PDF quote generation (script 1)
• Slack alert when a quote sits unsigned > 7 days (adapted script 2)
• Weekly billable hours dashboard (script 5)

Result 4 months later: invoicing moved from 38 M to 51 M FCFA / quarter. Not magical — just fewer forgotten quotes and better visibility on capacity.

Honest limits

• Apps Script quotas: 6 min / execution, 30 emails / day on free. For high volumes, you need Workspace and sometimes to split scripts.
• No true relations: Sheets is still a spreadsheet, not a DB. Beyond 5 linked sheets it gets clunky. Migrate to Airtable.
• Tricky versioning: a collaborator can break a script. Always version via Apps Script GitHub CLI ('clasp').
• Performance: > 50,000 rows, Sheets slows noticeably.

Our recommendation

For an SME < 15 people with a tight budget: Google Sheets + Apps Script is the most cost-effective choice in 2026. You get 70% of a premium stack's benefits for 15% of the cost.

For an SME > 30 people or with significant structured data: progressively migrate to Airtable + Make while keeping Sheets as a fast "Swiss army knife".

For a large enterprise: Sheets is great for ad-hoc analysis, but the business ERP must live elsewhere.

Best for: SMEs that want to automate without changing ecosystem. Avoid if: you need very granular per-record permissions — Sheets only handles permissions per sheet, not per row.

We deploy this stack in 2 to 4 weeks. WhatsApp +221 77 596 93 33 or free brief at /en/free-quote — we scope your case in 30 minutes.

FAQ

Is Apps Script really free?

Yes, completely, as long as you stay within quotas (6 min / execution, 30 emails / day on standard gmail, 1,500 emails / day on Workspace). For 95% of SME cases, that's plenty.

Do I need to know how to code to deploy Apps Script?

Better. But 2026 changed the game: with Claude or ChatGPT, a non-developer manager can generate a clean script in 30 minutes for simple cases. For production, we still recommend a developer for robustness.

Can Google Sheets replace a real CRM?

For < 500 active contacts and a 5-8 person sales team: yes, easily. Beyond that, it cracks. Typical migration threshold to Hubspot, Pipedrive or Airtable sits around 1,000 active contacts or 12 users.

Can I connect Apps Script to Wave Business?

Yes via UrlFetchApp (HTTP calls) + Wave webhook inbound. We've delivered 4 Wave-Sheets integrations in 2025-2026. The pattern holds as long as volume stays under 500 transactions / day.