Eamonn saw the inefficiencies in the manual processes, such as faxing orders on paper, and wanted to create a more efficient system using Google Sheets and scripting to reduce errors and save time.
Eamonn has published 37 freeCodeCamp tutorials focused on productivity and automation using spreadsheets.
Eamonn wakes up early, often at 4 a.m., to run and have quiet time before the day starts. He balances family commitments, running the coffee chain, and creating coding tutorials, often going to bed by 8:30 p.m.
His first project was creating an inventory management and ordering system using Google Sheets and scripting to replace the outdated faxing system.
Eamonn channels his creativity into productive tasks like coding, writing tutorials, and running his coffee chain. He believes in finding a balance between creative expression and practical responsibilities to provide for his family.
Eamonn uses a custom-built finance tracker in Google Sheets that requires manual input, helping him and his wife stay conscientious about their spending and maintain financial stability.
Eamonn's addiction led him to rehab at 19, which marked the beginning of his personal growth. He stayed sober for over 20 years and credits his recovery with helping him develop the discipline and focus needed to succeed in his career and personal life.
Eamonn believes that removing psychoactive drugs, including alcohol, can improve cognitive performance and overall productivity. He has been alcohol-free for over eight years and encourages others to consider abstinence for better focus and health.
Eamonn hopes to transition to full-time technical and creative work, but acknowledges the practical constraints of supporting his family. He plans to continue balancing his current responsibilities with his creative and technical pursuits.
Eamonn sees spreadsheets as incredibly powerful tools for automation and productivity in small businesses. He believes that even basic spreadsheet skills can make a significant difference in reducing errors and improving efficiency.
On this week's episode of the podcast, freeCodeCamp founder Quincy Larson interviews Eamonn Cottrell. He's a software engineer who also runs a local chain of coffee shops in Knoxville. Eamonn taught himself to code using freeCodeCamp. And he's since published 37 freeCodeCamp tutorials on using productivity and automation using spreadsheets.
Support for this podcast comes from a grant from Wix Studio. Wix Studio provides developers tools to rapidly build websites with everything out-of-the-box, then extend, replace, and break boundaries with code. Learn more at https://wixstudio.com
Support also comes from the 11,113 kind folks who support freeCodeCamp through a monthly donation. Join these kind folks and get involved in our mission by going to donate.freecodecamp.org
We talk about: - Eamonn love of coffee and how he bought VHS tapes to learn latte art - How he finds time to expand his skills in between running coffee shops and ultra-marathoning - How he used spreadsheets to automate the logistics of running coffee shops - How he balances being a musician and writer with the practical realities of providing for a family of 6
Can you guess what song I'm playing in the intro?
Also, I want to thank the 10,993 kind people who support our charity each month, and who make this podcast possible. You can join them and support our mission at: https://www.freecodecamp.org/donate
CORRECTION: Vincent van Gogh was supported by his younger brother – not his brother in-law. van Gogh never married so he never had a brother in law. I'm not sure why I thought that. Also, he seems to have sold more than one painting in his life (as many of us were taught in school), but nowhere near enough paintings to support himself as an artist.
Links we talk about during our conversation:
Eamonn's freeCodeCamp articles: https://www.freecodecamp.org/news/author/sieis/
Eamonn's YouTube channel: https://www.youtube.com/@eamonncottrell
Excel-based esports: https://www.youtube.com/watch?v=N2QC6VQXo8U
Ultra Marathons: https://www.youtube.com/@runtired
Got Sheet: https://www.gotsheet.xyz/
Progress and Perfection: https://www.progressandperfection.com/
Eamonn on LinkedIn: https://www.linkedin.com/in/eamonncottrell/
Eamonn on Twitter: https://x.com/EamonnCottrell