google docs to openai

Applejack86

Member
Hopefully someone can help me with this, because I am missing something. I wanted to create a process that triggers when a Google Doc is added to a folder. The document is a transcript of a meeting. I then want OpenAI to take the transcript, summarize it, and list tasks and owners. It is then emailed. My issue is that the OpenAI action does not take the document's content. It will email a response, but it is all made up. Can anyone give advice? Thank you in advance
 

Applejack86

Member
Hey @Applejack86

Please refer to the following video tutorial once on how you can process the data from Google Docs to OpenAI then try again.

@Supreme Thank you for the reply. Can you please clarify, how to map the Google Docs? When I select the map data, there are several options. I cannot figure out how to map the data so OpenAI reads the content in the document.
 
Last edited:

Applejack86

Member
Thank you for the response but it doesn't address my issue. I will try to restate my senerio and question.

I have a scribe tool for Google Meetings that once the meeting is complete it sends a transcript of the meeting to my Google Dive.

The trigger - when a new document is added to that folder.

Action 1 - OpenAi is prompted to use the document and provide meeting notes.

Action 2 - The response from Action 1 is emailed.

The Problem - in Action 1, OpenAi does not use the document to provide meeting notes. It instead provides sample (made-up) meeting notes.

It appears that OpenAi is not opening/reading/using the content in the document. I cannot figure out how to get OpenAi to read the content in the doc.

In the training videos when mapping a specific cell or response is seen in the drop down and used. Example, along with other meta information a name, email fields can be found in the drop down. Straight forward if I am looking to use a specific field.

I tried to map it using the document ID for example, but it did not return ANY information from the document when I tested. I tried several different options from the mapping drop down but none seem to work when I test.

What am I missing here? Is there a step required before OpenAi can read the document? Can it not read the document? Is there an easier integration?
 

Supreme

Well-known member
Staff member
Hey @Applejack86

Regarding your concern, the " Google Docs: Get Document Details" action step might be required after the trigger event to extract the data from the Doc which you can pass in the Open AI action step.

So, kindly recapture the webhook response once with the desired doc and then try again.

1673846367895.png
 

Applejack86

Member
Thank you, that did work to fix the error, but the overall issue is still there.

When I get to the OpenAI: Generate Content Action, I cannot map the content. I tried mapping it to the "Google Docs: Get Document Details" step, but I don't know what option to use. When I test the request, OpenAI makes up meeting details, it does not use the information in the Doc.

Is there a better way for this to be resolved? There is a lot of back and forth and I have to wait 24 hours to get an update.
 

Supreme

Well-known member
Staff member
You can now use all the TextRun Content type fields from the response to pass the data in the Open AI action step.

1674022599453.png
 

omp

Member
hi,
My students submit homework to my Google drive, different docs have different numbers of paragraphs. Then I will process their homework using OpenAI.

However, Google docs return text content for each paragraph. Is there any tip and trick that can combine them into one?
 
Top