Skip to main content
Best answer

How to use Google Doc content as ChatGPT prompt in Zapier?

  • November 21, 2023
  • 8 replies
  • 676 views

I’m trying to create a Zap where I find a specific Google doc and use the contents of it to send to ChatGPT as a “user message” or prompt. I’m not sure what I’m missing as I can’t find the contents of it as a data field. Is there another step in this Zap I need to add to extract the text of the document separately as a data point to use in the next step for the ChatGPT step? How do I do this?

Is this possible or out of scope with this ChatGPT integration?

Best answer by Troy Tessalone

@lou_cm 

Make sure the file is publicly accessible. (You may need to change the folder/file sharing permissions in GDrive.)

 

Or try this GDrive example that uses the file object, instead of a file url.

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @lou_cm 

Good question.

Check out this related topic:

 


  • Author
  • Beginner
  • 4 replies
  • November 30, 2023

Thanks so much Troy! I gave this a try and get this error when testing, do you reckon I am missing another step here? 
 

Failed to create a request in Webhooks by Zapier

The app returned "Unauthorized" (HTTP Status Code: 401)


Troy Tessalone
Forum|alt.badge.img+14

@lou_cm 

We would need to see detailed screenshots with how your Zap step is configured.


  • Author
  • Beginner
  • 4 replies
  • November 30, 2023

I have a few screenshots here of the step that is erroring 


Troy Tessalone
Forum|alt.badge.img+14

@lou_cm 

Try using GDrive Zap app to find the GDoc file instead of the GDocs Zap app.

 


  • Author
  • Beginner
  • 4 replies
  • November 30, 2023

I tried that initially but didn’t work so tried Google docs. Tried here again. 🤔


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30982 replies
  • Answer
  • November 30, 2023

@lou_cm 

Make sure the file is publicly accessible. (You may need to change the folder/file sharing permissions in GDrive.)

 

Or try this GDrive example that uses the file object, instead of a file url.

 


  • Author
  • Beginner
  • 4 replies
  • November 30, 2023

Oh wow! Thanks Troy, we just had to change the sharing to publicly accessible. I assumed Zapier <> Google Drive authorisation would enable this by default. Thanks so much for all your help!!