Help with Formatting and Adding Text to Google Docs Using OpenAI Modules in Make.com

How To
,
1

Hello Make Community,

First time posting here, and I’m seeking some help with the final modules of my first scenario. Here’s what I’m working on:

Scenario Overview:

I’m building a scenario that:

  1. Takes a screenshot from my Google Drive.
  2. Uses OpenAI to extract the text from the screenshot.
  3. Format text appropriately for google doc.
  4. Appends text to google doc

Where I need help:

  • I have an OpenAI module that extracts the text. Below is an example of the output:
### Week Ending 04/18/2025

- **Achievements**
  - Lorem ipsum dolor sit amet, consectetur adipiscing elit.

- **Key Learnings**
  - Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

- **Challenges**
  - Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris.

- **Opportunities**
  - Duis aute irure dolor in reprehenderit in voluptate velit esse cillum.
  - Excepteur sint occaecat cupidatat non proident.
  - Sunt in culpa qui officia deserunt mollit anim id est laborum.
  - Tempor incididunt ut labore et dolore magna aliqua.

- **Looking Ahead (Next Week)**
  - Magna aliqua ut enim ad minim veniam.
  - Quis nostrud exercitation ullamco laboris nisi ut aliquip.
  - Ex ea commodo consequat duis aute irure dolor.

- **Connection to Long-Term Goals**

Questions:

  1. Formatting Output in Chat Completion Module: I need to pass the output from the first OpenAI module to another Chat Completion module. My goal is to properly format the text so that it will be ready to append to a Google Doc. How do I configure the Chat Completion module to properly format this extracted text?
  2. Adding Formatted Text to Google Doc: Once the text is formatted, I want to append it to a Google Doc every Friday after uploading a new screenshot to Google Drive. How do I add the formatted text to the Google Doc and ensure it gets appended rather than overwriting?

Desired Google Doc Output:

Here’s an example of what I want to achieve in the Google Doc (with an inserted screenshot):

image
image1202×799 94.4 KB

Any help or guidance on how to achieve this flow would be greatly appreciated!

Thanks in advance!