Search Google Drive for ‘Shared with me’ with Google Apps Script

Search Google Drive for all of the files found in the Shared with me space and collate the results into a Google Sheet.

Search Google Drive ‘Shared with me’ and collate the results

It will collate the following information into a Google Sheet:

• The file name as a direct clickable link,
• The file ID,
• The type of file eg PDF, Google Sheet/Doc,
• The file creation date,
• The file last updated date,
• The folder path,
• The file owner.

Source: The Gift of Script: Search Google Drive for Shared with me