Auto update list of docs

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"
		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
	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