Hey everyone! I'm diving into something a bit out of my comfort zone and could use your insights. I'm trying to create a Python program that can read data from various social media posts and send that info over to a Google spreadsheet. I've made some progress with the Google API and can now read and write data to the sheets, which is great!
The challenge I'm facing is that this manual process is really time-consuming—tracking 30 brands across platforms like Facebook, Instagram, TikTok, and LinkedIn takes me around 2-3 hours due to my ADHD. I'm tracking post dates and engagement metrics (likes, comments, shares) to report in PowerBI.
I don't want to build a bot for posting or commenting; I'm strictly looking for a way to easily collect this engagement data. Are there existing apps that can help streamline this process? I've looked into a few CRMs and social media management tools, but they're often too pricey and offer more features than I need.
I'd be open to diving deeper into this myself if I could allocate some time, but suggestions for tutorials or even hiring someone would also be greatly appreciated!
1 Answer
Automating web scrolling could be a fun and instructive route! You can potentially use a Chrome extension to interact with specific elements. Just remember, it might take a while to work out all the bugs, especially if you're managing ADHD like me too!
That sounds like a fun way to learn! I'm a bit unsure about how it works with social media authentication, but I appreciate the suggestion!