Hi n8n,
I’m building a workflow to process a large Google Sheet using OpenAI. The goal is to add a new column to the sheet based on the results of OpenAI’s processing.
I’m encountering a challenge in sending the entire sheet content to the OpenAI API along with my prompt. I’d like to achieve a similar experience to how I can interact with ChatGPT directly, where I can provide a sheet file with instructions and get a new sheet in return. (I know I can process it row by row, each api call to OpenAi being one row, but it doesn’t suit the scale of my project)
Is it currently possible to send a complete file from a Google Sheet (or some other way, but still keeping it as a file) to the OpenAI API within an n8n workflow? If not, is this a planned feature or is there a workaround I could use? Perhaps I’m missing something in how to structure the API request within n8n.
Any guidance would be greatly appreciated.
Thanks!