GOOGLE FORM to OPENAI (synthesis) to EMAIL?

[Fei]

Hello,

I’ve tried to create a flow for … quite some time to no avail as I am just beginning on this n8n…

Once a month I want to :

Read a Google Form data Sheet answers
Send it to OPENAI to make a synthesis/report
Send it by EMAIL

Workflow

Schedule Trigger “Once a month” : OK
Google Sheet “Read” : OK
Summarization Chain : NOK

Error displayed

“No node connected to required input model”
“No node connected to required document”

Information on your n8n setup

• [email protected]
• Database (default: SQLite):
• Browser (Brave)
• W11

Is it possible ?

Thanks in advance,

Fei

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[Jon]

Hey @Fei,

The error you are seeing is because you have not added a model or a document to the summarisation node, although I don’t think this is the best node to use as the data is not from a document.

Instead you could try the OpenAI node and create a prompt including your data to do the work.