# Import from Google sheets

With the Google Sheets integration, you can easily import leads into 3sigma CRM from your Google Sheets. Whether you want to do a one-time import or set up continuous syncing, this feature streamlines the process of managing your leads.

## **Benefits of Google Sheets Integration**

1. **Effortless Bulk Import**:
   * Quickly import leads from Google Sheets in bulk, saving you time and ensuring that your lead database is always up to date.
2. **Continuous Syncing**:
   * Set up continuous syncing to automatically import new leads added to your Google Sheets. This is perfect for ongoing projects, surveys, or any service that regularly collects data.
3. **Easy Mapping of Fields**:
   * Map your Google Sheets column names to the corresponding lead fields in 3sigma CRM, ensuring all your data is accurately imported.

## **Use Cases for Google Sheets Integration**

* **Lead Generation Campaigns**:
  * Import leads collected from marketing campaigns or events to quickly add them to your CRM for follow-up.
* **Survey Responses**:
  * Sync responses from Google Forms surveys to capture potential leads and customer feedback seamlessly.
* **Project Management**:
  * Manage leads related to specific projects or initiatives stored in Google Sheets, making it easy to track and convert them.
* **Sync google form leads**
  * Use the import feature to import google responses connected to google sheets.

## **How to Import Leads from Google Sheets**

### **Authenticate Your Account**:

* Go to [web.3sigmacrm.com](https://web.3sigmacrm.com) and log in. Navigate to the **Leads > create new leads>**
* Select Import from **Google Sheets**. Click **Connect** and authenticate your Google account.

<figure><img src="https://2360397393-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FInUioAc4Scks6HcTR1Ns%2Fuploads%2FhGx1yV63JTDYQsIMo23f%2F2.png?alt=media&#x26;token=8186429e-92ea-48b2-804f-6396f8d4b192" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2360397393-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FInUioAc4Scks6HcTR1Ns%2Fuploads%2F3Za6U49JIeSsJTdjzht5%2F3.png?alt=media&#x26;token=f38d013e-d240-4437-a830-6338f483f834" alt=""><figcaption></figcaption></figure>

### **Select the Sheet to Import**:

* Once connected, choose the specific Google Sheet you want to import leads from.

<figure><img src="https://2360397393-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FInUioAc4Scks6HcTR1Ns%2Fuploads%2FOFikmoLIgu1tvLppCMwz%2F4.png?alt=media&#x26;token=e61506c3-aa2c-4313-888f-74b0cb015f61" alt=""><figcaption></figcaption></figure>

### **Map Column Names**:

* Align the column names in your Google Sheet with the lead fields in 3sigma CRM. This step ensures that each piece of data is imported correctly.

<figure><img src="https://2360397393-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FInUioAc4Scks6HcTR1Ns%2Fuploads%2FTiNMJXFgRFhDW7Wx2zu3%2F5.png?alt=media&#x26;token=c6298aaf-9e7a-45be-ac12-33c6d17ea73e" alt=""><figcaption></figcaption></figure>

### **Initiate the Import**:

#### One time impor

* After mapping, click **Import** to bring your leads into 3sigma CRM.

#### &#x20;     **Set Up Auto Sync** (Optional):

* After the initial import, you will be prompted to create an auto-sync. This feature will automatically scan for new rows or leads in your Google Sheet and import them into 3sigma CRM, keeping your lead list current.

<figure><img src="https://2360397393-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FInUioAc4Scks6HcTR1Ns%2Fuploads%2FEQo6sPWqmu11AYYg7re8%2F6.png?alt=media&#x26;token=a835437e-b7d1-4cf2-b1c4-0e86d9b4b389" alt=""><figcaption></figcaption></figure>

By integrating Google Sheets with 3sigma CRM, managing your leads becomes more efficient, helping you focus on engaging with potential clients and growing your business.

{% embed url="<https://youtu.be/ATLDwUWAKCs>" %}