I'm the Director of the SEO team within our company. I recently built a Google Sheet as a Content Article Production Dashboard to easily track the SEO content team workflow progress.
I have a Content Article Dashboard built in google sheets that's designed to be used by my content team for tracking content article production through publishing. I have date of task completed rows for each task carried out by the team. These cells can be used as triggers in a google sheet script to send an automated email to the team member set to complete the next task. I would like to have the Article title used as the subject line in the emails. There are 6 columns containing cells that will be used to auto send emails to the team member responsible for the next task. There are currently 5 team members to be used as email recipients. This is a fairly easy project and should be potentially completed in the same day. I've added a excel ver of the dashboard for job planning.
The work done will be of industry standard and would be liked by you ... its my promise to deliver the best. i would like you to give me a chance to showcase my talent.