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:
- Zapier needs to know when a new PDF report is added to Google Drive (or similar service).
- 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.
- We then need to automatically send a preset email to every contact with that matching child name.
Is this possible? Thanks in advance!