Hello all. Has anyone built a flow for adding/updating rows in a google sheet? The difficulty I’m running into is that I can’t get my flow to add only new rows to the sheet, while updating existing ones. The help documentation, while at times helpful, keeps sending me in circles where I either only update existing rows, or add all rows as new, resulting in duplicates. Thank you.
I created a hack around this by adding my new rows to a different tab and then having the existing row pull data via vlookup. That way the data from my GL output gets added to the existing row. Not sure if that’s applicable to your situation. Would want to see the flow/spreadsheet.
1 Like
Hey @user3 - At the moment, you can either add new rows or update existing ones using the writer/updater nodes but you can’t do both in one operation. If you explain your use-case further and share your workbook, we maybe able to find a workaround.
Thank you @chris_dyer and @Wasay-Gumloop for responding to my question.
Need - We have an A/R management gmail inbox where we receive various types of emails that include replies to our outbound billing emails, requests for invoice/billing history, invoice status disputes, invoice payment updates, pickup requests, etc. My long-term objective is to introduce AI automation to help manage this comms channel but that’s a long way away. In the shorter term, I want to set up a flow that reads the emails, applies categorizing criteria, and generates a “proposed” response to the email. Note that this is for a) applying Gumloop to a real-life use case so that I can demo it to the team, and b) to start the long process of learning and more predictably identifying the various types of comms we get, in the hopes of building a library of potential responses.
How - I’ve set up a workbook where I have the Gumloop flow add new rows for emails that aren’t yet catalogued, and update rows for emails that have already been added. I have also added columns for categories that I’ve defined for now, and for what a “proposed” response might look like based on those categories. I realize that, eventually, I will likely be using a help-desk tool that will likely have its own automation capabilities. But, as I mentioned, this is a way to learn more about Gumloop and automated AI-infused flows in general, plus a way to demo the capabilities.
Really digging @chris_dyer 's creative approach as it offers me a way out of the circular reference maze that I’ve been stuck in for a couple of days. Gummie has been helpful for basic education. But, this particular problem is exposing a bit of documentation freshness issues and, if there is AI involved, a bit of hallucination. It’s all good. Documentation maintenance is always a challenge and let’s say there are a couple of moments when I wasn’t very kind to Gummie for bs’ing me. At least it admitted it and apologized 
Hey @user3 - So I’m using you’ll have an IF-ELSE step in your flow which checks if an email is catalogued or not. You’d have to use two nodes here based on the condition. IF the email is catalogued, use the google sheet updater node ELSE use the google sheet writer node to add new rows.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.