All Articles
Import data into your CRM without leaving Gmail

Import data into your CRM without leaving Gmail

min read

Your CRM is only as useful as the data in it. Getting started with a pipeline full of data can set your team on the right track from the beginning, and regularly importing data from lead sources and other tools ensures you never miss an opportunity in your pipelines.

Our new importer is built directly into Streak and helps you clean and import your data in a simple interface without leaving Gmail. In just a few minutes, you can fill your pipeline with data and get to work in your CRM. 

<a href="#key-features-streak-importer" class="anchor-link">Key features of the Streak importer</a>

  • <a href="#import-multiple-file-types" class="anchor-link">Import multiple file types</a>
  • <a href="#easier-data-clean-up" class="anchor-link">Easier data clean up</a>
  • <a href="#intelligent-mapping" class="anchor-link">Intelligent mapping</a>
  • <a href="#auto-create-new-columns" class="anchor-link">Auto-create new columns</a>
  • <a href="#set-email-sharing-preferences" class="anchor-link">Set email sharing preferences</a>

<a href="#how-to-use-streak-importer" class="anchor-link">How to use the Streak importer</a>
<a href="#need-help-importing-data" class="anchor-link">Need help importing your data?</a>

<div class="anchor-wrapper"><div id="key-features-streak-importer" class="anchor-target"></div></div>

Key features of the Streak importer

Although importing your data without leaving Gmail is a big win on its own, we built in a number of useful features that help you review data, add it to your pipelines, and manage sharing settings more easily. 

<div class="anchor-wrapper"><div id="import-multiple-file-types" class="anchor-target"></div></div>

Import multiple file types from your pipeline

Our new importer gives you more options to import your data using multiple file types. This makes it easier to export data from another tool into your Streak pipelines without copy and pasting or converting file types. 

a screenshot of three options for file types to import

We now support the three most common file types for data import: 

  • Google Sheets
  • CSV file
  • Excel file

<div class="anchor-wrapper"><div id="easier-data-clean-up" class="anchor-target"></div></div>

Easier data clean up

For better or for worse, cleaning your data is a dreaded step in the process of most imports (unless you nailed it on the first try - go you!). Our new importer helps you quickly and efficiently fix errors in your data so you can continue with a successful import. 

 a screenshot of formatting errors surfaced in the spreadsheet and suggestions to fix them with one click.

The “All errors” sidebar brings formatting issues, blank cells, and more  to your attention in one place so you don’t have to search and click around the spreadsheet looking for issues. Quickly surface errors and fix them directly in the spreadsheet, delete unwanted rows, or use the find and replace tool to make bulk fixes throughout your spreadsheet.

For common errors like date formatting, the importer identifies issues and suggests the correct format. All you have to do is approve the change with one click. 

<div class="anchor-wrapper"><div id="intelligent-mapping" class="anchor-target"></div></div>

Intelligent mapping

When you run an import, the importer matches the columns in your spreadsheet to the columns in your pipeline and fills in or updates your CRM with new data. 

a screenshot of a user mapping their spreadsheet columns to the columns in their pipelines.

a screenshot of a user mapping their spreadsheet columns to the columns in their pipelines.

The new importer maps your data by intelligently guessing which columns in your import file should match to each pipeline column. For example, it recognizes that a column called “First name” in your import file should be mapped to “Given name” in Streak. 

The importer also remembers your previous mapping selections, saving you time if you run the same type of import more than once. You can also use this to regularly update existing boxes with new data.

Of course, you’ll have the final say on how your data maps into Streak and can adjust as needed. 

<div class="anchor-wrapper"><div id="auto-create-new-columns" class="anchor-target"></div></div>

Auto-create new columns

Each column in the spreadsheet that you want to import needs to map to a pipeline column. Now if you’re importing a type of data that doesn’t already exist in your pipeline, you can create a new pipeline column directly from the importer tool as needed.

a screenshot showing a user adding a new pipeline column and selecting the data type.

Without leaving the importer tool, you can name the column and specify what type of data it contains – freeform, drop down, checkbox, date, etc. This saves you valuable time preparing your pipeline for the import and cross-referencing your data.

<div class="anchor-wrapper"><div id="set-email-sharing-preferences" class="anchor-target"></div></div>

Set email sharing preferences for contacts and organizations

The new importer gives you the option to automatically share emails with your team when you add contacts and organizations to your pipeline. 

a screenshot of the "include all emails" option toggled on for automatic email sharing.

Turn on email sharing for contacts and organizations to automatically pull all of your team’s emails with that person or company into the box timeline. If your team member hasn’t already given permission to share their emails with the person or company, you’ll see that unshared emails exist and be able to request access. 

This applies to previous and future emails, so you’ll have a complete interaction history for each contact and organization available in your pipelines as soon as you import your contacts and organizations.

<div class="anchor-wrapper"><div id="how-to-use-streak-importer" class="anchor-target"></div></div>

How to use the Streak importer to add data to your CRM

Once you have your import file prepared in either a Google Sheet, CSV file, or Excel spreadsheet, you can access the importer right inside Streak - no additional apps or tools required.

a screenshot of the pipeline menu with the "import" option highlighted

From the pipeline view, click the pipeline menu in the pipeline toolbar and select Import

a screenshot of the Streak sidebar in a pipeline view with the "Import data" option highlighted

You can also open the Streak sidebar form the pipeline view and click Import data.

Now you’re ready to import your data in 3 steps. 

1. Select your import file

a screenshot of three options for file types to import

Tell Streak whether your import data is in a Google Sheet, CSV file, or Excel spreadsheet and select the correct file. 

2. Map the data columns to your pipeline

a screenshot of the map columns step of the streak importer

Once you choose a header row, the importer intelligently maps the columns in your import file to your pipeline. Review the mapping and make any necessary changes.

You can also create new pipeline columns during this step if your pipeline doesn’t already have a column you need.  

3. Review and finalize data

a screenshot of formatting errors surfaced in the spreadsheet and suggestions to fix them with one click.

Review any errors and make updates across your spreadsheet right from the importer sidebar. Approve suggested updates and make changes with one click, or use the find and replace tool to make your own changes. 

Once you’re happy with your data, click “Import Now” to import your data into the Streak pipeline. 

<div class="anchor-wrapper"><div id="need-help-importing-data" class="anchor-target"></div></div>

Need help importing your data?

Learn more about our pipeline importer and find instructions in our knowledge base.

Related articles

We're hiring

Come build something great with us.