We have a Google Sheet that has a few columns (3 at the moment, and not sequential so say column B, D, and G) with email addresses. Some of these email addresses are duplicated through the sheet. Once a week we would like to send an email to all the addresses (one email per address) with a new link to the sheet for them to review.
What is the best way to pull all the email addresses, and then filter that to a unique list, and send a standard email (the email will be the same for all addresses).
Thanks in advance, been working on this for awhile, got the emailing portion down, just trying to determine the best way to get the list of addresses out of the existing sheet.
Considering mainly your last sentence:
=ArrayFormula(sort(unique({B1:B;D1:D;G1:G})))