Need help with a simple Google Script. I have a Google Form that contacts need to fill out with their contact info. As they fill it out their email addresses are collected by default, which will be captured in column B of Sheet 1. Sheet 2 contains the list of email addresses who needs to fill out the form.
The script needs to compare the responses against the master list. If someone's email address is missing from the responses list, an email reminder would be sent with details.
Once the script is completed I would get an email letting me how many people have responded so far and how many more still need to.
Link to the spreadsheet:
[login to view URL]