I have quite a bit of experience in scripting using google sheets. I have developed different applications in google sheets such as Timeline tracker (Quite similar to the current project described, It used to send email's on new Task's Posted/If the Task's Status has been changed and many more functions).
Relevant Skills and Experience
Scripting in Google sheets, creating timeline Tracker, auto scraping information from website periodically