Please can you tell why workflow isn't executing; I have connected all files but something is not working, merge of titles and prompt is not working. Workflow link
Describe the problem/error/question
Please can you tell why workflow isn’t executing; I have connected all files but something is not working, merge of titles and prompt is not working. Workflow link
hey, that workflow link you shared is private to your n8n cloud instance so nobody else can actually see it to help debug. You’ll need to go into the workflow settings and hit Export, then paste the JSON here so we can take a look at what’s going on with your merge. Also if you can share what data is coming into the merge node from both branches that would help, sometimes the issue is one branch isn’t actually sending anything so the merge just sits there waiting.
I’d love to help you find solutions to your workflow, but not possible to access the workflow link you shared. n8n workflow links are private and only accessible to users with permission.
you’ll need to share your workflow in JSON file or take a screenshot of your full workflow.
System says new user cannot upload JSON files. but the image below shows my set up.
Here is the description of the task I am trying to do:
Build a workflow that copies a title from a document; merges the topic with preexisting prompts in a google doc; run the prompt on Google Gemini; and paste output in another document.
Titles source document is a google sheet; prompt is provided in google doc; output will be google doc and google sheet each output parameter from product name, and alphabet A to j serving as column header; and product category from source google sheet also appended in a column.
hey, from the screenshot it looks like your Merge node might be set to the wrong mode, if one input finishes before the other it’ll just wait forever. Try switching it to “Combine” mode with “Merge By Position” so it doesn’t block. Also worth clicking Test Step on the nodes before the merge to make sure both branches are actually outputting data, sometimes one side comes back empty and the merge has nothing to work with.
// Get the prompt from the first input
const prompt = $input.first().json.prompt;
// Get all titles from the second input
const titles = $input.all();
// Create output combining each title with the prompt
return titles.map(item => ({
json: {
title: item.json.title,
prompt: prompt,
category: item.json.category
}
}));
Set node → Build the final prompt: {{ $json.prompt }} {{ $json.title }}
Google AI → Process
Output nodes
Specific Configuration Steps
For the merge Node (if you keep it):
Set Mode to “Append”
This will give you all items from both sources
But you’ll still need a Code node after to properly combine them
For the Google AI Node:
Make sure the prompt field references the merged data correctly
Example: {{ $json.combinedPrompt }} or however you name the field
For Output Nodes:
Google Sheets: Map each output parameter (A-J columns) to the correct field from Gemini’s response
Google Docs: Format the output as needed
Next Steps
Add a Manual Trigger at the start if you don’t have one
Test each node individually using “Test step” to see what data each produces
Check the Merge node output - click on it after execution to see what data structure it creates
share the error message if you see any red triangles on nodes.
Hi @Charles.T_Adesina!
The workflow seems pretty straightforward and should be running just fine, make sure your Get Titles From Sheet at least output’s something as the merge node needs 2 inputs to merge in, although i am a little unclear about the error and actually in which node you are facing it, i recommend running your workflow and pinning all the data then copy pasting JSON in the preformatted text field, let us know if you are still facing that issue!
