# Analyze/summarize file in Google Drive using OpenAI

**URL:** <https://community.make.com/t/analyze-summarize-file-in-google-drive-using-openai/65405>\
**Category:** Questions\
**Tags:** open-ai\
**Created:** [January 3, 2025, 9:40am UTC](https://community.make.com/t/analyze-summarize-file-in-google-drive-using-openai/65405 "2025-01-03T09:40:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jason\_Lin](https://avatars.discourse-cdn.com/v4/letter/j/df788c/32.png) [@Jason\_Lin](https://community.make.com/u/Jason_Lin)\
**Post date:** [January 3, 2025, 9:40am UTC](https://community.make.com/t/analyze-summarize-file-in-google-drive-using-openai/65405/1 "2025-01-03T09:40:02Z")

</div>

Is there an OpenAI module that I can use to analyze google sheet or any word doc in Google Drive?

---

<div class="post-metadata">

**Author:** ![Shubham\_Khajuria1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/shubham_khajuria1/32/53751_2.png) [@Shubham\_Khajuria1](https://community.make.com/u/Shubham_Khajuria1)\
**Post date:** [January 3, 2025, 11:08am UTC](https://community.make.com/t/analyze-summarize-file-in-google-drive-using-openai/65405/2 "2025-01-03T11:08:59Z")

</div>

Yes this is very much possible with just Chatgpt’s Create a completion  
module:

### **Step-by-Step Guide**

#### 1. **Trigger the Scenario**

Decide when the extraction should occur, such as:

- When a new file is added or updated in Google Drive.
- On a schedule (e.g., daily/weekly).
- Manually triggered.

#### 2. **Locate the Google Doc**

Use the **Google Drive** module:

- **Action** : “Search for Files” or “Watch Files” in a specific folder.
- **Filter** : Restrict to `.docx` or Google Doc files.

#### 3. **Export the Google Doc Content**

- Use the **Google Drive - Download a File** module.
- Set the **MIME type** to `text/plain` to export the file as plain text.
- This will extract the entire text content of the Google Doc in a raw format.

#### 4. **Process the Text**

- Use the Chatgpt - Create a completion module to analyse the output

---

<div class="post-metadata">

**Author:** ![Jason\_Lin](https://avatars.discourse-cdn.com/v4/letter/j/df788c/32.png) [@Jason\_Lin](https://community.make.com/u/Jason_Lin)\
**Post date:** [January 3, 2025, 3:13pm UTC](https://community.make.com/t/analyze-summarize-file-in-google-drive-using-openai/65405/3 "2025-01-03T15:13:36Z")

</div>

what if my data is Google sheet?

---

<div class="post-metadata">

**Author:** ![Shubham\_Khajuria1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/shubham_khajuria1/32/53751_2.png) [@Shubham\_Khajuria1](https://community.make.com/u/Shubham_Khajuria1)\
**Post date:** [January 3, 2025, 5:57pm UTC](https://community.make.com/t/analyze-summarize-file-in-google-drive-using-openai/65405/4 "2025-01-03T17:57:01Z")

</div>

The same retrieves the Google sheet then use Google Sheets search rows module to get the data from the sheet, map the data in a ChatGPT’s create a completion module and analyse the data

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [April 3, 2025, 5:01pm UTC](https://community.make.com/t/analyze-summarize-file-in-google-drive-using-openai/65405/5 "2025-04-03T17:01:42Z")

</div>