How could I only append the file and remember the spreadsheetid for google sheet?

Questions
1

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?

image
image903×303 34.3 KB

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
2

Hello @Ernest_Yao, how are you?

Could you provide the file used in the form trigger so I can accurately evaluate the workflow?

3

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.

4

Wouldn’t it be possible to generate a sample txt file? I say this because of the function where you perform the “parse file”

5

@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
6

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 }}?

7

Another follow up question, if I run into similar problem next time, are there any sources other than the forum for answers?

8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.