→

Ready-made Workflow

Log new Google Drive files in Google Sheets

Keep a searchable file register in Google Sheets when new files are created in Google Drive. Each file adds one row with File ID, File name, MIME type, Created and Drive URL. Uses Append Values to write these five values in columns A-E in that order. Column headers are optional: an empty worksheet works immediately, or you can add your own header row. Connect Google Drive and Google Sheets, choose a folder to watch, and select the destination spreadsheet and worksheet. Leaving the folder empty watches the connected Drive. Includes its own fictional English file example. Values are written as plain text; file contents and permissions are never copied or changed. A Drive link still requires existing access. Folder monitoring covers direct children only and uses creation time: moving an older file into the folder may not trigger a row. Polling can include files from roughly the minute before setup; older files, later edits and deletions are not synchronized. Use a private worksheet for the file metadata. This is an append-only register, not a live inventory mirror.