You’ll need to use sheet formulas…
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts
You’ll want to do this anyway since a zap will need to be triggered from the spreadsheet anyway.
1 Like