Scrape newsletters from Substack

Looking for someone to provide a list of publications hosted on substack.com.

Preferably someone that has experience scraping substack in the past or similar platforms.

Looking for the following details fields compiled in a CSV:

Newsletter name
Newsletter URL
Owner/Founder Name
Owner/Founder Email
Category or Industry (like fashion, cosmetics, jewel, sports, food, retail, consumer goods, consumer electronics, and several more)
# of Readers/Subscribers