I’ve spent years watching people choose between two bad options: lock your notes into Notion or Obsidian’s proprietary format, or pay a subscription for the privilege of syncing them across your devices.
Then it hit me: most people are already dumping information into Google Sheets. It’s structured. It’s searchable. Everyone has access. And critically: you own it. The data lives in your Google Drive, not in a startup’s database that may or may not exist in three years.
So instead of building yet another note-taking app with yet another proprietary database, I built a beautiful frontend on top of Google Sheets. That’s brain2.0.
The Problem With Note-Taking Apps: Why a Free Personal Knowledge Base on Google Sheets Works Better
Let’s be honest about how note-taking apps work. You write everything into their platform. Your data lives in their format, on their servers, under their terms of service. Export options are an afterthought. Pricing increases are routine. Switching costs are high by design.
Notion is powerful but you’re paying per user per workspace once you need collaboration features. Obsidian gives you local files but syncing across devices costs money. When you’re already paying for software tools and cloud storage, adding another monthly fee to sync your personal notes feels absurd — especially when the underlying data format could just be a spreadsheet you already have for free.
Google Sheets as a Personal Knowledge Database
Google Sheets is already a database. It’s structured, filterable, shareable, and backed by Google Drive’s reliability. Almost every knowledge worker already has a Google account and knows how to use Sheets.
What Sheets doesn’t have is a good interface for knowledge management: no card view, no inline editing, no tag cloud, no full-text search that works the way your brain expects. These aren’t limitations of Sheets as a database. They’re just features that belong in a dedicated frontend layer built on top of it.
brain2.0 is exactly that: it talks to your Google Sheet via the Sheets API v4, gives you a modern interface, syncs bidirectionally, and lets you search, filter, and organize the way you’d expect from a real app. Your data never leaves your own Google Drive.
How brain2.0 Works: Features Built for Knowledge Work
The setup is simple because there’s no backend. You authenticate once with Google Identity Services. The app reads and writes directly to your Sheet. No server to maintain, no database to provision.
- Bidirectional sync: Edit in the app or directly in Sheets. Changes appear everywhere immediately.
- Dual view modes: Toggle between a card grid for browsing and a table view for bulk operations.
- Inline modal editing: Click any field to edit it in place. Auto-saves as you go.
- Drag-and-drop reordering: Organize cards in the order that makes sense to you.
- Full-text search: Find anything by title, content, or metadata instantly.
- Tag cloud filtering: Filter your knowledge base by tags with one click.
- PWA support: Install it on your phone or desktop. Works offline in draft mode.
Built on React 19 with TypeScript, Tailwind CSS, Zustand for state management, and dnd-kit for drag and drop. Everything is type-safe and fast.
Your Free Personal Knowledge Base on Google Sheets: Where to Go From Here
Your knowledge base lives in a Google Sheet you control completely. You can share it with colleagues. Back it up. Export it to CSV. Write your own scripts against it. Your data is genuinely portable because it’s in a format you already own.
If brain2.0 disappeared tomorrow, your knowledge wouldn’t go anywhere. It’s still in your Sheet. You could build a different frontend for it, or just use Sheets directly. That’s the principle: the interface should be great, but the database should never be a dependency.
No subscription. No lock-in. No proprietary format. Just a spreadsheet you control and a modern app to access it.
If you work with large volumes of unstructured data — like communication logs or project chats — another tool worth pairing with this is the WhatsApp Chat to Excel parser. It turns messy export files into clean structured data that can feed directly into a knowledge base like this one.
Full source code: github.com/ameyaagrawal99/brain2.0
About the Author
Ameya Agrawal is an IIM Kozhikode Gold Medalist and Executive Director at MIT World Peace University (MIT-WPU), Pune, leading the launch of WPU GŌA — India’s first transdisciplinary residential university campus. Previously CEO of Mahatma Gandhi Seva Sangh (MGSS), his disability rehabilitation work earned two Presidential National Awards from the Government of India, impacting over 100,000 lives across Maharashtra.
Author of the bestselling self-help book “A Leap Within” (published at age 21, earning him a National Record), Ameya has been published in Forbes, Business Standard, and The Print. He founded the SkillSlate Foundation, which trained 25,000+ individuals across 100+ organizations during the pandemic. Admitted to Harvard University in 2021, he chose to stay in India to continue his social impact work.
Projects on GitHub | Connect on LinkedIn | Follow on Twitter @ameyaagrawal | Read more at blog.ameya.page
Leave a Reply