DataSet Via Email Connector

DataSet Via Email Connector


[MUSIC PLAYING] Email is perhaps
the most common form of communication in
the business world today with over 123 billion
emails being sent each day. As a result, one of the most
common forms of data transfer, or sharing has been to send
file attachments on an email. Of course these
attachments are useful, but going through the process
of downloading the file and importing it
to Domo each time you receive it is not
only time consuming, but can also lead to your data
becoming stagnant over time. The DataSet via Email
connector solves this pain, and provides yet another way
to import your data into Domo by integrating Domo with your
existing email attachment workflow. Lets go through
an example of how to set up your connector so that
you can start importing data through email. Here’s a spreadsheet that a
marketing manager sends me every week showing email
campaign performance. Rather than download the
spreadsheet and upload it, I’ll set up a DataSet
via Email connector to capture this data for me. When setting up the connector,
a unique email address is generated that will
correspond to this DataSet. Any configurations that we
set up with this DataSet will be checked each
time an email is sent to our email address. If any of those
parameters are not met, the file will not be
imported into Domo. We first need to
select the file type to look for; the update method,
the email address or email domain that we will
accept emails from, what we are looking for in the
subject line and email body, and then also what
the attachment name is going to look like. Email subject,
body, and attachment name all use regex
inputs for validation. Something like this will
work for the attachment name with our spreadsheet. If we don’t want to
use these parameters, we have to type the word
“none” to deactivate them. For advanced parsing options,
select the advanced options box, and then we are
given input fields for where to begin reading
data, where the header rows are, any footer rows that
we need to skip, and also which Excel
sheet we are reading from. For our spreadsheet, we’ll want
to start reading data on row 3, skipped the bottom
three rows, and look for the sheet called MailChimp. Selecting raw headers will
preserve any special characters that might be in
the column headers, and then we need to
select which date format is used in this spreadsheet. With all of our parameters
set, all that’s left is to copy the email
address, and then save our configurations,
and name the data set. Now, whenever we send or CC
a message with an attachment to this address, the connector
will read the attached file, and if it meets the
parameters that we input during configuration,
it will update our DataSet in Domo. If you have any other
questions about how to set up your DataSet
via Email connector, please refer to
the Knowledge Base at knowledge.domo.com
for more documentation, and help on this subject. [MUSIC PLAYING]

Leave a Reply

Your email address will not be published. Required fields are marked *