In the CoPilot > Power List page, you can import SFDC IDs or Emails addresses from a CSV file directly. For this strategy, you must select Contact as the source object. This option is helpful in situations where you have a list of contacts’ email addresses and there’s no way to filter for them in SFDC or Gainsight, such as a list of webinar attendees. Your CSV file must contain the Contact IDs (Salesforce) and/or the associated email addresses.

This article addresses the proper CSV file format, and includes instructions for how to import contacts from a CSV file.  

CSV file Format

The CSV file must contain either of the following columns:

  • Contact IDs (Salesforce): Only the contact IDs in the CSV file that match with existing Salesforce contact IDs will be added to the Power List. In other words, contacts must already exist in SFDC. Any contact ID that does not match will be reported as a failed record in the excel sheet that is sent by email after a Power List is executed.
  • Email addresses.

Note: The CSV file size must be equal to or less than 2-MB and can contain a maximum of five thousand (5000) records.

Import contacts from a CSV file

To import contacts from a CSV file:

  1. In the CoPilot > Power List screen, create a Power List for Account.
  2. Select Salesforce as the data source.
  3. Select Contact as the source object.
  1. Click UPLOAD CSV. The Open dialog appears.
  2. Select a CSV file.
    • After you select a CSV file, map the contact object field with the header in the csv file.
    • If required, you can also delete the currently selected CSV file using the delete option.
  1. Click SAVE AND REFRESH. After you save the Power List, you cannot change the mapping.