Google Sheets Append Or Update Row Only Output Appended Row?

Questions
1

Hello! I have a workflow which gathers some data and appends it to a Google Sheet. The data includes an ID, so I have it set to Append or Update to avoid duplication. It works great. However, I also have a notification sent to Slack at the end of the workflow to say how many new rows were added to the Google Sheet. This always seems to be the full collection of data, as the Google Sheets node passes all the data through, with no way to distinguish between which items were appended and which were updated.

Does anyone have a recommendation for a nice simple way to achieve this before I go and over-engineer it? :sweat_smile:

Thanks!

2

I think you can use this ID in another Google Sheet node with Operation “Get Row(s)” and then the Slack notification at the end

1 Like
3

I thought about using that Get Row(s) node earlier in the workflow to then compare in a Function node… that might achieve what I want, yeah. I was just hoping the Append Or Update could somehow tell me to reduce steps and complexity :slight_smile:

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.