Code Riff

We Built an ESG News Bot in 1 Hour using Claude Code (Live)

Eric Tan, Yaohong Ch'ng Season 1 Episode 2

Use Left/Right to seek, Home/End to jump to start or end. Hold shift to jump forward or backward.

0:00 | 1:04:12

An ESG analyst at a bank spends her morning commutes reading news across Reuters, ESG News, and Financial Times, etc, then manually logging it into Excel and Word. She tried ChatGPT but got hallucinated headlines.

So we automated the whole thing in one hour using Claude Code from scratch, having fun while doing it together.

What you'll hear in this episode:
- A real sustainable finance analyst walking through her daily news workflow
- Building a Python news scraper live with little to no prior coding experience
- AI classifying articles into sustainable finance, policy, and country news
- Setting up a Telegram bot that delivers a formatted Word document daily
- Honest explanations of API keys, prompt injection, and context rot
- A conversation about AI in banking - augmenting jobs, not replacing them

Hosts: Eric Tan (non-technical builder) & Yaohong Ch'ng (engineer, Superuser HQ, ex-Stashaway head of Data)
Guest: Wachel - Sustainable Finance Analyst

Got a problem you want us to solve live? Fill out the form: https://forms.gle/DSyLzPAoR6x2M4Np9

Subscribe to our newsletter: https://substack.com/@coderiff?utm_campaign=profile&utm_medium=profile-page


Tools from this episode:
- Claude Code: https://claude.ai
- Newsdata.io: https://newsdata.io
- Telegram (BotFather): https://t.me/BotFather

Connect with us:
- Eric: https://www.linkedin.com/in/erictisme/
- Yaohong: https://www.linkedin.com/in/yaohongchng/
- Superuser HQ: https://superuserhq.com/
- Email: code.riffs.ai@gmail.com

Code Riff - messy real-world problems, solved with AI, so you can too.