From Kafka to a Spreadsheet - A Step by Step Python Tutorial

Sooner or later, someone will ask you to get data into a spreadsheet. It's a
universal truth of the software business. So let's create a project that does
exactly that!
In this Python coding walkthrough, we'll show you how to build a real-time
data-streaming pipeline that takes data from Apache Kafka and streams it into a
live Google Spreadsheet. You see every step of the code - minus our API keys -
as we build up the solution step-by-step. From empty directory to working,
live-updating sheet.
📥 This project's source code: github.com/quixio/simple-kafk...
👨‍💻 Quix Streams Source on Github: github.com/quixio/quix-streams
📓 Quix Streams API Docs: quix.io/docs/quix-streams/api...
📺 Watch all the videos in this series: • Quix Streams Walkthroughs
⚙️ Google Developer Console: console.cloud.google.com/
--

[@jake115577]

My mind is blown by how well you are thinking and translating it by typing it beautifully into python code. Thank you.

[@oliwiak82]

Yes. Please keep doing more vids!

[@QuixStreams]

You're very welcome!

[@ovidiu_nl]

Cool! A candlestick chart would have been nice. 🙂

[@QuixStreams]

We have a template that handles stock tick data and represents it on a candle stick chart github.com/quixio/template-real-time-data-pipelines-in-python

[@septic7]

The day quikstreams supports joins without internal Kafka topics I’m sold !! 😊

[@michaelrosam9271]

Joins are in the works. What’s your beef with internal topics?

[@septic7]

My beef with internal topics is that when a cloud service like confluent cloud bills per partition (internal topics included) well costs can balloon quite a bit.. I much prefer Flinks snapshotting model to some blob storage for HA rather than using Kafka topics

[@michaelrosam9271]

I feel your pain on that front. Thanks for the feedback!

[@kirakira160]

More kafka😊

[@souravbarua3991]

Thank you for this 🙏. This is a wonderful thing. I'm really enjoying this series.

[@QuixStreams]

Glad you enjoy it!

[@gustavosolano8625]

thank you for the content, keep it up !!

[@arisweedler4703]

Truly incredibly explained. I would love to know where you learned how to think/explain/communicate like that.

[@arisweedler4703]

Aight epic this dude has a podcast - Developer Voices - time to go monkey mode on those.

[@krisajenkins]

@@arisweedler4703 Thanks! And thanks for finding the podcast - I hope you're enjoying it. There are a couple more coding videos on that channel too. 🙂 How did I learn to do this? Interesting question. I think giving a lot of conference talks has certainly helped, as has years of refactoring code - they both push you to think about how you'd explain the code to someone else. 🙂