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)
- 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
- 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
- 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!