# Email Configuration In sunbird, SendGrid is used for sending email notifications. Below are the confgurations that need to be updated for sending email. These configurations are common for user-org service, notification service and notification data-pipeline flink job. ``` sunbird_mail_server_host = sunbird_mail_server_port = sunbird_mail_server_username = sunbird_mail_server_password = sunbird_mail_server_from_email = support@open-sunbird.org sendgrid_connection_reset_interval //default is 60000L ``` #### Adding Email Template to Cassandra DB Userorg service stores email templates in the table **email\_template** within the **sunbird** keyspace. The following command allows you to view email templates currently available in Cassandra DB: `SELECT * from sunbird.email_template;` Command to add an email template to Cassandra DB using CQL shell. Ensure that the template name is unique so that it doesnot override the existing template information in Cassandra DB: ``` INSERT INTO sunbird.email_template(name, template) VALUES('myEmailTemplate', '

#if ($orgImageUrl)

logo

#end

#if ($name)

Hi $name,

#end

$body

') ``` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://lern.sunbird.org/use/developer-guide/user-and-org-service/configuration/email-notification-configuration.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.