{"id":67547,"date":"2026-10-28T19:49:58","date_gmt":"2026-10-28T19:49:58","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=67547"},"modified":"2026-11-03T12:56:39","modified_gmt":"2026-11-03T12:56:39","slug":"import-using-external-sources","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/","title":{"rendered":"Import using External sources"},"content":{"rendered":"<style>\n\/* Offset anchor jumps so headings aren't hidden behind the fixed help header *\/\nh2[id], h3[id] {\n  scroll-margin-top: 100px;\n}\n<\/style>\n<p>Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an automation rule. From then on, Sogolytics picks up response files from that folder on the schedule you set and imports them for you \u2014 no manual uploads.<\/p>\n<p><strong>With external sources, you can:<\/strong><\/p>\n<ul>\n<li>Import response files automatically from an SFTP server, Google Drive, or OneDrive.<\/li>\n<li>Choose which files are imported and how often the rule runs.<\/li>\n<li>Decide how blank and mismatched values are handled.<\/li>\n<li>Receive email alerts when a rule runs, imports nothing, or fails.<\/li>\n<li>Manage all of your rules from the <strong>Import Automation Dashboard<\/strong>.<\/li>\n<\/ul>\n<p class=\"sogo-help-sub-head\">Navigate to<\/p>\r\n<ul class=\"sogo-help-sub-list\">\r\n    <li><a href=\"#section-1\">Select SFTP as the Source<\/a><\/li>\r\n    <li><a href=\"#section-2\">Select OneDrive as the Source<\/a><\/li>\r\n    <li><a href=\"#section-3\">Select Google Drive as the Source<\/a><\/li>\r\n    <li><a href=\"#section-4\">Set the Data Attributes<\/a><\/li>\r\n    <li><a href=\"#section-5\">Link Responses with a Directory<\/a><\/li>\r\n    <li><a href=\"#section-6\">Map Columns<\/a><\/li>\r\n    <li><a href=\"#section-7\">Choose Which Files to Import<\/a><\/li>\r\n    <li><a href=\"#section-8\">Set the Import Schedule<\/a><\/li>\r\n    <li><a href=\"#section-9\">Set the Mismatch Rules<\/a><\/li>\r\n    <li><a href=\"#section-10\">Set Email Alerts<\/a><\/li>\r\n    <li><a href=\"#section-11\">Save the Automation Rule<\/a><\/li>\r\n<\/ul>\r\n\n<h2>Before you begin<\/h2>\n<div class=\"sogo-help-info-box\">\n<i class=\"fal fa-info-circle\"><\/i><\/p>\n<div class=\"sogo-info-text\">\n<ul>\n<li>Importing from external sources requires the <strong>Import Automation<\/strong> feature. If it is not in your plan, an upgrade icon or a <strong>Request a Demo<\/strong> option is displayed.<\/li>\n<li>Importing from SFTP also requires the <strong>Data Automation<\/strong> add-on and an SFTP setup for your account. See <strong>How to Connect to Sogolytics SFTP Server<\/strong>.<\/li>\n<li>Prepare response files in .xlsx, .xls, or .csv format, up to 10 MB each, in the <strong>Sogolytics1 format<\/strong>. Keep the same column order in every file.<\/li>\n<li>Place at least one sample file in the source folder. The sample is used only for mapping; no responses are imported from it while you set up the rule.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>Selecting the source differs for SFTP, OneDrive, and Google Drive. All other steps \u2014 data attributes, Directory linking, mapping, automation settings, and saving the rule \u2014 are the same for every source.<\/p>\n<hr \/>\n<h2 id=\"section-1\">Select SFTP as the Source<\/h2>\n<ol>\n<li>Open the project you want to import responses into.<\/li>\n<li>Click the <strong>Data<\/strong> tab.<\/li>\n<li>Click <strong>Import<\/strong>. The import wizard opens on the <strong>Import Option Selection<\/strong> screen.<\/li>\n<li>Under <strong>Select Import Type<\/strong>, select <strong>Import New Responses<\/strong>.<\/li>\n<li>Under <strong>Select Source<\/strong>, select <strong>From External Source<\/strong>, then click <strong>SFTP Server<\/strong>.<\/li>\n<li>Under <strong>Select Source Folder<\/strong>, select the folder that contains your response files. If you recently created the folder, click the <strong>refresh<\/strong> icon to update the list.<\/li>\n<li>In the file list, select one sample file to use for mapping. Use the <strong>File Name<\/strong> search box to find a file, or sort by <strong>Date<\/strong> to find the most recent.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal1.png\" \/><\/p>\n<p>If <strong>SFTP Server<\/strong> shows an <strong>Import Automation<\/strong> message with a <strong>Request a Demo<\/strong> button, the Data Automation add-on is not active for your account.<\/p>\n<hr \/>\n<h2 id=\"section-2\">Select OneDrive as the Source<\/h2>\n<p>Use OneDrive when response files are saved to a folder in your organization&#8217;s OneDrive. Sogolytics connects to the OneDrive account linked to your Sogolytics account, lists its folders, and imports new files from the folder you select.<\/p>\n<ol>\n<li>Open the project you want to import responses into.<\/li>\n<li>Click the <strong>Data<\/strong> tab.<\/li>\n<li>Click <strong>Import<\/strong>. The import wizard opens on the <strong>Import Option Selection<\/strong> screen.<\/li>\n<li>Under <strong>Select Import Type<\/strong>, select <strong>Import New Responses<\/strong>.<\/li>\n<li>Under <strong>Select Source<\/strong>, select <strong>From External Source<\/strong>, then click <strong>OneDrive<\/strong>. Sogolytics checks whether a OneDrive account is linked. If one is linked, its folders are listed under <strong>Select Source Folder<\/strong>. If not, connect one first, as described below.<\/li>\n<li>Under <strong>Select Source Folder<\/strong>, select the folder that contains your response files. To find a folder, type in the <strong>Search with folder name<\/strong> box. If you recently created the folder, click the <strong>refresh<\/strong> icon.<\/li>\n<li>In the file list, select one sample file to use for mapping. Use the <strong>File Name<\/strong> search box to find a file, or sort by <strong>Date<\/strong> to find the most recent.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal2.png\" \/><\/p>\n<p><strong>If no OneDrive account is linked,<\/strong> the message <strong>No OneDrive account is linked yet. Connect your OneDrive account to continue.<\/strong> is displayed. To link an account:<\/p>\n<ol>\n<li>Click <strong>Connect OneDrive<\/strong>. The OneDrive integration page opens in place of the import wizard. Selections you made in the wizard are not saved.<\/li>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal3.png\" \/><\/p>\n<li>Click <strong>Connect with OneDrive<\/strong>. A Microsoft sign-in window opens. If your browser blocks pop-ups, allow pop-ups for Sogolytics and try again.<\/li>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal4.png\" \/><\/p>\n<li>Sign in to the Microsoft account that contains your response files and allow Sogolytics to access it. A message confirms the connection, and the account&#8217;s email address appears under <strong>Linked Account Details<\/strong>.<\/li>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal5.png\" \/><\/p>\n<li>Return to your project, click the <strong>Data<\/strong> tab, click <strong>Import<\/strong>, and select <strong>From External Source<\/strong> \u2192 <strong>OneDrive<\/strong> again.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal2.png\" \/><\/p>\n<p>The remaining steps \u2014 data attributes, Directory linking, mapping, automation settings, and saving the rule \u2014 are the same as for SFTP and are described in the sections below.<\/p>\n<div class=\"sogo-help-info-box\">\n<i class=\"fal fa-info-circle\"><\/i><\/p>\n<div class=\"sogo-info-text\">\n<ul>\n<li>Only one OneDrive account can be linked to a Sogolytics account. If OneDrive is already linked for another feature, such as Contact Lists, the same account is used for importing responses. To change or unlink it, use the OneDrive integration page.<\/li>\n<li>Linking a OneDrive account requires the OneDrive integration. If it is not in your plan, the integration page shows <strong>Available with an Enterprise account.<\/strong> and a <strong>Request a Demo<\/strong> button.<\/li>\n<li>Only folders at the top level of your OneDrive are listed. Subfolders and folders shared with you are not listed, so keep your response files in a top-level folder.<\/li>\n<li>If the folder list is empty, <strong>No Folders Found<\/strong> is displayed. Create the folder in OneDrive, then click <strong>Validate<\/strong>. If the selected folder has no files, <strong>No Files Found<\/strong> is displayed. Add a sample file, then click <strong>Refresh<\/strong>.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<hr \/>\n<h2 id=\"section-3\">Select Google Drive as the Source<\/h2>\n<p>Use Google Drive when response files are saved to a folder in your organization&#8217;s Google Drive. Sogolytics connects to the Google Drive account linked to your Sogolytics account, lists its folders, and imports new files from the folder you select.<\/p>\n<ol>\n<li>Open the project you want to import responses into.<\/li>\n<li>Click the <strong>Data<\/strong> tab.<\/li>\n<li>Click <strong>Import<\/strong>. The import wizard opens on the <strong>Import Option Selection<\/strong> screen.<\/li>\n<li>Under <strong>Select Import Type<\/strong>, select <strong>Import New Responses<\/strong>.<\/li>\n<li>Under <strong>Select Source<\/strong>, select <strong>From External Source<\/strong>, then click <strong>Google Drive<\/strong>. Sogolytics checks whether a Google Drive account is linked. If one is linked, its folders are listed under <strong>Select Source Folder<\/strong>. If not, connect one first, as described below.<\/li>\n<li>Under <strong>Select Source Folder<\/strong>, select the folder that contains your response files. To find a folder, type in the <strong>Search with folder name<\/strong> box. If you recently created the folder, click the <strong>refresh<\/strong> icon.<\/li>\n<li>In the file list, select one sample file to use for mapping. Use the <strong>File Name<\/strong> search box to find a file, or sort by <strong>Date<\/strong> to find the most recent.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal6.png\" \/><\/p>\n<p><strong>If no Google Drive account is linked,<\/strong> the message <strong>No Google Drive account is linked yet. Connect your Google Drive account to continue.<\/strong> is displayed. To link an account:<\/p>\n<ol>\n<li>Click <strong>Connect Google Drive<\/strong>. The Google Drive integration page opens in place of the import wizard. Selections you made in the wizard are not saved.<\/li>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal7.png\" \/><\/p>\n<li>Click <strong>Connect with Google Drive<\/strong>. A Google sign-in window opens. If your browser blocks pop-ups, allow pop-ups for Sogolytics and try again.<\/li>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal8.png\" \/><\/p>\n<li>Sign in to the Google account that contains your response files and allow Sogolytics to access it. A message confirms the connection, and the account&#8217;s email address appears under <strong>Linked Account Details<\/strong>.<\/li>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal9.png\" \/><\/p>\n<li>Return to your project, click the <strong>Data<\/strong> tab, click <strong>Import<\/strong>, and select <strong>From External Source<\/strong> \u2192 <strong>Google Drive<\/strong> again.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal5.png\" \/><\/p>\n<p>The remaining steps \u2014 data attributes, Directory linking, mapping, automation settings, and saving the rule \u2014 are the same as for SFTP and are described in the sections below.<\/p>\n<div class=\"sogo-help-info-box\">\n<i class=\"fal fa-info-circle\"><\/i><\/p>\n<div class=\"sogo-info-text\">\n<ul>\n<li>Only one Google Drive account can be linked to a Sogolytics account. If Google Drive is already linked for another feature, such as Contact Lists, the same account is used for importing responses. To change or unlink it, use the Google Drive integration page.<\/li>\n<li>Linking a Google Drive account requires the Google Drive integration. If it is not in your plan, the integration page shows <strong>Available with an Enterprise account.<\/strong> and a <strong>Request a Demo<\/strong> button.<\/li>\n<li>Only folders at the top level of your Google Drive are listed. Subfolders, shared drives, and files in <strong>Shared with me<\/strong> are not listed, so keep your response files in a top-level folder.<\/li>\n<li>Google Sheets files are not listed. Save your data as an .xlsx or .csv file in the folder instead.<\/li>\n<li>If the folder list is empty, <strong>No Folders Found<\/strong> is displayed. Create the folder in Google Drive, then click <strong>Validate<\/strong>. If the selected folder has no files, <strong>No Files Found<\/strong> is displayed. Add a sample file, then click <strong>Refresh<\/strong>.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<hr \/>\n<h2 id=\"section-4\">Set the Data Attributes<\/h2>\n<p>On the same screen, describe how your files are organized:<\/p>\n<ol>\n<li>Turn on <strong>My data has header(s)?<\/strong> if the first row of your file contains a heading for each column. Leave it off if your data starts in the first row.<\/li>\n<li>Turn on <strong>My data file has a unique column?<\/strong> if your file includes an Email Address, Phone Number, or Unique ID for each response. If you leave it off, Sogolytics generates a unique identifier for each response.<\/li>\n<li>Turn on <strong>Include additional metadata<\/strong> if your file contains participation details you want to import with the responses, and select the check box for each type of metadata your file contains. The options are described in the table below.<\/li>\n<\/ol>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 20%;\">Metadata option<\/td>\n<td style=\"width: 26%;\">What to enter in the column<\/td>\n<td style=\"width: 26%;\">If the value is blank or not recognized<\/td>\n<td style=\"width: 24%;\">Availability<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 20%;\">Participation status<\/td>\n<td style=\"width: 26%;\">Complete or Incomplete.<\/td>\n<td style=\"width: 26%;\">Marked as Complete.<\/td>\n<td style=\"width: 24%;\">Only when Save and Continue Later is enabled for the project.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 20%;\">Participant IP address<\/td>\n<td style=\"width: 26%;\">The participant&#8217;s IP address, for example 192.168.10.25.<\/td>\n<td style=\"width: 26%;\">Left blank.<\/td>\n<td style=\"width: 24%;\">Not available for Anonymous or Semi-Anonymous projects.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 20%;\">Participation language<\/td>\n<td style=\"width: 26%;\">The name of a language enabled in the project, for example Spanish.<\/td>\n<td style=\"width: 26%;\">Set to the project&#8217;s primary language.<\/td>\n<td style=\"width: 24%;\">Only for multilingual projects.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 20%;\">Participation start date and time \/ Participation end date and time<\/td>\n<td style=\"width: 26%;\">When the participant started or finished, in the format you choose (see below). Dates cannot be in the future.<\/td>\n<td style=\"width: 26%;\">Set to the current date and time.<\/td>\n<td style=\"width: 24%;\">Not available for Anonymous or Semi-Anonymous projects.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>If you select a start or end date and time, choose the format your file uses from the <strong>Format<\/strong> drop-down:<\/p>\n<ul>\n<li><strong>mm\/dd\/yyyy hh:mm<\/strong> \u2014 for example, 09\/18\/2026 14:30 (September 18, 2026, 2:30 PM).<\/li>\n<li><strong>dd\/mm\/yyyy hh:mm<\/strong> \u2014 for example, 18\/09\/2026 14:30 (18 September 2026, 2:30 PM).<\/li>\n<\/ul>\n<p>If you turn on <strong>Include additional metadata<\/strong>, select at least one option. If you select a date and time option, you must also choose a <strong>Format<\/strong>.<\/p>\n<hr \/>\n<h2 id=\"section-5\">Link Responses with a Directory<\/h2>\n<p>Turn on <strong>Link responses with a Directory?<\/strong> to associate each response with an existing contact or Activity record, so you can analyze responses alongside Directory information. Then select a linking option:<\/p>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 22%;\">Linking option<\/td>\n<td style=\"width: 37%;\">What it does<\/td>\n<td style=\"width: 37%;\">What you select<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 22%;\">Link responses with Directory only<\/td>\n<td style=\"width: 37%;\">Links responses with one or more Directories.<\/td>\n<td style=\"width: 37%;\">Choose the Directory type from the first drop-down, then the Directory from the second. To link both Directory types, click the + icon and add another row. Each Directory type can be linked only once.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 22%;\">Link responses with Directory and Activity<\/td>\n<td style=\"width: 37%;\">Links responses with records in an Activity, such as purchases or service visits.<\/td>\n<td style=\"width: 37%;\">Choose the Directory, then the Activity. The Respondent Directory and the Feedback Recipient Directory are linked automatically, if applicable.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>The two Directory types are:<\/p>\n<ul>\n<li><strong>Respondent Directory<\/strong> \u2014 the people who responded to the survey.<\/li>\n<li><strong>Feedback Recipient Directory<\/strong> \u2014 the people or entities the feedback is about, such as employees, vendors, or service providers.<\/li>\n<\/ul>\n<p>On the <strong>Map Columns<\/strong> screen, you then map a column from your file to a unique field in the Directory or Activity you selected.<\/p>\n<hr \/>\n<h2 id=\"section-6\">Map Columns<\/h2>\n<ol>\n<li>Click <strong>Continue<\/strong>. An <strong>Important Points<\/strong> message reminds you that the sample file must exactly match the format of the files the rule will import, that it is used only for mapping, and that files with a different column order may cause mismatches or failures.<\/li>\n<li>Click <strong>Ok, Got It!<\/strong>. The <strong>Map Columns<\/strong> screen opens.<\/li>\n<li>Optionally, click <strong>Preview Source File<\/strong> to view the sample file.<\/li>\n<li>If you linked responses with a Directory, map each row in the <strong>Map Directory\/Activity Columns<\/strong> section.<\/li>\n<li>Map your file&#8217;s columns to the project&#8217;s metadata and questions in the <strong>Map Columns<\/strong> section.<\/li>\n<li>Optionally, use the <strong>Map\/Static<\/strong> drop-down to set a fixed value for a field, as described below.<\/li>\n<\/ol>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 25%;\">Row<\/td>\n<td style=\"width: 71%;\">What to select<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Email Address\/Unique ID<\/td>\n<td style=\"width: 71%;\">The file column that contains each response&#8217;s email address or unique ID (up to 75 characters). If My data file has a unique column? is off, this row shows System Generated and no selection is needed.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 25%;\">Metadata fields<\/td>\n<td style=\"width: 71%;\">The file column for each metadata option you selected, such as Participant IP address or Participation start date and time.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Questions<\/td>\n<td style=\"width: 71%;\">Sogolytics automatically matches each question to a file column with the same question text. Review each match and select the correct column where needed. Grid and multi-part questions have one row per sub-question, such as Q3(a) and Q3(b).<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 25%;\">None<\/td>\n<td style=\"width: 71%;\">Leave a question set to None if you do not want to import data for it.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 25%;\">Map\/Static option<\/td>\n<td style=\"width: 71%;\">What it does<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Map Field (default)<\/td>\n<td style=\"width: 71%;\">Reads the value from the selected file column.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 25%;\">Static Field<\/td>\n<td style=\"width: 71%;\">Uses the same value for every imported response. Enter it in Enter Static Value. Static dates use MM\/DD\/YYYY HH:mm, and a static participation status must be Complete or Incomplete.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal10.png\" \/><\/p>\n<div class=\"example-block-container blue-shade\">\n        <span class=\"example-block-content\"><span class=\"example-block-header\">For example:<\/span>Every file in the folder comes from the Chicago hotel, but the files have no language column. Select <strong>Static Field<\/strong> for <strong>Participation language<\/strong> and enter <strong>English<\/strong>, so every imported response is recorded in English.<\/span>\n  <\/div>\n<hr \/>\n<h2 id=\"section-7\">Choose Which Files to Import<\/h2>\n<p>Click <strong>Continue<\/strong> to open the <strong>Automation Settings<\/strong> screen. Under <strong>File Selection<\/strong>, choose which files are fetched each time the rule runs:<\/p>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 25%;\">Option<\/td>\n<td style=\"width: 71%;\">Files fetched on each run<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">All Files<\/td>\n<td style=\"width: 71%;\">All files in the selected folder.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 25%;\">New files only<\/td>\n<td style=\"width: 71%;\">Only files added to the folder since the rule last ran.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Files uploaded on selected days<\/td>\n<td style=\"width: 71%;\">Only files uploaded on the days of the week you select (select at least one day).<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>Never use the same file again.<\/strong> is selected by default. Keep it selected so that a file that has already been imported is not imported again.<\/p>\n<hr \/>\n<h2 id=\"section-8\">Set the Import Schedule<\/h2>\n<p>Under <strong>Import Schedule<\/strong>, choose how often the rule runs. Run times are available in 30-minute intervals; click <strong>+<\/strong> to add another run time.<\/p>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 25%;\">Schedule<\/td>\n<td style=\"width: 71%;\">When the rule runs<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Daily<\/td>\n<td style=\"width: 71%;\">Every day at the selected time.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 25%;\">Weekly<\/td>\n<td style=\"width: 71%;\">On the selected day of the week at the selected time.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Monthly<\/td>\n<td style=\"width: 71%;\">On the selected day of the month (01\u201331) at the selected time.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 25%;\">Custom<\/td>\n<td style=\"width: 71%;\">Every 1 to 7 days, weeks, or months, on the selected day and time.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Instantly<\/td>\n<td style=\"width: 71%;\">Checks the folder for new files every 15 minutes. No run time is selected.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Then select the <strong>Start Date<\/strong> (cannot be in the past) and <strong>End Date<\/strong> (cannot be later than your account&#8217;s expiry date, and set to it by default). The rule runs in your account&#8217;s time zone, which is shown next to the dates.<\/p>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal11.png\" \/><\/p>\n<div class=\"example-block-container blue-shade\">\n        <span class=\"example-block-content\"><span class=\"example-block-header\">For example:<\/span>Choose <strong>Weekly<\/strong>, select <strong>Monday<\/strong> and <strong>9:00 AM<\/strong>, and <strong>New files only<\/strong>. Each Monday at 9:00 AM, the rule imports only the files added since the previous Monday. To run every two weeks instead, choose <strong>Custom<\/strong> and repeat every 2 weeks.<\/span>\n  <\/div>\n<hr \/>\n<h2 id=\"section-9\">Set the Mismatch Rules<\/h2>\n<p>Keep <strong>Mismatch Rules<\/strong> turned on, and choose how responses with blanks or mismatches are handled. A blank is a mapped field with no value; a mismatch is a value that does not match the expected answer options or format.<\/p>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 22%;\">Rule<\/td>\n<td style=\"width: 37%;\">What is imported<\/td>\n<td style=\"width: 37%;\">Example (file of 100 responses)<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 22%;\">Import responses even if blanks or mismatches are found.<\/td>\n<td style=\"width: 37%;\">All responses. Blank or mismatched answers are imported as unanswered.<\/td>\n<td style=\"width: 37%;\">A Yes\/No answer of Maybe is left unanswered; all 100 responses are imported.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 22%;\">If any mismatches are found, do not import mismatch records.<\/td>\n<td style=\"width: 37%;\">All responses except those with a mismatch.<\/td>\n<td style=\"width: 37%;\">The response with Maybe is skipped; 99 are imported.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 22%;\">If any blanks are found, do not import blank records.<\/td>\n<td style=\"width: 37%;\">All responses except those with a blank.<\/td>\n<td style=\"width: 37%;\">A response missing a mapped answer is skipped; the rest are imported.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 22%;\">If any blanks are found, do not import any responses.<\/td>\n<td style=\"width: 37%;\">Nothing from the file if any response has a blank.<\/td>\n<td style=\"width: 37%;\">One blank response means none of the 100 are imported.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 22%;\">If any mismatches are found, do not import any responses.<\/td>\n<td style=\"width: 37%;\">Nothing from the file if any response has a mismatch.<\/td>\n<td style=\"width: 37%;\">One Maybe means none of the 100 are imported.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 22%;\">Import responses only for records without any mismatches or blanks.<\/td>\n<td style=\"width: 37%;\">Only fully valid responses.<\/td>\n<td style=\"width: 37%;\">75 valid responses are imported; 25 with a blank or mismatch are skipped.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal12.png\" \/><\/p>\n<hr \/>\n<h2 id=\"section-10\">Set Email Alerts<\/h2>\n<p>Optionally, turn on <strong>Email Alerts<\/strong> and select at least one alert. Alerts go to the account email address unless you add others.<\/p>\n<div class=\"package-table-container no-scroll\">\n<table class=\"package-limit-table\" border=\"0\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"width: 25%;\">Alert<\/td>\n<td style=\"width: 71%;\">Sent when<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Send alert email if automation rule runs successfully.<\/td>\n<td style=\"width: 71%;\">The rule runs and responses are imported.<\/td>\n<\/tr>\n<tr class=\"column-bg-effect\">\n<td style=\"width: 25%;\">Send an alert email if the automation rule runs successfully, but no responses are imported as per the rules.<\/td>\n<td style=\"width: 71%;\">The rule runs but imports nothing \u2014 for example, no new files were found, or the mismatch rule skipped every response.<\/td>\n<\/tr>\n<tr class=\"column-bg-white-effect\">\n<td style=\"width: 25%;\">Send alert email if automation rule fails.<\/td>\n<td style=\"width: 71%;\">The rule cannot run \u2014 for example, the response limit was reached, the sample file used for mapping was deleted, or the project was deleted.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>To send alerts to other people, turn on <strong>Would you like to send alerts to any alternate email addresses?<\/strong> and enter up to 10 addresses, separated by commas or line breaks. When blanks or mismatches are found, the alert email includes a link to download a file that highlights them.<\/p>\n<hr \/>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal13.png\" \/><\/p>\n<h2 id=\"section-11\">Save the Automation Rule<\/h2>\n<ol>\n<li>Click <strong>Save Automation Rule<\/strong>. The <strong>Save Automation Rule<\/strong> window opens.<\/li>\n<li>In <strong>Automation Rule Name<\/strong>, enter a name of up to 50 characters that is unique within the project.<\/li>\n<li>Optionally, select <strong>Initial Sync<\/strong> to run the rule right away. Later runs follow your schedule. Initial Sync is not available with the <strong>Instantly<\/strong> schedule.<\/li>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal15.png\" \/><\/p>\n<li>Click <strong>Done<\/strong>. A message confirms that the automation rule was created. The rule appears on the <strong>Import Automation Dashboard<\/strong>.<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/importexternal15.png\" \/><\/p>\n<p><strong>Good to Know<\/strong><\/p>\n<ul>\n<li>Only .csv, .xls, and .xlsx files are listed, and files larger than 10 MB cannot be used. Only the first sheet of each file is imported.<\/li>\n<li>If the folder list is empty, create the folder on your SFTP server and click <strong>refresh<\/strong>. If the folder has no files, <strong>No Files Found<\/strong> is displayed.<\/li>\n<li>Map at least one question. A rule cannot be saved without a mapped question.<\/li>\n<li>When your files have a unique column, <strong>Email Address\/Unique ID<\/strong> must be mapped, and rows without a value are not imported. Sogolytics does not check for duplicate responses.<\/li>\n<li>Responses are linked only to records that already exist in the selected Directory or Activity. Importing does not create or update Directory contacts.<\/li>\n<li>If the rule name is already used in the project, <strong>Automation rule name already exists<\/strong> is displayed.<\/li>\n<li>Automation rules import new responses only. Editing a saved rule affects all future imports from that rule.<\/li>\n<\/ul>\n<hr \/>\n<h2>See also<\/h2>\n<ul>\n<li><a href=\"\/help\/survey-data-management\/\" rel=\"noopener\">Import Options<\/a><\/li>\n<li><a href=\"\/help\/import-automation\/\" rel=\"noopener\">Import Automation<\/a><\/li>\n<li><a href=\"\/help\/import-sogosurvey1-format\/\" rel=\"noopener\">Import Sogolytics1 Format<\/a><\/li>\n<li><a href=\"\/help\/import-offline-responses\/\" rel=\"noopener\">Import Responses Using a File<\/a><\/li>\n<li><a href=\"\/help\/integrations-connect-to-sogosurvey-sftp-server\/\" rel=\"noopener\">How to Connect to Sogolytics SFTP Server<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an automation rule. From then on, Sogolytics picks up response files from that folder on the schedule you set and imports them for you \u2014 no manual uploads. With external sources, you can: Import response files automatically from an SFTP server, Google Drive, or OneDrive. Choose which files are imported and how often the rule runs. Decide how blank and mismatched values are handled. Receive email alerts when a rule runs, imports nothing, or fails. Manage all of your rules from the Import Automation Dashboard. Before you begin Importing from external sources requires the Import Automation feature. If it is not in your plan, an upgrade icon or a Request a Demo option is displayed. Importing from SFTP also requires the Data Automation add-on and an SFTP setup for your account. See How to Connect to Sogolytics SFTP Server. Prepare response files in .xlsx, .xls, or .csv format, up to 10 MB each, in the Sogolytics1 format. Keep the same column order in every file. Place at least one sample file in the source folder. The sample is used only for mapping; no responses are imported from it while you set up the rule. Selecting the source differs for SFTP, OneDrive, and Google Drive. All other steps \u2014 data attributes, Directory linking, mapping, automation settings, and saving the rule \u2014 are the same [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"parent":0,"menu_order":269,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"_acf_changed":false,"footnotes":""},"categories":[201],"tags":[535,280],"class_list":["post-67547","page","type-page","status-publish","hentry","category-import-options","tag-automation","tag-enterprise-feature"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Import using External sources - Sogolytics<\/title>\n<meta name=\"description\" content=\"Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import using External sources - Sogolytics\" \/>\n<meta property=\"og:description\" content=\"Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-03T12:56:39+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/import-using-external-sources\\\/\",\"url\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/import-using-external-sources\\\/\",\"name\":\"Import using External sources - Sogolytics\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/#website\"},\"datePublished\":\"2026-10-28T19:49:58+00:00\",\"dateModified\":\"2026-11-03T12:56:39+00:00\",\"description\":\"Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/import-using-external-sources\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/import-using-external-sources\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/import-using-external-sources\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import using External sources\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/\",\"name\":\"Sogolytics\",\"description\":\"Sogolytics - Online Survey Tool\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import using External sources - Sogolytics","description":"Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/","og_locale":"en_US","og_type":"article","og_title":"Import using External sources - Sogolytics","og_description":"Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an","og_url":"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/","og_site_name":"Sogolytics","article_modified_time":"2026-11-03T12:56:39+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/","url":"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/","name":"Import using External sources - Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2026-10-28T19:49:58+00:00","dateModified":"2026-11-03T12:56:39+00:00","description":"Importing from an external source connects your project to a folder on an SFTP server, Google Drive, or OneDrive. You map a sample file once and save an","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/import-using-external-sources\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Import using External sources"}]},{"@type":"WebSite","@id":"https:\/\/www.sogolytics.com\/help\/#website","url":"https:\/\/www.sogolytics.com\/help\/","name":"Sogolytics","description":"Sogolytics - Online Survey Tool","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"seo_meta_info":{"yoast_noindex":"","rankmath_noindex":"","yoast_title":"Import using External sources","yoast_desc":"\/* Offset anchor jumps so headings aren't hidden behind the fixed help header *\/ h2[id], h3[id] { scroll-margin-top: 100px; } Importing from an external source&hellip;","rankmath_title":"Import using External sources","rankmath_desc":"\/* Offset anchor jumps so headings aren't hidden behind the fixed help header *\/ h2[id], h3[id] { scroll-margin-top: 100px; } Importing from an external source&hellip;"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/67547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/comments?post=67547"}],"version-history":[{"count":5,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/67547\/revisions"}],"predecessor-version":[{"id":67588,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/67547\/revisions\/67588"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=67547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=67547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=67547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}