Visibility: Public Uploaded by: Technically Creative LLC Uploaded at: 2026-03-23 Length: 03:44 Views: 40 Likes: 1 Category: Science & Technology

Built a personal productivity automation using n8n that captures daily work logs via Telegram — either as typed text or voice messages. Voice notes are automatically transcribed using Google Gemini 2.5 Flash, then routed through a switch node to normalize both input types. Structured log entries (date, timestamp, category, status, notes, tags) are appended or updated in a Google Sheets daily log, while a formatted digest — including weather, project status, decisions, next steps, and risks — is written to a Google Doc. A scheduled trigger pulls the day's data, passes it to an AI model for summarization, and outputs a formatted "Daily Digest Newspaper" report. Error handling routes failures to a dedicated error log sheet automatically.

// ABOUT THE CHANNEL // Welcome to my channel where music production meets continuous improvement. I explore djent & metal on extended-range guitars through the lens of a PMP and Lean Six Sigma Green Belt. We believe in a fact-based, principled approach to art and technology.

// LINKS & SOCIALS // ► All Links: [https://technicallycreative.start.page/] ► Website: [www.technicallycreative.work] ► Linkedin: [www.linkedin.com/in/kennethdunnpmp] ► Instagram: [@tech.cre8] ► Twitch: [https://www.twitch.tv/techcre8] ► UpWork: [www.upwork.com/freelancers/ techcre8] ► Gumroad: [techcre8.gumroad.com] ► Redbubble: [techcre8.redbubble.com]

// MY GEAR & SOFTWARE // ► Guitar: Schecter PT-8 MS Black Ops 8-string Electric Guitar - Black ► Audio Interface: Scarlett Focurite 1i820 2nd Gen ► DAW: Ableton Live ► Video Editor: Davinci Resolve ► VSTs: Izotop Production Suite | Nueral Dsp Gojira

Hey, I'm Kenny Dunn. I'm a project manager and music producer. I'm also the owner of Technically Creative LLC. This is my daily logging automation I built in N8N. It connects Telegram to Google Sheets and handles two inputs. If I send a voice memo, it downloads it, transcribes it, and then logs it. If I send text, it formats it, drops it straight into the sheet. Either way, everything ends up in one place for future analysis. If you've been in project management for a while, you understand the value of what each day brings and how it differs from the next. You also understand the importance of lessons learned from completed projects, completed phases throughout your process. I've designed an automation with the with Telegram and N8N to log daily summaries using AI to generate a specific type of format for the daily logs that goes into a Google Sheet. And then I can run analysis on it through Gemini or Chat GPT. I also have it sent to a Google document so that I can also again use that as um another format to read through daily logs. Now for a quick demo of the process. So I have up here my Telegram. I call it TC Log Bot. So essentially, I'm going to just type in a few different words just to show the capability of the process. So I'll just type in testing the daily log summary bot. Now we're going to hit enter. And what's happening behind the scenes is it's going to run through this. It's going to realize that it is not a uh a recording and then it's going to log straight into the sheet. So now that we click into executions, we see the how it ran straight from Telegram into the switch and then into append row to sheet. The beauty of this particular uh log is that some people don't want to type everything. You can also do speech to text. Hello. Hello. Testing 1 2. Going to see it switch over to grabbing the file, the audio file, transcribing the recording through and then out to edit fields and then appended a row in the Google Sheets. Now we look at our execution. Telegram triggered again. Switch recognized that it was a speech to text. And it grabbed the file, transcribed the recording, added the edited fields, and then placed into our Google Sheet. Now if we pull up the Google Sheet, the daily work summary sheet, we have our voice displayed here in the notes section. Hello. Hello. Hello. Testing 1 2. It's clean, flexible, and fully automated. One less thing to think about at the end of the day.