I sell an excel add-in that integrates with some popular trading software. It makes life easier for traders. It has a couple thousand users paying around $10 a month. That's about as specific as I want to get.
It required a little domain specific knowledge to create, and a recognized name among trading forums to initially market. Otherwise it's super simple and I'm continually surprised that there are no real competitors.
That is the exact niche type of side project that I dream about. Though, with "a couple thousand users paying around $10 a month" that is hardly a side project anymore, given the annual revenue north of $200K.
I've tried this with Google Sheets add-ons. It can be hard since there is no built in payment method so I end up using lots of API calls to Stripe to check for current subscription status. However, you have to get the user to subscribe on one site and install the add-on on another.
It is still outrageous because those two big ones make a huge economy of scale. They did not develop a payment method for a single app but for millions.
I don't know much about this ecosystem but do you see an opportunity for a business to supply these tools (or be the app store) for excel/google sheets addons?
There definitely is for excel. Both for consumer add-ins and internal business add-ins. I've thought about it, and even started on the idea a few times, but have given up. There are just so many components of the system that are outside of your control as a developer. Someone with the appropriate resources might be able to do something neat.
I've thought about selling my code snippet for handling payments on something like Gumroad or similar. However, it's not a great solution since people still need to sign up somewhere and then install add-on. Plus they need to subscribe on stripe with their same email that the add-on will use (since the code grabs their email programmatically). As I'm thinking through this, there could be ways to mitigate some of these issues but who knows!
There is someone that built something similar but for browser extensions (https://extensionpay.com/).
I had spent years building a reputation in various forums, chat rooms, etc. I had released some free software that a bunch of people used. So it wasn't hard to get users when I released a paid product.
I'm not sure this side project could be achieved any other way.
It required a little domain specific knowledge to create, and a recognized name among trading forums to initially market. Otherwise it's super simple and I'm continually surprised that there are no real competitors.