I wouldn't recommend Substack (newsletter operator here).
They're trying to become the "everything" platform for some creators and there are point solutions that are much more effective, their strategy of going broad has backfired.
Twitter also penalizes outbound links to Substack because Substack tried to compete with Twitter on several of its features back in April/May.
You'll have much better luck using Convertkit/Beehiiv if you're trying to create a funnel involving a newsletter.
The Feed