---
title: "How to: Create leads from contacts in Google Sheets"
description: "Automatically get new Google sheet contact rows saved as leads in noCRM"
url: https://help.nocrm.io/en/articles/163-how-to-create-leads-from-contacts-in-google-sheets
collection: "Integrations"
updated: 2026-11-10
language: en
alternates: [pt-br, fr, es, de, it]
---

# How to: Create leads from contacts in Google Sheets

Automatically get new Google sheet contact rows saved as leads in noCRM

# How to: Create leads from contacts in Google Sheets

Whether it’s a sheet your outbound marketing team is working on or simply your own list of contacts, you can save new rows as noCRM.io leads to manage. This [automation in your sales process](https://www.nocrm.io/no-code-academy/introduction) will allow you and your tam to save a great amount of time

  
All you need to set it up are **Google Sheets, noCRM.io, and Zapier** accounts.

* * *

If you don’t have an account with noCRM.io, [**click here**](https://www.nocrm.io/) **to start a FREE trial.**  
If you don't have an account with Zapier, [**click here**](https://zapier.com/sign-up/) **to sign up for a FREE trial.**

* * *

## Get Started

[**Set up your TRIGGER**](#trigger) [**Set up your ACTION**](#action)

### Connect your TRIGGER App Account and Set Up the Trigger

Sign into your [Zapier](https://www.nocrm.io/app-integrations/zapier) account and click on the **Create Zap** button at the very top where you will be directed to a new page:

![](https://ydncrm-www.s3.amazonaws.com/V2/Help%20Center%20V2/ZapierZapbook.png)

**1.** Choose the Trigger App: **Google Sheets**  
**2.** Choose the Trigger: **New Spreadsheet Row**  
**3.** Connect Zapier to your Gmail account  
**4.** Set up Google Sheets Spreadsheet Row

![](https://ydncrm-www.s3.amazonaws.com/V2/Help%20Center%20V2/spreadsheet1.png)

**5.** Test this Step and on to the Action set up!

* * *

### Connect your ACTION App Account and Set Up the Action

**1.** Choose an Action App: **noCRM.io**  
**2.** Choose an Action: **Create Lead**  
**3.** [Connect Zapier to your noCRM.io account](https://www.nocrm.io/no-code-academy/connect-no-crm-to-automation-platforms-zapier-and-integromat) if you haven’t already by  

Entering your slug/account name (`https://ACCOUNT.nocrm.io`) Entering your API Key (Go to your nocrm.io account **Admin Panel**, select **Webhooks and API**, **API Keys** then click on the **Create an API Key** button and name it.)

  
  
**4.** Edit Template to set up your noCRM.io lead!  
Based on the spreadsheet you tested earlier, select the fields you want noCRM.io to retrieve information from every time a new row is created.

![](https://ydncrm-www.s3.amazonaws.com/V2/Help%20Center%20V2/APIKey.png)![](https://ydncrm-www.s3.amazonaws.com/V2/Help%20Center%20V2/spreadsheet2.png)

**5.** Test the step and the Action is set!

* * *