How to Use Zapier and ChatGPT to Find Newsletter Sponsors | YMH No. 59


How to Use Zapier and ChatGPT to Find Newsletter Sponsors

One of the best ways to identify potential sponsors for an email newsletter is to monitor other newsletters.

It sounds simple enough, but for a newsletter creator, it can feel like there are just two options. You can either manually monitor dozens or even hundreds of newsletters, or you can pay several thousand dollars a year to use a service.

Recently, I came up with a third option. I built a rudimentary email parser that captures emails, identifies sponsors, and produces a spreadsheet I can use to prospect potential advertisers.

The Email Parser

This very basic parse requires a domain, a Zapier Pro account, paid access to the ChatGPT API, and a Google Drive account.

Set Up an Email Address

Start with an Email by Zapier trigger. In the configuration step, this trigger will provide an email address. You will need to customize it a little, but it will probably look like this: example.1234z@zapiermail.com.

Next, I went to my domain registrar and set up an email forward so that the email address armando@adomainiown.com forwarded to the Zapier address example.1234z@zapiermail.com.

Email verification was a little tricky. I had to capture the verification message in Zapier, extract the HTML output from the zap, create an HTML file, and open the file in a browser to find and click the verification link. But this was just about the most technical part of the entire process.

Ask ChatGPT

The next action in the zap is to ask ChatGPT to identify the sponsor in an inbound email.

ChatGPT was surprisingly good at identifying sponsors in my initial tests, but I had to add the exact format I wanted in the "Assistant Instructions" section of the zap.

Parse the JSON

The output from ChatGPT must be parsed to extract the values for the sponsor name, ad copy, image URL, and link.

Although I consider myself a capable Javascript developer, I asked Zapier's code AI to generate a script to parse and output an object.

Connect to a Google Sheet

The final step in the zap is to connect to a Google Sheet, adding a row each time a new sponsor is found.

Just like that, the sponsor information is added to the designated Google Sheet.

Getting Newsletters

Start signing up for the email newsletters you want to track and use the sponsors they get as your newsletter's sponsorship lead list.

412 South 3rd Street Apt. 609, Boise, Idaho 83702
Unsubscribe · Preferences

You, Money, Happiness

You, Money, Happiness helps newsletter creators and bloggers grow and earn online.

Read more from You, Money, Happiness

Top stories for bloggers, newsletter writers, and content creators. Please share this newsletter with one person. No. 1: Google Boosts Credibility for Creators Google's latest moves have significant implications for content creators. The search giant now explicitly recognizes individuals as content creators, assigning them titles like "Content Creator (Health)" or "Content Creator (Travel)" in search results. This new labeling is a game-changer for SEO. For the creators, it means more...

Arguments For and Against Microtransactions and Pay-per-article Schemes Could accepting tiny little payments of just a few pennies each be a way to unlock loads of blog revenue? That is the question at the heart of a recent Reddit post, "What do you think about making money from your content with microtransactions?" In the context of monetizing a blog, the term "microtransactions" often describes a low-cost paywall. The idea is that readers pay a small fee ranging from a few cents to about a...

Top stories for bloggers, newsletter writers, and content creators. If there is an article you think should be included in this roundup, please reply with a link. No. 1: Fix Problems, Then Grow If you're feeling stuck, constantly chasing opportunities but seeing limited results, you're probably focusing on the wrong things. Alex Hormozi breaks it down —there are two main forces at play in a content business—problems and opportunities. Missed opportunities are exciting. They're the shiny new...