Hi!
I would like to query a column from an Excel365 sheet for import into matching monday.com Item Updates (ie: The Update section that is used for internal chat regarding an item in monday.com).
I have so far used these three make.com modules:
- MS Excel “Watch Worksheet Rows”
- Monday "Search items in the Board by Column Values
- Monday “Create an Update”
The excel module is configured as follows:
I ran the Excel module once, and it successfully fetched the Sheet data such that I can see the 1st 10 rows of row content in 2 bundles, so I seem to be set there. This is what I get:
(It is the “Notes” field that I am would like to query. (Context: It is a very long field that will not fit into any of the standard Monday.com text fields, so it needs to be added to item Updates instead).
I get stuck however at step 2. I have configured the module like this:
However, when I hit Run once, I see this, and I do not know what I am to enter:
When I force it run anyway, I see this error:
Can anyone help here?
I have only recently started my make training, and would appreciate any guidance here.
Thanks!!
Steve