noCRM-Google Sheets: Add a New Google Sheets Row When a New Prospect is Created

Help Center

If you can't find the answer to your question here, please ask your question to our support team at

How to add no CRM prospects as new rows in Google Sheets

Whether it’s a sheet your outbound marketing team is working on or simply your own list of contacts being managed on no CRM, add them automatically to your Google Sheets when new prospects are added.

All you need to set it up are Google Sheets, no, and Zapier accounts.

If you don’t have an account with no, click here to start a FREE trial.
If you don't have an account with Zapier, click here to sign up for a FREE trial.

Get Started

  • Set up your TRIGGER
  • Set up your ACTION
  • Connect your TRIGGER App Account and Set Up the Trigger

    Sign into your Zapier account and click on the MAKE A ZAP! button at the very top where you will be directed to a new page:

    1. Choose the Trigger App: no
    2. Choose the Trigger: New Prospect Created
    3. Connect Zapier to your no account if you haven’t already by

  • Entering your slug/account name (
  • Entering your API Key (Go to your no account Admin Panel, select Webhooks and API, API Keys then click on the Create an API Key button and name it.)

  • 4. Customize Prospect
    Select the prospecting list you wish to retrieve new prospects from or leave it empty if you want this zap to be triggered anytime a new prospect is created in any prospecting list.

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

    Connect your ACTION App Account and Set Up the Action

    1. Choose an Action App: Google Sheets
    2. Choose an Action: Create Spreadsheet Row
    3. Connect Zapier to your Gmail account
    4. Set up Google Sheets Spreadsheet Row
    Enter the fields you want to retrieve from your prospects into the corresponding columns in your selected spreadsheet.
    Based on the prospecting list you tested earlier, select the fields you want no to retrieve information from every time a new prospect is created.

    5. Test the step and the Action is set!