Beginner excel form filling

Questions
1

Hello! I’m new to n8n and I want to let users upload an Excel file, extract fields for form filling, and then create a PDF that uses that information to fill in the Excel. However, I’m having trouble with the very beginning, specifically with the onFormSubmission and switch nodes. I can’t seem to separate the process into two branches.

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

{

Information on your n8n setup

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

Here is the beginning for you:

3

it works! OK may I know that we must use code? we cannot pure use UI? this is what I am struggling. Seems n8n still rely heavily on code,=

4

No, it doesn’t really rely on code much, but I found that splitting binaries is one of those cases when code node shines.

5

you save me life!!! I just stuck in this little step now I complete the whole working flow….however, I guess I need to do a branch of RAG for PDF parts in order to find the information and fill in the Excel field. hope can figure out

6

Glad I was able to help you and you are on the right direction to getting this whole thing done. If the answer was helpful, kindly mark my answer as solution. Thank you.

Cheers