Google Script approach

[ondrae]

What

First attempt to put a warning on old out of date Google Docs was to use Google Scripts at https://github.com/18F/old_docs/blob/master/Code.js.

How

The intention was to write a script that would go through all of 18F's Google Docs, find the ones that hadn't been edited in a year, and put a little warning in the header that would let the reader know as much.

We found a few limitations though:

• Google scripts can only can find files in the script runners Google Drive.
• Adding the ugly orange header update the files lastModified attribute, so it no longer appears to be old or out of date (expect for the big orange header explaining as much.

[ondrae]

I could see a process like this:

• A slack bot that pings people to do some annual cleanup. It list out a few things they should do.
• One of the recommendations would be to run a Google Script like ours.
• It would list out the un-edited Google Docs owned by that person. (Maybe only ones also shared with others)
• It would ask them if they'd like to add an Out of Date header to the doc.
• Do so if they opt in.
• Done till next year.

[wslack]

Very interested in what y'all figure out; this is a tough problem.

Have you reached out to the GSA google account manager and technical rep?