Hi there, I’d like to create an automation that, when triggered manually, appends all records that match certain conditions to a Google Sheet (that I then apply built-in formulas to in the sheet).
My first attempt was to choose the trigger “When record matches conditions” but that only seems to fire for when a new or updated record matches conditions, not for when an existing one does.
How might I set up the conditions and action and then for a trigger be able to just click a button like “run” or turn it on? Is there another way to do this?