How do I read files on a Google Drive and filter to only the latest version of a specific file?

How To
1

Hello Make Community,

Hoping someone can help as I’m super stuck and can’t seem to figure this out.

I have a Google Drive folder that has 3 documents in it (for my test case):

Industry Research - 20250612_140000
Buyer Persona - 20250612_160000
Buyer Persona - 20250612_150000

As you can see, each file has a date/time stamp at the end.
This is on purpose so I can get Make to find the “latest version” of the file.

My ultimate goal is to have Make.com look at each file name and get the latest version. In this case it should eventually read the contents of “Industry Research - 20250612_140000” (Latest version since there’s only one doc named ‘Industry Research’) and “Buyer Persona - 20250612_160000” (since that is the newest version based on date/time stamp of the ‘Buyer Persona’ file).

I have tried coming at this every which way, and been taking suggestions from GPT, but nothing I do is working.

Does anyone have any ideas?

Thanks in advance.

3

Welcome to the Make community!

Can’t you just sort by file name descending?

To do this, you can try using the Google Drive “Search for Files/Folders” module —

Searches for files or folders based on search criteria.

For more information about the Search for Files/Folders module and Google Drive app, see the corresponding Integrations page and the Help Centre documentation.

Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

— @samliew