You can create automated document workflows in most Google Workspace apps, including Google Docs, Sheets, Gmail, and Forms. How to automate document workflow: Apps Script vs. add-ons ...

It might take 10-15 minutes, but eventually you’ll start to see a list of the emails you’ve marked form inside the Google Sheet alongside a note saying whether or not the script was successful.

Google Apps Script is a JavaScript-based language used for the creation of add-ons and extensions for applications in the Google ecosystem, including Docs, Sheets, Slides, and Forms.

This simple Gmail script will fix that. This Google script will run in the background, on Google’s servers, and mark any archived email as read without you having to lift a finger.