Guys. Thanks so much for the rapid input. This was of interest in particular:
So I guess I need to somehow create a mechanism that will dynamically populate an array column of emails. As I understand it, you can’t do this in the data editor (a relation is computed). You also can’t do it in a Google Sheet because you’d need to specify the column name “in advance” i.e. Email 1, Email 2 etc.
So … it can’t be done?