Help with matching and iterating multiple rows/columns in sheets for cold email system

How To
, ,
1

I’m building a basic local business web scraper via apify & anymail. The scraper is built, and dumps into Google sheets. It dumps all the emails it collects into a single cell as an array. I have a couple formulas to separate the emails into their own cells, and another one to separate the names.

image
image2540×238 23.6 KB

What I want to do:

  • Build a workflow that iterates through all the new rows & columns that are added, matches the email with the name (Email 1 & Name 1…) and writes an email. If I scrape a business and pull 3 addresses, it should send 3 emails, then move onto the next row.
  • The first letter of the name should be capitalized (john → John)
  • Generic emails (info@, service@, contact@) should have a generic greeting (Hi / Hello)
  • Some rows might have 1 email, some might have 5, but I’m pretty sure the iterator can account for that on its own, if not let me know.

I’m having issues figuring out how to target and iterate the different columns within each new rows. If I can get that going, I think the rest should be pretty straight forward.

Thanks!

2

Hey Alex!

I am currently trying to learn implementing real issues in make.com, i have completed the make.com courses (foundation till Advanced) but i still feel like my actual implementation is mediocre so i have decided to try helping others to get my own experience up.
I have tried making the scenario that you described and it might not be good/perfect since i am still trying to learn but i hope it gives you some type of value.

How does it work:
I have excel module called “search rows” to check the rows that are in the doc, i then filtered it between generic emails (info@ etc.) and non generic, like you wanted. I added a prompt (which you will need to change) that will generate a message you can send to the email. This prompt generates an prompt and starts with the first letter of the “name” as capital with the function Upper(). The generic email just says " hello,". I have also filtered the 5 emails on different module’s so that it will only generate and send an email if it isn’t blank( so if it exist).

Please let me know any optimizations and feedback since that’s valuable for me and it took me quite some time building it as a beginner, so i would highly appreciate some feedback!

The scenario:
blueprint (3).json (395.2 KB)

2 Likes