Required Google Apps Script,Google Apps,Google Sheets freelancer for Google Sheet Automation / Google Apps Script - To Send Email From Sheet job

Secenario:

We run a content marketing agency. I have a Google Spreadsheet which we use to track which clients have submitted content to us.

Columns represent clients and rows represent weeks.

When click A submits content for this week, we input some basic details into the cell.

When content is not entered into a cell for the next week, meaning we do not have content for the next week, I would like an email to send to the client as a reminder, which we can have stored in the spreadsheet.

Possible?

Skills & Expertise Required

Google Apps Script Google Apps Google Sheets