SeekWell lets you send query results (either from your database or a Google Sheet) via email. The email contains an HTML preview of the results, a link back to the block and a CSV with the query results
Change the destination to "Email" by clicking on the current destination (default is "Sheets")
Enter email addresses as a comma separated list and click the check mark
To test that the email is sent, run the query again