Log your day by voice and wake up to a fully organized health tracker—completely free
I track my recovery daily—mood, energy, focus, activities, medications, and reflections—but typing everything out never lasted more than a few days. So I built a voice-first pipeline: I talk, and it automatically becomes a clean, organized Google Sheet. 1. I built a free iPhone Shortcut that records my voice when I say, “Hey Siri, Log,” and sends it to the Gemini endpoint. 2. Gemini transcribes the audio and extracts structured details, including wake time; mood, energy, and focus scores; activities with categories and durations; medications; and reflections. 3. Everything is automatically organized in the appropriate place in a Google Sheet: a daily summary, activity log, metrics log, medications log, and clean, human-readable digest for each day. 4. I can say “yesterday” or “on Monday” to log something I forgot, and it files the entry under the correct date. 5. I connected the completed sheet to a separate AI chat scoped specifically to reflection, so I can ask questions such as how my exercise correlates with my mood or how my energy trends over the month. The best part is that the entire workflow runs on free tiers—Google Sheets, Apps Script, iPhone Shortcuts, and Gemini’s free API tier—so there’s zero cost to build or run it. The result is a daily tracker that takes seconds to update from anywhere, requires no typing, and turns my entries into a dataset I can actually learn from—all without writing a traditional app.
0 comments