So I have a substack, but have decided to go with Medium long term. I have made $300 this year accidentally so I feel I could perhaps nourish into a real income stream. I can't be assed audience building and I prefer working in public. I post all my articles publically but syndicate to medium privately, and they still make money. I've spent years trying things out, but I had a long think about what I have that no-one else does, and realised I have a lot of knowledge and a bird's eye view, so my most valuable resource is not my original ideas, but my ability to summerize what is going on in my niches as a domain expert. Discovery is a hard problem and I have that info so now I jsut write it down and it seems to do well
https://tom-larkworthy.medium.com/100-beautiful-and-informative-notebooks-of-2021-dc2362f7ccf1
My other most read article is
https://observablehq.com/@tomlarkworthy/hacker-favourites-analysis
So the data for me is fairly clear, aggregation and summary by experts is something people are desperate for. I am kinda disappointed my own ideas rarely get traction but on the other hand it utilizes a resource I already have so it's not actually that hard to do.
Sorry I can't help much about substack though.