Is it possible to create Sheets translator workflow if all files are random?

Questions
1

Describe the problem/error/question:
I wanted to create a workflow for excell file translation from chinese to Eng, but files are random and i cant map every file manually. also some files has 1 coloumn on top saying the name of the company, and starting from row 7-8 there are categories like name/qty/images etc.

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: 1.106
  • Database (default: SQLite): none
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): self-hosted, docker
  • Operating system:
2

You could use an AI agent node but it will require at least 1 thing that’s similar across the sheets - starting row, general format or a column that will always have values, so it use that as a starting guide.

If you can share a few examples form the sheets maybe we can look for a common patter we can use in the AI agent node. It will then extract the ranges for us.

Hint: You can get free API key for Google Gemini here: https://aistudio.google.com/apikey

3

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