Setting Up Append Row Action for Collaborative Data Entry in Sheets
does anyone know how to setup Append row action for connected agents, but in a way that they complement each other and fill out the same row (different columns) instead of adding new row each time? I have connected 3 agents each updates the spreadsheet upon closure and triggers/notifies the next agent. However, instead of working on the same line they each create a new row and fill our the same fields, so I end up with 3 repeating rows of data, 2 incomplete and last one complete. My workflow: 1st agent is a job analyzer - (triggered by notification) adds qualified job title, description and budget info. 2nd agent is portfolio picker (triggered by job analyzer) - analyzes job details and looks into existing portfolios in our database and lists all relevant cases 3rd one is proposal writer (triggered by portfolio picker) - analyzes entries of the previous 2 and writes a compeling proposal. So ideally it all needs to be on the same line