---
title: "How to: Save new rows in Google Sheets as new prospects"
description: "Automatically create new contacts in Google Sheets as new rows in a prospecting list of your choice and start your qualification process."
url: https://help.nocrm.io/pt-br/articles/165-how-to-save-new-rows-in-google-sheets-as-new-prospects
collection: "Integrações"
updated: 2026-09-21
language: pt-br
alternates: [en, fr, it, es]
---

# How to: Save new rows in Google Sheets as new prospects

Automatically create new contacts in Google Sheets as new rows in a prospecting list of your choice and start your qualification process.

# How to: Save new rows in Google Sheets as new prospects

Automatically create new contacts in Google Sheets as new rows in a prospecting list of your choice and start your qualification process.

To get started, you would need to have an account with **Zapier and noCRM**.

* * *

-   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_.
    

* * *

## Build the workflow from scratch

### Create your workflow

Your workflow consists of a trigger that sets off the action(s) you want. In this case, when a new row is added to a chosen Google Sheet, it will trigger the action of creating a prefilled row in your chosen prospecting list in noCRM.

### Create your Trigger

-   Sign into your Zapier account and create a Zap by clicking on the "**Create Zap**" button on the top-left corner of the page
    
-   Select the **Google Sheets** app as the App Event and choose the Trigger Event "**New Spreadsheet Row**"
    
-   Connect your Google Account to Zapier by signing into your Gmail.
    
-   Set up your trigger by choosing the **spreadsheet** and **worksheet** you want Zapier to watch for new rows.
    

* * *

### Create your Action

Select the **noCRM.io** app as App Event and pick the Action Event "**Create Row**"

#### I. Connect your noCRM account

-   Enter your account name (`https://AccountName.nocrm.io`)
    
-   Enter your API Key. To find your API key, go to your noCRM account > Admin Panel > Integrations > API > API Keys then click on the **Create an API Key** button and name it.
    

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

#### II. Set up your Action

-   Select the Prospecting List you want to save your Google Sheets row in
    
-   Based on the Google Sheet row Zapier retrieved in the test earlier, select the fields you want Zapier to fill in the noCRM prospect fields.
    

![](https://ydncrm-www.s3.amazonaws.com/V2/No-code%20Academy/create-row-set-up.jpg)

Your workflow setup is now complete!

![](https://ydncrm-www.s3.amazonaws.com/V2/No-code%20Academy/new-prospect-from-new-row-workflow.jpg)