{"id":2788,"date":"2013-02-08T23:33:16","date_gmt":"2013-02-08T23:33:16","guid":{"rendered":"http:\/\/bme2.flywheelsites.com\/blog\/how-to-create-a-diy-crm-system-with-google-docs\/"},"modified":"2020-01-17T02:07:16","modified_gmt":"2020-01-17T02:07:16","slug":"how-to-create-a-diy-crm-system-with-google-docs","status":"publish","type":"post","link":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/","title":{"rendered":"How to Create a DIY CRM System with Google Docs"},"content":{"rendered":"<div>If you\u2019re a small business owner, you\u2019re likely managing everything from your financials to your marketing activities&#8211;and you&#8217;re doing it all on a limited budget. While you know that you need a better way to manage your sales prospects, especially during periods of growth, you just aren\u2019t ready to pay for a customer relationship management system to keep in touch with potential and existing customers.<\/p>\n<p>At Software Advice, I help review and compare most of the major\u00a0<a href=\"https:\/\/www.softwareadvice.com\/crm\/#buyers-guide\" target=\"_blank\" rel=\"noopener noreferrer\">CRM systems<\/a>on the market. But the truth of the matter is that many of the popular systems on the market can be too expensive for many small business owners. For these small businesses, it may be more effective to take the do-it-yourself (DIY) approach and build your own CRM system.<\/p>\n<p>Building your own CRM system can provide several benefits:<\/p>\n<ul>\n<li>It&#8217;s affordable (read: free)<\/li>\n<li>It&#8217;s flexible<\/li>\n<li>It&#8217;s easy to use and customize<\/li>\n<\/ul>\n<p>A great tool for building a CRM system on your own is Google Docs. If you have a Gmail account, you already have access to an easy way to build your own CRM software. Already widely used as a management tool, it\u2019s fairly easy to extend the power of these applications to help with customer management. Here\u2019s a quick step-by-step overview of how to do it.<\/p><\/div>\n<h3 class=\"subtopic\">Decide Who Gets Access, and What Information to Include<\/h3>\n<div>Google Docs allows all users to collaborate across any document thanks to their sharing and editing features. So, if one person changes a contact&#8217;s information, it automatically syncs across the system. This allows all document collaborators to see the change immediately. Beyond that, you can monitor user privileges to ensure that all users have access to the right information.<\/p>\n<p>Once you decide who will be able to access and update data in your CRM system, you&#8217;ll need to create a Google Spreadsheet. After that, it&#8217;s time to determine what information you want to track about sales prospects in your spreadsheet. A few pieces of information that are a good idea to track include:<\/p>\n<ul>\n<li><b>Demographics<\/b>\u00a0&#8211; Company name, contact name, email, phone number, etc.<\/li>\n<li><b>Prospect source<\/b>\u00a0&#8211; How the prospect found out about your company<\/li>\n<li><b>Next actions<\/b>\u00a0&#8211; A code that determines how you\u2019ll follow (e.g. phone call or email)<\/li>\n<li><b>Contact log<\/b>\u00a0&#8211; Notes from every contact you make with the prospect<\/li>\n<li><b>Estimated opportunity size<\/b>\u00a0&#8211; An estimate of the size of the sale<\/li>\n<li><b>Lead nurturing stage<\/b>\u00a0&#8211; A numbered system that shows how close the prospect is to purchasing (1 = aware but not interested; 4 = has purchased)<\/li>\n<\/ul>\n<p>Keep in mind that this is just a starter list and you\u2019ll likely want to record other information that\u2019s specific to your business. So feel free to add any field that&#8217;s relevant to your company. If after a while you realize that you want to track more information, it\u2019s fairly easy to add a new field.<\/p><\/div>\n<h3 class=\"subtopic\">Learn How to Manipulate the Data with Spreadsheet Functions<\/h3>\n<div>One nice thing about using a Google Spreadsheet is that there are easy sort features that allow you to sort by any field you like. If you only want to look at contacts with the biggest opportunity size, just sort by \u201cestimating opportunity size\u201d and you can view your largest sales prospects from largest potential sales to smallest.<\/p>\n<p>Or, maybe you\u2019re interested in looking at the number of companies that are in the very beginning of the lead nurturing stage. You\u2019ve already coded all entries that are in this stage of the buying process with a 1, but you don\u2019t know how many of your contacts are at that phase. To figure this out, you can use a simple function known as a \u201ccountif()\u201d. It works like this:<\/p>\n<ul>\n<li>Determine the cell range you want to count sales prospects for (let\u2019s say it\u2019s cells C2 to C100)<\/li>\n<li>Decide the criteria for counting each cell (in this case it&#8217;s a \u201c1\u201d)<\/li>\n<\/ul>\n<p>To count all your prospects that are at the beginning of the sales cycle, you can use the formula in cell C101: &#8216;=countif(C2:C100, \u201c1\u201d)&#8217;. This will give you the total number of contacts that are at phase one in the buying process. Of course there are a whole host of other functions that you can use to manipulate that data, but you get the idea. For a comprehensive list of spreadsheet functions that will work in a Google Spreadsheet, check out Google\u2019s help page.<\/p>\n<p>With this method, you can start tracking their sales prospects in an efficient and paperless manner. And you can do it for free. As a bonus, you\u2019ll also be able to access this data from anywhere with an Internet connection, because information in Google Docs is stored in the Cloud.<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019re a small business owner, you\u2019re likely managing everything from your financials to your marketing activities&#8211;and you&#8217;re doing it all on a limited budget. While you know that you need a better way to manage your sales prospects, especially during periods of growth, you just aren\u2019t ready to pay for a customer relationship management&hellip;<\/p>\n","protected":false},"author":313,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[2171],"tags":[],"class_list":["post-2788","post","type-post","status-publish","format-standard","hentry","category-beyond"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create a DIY CRM System with Google Docs - in<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a DIY CRM System with Google Docs - in\" \/>\n<meta property=\"og:description\" content=\"If you\u2019re a small business owner, you\u2019re likely managing everything from your financials to your marketing activities&#8211;and you&#8217;re doing it all on a limited budget. While you know that you need a better way to manage your sales prospects, especially during periods of growth, you just aren\u2019t ready to pay for a customer relationship management&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/\" \/>\n<meta property=\"og:site_name\" content=\"in\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-08T23:33:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-17T02:07:16+00:00\" \/>\n<meta name=\"author\" content=\"Software Advice\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Software Advice\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/\"},\"author\":{\"name\":\"Software Advice\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#\\\/schema\\\/person\\\/50f8e28bed3106d04f17c4a58230abde\"},\"headline\":\"How to Create a DIY CRM System with Google Docs\",\"datePublished\":\"2013-02-08T23:33:16+00:00\",\"dateModified\":\"2020-01-17T02:07:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/\"},\"wordCount\":811,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#organization\"},\"articleSection\":[\"Beyond\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/\",\"url\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/\",\"name\":\"How to Create a DIY CRM System with Google Docs - in\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#website\"},\"datePublished\":\"2013-02-08T23:33:16+00:00\",\"dateModified\":\"2020-01-17T02:07:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/how-to-create-a-diy-crm-system-with-google-docs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a DIY CRM System with Google Docs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#website\",\"url\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/\",\"name\":\"in\",\"description\":\"Email Marketing Software\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#organization\",\"name\":\"Benchmark Internet Group, LLC\",\"url\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/benchmarkemail.com\\\/in\\\/wp-content\\\/uploads\\\/sites\\\/11\\\/2019\\\/09\\\/benchmark-logo.svg\",\"contentUrl\":\"https:\\\/\\\/benchmarkemail.com\\\/in\\\/wp-content\\\/uploads\\\/sites\\\/11\\\/2019\\\/09\\\/benchmark-logo.svg\",\"width\":1,\"height\":1,\"caption\":\"Benchmark Internet Group, LLC\"},\"image\":{\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/#\\\/schema\\\/person\\\/50f8e28bed3106d04f17c4a58230abde\",\"name\":\"Software Advice\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/72795daf658b576d893d5311795b31dad3b243c1bc4d7fda03c68e2004ac2f4b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/72795daf658b576d893d5311795b31dad3b243c1bc4d7fda03c68e2004ac2f4b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/72795daf658b576d893d5311795b31dad3b243c1bc4d7fda03c68e2004ac2f4b?s=96&d=mm&r=g\",\"caption\":\"Software Advice\"},\"description\":\"Derek Singleton is an analyst at the Austin, Texas based research firm Software Advice. Derek reports on technologies topics and trends related to B2B marketing and CRM software. His writing has appeared in various tech publications such as Sandhill, Sys-Con and ZDNet. Ashley Verrill is a CRM software analyst for Software Advice. She has spent the last six years reporting and writing business news and strategy features. Her work has appeared in myriad publications including Inc., Upstart Business Journal, the Austin Business Journal, and the North Bay Business Journal. Before joining Software Advice in 2012, she worked in sales management and advertising.\",\"url\":\"https:\\\/\\\/www.benchmarkemail.com\\\/in\\\/author\\\/softwareadvice\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a DIY CRM System with Google Docs - in","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"How to Create a DIY CRM System with Google Docs - in","og_description":"If you\u2019re a small business owner, you\u2019re likely managing everything from your financials to your marketing activities&#8211;and you&#8217;re doing it all on a limited budget. While you know that you need a better way to manage your sales prospects, especially during periods of growth, you just aren\u2019t ready to pay for a customer relationship management&hellip;","og_url":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/","og_site_name":"in","article_published_time":"2013-02-08T23:33:16+00:00","article_modified_time":"2020-01-17T02:07:16+00:00","author":"Software Advice","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Software Advice","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/#article","isPartOf":{"@id":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/"},"author":{"name":"Software Advice","@id":"https:\/\/www.benchmarkemail.com\/in\/#\/schema\/person\/50f8e28bed3106d04f17c4a58230abde"},"headline":"How to Create a DIY CRM System with Google Docs","datePublished":"2013-02-08T23:33:16+00:00","dateModified":"2020-01-17T02:07:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/"},"wordCount":811,"commentCount":0,"publisher":{"@id":"https:\/\/www.benchmarkemail.com\/in\/#organization"},"articleSection":["Beyond"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/","url":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/","name":"How to Create a DIY CRM System with Google Docs - in","isPartOf":{"@id":"https:\/\/www.benchmarkemail.com\/in\/#website"},"datePublished":"2013-02-08T23:33:16+00:00","dateModified":"2020-01-17T02:07:16+00:00","breadcrumb":{"@id":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.benchmarkemail.com\/in\/how-to-create-a-diy-crm-system-with-google-docs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.benchmarkemail.com\/in\/"},{"@type":"ListItem","position":2,"name":"How to Create a DIY CRM System with Google Docs"}]},{"@type":"WebSite","@id":"https:\/\/www.benchmarkemail.com\/in\/#website","url":"https:\/\/www.benchmarkemail.com\/in\/","name":"in","description":"Email Marketing Software","publisher":{"@id":"https:\/\/www.benchmarkemail.com\/in\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.benchmarkemail.com\/in\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.benchmarkemail.com\/in\/#organization","name":"Benchmark Internet Group, LLC","url":"https:\/\/www.benchmarkemail.com\/in\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.benchmarkemail.com\/in\/#\/schema\/logo\/image\/","url":"https:\/\/benchmarkemail.com\/in\/wp-content\/uploads\/sites\/11\/2019\/09\/benchmark-logo.svg","contentUrl":"https:\/\/benchmarkemail.com\/in\/wp-content\/uploads\/sites\/11\/2019\/09\/benchmark-logo.svg","width":1,"height":1,"caption":"Benchmark Internet Group, LLC"},"image":{"@id":"https:\/\/www.benchmarkemail.com\/in\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.benchmarkemail.com\/in\/#\/schema\/person\/50f8e28bed3106d04f17c4a58230abde","name":"Software Advice","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/72795daf658b576d893d5311795b31dad3b243c1bc4d7fda03c68e2004ac2f4b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/72795daf658b576d893d5311795b31dad3b243c1bc4d7fda03c68e2004ac2f4b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/72795daf658b576d893d5311795b31dad3b243c1bc4d7fda03c68e2004ac2f4b?s=96&d=mm&r=g","caption":"Software Advice"},"description":"Derek Singleton is an analyst at the Austin, Texas based research firm Software Advice. Derek reports on technologies topics and trends related to B2B marketing and CRM software. His writing has appeared in various tech publications such as Sandhill, Sys-Con and ZDNet. Ashley Verrill is a CRM software analyst for Software Advice. She has spent the last six years reporting and writing business news and strategy features. Her work has appeared in myriad publications including Inc., Upstart Business Journal, the Austin Business Journal, and the North Bay Business Journal. Before joining Software Advice in 2012, she worked in sales management and advertising.","url":"https:\/\/www.benchmarkemail.com\/in\/author\/softwareadvice\/"}]}},"_links":{"self":[{"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/posts\/2788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/users\/313"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/comments?post=2788"}],"version-history":[{"count":0,"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/posts\/2788\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/media?parent=2788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/categories?post=2788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benchmarkemail.com\/in\/wp-json\/wp\/v2\/tags?post=2788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}