cancel
Showing results for 
Search instead for 
Did you mean: 

[10-Minute Exercise] How to send a list of employees to email using the Email Sender Snap

Karen
Former Employee

Difficulty Level: Hard

In this exercise, you will learn how to send a list of employee names to an email by:

  • Using the Email Sender Snap from the Snaps Catalog
  • Adding a valid email account that you want the list of employees sent to

The sample pipeline for this exercise is for a mergers & acquisitions use case. When a company is acquired, HR receives a CSV file containing employee information from that company and wants to route a list of employees to department heads for review, including Customer Success, General & Administration (G&A), Sales & Marketing, and Engineering.

In this exercise, the list of employees in the Engineering organization will be sent to an email.

The following 4-minute video shows walks through this exercise:

Step 1: Make sure you have copied the sample pipeline (Sample_Pipeline) from the Shared folder within the Pipeline Catalog to your own project folder. Upload the shared EmployeeRecords file from the shared folder as well.

406fd7be94d214ad86b2a14d6c6431b98a4c188f.png

Step 2: In the Engineering branch of the pipeline, delete the Excel Formatter and File Writer

d7d8f9629401eeb287952241186531da888bb67f.png

Step 3: Go to the Snap Catalog, find the Email Sender Snap and drag it next to the Sort Snap. We will configure the Email Sender Snap first before connecting it to the Sort Snap.

a618ea5503ead32d231a004705f04f6bc75a6780.png

Step 4: Open the Snap to configure the following:

  1. Click Add Account

  2. Select your project as the location and click Continue

  3. Supply the following information:

  4. Label: a name to help you identify the account, like My Personal Email

  5. Email ID: your full email address

  6. Password: your password for this account. (It will be encrypted)

  7. Server Domain: The SMTP server domain name. For Gmail, it’s smtp.gmail.com

  8. Port: The port number of the email server. This will vary depending on your mail provider, account type, and the Secure connection selected. For Gmail, use 465

  9. Secure Connection: How the secure connection to the email server should be initiated. For Gmail, keep it at SSL

  10. Click Apply, then go to the Views tab

21584f66b5f8ccfe22bc7030e289e51693e702f7.png

Step 5: To receive information from the Sort Snap, add an input view by clicking the + sign under Input. You don’t need to rename it. You can also remove the output view, but it’s not required. Then go to the Settings Tab

da6e1474e8a9bf7a434bb8c1fae22c5c1f1dd521.png

Step 6: Set the To field to your email address, then add a subject. You don’t need to specify a from as it will use your account information

Step 7: Set the Email type to HTML Table. If you configure an Email Sender Snap with an input view and connect it to receive data from upstream Snaps, one email will be sent for each document processed through the pipeline unless you are using an HTML table as the Email type. The HTML table format will embed the data in the email body up to the Batch size limit, sending as many emails as necessary to batch through the documents

Step 8: Go to the SnapLogic Documentation for the Email Sender Snap (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438208/Email+Sender), and copy the HTML sample provided under Template. Paste the HTML into the Template field of your Email Sender Snap. Update the title and body paragraphs of the email to your messaging, but leave the table within the body as is

Step 9: Set the Table-data path to $

ba70d35f89d78b00abd4efc903e0cbbe56f5f89e.png

Step 10: Save the Snap, then close the dialog

Step 11: Drag the Email Sender Snap until it connects with the Sort Snap and place the Snap

f2cec58bbf71c2bf610420a921cbabf3a15cf819.png

Step 12: Save the pipeline and execute it. You should receive one email with all of the users for the Engineering department

Congratulations! You have completed this pipeline exercise!

Need more help?

You can launch the step-by-step exercise and additional resources on the SnapLogic Knowledge Center b5f6f864701935657c6d57928a79f2755d8615e9.png on our SnapLogic platform, or peruse through the categories and topics on the SnapLogic Community.

[ The SnapLogic Knowledge Center is only available within the SnapLogic Free Trial. ]

5 REPLIES 5

shaqirah
New Contributor II

Hi, need your kind help, i’m getting error when executing the pipeline with Email Sender Snap. Attached
with error that I get Error.txt (10.4 KB)

Your help is appreciated. Thank you in advance.

The message that Google is sending back seems to indicate that your email account for Gmail may not be configured correctly. Does it look similar to the image for step 4 above?


Diane Miller

Do you use 2-step verification on your Google account? If so you’ll need to configure an App password. Here’s a good article:

See “How to Set Up App Passwords”.

Also, the Error.txt file you attached contains this URL for help:

Lots of troubleshooting info there.