Search and extract the content of Google Drive files. Collate the row data into a collective Google Sheet.
This was created for a specific Subject Access Request but may be of interest/use to others.
Source: The Gift of Script: Search Google Drive files and extract row data
![Phil B Profile Pic](https://pulse.appsscript.info/files/2024/02/Phil-B-Profile-Pic.png)
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog, where I also have a number of useful Google Add-ons: www.pbainbridge.co.uk