👀 I know you missed me… and guess who’s back — it’s ym!
Took a little break (life happens 📴), but I’m back on the grind and excited to share what I’ve been building.

In the Sunday School system I’m working on, I hit a real-world challenge: the department heads already manage attendance and student info in Google Sheets, and those sheets are updated constantly. Instead of asking them to change tools, I needed my app to fetch that data dynamically and always stay in sync.

Here’s how I solved it:
⚡️ Created a Google Service Account in the Cloud Console
⚡️ Generated a service-account.json key file
⚡️ Shared the spreadsheet with that account for access
⚡️ Used the googleapis package to build a Next.js API route at /api/sheet

Now, calling /api/sheet?sheet=Sheet1 instantly returns structured data. The first row in the sheet becomes headers, and each row after that gets mapped into objects my app can work with.

To make it even smoother, I built a small mapping layer that converts Amharic headers into clean English keys (Unique_ID, First_Name, Sex, Grade …). With that in place, syncing data from Sheets → Database became effortless.

✅ Department heads keep using Google Sheets exactly as they’re used to
✅ The system stays up-to-date automatically
✅ No manual syncing needed

It’s smooth, simple, and just works ✨


#YmSoftware #Birhane_Hiwot_Sunday_School #Attendance_Management #Nextjs #WebDev #CodingLife #WebApp #SchoolManagement #SundaySchool #EthiopiaTech #MongoDB #SoftwareDevelopment

Why So Many People Quit Coding (Even When They Love It)

Let’s be honest.

Nobody starts learning how to code and thinks,
“Yay! I can’t wait to be frustrated and overwhelmed!” 😩

But somewhere between writing your first hello world and facing your 10th error in one hour…

People start to tap out.

Here’s why people give up on their coding journey:

1. They want it fast, not deep.
They want to “learn fast and get a tech job in 3 weeks.”
But coding is a process. Not magic.
You have to understand the logic, not just memorize tutorials.

2. Tutorial Hell is real.
They hop from one YouTube video to the next without building anything.
It feels productive, but it's just digital procrastination.

3. Impostor syndrome creeps in.
They compare themselves to someone on LinkedIn who built an app in 1 month.
They forget that they’re on chapter 2, comparing it to someone else’s chapter 20.

4. No accountability.
When nobody is checking in on you, it’s easy to “rest” for one day...
Then that day becomes a month.
Then the dream dies a quiet death.

5. They don’t know why they’re learning.
If your only reason is “tech pays well,”
the first moment it gets hard, you’ll start asking yourself:
“Is this even worth it?”
But when you have a clear WHY you push through the discomfort.

Coding will stretch you. It will test your patience.
But it will also grow you. It will open doors.

Not everyone who starts finishes.
But everyone who finishes will tell you it was 1000% worth it.

So, before you quit, ask yourself:

Did I really give it my all… or did I give up when it got uncomfortable?

You’re not behind.
You’re not too late.
You just need to start again with clarity and consistency.

💻 Keep going. The future still needs your code.

I feel 3 & 5

especially number 4

I believe that

I'm not behind.
I'm not too late.
I just need to start again with clarity and consistency.

Then I want to push myself harder with ALX words #DoHardThings

I start from now. I don't want to fail myself. I promise you will see something in the coming weeks.

#YmSoftware

Cooking something
#YmSoftware @ym_software

Another one 🔥