I’ve came to a situation where I needed to get the direct download url for my Google Drive files sync table (or the publicly accessible URL).
So I created a pack to do just that: Google Drive Download Url Pack, extend Coda with... - Coda
Just create a column, pass the Google Drive file ID to it and get the direct download link.
Works great with the ChatPDF AI pack, to extract info out of docs on a Google Drive folder.