Update specific cell in Google Sheets based on column and row

Questions
2

@jlhsolutions , here’s your improvised solution

Explanation

You cannot just update a specific cell, it has to be the whole row. As you do not want to override the cells in the required row that were filled out in the previous days, you need to know the current values and reenter them together with the new value for the current date.

Thus, the steps are

  1. Get the current rows
  2. Pick the one corresponding to the current month (with the help of Merge node)
  3. Populate the cell corresponding to the current date (with the help of Code node)
  4. Update the row using “Month” column to match on

NOTE: “Date and Quantity” node formats the current date to extract the name of the month and the date as separate entities to be used later on in the flow for matching purposes.