Doing a get column in Google Sheet

Questions
1

Hey all,

I am a tricking one. As you know Google Sheet alows you to read a row but I have not found how can I read a Column.

To be more specific I need to match a row and column to add something. In this table below each column represents a week and then Column A is code.

I need to search for example week 5 row 4 and then marked with a value that I bring

image
image1263Ă—111 5.67 KB

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

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

try this:

  • in Edit Fields Node you can either set the week-number dynamically or from some other source
  • in the GoogleSheets Node choose “Map automatically” and provide a valid identifier for your row (“ARTICULO”)
1 Like
4

Thanks it work as you said

1 Like
5

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