Automatically send new files to appropriate contacts

  • 15 May 2023
  • 1 reply

Userlevel 1

I lead a child sponsorship program with over 500 children. Each quarter we receive a PDF update on those children and need to send the updates to the sponsors attached to them. This is very tedious and can hopefully be automated! The process I need is:

  1. Zapier needs to know when a new PDF report is added to Google Drive (or similar service).
  2. That file name will have the name of a child. Zapier needs to search a table or list to find all contacts who are connected to that child’s name.
  3. We then need to automatically send a preset email to every contact with that matching child name.

Is this possible? Thanks in advance!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @daleeatsrice 

Good question.

Try these Zap steps:

  1. Trigger: GDrive - New File in Folder
  2. Action: [APP] - Find Record/Row
    1. e.g. Airtable - Find Record
  3. Action: [APP] - Send Email
    1. e.g. Gmail - Send Email