How I AUTOMATE my FINANCES USING PYTHON

Published: 23 July 2022
on channel: Internet Made Coder

204,144

5.7k

Thank you to Mailgun for sponsoring this video! Try Mailgun today by using my link https://mailgun.com/internetmadecoder

🚀 Zero to Software Engineer with no Degree - https://academy.internetmadecoder.com...

Today, we will learn how you can automate your personal finances using PYTHON and Google Sheets.

Make Python your (unpaid) financial manager!

📈 GOOGLE SHEETS TEMPLATE (copy this or create your own) - https://docs.google.com/spreadsheets/...

1. Acces your transactions as CSV files - further detail on reading CSV data in Python https://realpython.com/python-csv/
2. Access Google Sheets using the spread library - detailed instructions for how to set up the API if I go too fast in the video - https://docs.gspread.org/en/latest/oa...
3. Clean up data in Python using DATA SCIENCE
4. Extract data to Google Sheets via gspread
5. Customize the financial spreadsheet to your liking and make your app categorize transactions automatically!

CHAPTERS:
0:00 What you will learn
1:00 Set up Transaction data Access
3:00 Set up Google Sheets API Access
5:15 SPONSOR: Mailgun
6:25 Clean up data in Python using Data Science Magic
8:10 Make your app INTELLIGENT
9:28 Extract data to Google Sheets (using magic)
13:30 Make your app even better (ideas)

WHO AM I?
On this channel, my aim is to give you the tools, strategies and methods to learn to code effectively - according to science! In addition, I document my life as a self-taught software engineer.

DISCLAIMER: some of the links in the description may be affiliate links. If you purchase a product or service using the links that I provide I may receive a small commission. This is no extra charge to you! Thanks for supporting Internet Made Coder :)

Tags: python automation projects, automate the boring stuff with python, learn python, python data analytics, google sheets API, python finance, python csv tutorial, python automation, automate your life, learn python fast, python fundamentals, bash scripting, learn to code, coding projets, coding project ideas, python tutorial, desktop automation, coding tutorial, python 101, how to automate tasks for beginners