EPIC Google Sheets to Interactive Dashboard in Python ft. Streamlit / CSS

Looking for an end to end implementation of a live stocks dashboard from Google Sheets to a Python Web App? In this tutorial, you'll discover my comprehensive workflow to build my Streamlit web dashboard:

- How I build a live Stocks tracker in a Google Sheets workbook
- How I connect to Google Sheets from Python using @AirbyteHQ ( https://airbyte.com/product/pyairbyte )
- How I build the Streamlit app with horizontal layout columns, Plotly Candlestick and a grid of indicators for easy reading
- How I add custom styling to the Streamlit app with heavy use of HTML inspection, targeting widgets to add colors, box shadows and new Google fonts

By the end of this video, you'll be equipped with the skills to quickly recreate Excel dashboards within Python web apps. No more struggling with complex VBA macros – empower yourself to generate interactive and visually appealing dashboards for financial data analysis.

00:00 Dashboard Mockup
01:08 Build live stocks tracker in Google Sheets
02:40 Create a service account for Python
05:14 Connect to Google Sheets with Airbyte
09:17 Download Google Sheets data to Python with Airbyte
10:31 Display a Dataframe with inline sparkline
12:14 Track data with an interactive Candlestick plot
14:42 Create a grid of indicators
16:41 CSS Styling Prerequisites: inspect HTML
19:04 Create a grid of company watchcards
20:54 Inject a Google font into the Streamlit title
22:51 CSS Styling of indicators into cards
25:09 CSS Styling of company watch cards
26:59 Enjoy the dashboard!

---

🗣️ Stay up to date with the Data Web App Ecosystem

- 📑 Follow my socials ➡ https://andfanilo.com
- 📧 Get my latest updates in your inbox ➡ https://newsletter.andfanilo.com
- 💰 Buy me a coffee to stay awake while editing ➡ https://www.buymeacoffee.com/andfanilo

🔗 Links

- Source code + Sample Data: https://github.com/andfanilo/social-media-tutorials/tree/master/20240512-cssdashboard
- Or fork this Google Sheets: https://docs.google.com/spreadsheets/d/1DPzFbZ6Oh-FixU6hP5Eoix0wsgb_C2FHx9KAGEunph4/edit?usp=sharing

🔧 My tools (Affiliate links to support me)

- 📕 Streamlit Official Book - https://amzn.to/3QuRPwl
- 📷 Main Camera - https://amzn.to/3QvTosB
- 📷 Main Lens - https://amzn.to/3svYCwq
- 🎙️ Microphone - https://amzn.to/47l5ewA
- 🎵 Music & Sound Effects - https://www.epidemicsound.com/referral/a2p22s

---

🪶 A segment of this video was sponsored by @AirbyteHQ . It was very easy to setup, go build Streamlit apps over new data sources with Airbyte!

⚠️ This video was made possible through the sponsorship of Airbyte. All views and opinions expressed are solely those of the creator, and do not reflect those of Airbyte.
Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. Thank you for supporting my channel so I can continue providing you with free content!

#streamlit #python #datascience #dataapps