Format & Filter HAROs

[mmarrs]

Hoping to create an Active Piece system that can filter and organize text from HAROs, just like i have managed to set up for Zapier.

For those you don’t know, HAROs are an email you get from journalists every day with requests. It looks a bit like this (these are just a few in a list of hundreds)

---

2. Summary: registered dietitian or medical doctor to comment on potential benefits of potassium supplements

Name: Alyssa Northrop Forbes Health

Category: Biotech and Healthcare

Email: query-fs3s@helpareporter.net

Media Outlet: Forbes Health

Deadline: 7:00 PM CST - 28 September

Query:

I’m writing an article for Forbes Health on the potential
benefits and side effects of potassium supplements. I’m looking
for a registered dietitian or medical doctor to answer the
following questions:

• Who may benefit from taking potassium supplements? * What
  are the potential health benefits of potassium supplments? (all
  claims will need to be backed by research) * What is the
  recommended dosage for potassium supplements? * What should
  someone consider before purchasing a potassium supplement?

Please let me know how you’d like to be referred to in the
article (name, qualifications, where you’re based, and a link to
your professional “about” page).

Thank you! Alyssa

Requirements:

registered dietitian or medical doctor

Back to Top Back to Category Index

---

3. Summary: Otolaryngologist needed for UnitedHealthcare articles

Name: Lauren Bedosky UnitedHealthcare

Category: Biotech and Healthcare

Email: query-fs4v@helpareporter.net

Media Outlet: UnitedHealthcare

Deadline: 10:00 AM EST - 28 September

Query:

I’m writing a few articles about hearing loss for the
UnitedHealthcare blog and I need an otolaryngologist who can
answer the following questions:

• How do loud noises harm the ears and lead to hearing loss? -
  How loud does a noise have to be to cause hearing damage and
  loss? - Who faces the greatest risk for hearing damage and loss
  from loud noises? - What can people do to protect themselves
  from hearing damage and loss from noises?

Requirements:

Otolaryngologist

Back to Top Back to Category Index

---

4. Summary: Vets Needed for Story on Reverse Sneezing in Dogs

Name: Brittany Natale Chewy

Category: Biotech and Healthcare

Email: query-fs69@helpareporter.net

Media Outlet: Chewy

Deadline: 12:00 PM EST - 29 September

Query:

Hi! I’m looking for vets who can help answer the below questions:

• What is reverse sneezing in dogs? - Are there certain breeds
  who reverse sneeze more than others? - What does reverse
  sneezing in dogs sound like? - Why do dogs reverse sneeze? - How
  to stop reverse sneezing in dogs

Requirements:

Vets (DVM)

---

What I want to do is have ActivePieces is to format and split up all this text into:
Subject
Category
Journalist
Outlet
Email
DueDate
Query
Requirements

And then upload all ones that have “pet” in the subject or query, and upload those to a spreadsheet.

I have the Zap step screenshots I use here: Zapier HARO Uploads - Google Drive

Would love to switch away from Zapier to ActivePieces for this!

[thisthatjosh]

I am not currently doing that in AP, as I am not aware of a tool, that can specifically grab information like that in AP. However, I do actively use openrouter, and ask it to filter information, each in insular steps.

I’d be happy to help you if you wanted to try.

Interestingly, we may be able to actually build responses as well, of which you would have to approve.

[mmarrs]

Id’d definitely be open to trying OpenRouter if you have some ideas!

[thisthatjosh]

reach out to me on telegram or discord by the same name, and I can try to help

[ashrafsam]

Hi @mmarrs Is it appropriate to suggest doing this with ChatGPT? We have this as a piece with all models available.

I tested out the capability, posted 12 HARO items from my email to ChatGPT and prompted it like this:

turn the following HARO items into a JSON array, for each item include the following props:
Subject
Category
Journalist
Outlet
Email
DueDate
Query
Requirements

And the result was:

If this looks like something you’d like to consider, I can help you out with it.

[ashrafsam]

I just saw you suggested something similar with OpenRouter @thisthatjosh Sorry for repeating your suggestion but I was excited to try it out haha!

I can help if needed.