Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Trying to automate a specific email... help!

  • February 25, 2020
  • 6 replies
  • 113 views
M

Hello, I am trying to automate an email series I have to send out to a number of people and it takes FOREVER. Bear with me through the details...

I am the course scheduler for my department at a university. During the course scheduling period, I will send EACH teaching instructor their course load with some email text. The course load information can either come from an Excel spreadsheet with multiple rows dedicated to each class/lab/seminar etc, or from a PDF version with the same information broken down in a more paragraphical way.

I am looking for a workflow that will select the chunk of rows from the spreadsheet that belongs to each professor, and send that information in the body of an email to said professor.


Any suggestions?


Best answer by AndrewJDavison_Luhhu

Hi @matteberry

So, if you're able to switch to Google Sheets, then there is a search step that allows you to grab multiple rows of data:

Screen Shot 2020-02-26 at 10.18.54.pngAs for grabbing the data from PDFs, you'll want to look at apps like https://docparser.com/ which integrates with Zapier.


View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Hi @matteberry

So, if you're able to switch to Google Sheets, then there is a search step that allows you to grab multiple rows of data:

Screen Shot 2020-02-26 at 10.18.54.pngAs for grabbing the data from PDFs, you'll want to look at apps like https://docparser.com/ which integrates with Zapier.


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
M
1 person likes this
  • M
    matteberry
M
  • matteberry
  • Author
  • 3 replies
  • February 26, 2020

Hi @AndrewJDavison_Luhhu,

Yes, I figured that feature of google sheets would come into play. But then how do I specifically get the workflow to pull each row associated to a professor, and email it to them?


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@matteberry

Is there (or can there be) a column stating which professor each row belongs to? Then you could make that your search criteria.

This would mean a zap for each professor, though.


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
M
1 person likes this
  • M
    matteberry
M
  • matteberry
  • Author
  • 3 replies
  • February 26, 2020

@AndrewJDavison_Luhhu

Yes there is a professor column. Theoretically I could also add a column with their emails.

-- so that is the problem. Would there be any way to do a multi-step zap that could limit the need to do a zap for every prof?


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

You might want to check out Integromat.

It's similar to Zapier, but in the case you can setup a single operation of a single automation scenario to retrieve all rows on a Google Sheet and iterate over all of them.

Combining that with a column of professor's email addresses and you should be able to do what you want.


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
M
1 person likes this
  • M
    matteberry
M
  • matteberry
  • Author
  • 3 replies
  • February 26, 2020

@AndrewJDavison_Luhhu

Thank you! I will check that out!!


Terms & Conditions