I have a scenario that is eating a lot of credits by using google sheets “get a cell”. I’m looking for a work around way to still get the data from those cells, but without having to have another module for every cell I need (there’s currently 20-21 google sheet modules running, just for 1 portion of the scenario).
From there I would need it to update it’s corresponding columns in Monday.com with the data from those cells.
What is the problem & what have you tried?
I’ve tried to use the “Get a range” module, but I’m still really new at this and I’m not sure I’ve done it correctly.
I’ve tried finding the Get a Row module, but it doesn’t show up in my drop down list. I’ve also tried using the get range values, but it wants to add everything together, when I need the data on its own to move it back over to monday.com.
These cells auto populate with the data from the google sheet; when we’re trying to calculate a price, we change the status to calc, it pulls the data from monday, and it processes the formulas on the GS, then puts all the info back into Monday again.
Would the search rows module allow me to pick specific data from the cells (or columns) i need in that row?
What does the data look like inside the sheet? Is it in the same row? Or is it spread out and you need to search for specific cells from different rows?
Yeah, so the Search Rows module is the one you need. I assume there is some identifier in the row you can use since you were getting the cells from it already?
You can probably reduce the number of Google Sheets modules by getting the required range once and then mapping the returned values to the corresponding Monday com columns. The key is structuring the range so each value can be identified easily.
If the cells are in the same row or a predictable range, “Get a range” should be a better approach than using 20+ individual “Get a cell” modules. You may also be able to use an Iterator or Array Aggregator depending on how your Monday com update is structured.
Sam, the important check is whether that Monday item ID is also stored in a column in the Google Sheet. Selecting an ID in the Monday module doesn’t, by itself, tell Search Rows which sheet row to find.
If it is in the sheet, you can build on Stoyan’s suggestion like this:
In Search Rows, filter the sheet’s Item ID column to equal the Item ID coming from your trigger. Include the columns with your calculation results.
Test one item and inspect the output. You want one bundle with each result column available separately, not the values added together.
Map those fields into Monday’s Update Column Values of a Specific Item, using the same Item ID.
You don’t need an Iterator or Array Aggregator just to map the columns of one matched row. Make Academy’s example shows how Search Rows returns one bundle per matching row. Check that your test returns exactly one row before enabling the Monday update.
Is the Item ID actually written into your sheet, or only selected in the Monday module?
If I use the “Get a range” module, will it let me select multiple ranges? (i.e A3:D3, G3:k:3) the reason I ask is there are cases where most of the cells in that row are empty, except for the 7 or 8 that we actually need. Other times 2/3 of the cells have data, with empty cells in between.
I’ve tried running it through an aggregator as well but it doesn’t seem like the data is going back into monday like I need it to, none of the monday columns i selected updated with the data.
I don’t think Get a Range supports selecting multiple separate ranges in one field like A3:D3, G3:K3. In this case, I’d probably keep the ranges together and handle the empty cells with mapping/filtering before sending the values to Monday.
For the Monday side, an aggregator may not help if the output structure doesn’t match what the Monday update module expects. I’d check the bundle coming out of Google Sheets first to confirm the values are actually being returned, then map those individual values directly to the corresponding Monday columns
What is your goal?
What is the problem & what have you tried?