Basically I want to transform data from this:
To this:
I’m getting the raw data from monday.com, and wanted to summarize the raw data into a sum of hours based on assigned role of the employee, pushing the data back to monday.com in a summary board.
As much as possible, I’d want the data transformation to be done via n8n rather than me pushing raw data to a Google Sheet, then get the processed data from the same Google Sheet back to monday.com (just streamlining the sync automation).
Not sure what’s the best approach to summarize the data but would like your input on these guys as to what’s the best approach to do this. Thanks!