Simple CRM For Google Sheets: Onesheet CRM
Wordpress tools How to

Simple CRM For Google Sheets: Onesheet CRM

AliDropship is the best solution for drop shipping

Editor Rankings:

Person Rankings:

[Total: 1   Average: 1/5]

Opensheet CRM for Google Sheets is a Google Sheets based mostly free CRM that may help you in managing your small enterprise by holding monitor of gross sales and leads, and managing varied enterprise contacts like clients, firms, and many others. It simplifies these duties by offering varied spreadsheets like Dashboard, Corporations, Individuals, Alternatives, Filter alternatives, and Settings to handle enterprise contacts and preserve monitor of your offers.

Preserve studying to know extra about how one can use these free CRM for Google Sheets.Home

Opensheet CRM offers an environment friendly buyer relationship administration instrument. It lets you specify buyer varieties through the use of built-in classes or you possibly can even customise classes as per your wants.

One of the best a part of Opensheet CRM is that it comes with an Excel impressed interface. The Solely distinction is that you simply shouldn’t have to use any formulae for calculating complete values/gross sales or drawing histograms to characterize leads/alternatives. It routinely performs all that give you the results you want and also you simply need to enter knowledge.

It additionally retains monitor of your offers/alternatives by levels. Opensheet CRM offers pre-defined levels like Contract despatched, Observe up, Negotiations, and many others. It additionally offers you the pliability to customise these classes. Conserving monitor of offers by levels permits you to analyze your online business methods and push up your gross sales.

Opensheet CRM is sort of easy and might solely serve the wants of a small scale enterprise. If you happen to want a full-fledged CRM software program, you possibly can take a look at from any of these. Nonetheless, if you happen to want a easy CRM for your online business, Opensheet CRM is an ideal instrument because it permits fast enhancing by way of personalized drop-down, managing clients and corporations by way of varieties, preserve monitor of offers by varied levels and apply filters on offers to type them out.

How you can Use Opensheet CRM for Google Sheets:

Getting began with Opensheet CRM is as simple as ABC. You simply must register your self here after which you’ll obtain a hyperlink to Opensheet CRM Google Sheet in your registered e-mail ID. Open that Google Sheet and make its copy on Google Drive. Now your Opensheet CRM will dwell in your Google Drive and you may entry it from wherever. So you possibly can preserve tracks of gross sales and handle enterprise contacts on the go utilizing this Google Sheet CRM instrument/template.

Let’s dig deep into Opensheet CRM and see how one can handle enterprise contacts and preserve monitor of offers utilizing it.

As I discussed earlier, it offers totally different worksheets like Dashboard, Individuals, Corporations, and many others to work with and handle your online business. These worksheets are fairly just like Excel sheets so I suppose you gained’t come throughout any downside in enhancing worksheet.

Let’s see these totally different worksheets and how one can work with them.

Dashboard: As you possibly can see in the principle screenshot, by way of Dashboard you possibly can see complete gross sales, complete variety of folks/clients, firms, and offers/alternatives. It additionally shows complete quantity and worth of offers by levels in a tabular format and thru histograms as properly. You should use its Dashboard as a monitor window to view insights associated to your online business.

Individuals: You possibly can simply handle your clients by way of Individuals worksheet. For straightforward administration of contacts, you can too set Contact Varieties like Potential Buyer, Present buyer, and different. You may also customise these pre-defined varieties by way of Settings worksheet, which we’ll see somewhat later on this article. For including a buyer/individual, it is advisable specify following particulars.

  • Title
  • Firm
  • Work E-mail
  • Title
  • Contact Kind
  • Work Telephone
  • Work Web site
  • Handle
  • Metropolis
  • Zip
  • Linkedin
  • Tags
  • Descriptionpeople

Corporations: You possibly can handle a listing of firms you’re employed with by way of this worksheet. Please don’t get confused with Individuals and Corporations worksheet, as they’ve similar fields. Perhaps they’re stored individually to maintain issues easy and little much less complicated.


Alternatives/Offers: For holding a monitor of your offers/gross sales/alternatives, it is advisable enter offers on this spreadsheet. For including a deal you must specify following particulars.

  • Title
  • Firm
  • Stage
  • Worth
  • Shut date
  • Win %
  • Standing
  • Loss Bounds
  • Precedence
  • Supply
  • Tags
  • Description

dealsFilter Alternatives: Via this spreadsheet, you possibly can apply varied filters like Stage, Standing, Loss Bounds, and Supply to type out offers/alternatives. filter

Settings: Via this spreadsheet, you possibly can customise buyer varieties and offers levels. For eradicating a pre-defined kind or stage, simply delete the content material of its cell. For including a Contact kind, simply enter a worth in Contact Kind area of this spreadsheet. In the identical method, you possibly can customise deal levels, Standing, Supply, and Lose Bounds.settings


I’ll undoubtedly suggest Opensheet CRM as it’s fairly easy to make use of and you may handle enterprise contacts on the go by saving its Google Sheet template to Google Drive. You should use it to effectively handle the database of your clients and preserve monitor of gross sales and handle your contacts. I actually appreciated its fast enhancing function by way of customizable drop-down lists.

Get Opensheet CRM from here.