I am looking to build a workflow to research and outreach to blog owners/YouTubers, such as those in the Shamboo Production space. This involves searching for blogs and YouTube channels that cover other brands in the same industry.
The workflow should identify websites with a review URL, Contact Email, and send them a personalised email to feature our Shampoo on their blog and invite them to the affiliate program.
Also, prepare the sheet with Average Monthly Traffic on URL, Blog Authority, etc using Ahrefs API.
Note: I am ready to pay upto $100 if automations works as expected
Hi Rajesh, sounds like you need a single workflow that researches relevant blogs/YouTube channels, captures contact details, and triggers personalised outreach.
A typical sequence would be: 1) start with a scheduled or manual trigger 2) call the Ahrefs API to pull sites ranking for your target keywords and filter by traffic/domain rating 3) use HTTP Request nodes to hit each site’s /contact or /about page and scrape an email address 4) push the qualified leads into a Google Sheet or Airtable with metrics like monthly traffic and blog authority 5) loop over that list and send a templated email via Gmail or SendGrid, recording status back to the same row 6) add a Slack alert branch for any failed lookups or sends.
A couple of clarifying points: which ESP do you prefer for email, and do you need deduping against past outreach lists?
Watch out for Ahrefs rate limits—chunk requests or add delay nodes if needed.
This is general guidance based on my experience with similar projects.