---
title: "Extract text from multiple Google Docs into a Sheet"
author: "Phil Bainbridge"
date: 2021-07-13T19:33:53+00:00
modified: 2021-07-13T19:33:57+00:00
canonical_url: https://pulse.appsscript.info/p/2021/07/extract-text-from-multiple-google-docs-into-a-sheet/
markdown_url: https://pulse.appsscript.info/p/2021/07/extract-text-from-multiple-google-docs-into-a-sheet.md
categories:
  - "Beginner"
  - "Docs"
  - "Sheets"
  - "Solutions"
  - "Video Tutorial"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2021/07/Get2BParagraphs2Bfrom2BDocs2BTool.png
description: "The following Google Apps Script is designed to iterate through Google Docs in a given Google Drive folder and extract the paragraphs of text along with a link to each file into a Google Sheet. A new column will automatically be appended for each paragraph."
---

# Extract text from multiple Google Docs into a Sheet

![Extract text from multiple Google Docs into a Sheet](https://pulse.appsscript.info/files/2021/07/Get2BParagraphs2Bfrom2BDocs2BTool.png)

> The following Google Apps Script is designed to iterate through Google Docs in a given Google Drive folder and extract the paragraphs of text along with a link to each file into a Google Sheet. A new column will automatically be appended for each paragraph.
> This tool was designed with the vision that you may wish to centrally collate some comments/feedback written by others in Docs, into one central location so you do not need to open each file in turn.
> [https://www.pbainbridge.co.uk/2021/07/extract-text-from-multiple-google-docs.html](https://www.pbainbridge.co.uk/2021/07/extract-text-from-multiple-google-docs.html)Provide a Google Folder ID to extract text from Docs

Source: *[The Gift of Script: Extract text from multiple Google Docs into a Sheet*](https://www.pbainbridge.co.uk/2021/07/extract-text-from-multiple-google-docs.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/07/extract-text-from-multiple-google-docs-into-a-sheet/](https://pulse.appsscript.info/p/2021/07/extract-text-from-multiple-google-docs-into-a-sheet/)*