Archive Old Published Content

In the Google Sheet '[Content Calendar]', find all rows where the 'Publish Date' is older than 7 days and the 'Status' is '[Published]'. Update the 'Status' column for these rows to '[Archived]'.

Apps used

Google Sheets