All Collections
Prospects
Moving Prospects into and out of Klenty
Can I import Prospects from Google Sheets?
Can I import Prospects from Google Sheets?

Instructions on connecting your Google Drive and importing Prospects from Google Sheets.

Preena Francis avatar
Written by Preena Francis
Updated over a week ago

Google Sheets can be an easily accessible and shareable source to add your prospects to and import them to Klenty.

To begin, connect your Google account:

Login to Klenty and go to Settings -> Integrations -> Google Sheets

  1. Enter the Google Drive account’s email ID account that you wish to connect to Klenty and click on Authenticate.

After doing this, click on "Import prospects", you can create Sheets via Klenty and add your prospects’ information. Klenty will create the Sheets in a new Klenty folder in your Google Drive.

  1. Enter a name to create a new Sheet.

  2. Copy your prospect details over to this new Sheet.

  3. In Klenty, you’ll see the Sheets you’ve created via this process in the Google Sheets tab listed as Your Sheets. Click on the Import button on the Sheet you want to import.

  4. Klenty will automatically map your Sheet headers with Klenty prospect fields. You can verify and edit as required and create a new custom field if there are no prospect fields that match your requirement.

  5. Add to a list or tags if needed, you can also assign the prospect owner using the "Assign to" option. Select your teammate's email address from the drop-down to assign the prospect owner to their name.

  6. Click on Start Import to start adding the prospects to Klenty.

Once you Import a Sheet, you can

  • Enable the auto-import option to automatically import new additions to the Google Sheet (remember to add the new prospects to the last row of the Sheet).

  • Click on Import New Rows to immediately import any new additions in the Sheet.

Did this answer your question?