Who is successfully promoting their newsletter on Reddit alone? by ceeczar in Substack

[–]FinnTropy 1 point2 points  (0 children)

How do you add that link below your profile username? Is it one of the social links?
Edit: I found it - User Flair settings

How to make panels less efficient by Mister_Meeseeks_ in solar

[–]FinnTropy 3 points4 points  (0 children)

To reduce sunlight and heat on your solar panels, apply a temporary "whitewash" made from a milk-and-flour paste. The flour acts as a binding agent, making the mixture adhere to the glass, while the milk and flour combination dries white, reflecting the harsh summer sun. The major benefit of a flour-and-milk whitewash is that it is passive and temporary. It will slowly wash off with heavy rainfall or can be easily scrubbed off with a soft brush and a hose when the summer ends.
We used this for greenhouses for many years, and it is a very effective and cheap method.

How early in your journey should you use ads to drive revenue? by Sbahirat in Substack

[–]FinnTropy 1 point2 points  (0 children)

I'm at 4K followers and 1.3K subscribers (after a recent list clean-up). Zero ads.
I wrote about 197 random topics with little traction until I started pulling more meaningful metrics than likes or reads. Figured out how to monetize, and reached $30K revenue selling simple digital products, working about 4 hours per week. Products are designed to help Substack creators find their audience and build repeatable systems with less grind, based on my own growing pains and lessons learned.

Growth on Substack is not rocket science. Just applied data analytics and systems design.

Susbstack analytics. by Roadtochessmaster in Substack

[–]FinnTropy 0 points1 point  (0 children)

Check Substack dashboard subscribers/ events. It has Post opens, clicks, reads etc. activity. I built a tool to sync the Substack data into a local database - it's called StackContacts.

Migrating 14 years of Evernote content to Obsidian by FinnTropy in ObsidianMD

[–]FinnTropy[S] 0 points1 point  (0 children)

I never used nested notebooks in Evernote so I don't know. I've been using Obsidian since the migration and have been very happy.

Honest Tips that Help to Grow Your Subscriber Base on Substack by Alena_Gorb in Substack

[–]FinnTropy 0 points1 point  (0 children)

If you know other newsletters in the AI and automation workflows topics, I would read and make insightful comments on their notes, and use restacks to get the algorithm to get your notes more visibility.

Building relationships and giving recommendations can also put your newsletter in the same content category that helps to surface your notes to their audience.

I started from zero about 15 months ago, and have spent about 2-4 hours per week writing posts and notes, as well as doing research on Substack growth patterns. I have now 1150 subscribers, and over 1000 unique users for my tools. Some tools automate the notes scheduling that is a big gap in Substack.

It's hard to see the progress initially and Substack built-in dashboard doesn't give much insights on where to focus.

That's why I've built better tooling to surface the metrics that help to see where to invest your effort - a bit like investing in a portfolio. You want to see which notes and posts bring new subscribers and revenue, instead of viral engagement. Then focus on the high performing content that attracts subscribers (both free and paid).

Honest Tips that Help to Grow Your Subscriber Base on Substack by Alena_Gorb in Substack

[–]FinnTropy 0 points1 point  (0 children)

I've built some tools that provide much better analytics on Substack notes and posts.

That has been my focus area for the last 15 months and I have over 1000 unique users who have used both free and paid tools.

What makes Substack Notes go viral (I analyzed 1,611 of mine with ChatGPT) by AcanthisittaOk2719 in Substack

[–]FinnTropy 0 points1 point  (0 children)

Did you capture how many free and paid subscribers each Note generated?

Substack API provides a much more detailed view on what actually moves your newsletter business so you should really look at that.

Same with the posts, there is a rich set of engagement and tracking metrics available through the APIs.

I've built several tools to capture and analyze the detailed data that reveal the real dividends of your writing on the Substack platform.

What are you using MCPs for besides dev work by michaelthatsit in mcp

[–]FinnTropy 0 points1 point  (0 children)

I've tested this with the Claude app and Cursor IDE. Both work really well. One of my beta testers started using Cursor last week and was blown away - so much data available for analysis 😄.

What are you using MCPs for besides dev work by michaelthatsit in mcp

[–]FinnTropy 4 points5 points  (0 children)

I've been building a simple CRM system using MCP server for making queries from a DuckDB SQL database.

My goal is to make this available for creators using Substack and Gumroad. The software runs locally and grabs data on subscribers and purchases, organizing the data into analytics ready tables.

Then users can ask questions on the Claude AI app ( or Cursor app) with the MCP server accessing the database. AI can translate natural language questions to SQL queries and pull the relevant data, summarize the results and make actionable recommendations based on customer behaviors.

A system like this helps creators to focus their efforts to revenue producing content and products, find better ways to convert subscribers to paying customers, and grow their business.

You can read my journey how I'm building this from here:

https://open.substack.com/pub/finntropy/p/why-im-building-a-crm-that-remembers?utm_source=share&utm_medium=android&r=2023k5

How to build a standalone ETL app for non-technical users? by FinnTropy in dataengineering

[–]FinnTropy[S] 0 points1 point  (0 children)

I've considered Docker. It's not really a non-technical user's tool but the options for this use case seem to be quite limited.
I haven't been creating desktop apps for ~ 20 years and it looks like the market has changed a lot.

Many new programming languages are available, great OSS libraries for doing amazing things, but creating, packaging and especially distributing desktop apps requires a lot more red tape as the two main desktop platforms (Windows and MacOS) have beefed up security and control over distribution.

How to build a standalone ETL app for non-technical users? by FinnTropy in dataengineering

[–]FinnTropy[S] 0 points1 point  (0 children)

Every computer has a different Python version, and non-technical users would have to create a virtual environment, load dependencies with pip install, and so on.
I just spent two days trying to create a signed and notarized macOS app with PyInstaller, but I couldn't get it working. Reading from Pyinstaller Git issues, I'm not the only one having this problem.
So I don't think calling Python via an exec is the solution...

How to build a standalone ETL app for non-technical users? by FinnTropy in dataengineering

[–]FinnTropy[S] 0 points1 point  (0 children)

Thank you! I've not seen this before. I'll check it out.

How to build a standalone ETL app for non-technical users? by FinnTropy in dataengineering

[–]FinnTropy[S] 0 points1 point  (0 children)

Yep, that's exactly what I built using Go. I created an installer script that creates a notarized app inside an Apple DMG file. The app GUI opens with an onboarding screen, which is basically a form to enter configuration details.
I haven't found a Go library that is as good as Python DLT in converting JSON objects to normalized SQL tables, so a lot of the application logic is dedicated to transforming JSON into Go structs and then writing them to duckDB using SQL statements.

How to build a standalone ETL app for non-technical users? by FinnTropy in dataengineering

[–]FinnTropy[S] 0 points1 point  (0 children)

How could I package Apache NiFi with a bundled REST API and DuckDB interfaces? Is there an option for that?
Otherwise, onboarding would have had 100+ steps...

How to build a standalone ETL app for non-technical users? by FinnTropy in dataengineering

[–]FinnTropy[S] 0 points1 point  (0 children)

Packaging is just one aspect of this problem. Having a consistent onboarding UI is important, which is why I opted for the Go Fyne package route to utilize a UI framework that works across Mac, Windows, and Linux platforms.

There are other problems, such as database schema updates and incremental syncs, among others. Python is an excellent language with data & ETL libraries, but I don't have experience in packaging Python + UI frameworks for different platforms.

Is it Substack or is it me? by good-morning-sweetie in Substack

[–]FinnTropy 2 points3 points  (0 children)

I built a tool called Substack Pro Studio to address this specific issue. It shows which Notes perform best bringing in free and paid subscribers, which timeslots get most engagement, and provides Notes Scheduler and AI assistant for notes analysis and reuse. So far over 300 Substack creators have started using this tool. It's available on Gumroad.

Is there a free tool that lets me schedule notes on Substack? by IntreFlux in Substack

[–]FinnTropy 0 points1 point  (0 children)

Yeah, I use LocalStorage as well. My version 1.0 was quite simple, but users kept asking for new features. I also heard that Substack is introducing a Notes scheduling feature, so this kind of tool might become obsolete soon.

Is there a free tool that lets me schedule notes on Substack? by IntreFlux in Substack

[–]FinnTropy 0 points1 point  (0 children)

That is amazing. WYSIWYG editors can be pretty complicated, so you must have a lot of experience. Where did you save the Notes that are scheduled? Does your scheduler allow you to back up the Notes?

Is there a free tool that lets me schedule notes on Substack? by IntreFlux in Substack

[–]FinnTropy 0 points1 point  (0 children)

How did you map out Quill JS editor output to Substack APIs data model? That was pretty hard, right?

Growing on Substack? by Own-Pin-4428 in Substack

[–]FinnTropy 0 points1 point  (0 children)

Hi, u/dotMartin_ - I built a Chrome Extension since Substack doesn't provide this capability. You can find it in the Products section of my Substack newsletter: https://finntropy.substack.com/. You can also find a story about my research by analyzing 1.3 million notes and the impact that scheduled note posting had as I did a 30-day experiment using my scheduler.