Skip to main content
Question

ChatGPT can't analyze excel document from Zapier Interfaces Form

  • December 25, 2024
  • 3 replies
  • 60 views

  • Beginner
  • 5 replies

Hi there. I’ve created a Zapier Interfaces Form where people can upload excel documents.

 

I simply want to give the uploaded excel file to ChatGPT, and ask ChatGPT a question about the contents of the Excel file.

 

There doesn’t seem to be a way to get the excel sheet into ChatGPT via Zapier. And every workaround I’ve tried has failed so far. Is there a way to extract text from excel and pass it to chatgpt in order to read the content?

 

Would appreciate if anyone knows a solutions!

 

Cheers,

Rob

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.

3 replies

Forum|alt.badge.img
  • Zapier Staff
  • 9 replies
  • December 26, 2024

Hi ​@Rbm  

 

Uploading Excel to ChatGPT to have a conversation about its contents sounds like a pretty sweet idea!

 

Have you given the “Conversation with Assistant” action from ChatGPT a try? You could upload the file to a message using the “New Files” field. I’ve included a screenshot below of what it looks like:

 

069303dffb00630cef89dd74c8f0b209.png
(view larger)

 

The same action also has a field for “message” where you could send the prompt.

 

Feel free to let me know if you’ve tried this and run into any difficulties or limitations! 


  • Author
  • Beginner
  • 5 replies
  • December 27, 2024

Sadly I haven’t been able to get this to work with submissions from Zapier forms.

 

Here’s the error message that comes back every time. 

 

 


Forum|alt.badge.img
  • Zapier Staff
  • 9 replies
  • December 30, 2024

Hey,

 

Looks like this is a known issue with the ChatGPT API. Found a discussion on this here: https://community.openai.com/t/what-file-types-are-actually-supported/929529/13

 

Particularly, it looks like files with .xlsx extension (Excel files) aren’t supported at the moment, since it isn’t in the list here: https://platform.openai.com/docs/assistants/tools/file-search/supported-files#supported-files

 

Perhaps you could add a step that can convert the Excel file to PDF before the ChatGPT step? You should be able to do so using Google Drive upload, and there’s an answered community discussion on this here: 

(Upload Excel to Google Drive to get the sheets in a PDF format)