Basic Coding for Non-Programmers in Nigeria — Complete Guide
Home › Technology & Digital Skills › Basic Coding for Non-Programmers in Nigeria
Basic Coding for Non-Programmers in Nigeria — The Complete Automation Guide (2026)
By Samson Ese, Founder & Editor-in-Chief, Daily Reality NG | Warri, Delta State | Originally published February 19, 2026 | Updated August 22, 2026 | Reading time: 26 minutes
Update notice: This is a substantially expanded version of the February article. The original covered Google Apps Script and no-code tools only. This version adds a full Excel VBA track for Nigeria's many Office-centric workplaces, real copy-paste code examples for both platforms, a troubleshooting section, and a complete beginner-to-advanced learning path.
⏱️ Check This Before You Read Further
Confirm which tool your actual workplace uses before picking a path — check whether your daily work lives in Google Sheets or Microsoft Excel, since the two tracks below (Apps Script vs VBA) are not interchangeable. Verify Apps Script access at Google's official page or VBA basics at Microsoft Learn.
Takes 2 minutes. Prevents you from learning the wrong tool for your actual daily tools.
Grace runs a small tutoring business from her flat in Enugu, tracking 40 students' payment status in a Google Sheet she updates by hand every evening. When a parent's payment is late, she manually scrolls the sheet, finds the name, and sends a WhatsApp reminder — roughly 45 minutes every week spent on a task that has zero decision-making in it. She'd heard "you need to learn coding" was the answer, tried a YouTube video aimed at aspiring software engineers, and closed the tab after ten minutes of talk about variables and data types she couldn't connect to her actual problem. She didn't need to become a programmer. She needed 20 lines of code that already exist, adapted to her spreadsheet.
Across town in a different sector entirely, Tobi works in the accounts department of a mid-sized Warri logistics firm — one that, like most Nigerian offices, runs entirely on Microsoft Excel rather than Google Sheets. Every Friday he manually consolidates delivery data from six regional spreadsheets into one summary report. Nobody at his office had ever mentioned that the exact same repetitive task Grace was fighting had an equivalent solution sitting inside the Excel he'd been using for years — he just didn't know where to look.
Quick Answer
You do not need formal programming training to automate repetitive work in 2026. Which tool you start with depends on where your work actually lives: Google Apps Script if you work in Google Sheets/Gmail — completely free, no dollar card, built into any Gmail account — or Excel VBA if you work in Microsoft Excel, which runs locally with no internet dependency but requires desktop Excel (it does not work in the free web version). As of 2026, AI tools — Gemini in Sheets, Microsoft Copilot in Excel — can generate the code for both from a plain-English description, meaning you don't need to learn syntax from scratch to get a working result.
Who This Article Is For
This is written for Nigerian small business owners, freelancers, virtual assistants, accounts and operations staff, and anyone doing repetitive spreadsheet, email, or data-entry work who has never written a line of code and doesn't intend to become a software developer. If your work involves copying data between a spreadsheet and email, sending the same reminder message repeatedly, manually compiling reports from raw data, or consolidating numbers across multiple sheets every week, this guide is built for exactly that gap — whether your world runs on Google Workspace or Microsoft Office.
Which Track Fits You — Apps Script or VBA?
| Your Situation | Start Here | Why |
|---|---|---|
| Work lives in Google Sheets, Gmail, Google Drive | Google Apps Script | Free, browser-based, built into your existing Gmail account |
| Work lives in Microsoft Excel, desktop-based office | Excel VBA | Built into desktop Excel, no internet or Google account needed |
| Use Excel mostly through the free web version / OneDrive browser access | Neither — reconsider | VBA macros do not run in Excel for the web at all |
| Need to connect apps outside Google/Microsoft entirely (WhatsApp, CRM) | No-code tool (Zapier/Make) | Purpose-built for cross-platform connections |
Why Google Apps Script Is the Right First Step for Nigerians in Google Workspace
Most "learn to automate your work" content is written for a US or European audience where a $20/month Zapier subscription is a non-issue. That framing quietly assumes something that isn't universally true here: reliable access to a card that can process recurring dollar billing. Google Apps Script sidesteps this entirely — it's a free, browser-based JavaScript platform built into every Google account, with nothing to install and nothing to pay for at any tier for individual use.
What Apps Script Actually Is
Think of it as the remote control for your Google account. Apps Script lets you write small pieces of JavaScript that call built-in shortcuts — SpreadsheetApp, MailApp, DriveApp — to read your spreadsheet, send an email, or move a file, without needing to set up API keys or authentication the way most programming languages require. You access it from any Google Sheet through Extensions > Apps Script.
Build Your First Apps Script Automation in About 30 Minutes
- Open your Google Sheet with your student/client list, including a column for payment status.
- Go to Extensions > Apps Script. This opens a code editor in a new tab — no download, no install.
- Describe what you want in plain English to an AI assistant — something like: "Write a Google Apps Script that checks column C for 'Unpaid' and emails me a list of names from column A where that's true." This AI-generated approach genuinely works for beginners and removes the need to understand JavaScript syntax from scratch.
- Paste the generated code into the script editor, adjust the column letters and email address to match your actual sheet, and click Run.
- Grant the permissions Google asks for — this is Google confirming the script can access your own Sheet and Gmail, not a security risk from an outside party.
- Set a trigger (the clock icon in the Apps Script editor) so the script runs automatically every morning instead of requiring a manual click.
Real Apps Script Code You Can Copy Today
Here's a working example matching Grace's exact situation — assuming Column A has names and Column C has payment status:
function sendOverdueReminders() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = sheet.getDataRange().getValues();
var overdueList = [];
for (var i = 1; i < data.length; i++) {
var name = data[i][0];
var status = data[i][2];
if (status == "Unpaid") {
overdueList.push(name);
}
}
if (overdueList.length > 0) {
var message = "Overdue payments:\n\n" + overdueList.join("\n");
MailApp.sendEmail("your-email@gmail.com", "Weekly Overdue List", message);
}
}
To make this run automatically every Monday morning: in the Apps Script editor, click the clock icon (Triggers), choose this function, set the event source to "Time-driven," and pick a weekly schedule. That's the entire automation — no server, no hosting, no ongoing cost.
The Limits You Should Know About
On a free consumer Gmail account, each script execution is capped at 6 minutes of runtime, with total daily script runtime capped at 90 minutes. For a weekly payment-reminder script processing 40 rows, this is nowhere close to a constraint — these limits only start to matter if you're processing thousands of rows or making heavy external API calls, well beyond a first project.
The Excel VBA Track for Office-Centric Workplaces
If your work — like Tobi's at the Warri logistics firm — lives in Microsoft Excel rather than Google Sheets, Apps Script simply won't apply to you. The equivalent tool built directly into Excel is VBA (Visual Basic for Applications), and in 2026 it remains genuinely relevant despite newer tools existing, particularly in corporate environments where IT governance moves slowly and existing VBA-dependent workflows are already embedded in daily finance, logistics, HR, and manufacturing operations.
Getting Started With VBA
- Enable the Developer tab: File > Options > Customize Ribbon > check "Developer" under Main Tabs.
- Try Record Macro first — it's on the Developer tab and automatically generates VBA code that reproduces whatever actions you manually perform, which is a genuinely useful way to see real, working code without writing any yourself initially.
- Open the VBA editor directly with Alt+F11 when you're ready to write or paste code rather than just recording actions.
- Use Copilot (if available on your Microsoft 365 plan) or an AI chat tool to generate VBA code from a plain-English description — the same principle as the Apps Script approach above.
⚠️ The Web-Version Trap
VBA macros do not run in Excel for the web — only in desktop Excel. This catches people out constantly: a file opened from Teams, SharePoint, or OneDrive in a browser launches in Excel for the web, where macros simply won't execute, often with no obvious explanation of why "the macro that worked yesterday" suddenly does nothing today. If your organization relies heavily on browser-based file access, confirm you're opening files in the actual desktop Excel application before building any VBA-dependent workflow.
Real VBA Code You Can Copy Today
A common task across Nigerian accounts and operations roles — removing duplicate rows before consolidating a report:
Sub RemoveDuplicateRows()
Dim ws As Worksheet
Set ws = ActiveSheet
Dim lastRow As Long
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
ws.Range("A1:D" & lastRow).RemoveDuplicates Columns:=1, Header:=xlYes
MsgBox "Duplicates removed successfully."
End Sub
To run this: press Alt+F11, go to Insert > Module, paste the code, adjust the column letters to match your data range, then press F5 or return to Excel and run it from the Developer tab. VBA performs perfectly for data volumes up to roughly 100,000 rows — well beyond what most manual reporting tasks in a Nigerian SME context involve.
No-Code Tools — Zapier, Make, and n8n Compared
Once you've outgrown what Apps Script or VBA comfortably handles, or your automation needs to connect apps entirely outside Google or Microsoft's ecosystem (WhatsApp Business, a CRM, a payment platform), visual no-code tools become the next step.
| Tool | Best For | Learning Curve | Nigeria Payment Note |
|---|---|---|---|
| Zapier | Simple two-app connections, fastest setup | Easiest | USD billing on paid tiers — needs dollar card |
| Make | Complex, branching workflows, ~60% cheaper than Zapier | Moderate | USD billing on paid tiers — needs dollar card |
| n8n | Full control, self-hosted option | Steepest | Genuine free self-hosted tier available |
| ⚠️ Source: Zapier official blog low-code comparisons; LOW/CODE 2026 platform comparison; Exotic AI Tools Solutions Zapier vs Make vs n8n analysis, mid-2026. Pricing changes — verify current terms directly with each vendor. | |||
The Payment Reality Most Automation Guides Skip
Free tiers of Zapier and Make can generally be started with just an email signup, enough to test whether a workflow works. But scaling past a handful of simple automations typically requires a paid plan billed in US dollars — and most Nigerian naira debit cards fail or get declined on recurring foreign currency subscriptions. The realistic path for a Nigerian moving beyond Apps Script or VBA into Zapier or Make involves first securing a virtual dollar card from a Nigerian fintech provider, an extra step most tutorials written for a US audience never mention because they don't need to.
What to Automate First — Highest Value, Lowest Complexity
| Task | Best Tool | Time Saved (Realistic) |
|---|---|---|
| Overdue payment/invoice email reminders | Google Apps Script | 30-60 min/week |
| Auto-save Gmail attachments to Drive folder | Google Apps Script | 15-20 min/week |
| Notification when a Google Form is submitted | Google Apps Script | Immediate, ongoing |
| Removing duplicates, cleaning multi-sheet data | Excel VBA | 30-90 min/week |
| Weekly consolidated report from multiple worksheets | Excel VBA | 1-3 hours/week |
| Connecting WhatsApp Business to a CRM or Sheet | Zapier or Make | Varies — often several hours/week |
When It Doesn't Work — Troubleshooting
The Most Common Beginner Errors
- Wrong column letter or sheet name. AI-generated code is only as accurate as the description you gave it — always double-check the code references your actual columns, not a placeholder assumption.
- Skipped permission grants. Both Apps Script and macro-enabled Excel files ask for permission before running — declining or skipping this silently breaks the automation with no clear error message.
- Opening a macro file in the wrong Excel version. As covered above, this is the single most confusing VBA failure for beginners — the file "just doesn't do anything" with no obvious cause.
- Not adjusting AI-generated code to your exact structure. Copying code verbatim without checking it matches your specific spreadsheet layout is the most common reason a first automation doesn't work on the first try.
Both platforms include a debugger: press F8 in the VBA editor to step through code line by line, or check the execution log in the Apps Script editor to see exactly where a script stopped and why.
The Full Learning Path — Beginner to Advanced
- Week 1: Build one small Apps Script or VBA automation solving an actual problem you have right now — not a tutorial exercise, a real task.
- Weeks 2-4: Expand to two or three more automations covering different repetitive tasks in your actual workflow.
- Month 2+: Move to a no-code tool like Zapier or Make once you need to connect apps outside Google or Microsoft's ecosystem entirely.
- Beyond that: Consider Python only if you're processing genuinely large datasets (well beyond VBA's ~100,000-row comfort zone) or want automation as a career skill rather than a personal productivity tool. VBA itself is a reasonable bridge here — its core concepts (loops, variables, functions, error handling) transfer directly to Python, JavaScript, and SQL.
Where This Skill Actually Leads
This isn't only about personal productivity. Demonstrable ability to automate repetitive spreadsheet, email, or workflow tasks is an increasingly valued skill for Nigerian virtual assistants, operations staff, and small business support roles — because it directly and measurably reduces the manual hours an employer would otherwise have to pay for. A VA who can say "I built an automation that saves my client 5 hours a week" has a concrete, demonstrable claim that a generic "proficient in Excel" line on a CV doesn't carry.
Real-World Impact
🗓️ The Daily Life Impact: Grace's overdue-payment script, once built, turned a 45-minute weekly task into a two-minute Monday-morning email check — roughly 39 hours reclaimed per year from one 30-minute investment.
🏪 The Business Impact: Tobi's Friday consolidation report, rebuilt in VBA, dropped from a 90-minute manual process to a single button click that runs the macro across all six regional sheets — freeing up nearly an entire workday per month for higher-value analysis work instead.
💰 The Wallet Impact: For a freelance VA charging by project rather than by hour, automating a client's recurring reporting task directly increases effective hourly earnings without raising the client's invoice — the time saved becomes capacity for additional paying work.
Your 24-Hour Action
Your action: Identify whether your daily work lives in Google Sheets or Excel, open the matching tool (Extensions > Apps Script, or Alt+F11 for VBA), and describe one specific repetitive task to an AI tool exactly as shown in the code examples above. You don't need to understand every line to start — you need it to work on your first try, then learn from what it produced.
Frequently Asked Questions
Do I need to know how to code to automate my work?
No — no-code tools like Zapier/Make use drag-and-drop, and both Apps Script and VBA can now be AI-generated from plain English descriptions.
What is Google Apps Script and why start there in Nigeria?
A free, browser-based JavaScript platform built into every Google account — no dollar card or subscription needed, unlike Zapier or Make.
What are the free Apps Script usage limits?
6 minutes per script execution, 90 minutes total daily runtime on free consumer accounts — sufficient for most individual automation tasks.
What is Excel VBA and how does it differ from Apps Script?
VBA is built into desktop Excel, runs locally with no internet needed — the right choice for Office-centric Nigerian workplaces rather than Google Workspace ones.
Can VBA macros run in the free web version of Excel?
No — VBA only works in desktop Excel, not Excel for the web. This trips up many beginners opening files via Teams or OneDrive in a browser.
Which no-code tool should a beginner start with?
Zapier for fastest simple setup; Make for more complex workflows at lower cost; n8n for a genuinely free self-hosted option if technically comfortable.
Can I use Zapier or Make without a foreign currency card?
Free tiers need just an email, but paid tiers are USD-billed and typically require a Nigerian fintech virtual dollar card.
What should a beginner automate first?
Payment reminders, auto-saving email attachments, form notifications, and weekly summary/consolidation reports.
How long does the first automation realistically take?
About 30-60 minutes for a simple script or macro, even with zero prior coding background.
What should I do when my automation doesn't work?
Use the built-in debugger (F8 in VBA, execution log in Apps Script) and check for the most common errors: wrong column references, skipped permissions, or the wrong Excel version.
Is VBA still worth learning given newer tools exist?
Yes — it remains embedded in many corporate workflows and is a gentle, transferable introduction to core programming concepts.
Should I learn Python instead of starting with Apps Script or VBA?
Not as a first step — Python needs separate installation and a steeper curve. It's a reasonable second step once you've outgrown Apps Script or VBA.
What's the realistic full learning path?
One real automation in week 1, expand over the first month, move to no-code tools when you need cross-platform connections, consider Python only for large-scale needs.
Can AI tools write the code for me completely?
Largely yes for common tasks — but you still need to adjust generated code to match your exact spreadsheet structure.
Is this useful for getting hired, or just personal productivity?
Both — it's an increasingly valued, demonstrable skill for Nigerian VA and operations roles.
Key Takeaways
- Pick your track based on where your work actually lives: Google Apps Script for Google Sheets/Gmail, Excel VBA for Microsoft Office environments.
- Both are free and require no dollar-denominated subscription — a real advantage over Zapier/Make for most Nigerians starting out.
- AI tools (Gemini in Sheets, Microsoft Copilot) can generate working code from plain English — you don't need to learn syntax from scratch.
- VBA does not run in Excel for the web — a common, confusing failure point worth confirming before you invest time.
- The realistic path is: one real automation now, expand over a month, add no-code tools when you need cross-platform connections, consider Python only for large-scale needs.
For related reading, see no-code development in Nigeria, the realistic web development learning timeline, the student tech skills guide, Grey vs Chipper Cash vs GeegPay dollar accounts, building a portfolio with no experience, and learning QuickBooks and Sage for freelance accounting.
Disclosure: This article references Google Apps Script, Microsoft Excel/VBA, Zapier, Make, and n8n for illustrative comparison purposes. Daily Reality NG has no affiliate or sponsored relationship with any of these platforms.
Disclaimer: This article provides general educational guidance on automation tools current as of August 2026. Tool pricing, features, and usage limits change — verify current terms directly with each provider before committing time or payment. Code examples are illustrative starting points and should be tested and adjusted for your specific spreadsheet before relying on them for business-critical tasks.
Samson Ese
Founder & Editor-in-Chief, Daily Reality NG. I write practical, Nigeria-grounded guides on technology and digital skills from Warri, Delta State. Read the full story of how Daily Reality NG was built.
© 2025–2026 Daily Reality NG — Empowering Everyday Nigerians | All posts are independently written and fact-checked by Samson Ese based on real experience and verified sources.
Comments
Post a Comment