Hello! My goal is to use Google Forms to collect information from my clients and then use n8n to automate the processing of this information.
My workflow involves:
Collecting data through Google Forms.
Using n8n to read the Google Sheets spreadsheet with the responses from my clients.
Applying a specific prompt (with defined functions and objectives) to analyze and process the data provided through the questionnaire in the form.
Creating a new spreadsheet with the processed information after executing the prompt.
Currently, my workflow reads and updates the spreadsheets, but the issue is that the prompt is not being executed correctly; the prompt is simply being rewritten in the new spreadsheet instead of processing the data and writing the analysis that should be executed.
Welcome to the community @sergio_eduardo_flore
Thanks for posting and sorry to hear that you’re having issues with this. You’ve posted a link to your instance but the community won’t have access to it so could you share your exported workflow JSON instead? You can do that by copy & pasting the workflow JSON in between two ``` (see docs for more details)!
Hi @sergio_eduardo_flore, thanks for sharing your workflow! From a quick look, it looks like you’re using the OpenAI node to create an assistant, which will create an assistant every time there’s a new survey entry (which I assume is not what you’re looking for here).
I think there are a few ways to go about this but here are some suggestions:
You can create an assistant (e.g. to analyze and summarise survey data) and then use another OpenAI node to message that assistant with specific instructions for every survey entry in Google Form.
You can also use the Message a Model Operation instead, here’s an example using dummy data:
You can also check out some other AI nodes that might be useful in your use case:
