Describe the problem/error/question
How could I append only information from the parsed file to the newly created sheet without the spreadsheet ID and sheet ID being appended?
What is the error message (if any)?
Please share your workflow
Share the output returned by the last node
Information on your n8n setup
- n8n version: 1.107.4
- Database (default: SQLite): SQLite
- n8n EXECUTIONS_PROCESS setting (default: own, main): own
- Running n8n via (Docker, npm, n8n cloud, desktop app): desktop app
- Operating system: windows
Hello @Ernest_Yao, how are you?
Could you provide the file used in the form trigger so I can accurately evaluate the workflow?
It would be client’s information so I cannot provide. But it is a txt file, and with the parsed code, I was able to append them to the google sheet.
It is when combined with created new sheet, I would be appending the spreadsheetID into the column as well, making the process later on difficult.
Wouldn’t it be possible to generate a sample txt file? I say this because of the function where you perform the “parse file”
@Ernest_Yao
Try this, it worked for me; based on the flow I generated a sample txt.
Since the flow is triggered by form submission, there’s no chance of repeated execution or invalid data.
In the merge node, it is necessary to select branch 2.
If this helps you, mark this answer as the solution. I’m grateful to be able to help.
1 Like
Hi! It works! Thank you so much. A follow up question, if I am to reference the spreadsheet Id and sheet Id later on, I could just reference {{ $(‘Get SpreadsheetID & SheetID’).first().json.spreadsheetId }}?
Another follow up question, if I run into similar problem next time, are there any sources other than the forum for answers?
