{"id":4868,"date":"2025-04-08T07:47:37","date_gmt":"2025-04-08T07:47:37","guid":{"rendered":"https:\/\/www.growby.net\/blog\/?p=4868"},"modified":"2025-04-11T06:00:07","modified_gmt":"2025-04-11T06:00:07","slug":"how-to-import-contacts-from-the-google-sheets-in-the-growby","status":"publish","type":"post","link":"https:\/\/www.growby.net\/blog\/how-to-import-contacts-from-the-google-sheets-in-the-growby\/","title":{"rendered":"How to import contacts from the Excel file in the Growby?"},"content":{"rendered":"<p>Importing contacts into Growby.net is a streamlined process designed to enhance your WhatsApp marketing experience. In this detailed guide, we will walk you through the steps to easily import contacts from Excel files and integrate them seamlessly into your Growby account. Follow these instructions to get started:<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 1:\u00a0 Click on Login\u00a0<\/span><\/strong><\/span><\/h4>\n<p>To begin, click the\u00a0<strong data-start=\"544\" data-end=\"553\">Login<\/strong>\u00a0button located at the top-right of the page.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4866\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2022\/03\/LOGIN-landing-page.png\" alt=\"\" width=\"1918\" height=\"867\" \/><\/p>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 2:\u00a0 Login to your Account\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Enter your registered\u00a0<strong data-start=\"703\" data-end=\"720\">email address<\/strong>\u00a0and\u00a0<strong data-start=\"725\" data-end=\"737\">password<\/strong>\u00a0to sign in.<\/p>\n<p>In case of you\u2019ve forgotten your password then you can sign in to your Account with the OTP by the following steps:<\/p>\n<ol>\n<li>Click\u00a0<strong data-start=\"798\" data-end=\"816\">Login with OTP<\/strong><\/li>\n<li>Enter the OTP sent to your registered email.<\/li>\n<li>Click on\u00a0<strong>Login\u00a0<\/strong>button to login to your Account.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4865\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2022\/03\/login-button.png\" alt=\"\" width=\"1918\" height=\"863\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 3: Access the Templates Section\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Once logged in, you\u2019ll be directed to your\u00a0<strong data-start=\"994\" data-end=\"1014\">Growby Dashboard.\u00a0<\/strong>Now, click on the\u00a0<strong data-start=\"994\" data-end=\"1014\">Contacts <\/strong>tab in the left sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4867\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2022\/03\/Dashboard-1.png\" alt=\"\" width=\"1922\" height=\"863\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 4: Add New Contacts\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Click on &#8220;<strong>Add Contact&#8221;\u00a0<\/strong> button located on the top-right corner to begin adding new contact.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4869\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/add-contact-button.png\" alt=\"\" width=\"1918\" height=\"866\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 5: Download the Sample File\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Before proceeding, it&#8217;s essential to ensure your contact data is correctly structured. To help with this, click on <strong data-start=\"2110\" data-end=\"2134\">Download sample file<\/strong> to access a template.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4873 size-full\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Sample-file-button.png\" alt=\"\" width=\"1918\" height=\"867\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 6: Format Your Data in Excel Sheets\u00a0<\/span><\/strong><\/span><\/h4>\n<p>make sure the column name must be same as shown in the sample file.<br \/>\nThe columns you can add for your contacts are:<\/p>\n<ol>\n<li>Firstname : The contact\u2019s first name<\/li>\n<li>MobileNumber : The contact\u2019s mobile number, including the country code<\/li>\n<li>LastName : The contact\u2019s last name<\/li>\n<li>Birthdate : The contact\u2019s date of birth (in <strong data-start=\"2676\" data-end=\"2690\">DD-MM-YYYY<\/strong> format)<\/li>\n<li>City : The contact\u2019s city of residence<\/li>\n<\/ol>\n<p>If you wish to include additional information, the extra columns (Column 1 to Column 5) are available for supplementary information. Such as:<\/p>\n<ul>\n<li><strong data-start=\"566\" data-end=\"578\">Column 1<\/strong>: Use for details like <strong>Lead type<\/strong> (hot, cold, warm) or <strong>address<\/strong>, or <strong>personal\u00a0details<\/strong><\/li>\n<li><strong data-start=\"643\" data-end=\"655\">Column 2<\/strong>: Track <strong data-start=\"663\" data-end=\"678\">preferences<\/strong> such as product interests or preferred communication channels.<\/li>\n<li><strong data-start=\"744\" data-end=\"756\">Column 3<\/strong>: Store <strong data-start=\"764\" data-end=\"784\">purchase history<\/strong> or <strong data-start=\"788\" data-end=\"805\">service usage<\/strong> data.<\/li>\n<li><strong data-start=\"814\" data-end=\"826\">Column 4<\/strong>: Record <strong data-start=\"835\" data-end=\"854\">customer status<\/strong> like active or inactive.<\/li>\n<li><strong data-start=\"882\" data-end=\"894\">Column 5<\/strong>: Add <strong data-start=\"900\" data-end=\"909\">notes<\/strong> or relevant context for future follow-ups.<\/li>\n<\/ul>\n<p class=\"\" data-start=\"1594\" data-end=\"1781\">These extra columns provide the flexibility to store additional data, ensuring that you can capture all the relevant information necessary for targeted and personalized marketing efforts.<\/p>\n<p>&nbsp;<\/p>\n<h4><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4871\" style=\"font-size: 17px;\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/googlesheet.png\" alt=\"\" width=\"2142\" height=\"1053\" \/><\/h4>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 7: Upload Your File\u00a0<\/span><\/strong><\/span><\/h4>\n<p>After setting up your Excel Files, Click on <strong>file import\u00a0<\/strong>area to select the file for adding contacts and select the file from which\u00a0 you want to add the contacts.<\/p>\n<p><strong>Note<\/strong>: Supported file formats are <strong>.xls, .xlsv, .csv<\/strong> files including upto <strong>10,000<\/strong> contacts and does not exceed <strong data-start=\"3267\" data-end=\"3274\">5MB<\/strong> in size..<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4874\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Import-file-button.png\" alt=\"\" width=\"1918\" height=\"867\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 8: Continue to the Next Step\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Once you select your file, you will see its name displayed on the screen.<\/p>\n<p>Click <strong data-start=\"3469\" data-end=\"3494\">Continue to next step<\/strong> to proceed with the import process<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4876\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Continnue-to-next-step.png\" alt=\"\" width=\"1918\" height=\"866\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 9: Add Contacts to a Group\u00a0<\/span><\/strong><\/span><\/h4>\n<p class=\"\" data-start=\"3419\" data-end=\"3522\">A pop-up will appear, prompting you to choose whether you want to add the imported contacts to a group.<\/p>\n<ul>\n<li data-start=\"3419\" data-end=\"3522\">Click <strong>Yes<\/strong> if you wish to add the contacts to an existing group or create a new group (Refer to<strong> Step 10<\/strong>).<\/li>\n<li class=\"\" data-start=\"3524\" data-end=\"3638\">\n<p class=\"\" data-start=\"3526\" data-end=\"3638\">Click <strong>No<\/strong> if you do not want to add the contacts to any group and proceed with the\u00a0<strong>Step 11<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4878 size-full\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Yes-No-continue.png\" alt=\"\" width=\"1918\" height=\"867\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 10: Create or Select a Group\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Here, you will now have the option to either <strong data-start=\"3909\" data-end=\"3931\">create a new group<\/strong> or add the contacts to an<strong data-start=\"3935\" data-end=\"3976\"> existing group<\/strong>. After making your selection, click <strong data-start=\"4013\" data-end=\"4021\">Next<\/strong> to proceed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4879\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Add-to-groups.png\" alt=\"\" width=\"1167\" height=\"525\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 11: Country Code Confirmation\u00a0<\/span><\/strong><\/span><\/h4>\n<p class=\"\" data-start=\"4124\" data-end=\"4272\">A prompt will appear asking if you have included the <strong data-start=\"4177\" data-end=\"4193\">country code<\/strong> in the mobile number column of your file. Select one of the following options:<\/p>\n<ul>\n<li data-start=\"4124\" data-end=\"4272\">Click <strong>Yes<\/strong> if the country code has already been added to the mobile numbers (Refer to<strong> Step 13<\/strong>).<\/li>\n<li class=\"\" data-start=\"4273\" data-end=\"4377\">\n<p class=\"\" data-start=\"4275\" data-end=\"4377\">Click\u00a0 <strong>No<\/strong> if you haven\u2019t added the country code, and proceed with <strong>Step 12<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4880\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Country-code-popup.png\" alt=\"\" width=\"1918\" height=\"863\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 12: Add Country Code\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Add your country code and click <strong data-start=\"4723\" data-end=\"4733\">Submit<\/strong> to proceed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4881\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Add-country-code.png\" alt=\"\" width=\"1932\" height=\"866\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 13: Map Your Columns\u00a0<\/span><\/strong><\/span><\/h4>\n<p class=\"\" data-start=\"255\" data-end=\"435\">Ensure that each column from your file is accurately matched with the corresponding field. This step ensures that the contact details are properly aligned for seamless integration.<\/p>\n<ul>\n<li data-start=\"255\" data-end=\"435\">Carefully review each field (e.g., First Name to First Name, Mobile Number to Mobile Number, etc.)<\/li>\n<li class=\"\" data-start=\"437\" data-end=\"554\">\n<p class=\"\" data-start=\"439\" data-end=\"554\">Adjust the mapping if necessary to ensure everything is correctly aligned.<\/p>\n<\/li>\n<\/ul>\n<p class=\"\" data-start=\"557\" data-end=\"631\">Once you confirm the mapping is accurate, click <strong data-start=\"682\" data-end=\"690\">Save<\/strong> to finished this process.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4882\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Mapping-columns.png\" alt=\"\" width=\"1917\" height=\"907\" \/><\/p>\n<h4><\/h4>\n<h4><span style=\"color: #000000;\"><strong><span style=\"background-color: #bfd8e6; font-size: 18pt;\">Step 14: View Your Imported Contacts\u00a0<\/span><\/strong><\/span><\/h4>\n<p>Upon completion, you\u2019ll be directed to the contacts section, where your newly added entries will be visible.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4884\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/04\/Contacts-tab-final.png\" alt=\"\" width=\"1918\" height=\"863\" \/><\/p>\n<p class=\"\" data-start=\"1002\" data-end=\"1084\">Now, your contacts are ready to be used across various features, such as:<\/p>\n<ul>\n<li data-start=\"1002\" data-end=\"1084\">Creating and managing chatbot flows<\/li>\n<li data-start=\"1002\" data-end=\"1084\">Launching marketing campaigns<\/li>\n<li class=\"\" data-start=\"1085\" data-end=\"1120\">\n<p class=\"\" data-start=\"1087\" data-end=\"1120\">Setting up automations<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Importing contacts into Growby.net is a streamlined process designed to &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to import contacts from the Excel file in the Growby?\" class=\"read-more button\" href=\"https:\/\/www.growby.net\/blog\/how-to-import-contacts-from-the-google-sheets-in-the-growby\/#more-4868\" aria-label=\"More on How to import contacts from the Excel file in the Growby?\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,27,6,1],"tags":[],"class_list":["post-4868","post","type-post","status-publish","format-standard","hentry","category-contact-management","category-growby-features","category-how-to","category-uncategorized","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"_links":{"self":[{"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/posts\/4868"}],"collection":[{"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/comments?post=4868"}],"version-history":[{"count":14,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/posts\/4868\/revisions"}],"predecessor-version":[{"id":4915,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/posts\/4868\/revisions\/4915"}],"wp:attachment":[{"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/media?parent=4868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/categories?post=4868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/tags?post=4868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}