is there a way to add a row to either a google sheet (preferred), an external spreadsheet (2nd preference) or a dt3 spreadsheet every time i add a document to my dt3? in other words a regularly updated list of all the documents i have in here?
No idea, I don’t use spreadsheets.
This script gets all filenames, might be a good starting point.
-- Get list of all filenames property theDatabaseName : "_temp" tell application id "DNtp" try set theDatabase to database theDatabaseName set theFilenames to filename of content of theDatabase #set theFilenames_string to my tid(theFilenames, linefeed) on error error_message number error_number if the error_number is not -128 then display alert "DEVONthink" message error_message as warning return end try end tell on tid(theInput, theDelimiter) set d to AppleScript's text item delimiters set AppleScript's text item delimiters to theDelimiter if class of theInput = text then set theOutput to text items of theInput else if class of theInput = list then set theOutput to theInput as text end if set AppleScript's text item delimiters to d return theOutput end tid
Does it have to be a spreadsheet - Why not use a smart group that lists all the documents
fwiw I can copy/paste the list into a spreadsheet
I would keep it simple and have the script write the filenames to a .csv file.
It’s easy to import the .csv file into a spreadsheet