---
title: "Search Google Drive files and extract row data"
author: "Phil Bainbridge"
date: 2021-08-10T20:26:06+00:00
modified: 2021-08-10T20:26:12+00:00
canonical_url: https://pulse.appsscript.info/p/2021/08/search-google-drive-files-and-extract-row-data/
markdown_url: https://pulse.appsscript.info/p/2021/08/search-google-drive-files-and-extract-row-data.md
categories:
  - "Beginner"
  - "Drive"
  - "Sheets"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2021/08/Search2BDrive2Bfor2Bdata.png
description: "The following Google Apps Script is designed to search the content of files on Google Drive which includes the given search word(s). Once it has collated these files it will then go into each one, search for the row of data that matches our search word(s) and extract that into a collective Google Sheet."
---

# Search Google Drive files and extract row data

![Search Google Drive files and extract row data](https://pulse.appsscript.info/files/2021/08/Search2BDrive2Bfor2Bdata.png)

> Search and extract the content of Google Drive files. Collate the row data into a collective Google Sheet.
> [https://www.pbainbridge.co.uk/2021/08/search-google-drive-files-and-extract.html](https://www.pbainbridge.co.uk/2021/08/search-google-drive-files-and-extract.html)Search and extract the content of Google Drive files

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*](https://www.pbainbridge.co.uk/2021/08/search-google-drive-files-and-extract.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/08/search-google-drive-files-and-extract-row-data/](https://pulse.appsscript.info/p/2021/08/search-google-drive-files-and-extract-row-data/)*