I have a requirement where need to automate certain process using google sheet. Explained below:
1. I will have different information which people need to read. It could be multiple information lines they can read this by clicking on Read more button then the content visible and they have to read all information by clicking on read more and they have to wait for 1 min before clicking on next read more information.
2. Once they are done reading all information they have to click on an acknowledgment button, once they do it will record the email id of the people which he has used to access sheet.
We will have list of email ids in a different tab of same sheet. Then it will match recorded email id who have taken acknowledgment and match it with pre filled emails. If anyone is missing it will send an email to them who have not taken acknowledgment along with other email ids. This it will keep everyday till everyone has taken acknowledgment from the sheet. After successful acknowledgement by everyone it will send an email to other email ids from a tab stating that everyone has taken acknowledgment for this update where Subject we will keep In a title tab of the sheet.
About the recuiterMember since May 20, 2018 Lakshit Bajaj
from Friesland, Netherlands