Prepare Upcoming Week's Content

In the Google Sheet '[Content Calendar]', find all rows where the 'Publish Date' is within the next 7 days and the 'Status' is '[Draft]'. Update the 'Status' for these rows to '[Ready for Review]'.

Apps used

Google Sheets