The verdict in three sentences
If you are an administrative officer at a cooperative union in Bobo-Dioulasso, compiling your producer groups' monthly data is the easiest task in your job to automate: 2 to 3 days of data entry per month can shrink to half a day of checking. The tools you need are free or under 10,000 FCFA a month (about EUR 15), and no code is required. What is usually missing is the method to connect forms, spreadsheet, AI and automatic sending without losing the reliability partners demand.
What can be automated in your monthly report
A union grouping 40 cotton and mango producer groups must send clean figures every month to its partners: Sofitex, dried mango exporters, NGOs and funded projects. Today, data arrives through WhatsApp messages, photographed notebooks and phone calls. The clerk copies, recalculates, formats and then writes a commentary. Here is what changes with an automated chain.
| Monthly task | Manual method | Automated method | Manual time | Automated time |
|---|---|---|---|---|
| Collecting volumes per group | Calls and WhatsApp messages | Google Form or KoboToolbox filled in by each group secretary | 8 to 10 h | 1 h of reminders |
| Entering data in the sheet | Line-by-line copying | Answers flow automatically into Google Sheets | 4 to 6 h | 0 h |
| Checks (duplicates, outliers) | Visual proofreading | Validation rules and email alert | 2 h | 15 min |
| Calculations (tonnages, average prices, bonuses) | Calculator and copy-paste | Formulas and pivot table | 2 to 3 h | 0 h |
| Report commentary | Written by hand | Draft written by AI, reviewed by you | 2 h | 30 min |
| Sending to partners | Emails one by one | Make scenario that builds the PDF and sends it after your approval | 1 h | 10 min |
| Total | 19 to 24 h | about 2 h |
The human stays in the loop where it matters: approving the report before sending, and checking the figures used to pay producers.
What it costs in 2026 and what it can earn you
| Item | Option | 2026 cost (order of magnitude) |
|---|---|---|
| Forms | Google Forms or KoboToolbox | 0 FCFA |
| Spreadsheet | Google Sheets | 0 FCFA |
| Automation | Make, free plan (1,000 operations/month) or paid | 0 to 6,500 FCFA/month |
| AI assistant | Free plan or individual subscription | 0 to 13,000 FCFA/month |
| Internet | Orange or Moov mobile data bundle | 5,000 to 10,000 FCFA/month |
| In-person training in Ouagadougou (2 to 3 days) | Travel and lodging on top | 150,000 to 300,000 FCFA |
| Free YouTube tutorials | No corrected exercises, no certificate | 0 FCFA, several weeks of trial and error |
| Kolonell level 4 course | 20 h online, 8 projects, certificate | 100,000 FCFA (about EUR 152) |
On earnings, let's be honest: nothing is guaranteed. As a 2026 order of magnitude, an administrative profile who automates reports can negotiate a bonus of 15,000 to 40,000 FCFA a month or a move to a monitoring and evaluation officer role, often paid 250,000 to 450,000 FCFA a month in unions and funded projects in Bobo-Dioulasso. As freelance work, a simple automation for another cooperative or SME is commonly billed 150,000 to 400,000 FCFA.
The recommended course and where it fits in the track
The course Automate your work with AI, without writing code, taught in French, matches this need exactly: level 4 Intermediate, 100,000 FCFA, 20 hours, 8 modules, 99 corrected exercises and 8 projects to submit. You build custom assistants, process more than 200 rows in Google Sheets with AI, set up Make and Zapier scenarios including one with human approval, and document a complete process with its monthly cost. Personal data protection is covered, which matters when your files contain producers' names and phone numbers.
| Level of the Artificial Intelligence track | What you learn |
|---|---|
| Levels 1 to 2 | Using AI assistants well every day |
| Level 3 | Generative AI for professionals, first simple scenario |
| Level 4 | Automate your work with AI, no code (this course) |
| Level 5 | AI consultant: sell, scope and deliver engagements |
If you are starting from scratch, the full 5-level track costs 350,000 FCFA instead of 450,000 FCFA. A computer is required; a mobile connection is enough to follow the lessons.
Mini case study
Learn this skill with Kolonell Academy
Short, practical online courses (taught in French), graded exercises, certificate. Pay with Wave or Orange Money.
Salif, 29, an administrative officer at a cooperative union in Bobo-Dioulasso, earns 180,000 FCFA a month and spends 22 hours each month on the report for 40 producer groups. He takes the course for 100,000 FCFA, paid with Orange Money, and within a month sets up one form per group, a validated Google Sheet and a Make scenario that sends the report after his approval. The report now takes him about 3 hours: he wins back 19 hours a month, which he spends on following up quality bonuses. His union grants him a 25,000 FCFA monthly bonus for data reliability. The course pays for itself in 4 months, not counting a possible first freelance job at 200,000 FCFA for a neighbouring union, which would repay it in a single engagement. These amounts are orders of magnitude, not a promise.
FAQ
Do I need to know how to code to take this course?
No. Being able to fill in a Google Form and build a table is enough. The 20 hours are built around no-code tools such as Google Sheets, Make, Zapier and AI assistants.
Can producer groups without internet send their data?
Yes, with an offline form such as KoboToolbox, filled in on a phone and synced as soon as there is network. An entry-level smartphone at about 50,000 FCFA per group secretary is enough.
How much do the tools cost each month?
For 40 groups and one monthly report, free plans are often enough: 0 FCFA. If volumes grow, plan for under 10,000 FCFA a month for a paid automation plan, excluding internet.
How do I pay for the course from Burkina Faso?
Payment is made with Wave or Orange Money, in one go: 100,000 FCFA for this level 4. The full 5-level track costs 350,000 FCFA instead of 450,000 FCFA.
Is the certificate recognised by partners?
It is a Kolonell certificate verifiable online, not a state diploma. Your portfolio of 8 documented automations often speaks louder to an employer or project than a piece of paper.
Take the next step. Enroll in Automate your work with AI, without writing code: 20 hours, 100,000 FCFA, Kolonell certificate verifiable online, taught in French. Pay with Wave or Orange Money. Questions? WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
