{"id":69,"date":"2011-11-25T17:28:45","date_gmt":"2011-11-25T11:58:45","guid":{"rendered":"https:\/\/www.dhruvsoft.com\/blog\/?p=69"},"modified":"2025-06-04T19:34:02","modified_gmt":"2025-06-04T14:04:02","slug":"using-google-docs-for-small-business-crm","status":"publish","type":"post","link":"https:\/\/www.dhruvsoft.com\/blog\/using-google-docs-for-small-business-crm\/","title":{"rendered":"Using Google Docs for Small Business CRM"},"content":{"rendered":"<p>More and more small businesses are beginning to implement customer relationship management (CRM) software. It is an extremely useful tool for managing customer interactions and tracking sales prospects. In this article we will be discussion about how we can use\u00c2\u00a0Google Docs for Small Business CRM?<\/p>\n<p>Companies interested in CRM have two options:<!--more--> 1) They can research and look at <a href=\"http:\/\/www.softwareadvice.com\/crm\/\" target=\"_blank\" rel=\"noopener\">CRM software reviews<\/a> to select one of the popular systems on the market; or 2) they can build their own.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.dhruvsoft.com\/blog\/using-google-docs-for-small-business-crm\/#What_are_the_benefits_of_building_CRM_over_buying_CRM\" >What are the benefits of building CRM over buying CRM?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.dhruvsoft.com\/blog\/using-google-docs-for-small-business-crm\/#Google_Docs_CRM_-A_Getting_started_with_Set_Up\" >Google Docs CRM -\u00c2\u00a0Getting started with Set Up<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"What_are_the_benefits_of_building_CRM_over_buying_CRM\"><\/span>What are the benefits of building CRM over buying CRM?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Reduced cost (it can be free!)<br \/>\n2. Increased flexibility<br \/>\n3. Optimal customization<br \/>\n4. Easy to use<\/p>\n<p>Building your own CRM system may seem like a daunting task. The average small business owner is not a computer programmer. But the good news is, you don&#8217;t have to be. A great tool to start with is Google Docs.<\/p>\n<p>Not only does Google Docs have the tools for basic contact management, email marketing and document management, it also allows for sharing and real-time editing. This means that if both Jack and Jill are using the system at the same time, and Jack updates client information in the system, Jill will see the update immediately.<\/p>\n<p>Another neat feature is that Google Docs allows for privilege settings. Small business owners can manage which of their employees can access certain information with just a few clicks.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Google_Docs_CRM_-A_Getting_started_with_Set_Up\"><\/span>Google Docs CRM -\u00c2\u00a0Getting started with Set Up<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One of the most important things for small businesses to keep track of is customer data. So, the first step in building a CRM system using Google Docs is to collect all relevant customer data in a master spreadsheet.<\/p>\n<blockquote><p>You should include the following in the Google Docs CRM:<\/p>\n<ol>\n<li><strong>Demographics<\/strong> &#8211; Name, phone number, email, company name, address, etc.<\/li>\n<li><strong>Source<\/strong> &#8211; Note where the prospect came from to help track the effectiveness of your marketing campaigns.<\/li>\n<li><strong>Next action code<\/strong> &#8211; A number system that coincides with the next actions to be taken with prospects.<\/li>\n<li><strong>Next action date<\/strong> &#8211; Assigned date for next action<\/li>\n<li><strong>Interaction log<\/strong> &#8211; A large cell where you can track every call, email and important interaction with the prospect. You should date significant items such as buyer hot buttons or requirements.<\/li>\n<li><strong>Lead nurturing stage<\/strong> &#8211; A numbered system that coincides with where the prospect is in the buying cycle. Here is an example system: 1)Aware, no interest; 2)Interested; 3)Verbal commitment; 4)Purchased.<\/li>\n<li><strong>Estimated size<\/strong> &#8211; Your estimate of how large the sales opportunity is with the prospect. This should be modified to whatever is applicable to your business model.<\/li>\n<\/ol>\n<\/blockquote>\n<p>These are just a recommended set of fields to get started with. They will vary by business. For example, an eyeglass store might also want to have additional fields for prescription and lens preference. It is easy to add and delete fields in Google Docs, customizing the system as you go along to better fit the needs of your business.<\/p>\n<p>Once you are able to gather all this information into the master spreadsheet, the sort option makes it easy to segment prospects. Let&#8217;s say you want to identify all prospects that have been tagged &#8220;interested&#8221; in order to send a targeted marketing email. Simply sort by lead nurturing stage. Similarly, if the eyeglass store wants to find out how many contact lens wearers they have, they can simply sort by that field. It&#8217;s fairly straightforward.<\/p>\n<p>Finally, one of the best perks of using Google Docs to manage your customer relationships is its familiar user interface that is easy to use. Many people use Google for managing their personal life (Gmail, Calendar, etc.). Being able to use it in business makes for an easy and quick transition. Also, if your company grows to a point that you need to upgrade from your homegrown system, it is easy to export data from Google Docs. System data transfer can typically be a time-consuming, frustrating process, but Google Docs makes it easy with just a few clicks.<\/p>\n<p>Google Docs provides all of the basic functionality of a CRM system, but at a better price point &#8211; Free. You just can&#8217;t beat that. For more on Google CRM, visit the <a href=\"http:\/\/blog.softwareadvice.com\/articles\/crm\/google-docs-crm-1090611\/\" target=\"_blank\" rel=\"noopener\">Software Advice blog<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>More and more small businesses are beginning to implement customer relationship management (CRM) software. It is an extremely useful tool for managing customer interactions and tracking sales prospects. In this article we will be discussion about how we can use\u00c2\u00a0Google Docs for Small Business CRM? Companies interested in CRM have two options:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56,23,8],"tags":[124,30],"class_list":["post-69","post","type-post","status-publish","format-standard","hentry","category-crm-overview","category-crm-products","category-google-apps","tag-crm-products","tag-google-docs","entry"],"_links":{"self":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":0,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/69\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}