1. Add your Gmail access

  1. In the Destinations tab, click on the “Add destination” button located on the top right of your screen. Then, select the Gmail option from the list of connectors.

  2. Click Next and you’ll be prompted to add your access.

    • Gmail Authorization: Authorize nekt with your Gmail account. Make sure you are doing it with the email address you want to use to send the email.

    • Recipients: The list of email addresses that should receive the email. It should be a comma-separated list such as john.doe@example.com, jane.doe@gmail.com and so on.

    • Email subject: The subject of the email. you want to add a datestamp to the subject, please include the parameter {datestamp} in brackets.

    • Email body: The email body message to send. There are two variables you can include in the email body that will be replaced by dynamic information during exection:

      • Data preview: this will include a preview of your data (max of 100 records) in the email body in a tabular form. This is useful to give the recipients a quick glimpse on the data. In order to use data, include the variable {data_preview} in your email body.

      • Datestamp: this will include the current date timestamp in the format YYYY-MM-DD in the email body. Useful if you want to add a date reference to the email body. To use that include the variable {datestamp} in your email body.

    • Maximum preview size: The total number of rows to preview in the message body. Maximum is 100.

    • Send email with empty data: Whether the email should be sent in case the input table is empty (due to filtering or other conditions). If this option is True, then you have the option to specify a different email body to be used in such cases.

    This is an example of how the email would look like when using {datestamp} in the subject of the email and {date_preview} in the email body:

  3. Click Next.

2. Select your catalog data to send

  1. The next step is letting us know which data you want to attach to the email. Select the layer and then the desired table.

Tip: The table can be found more easily by typing its name.

  1. Click Next.

3. Configure your Gmail data destination

  1. Describe your destination for easy identification within your organization. You can inform things like what data it sends, to which team it belongs, etc.

  2. To define your Trigger, consider how often you want this email to be sent to the list of recipients. This decision usually depends on how frequently you need the new table data updated (every day, once a week, only at specific times, etc.).

  3. Click Done.

Check your new destination!

  1. Once completed, you’ll receive confirmation that your new destination is set up!

  2. You can view your new destination on the Destinations page. Now, for the email to be actually sent, you have to wait for the pipeline to run. You can monitor it on the Destinations page to see its execution and completion. If needed, manually trigger the pipeline by clicking on the refresh icon. Once executed, your email should be sent.

If you encounter any issues, reach out to us via Slack, and we’ll gladly assist you!