{"id":4651,"date":"2025-03-31T07:06:49","date_gmt":"2025-03-31T07:06:49","guid":{"rendered":"https:\/\/www.growby.net\/blog\/?p=4651"},"modified":"2025-03-31T11:39:32","modified_gmt":"2025-03-31T11:39:32","slug":"google-sheet-and-growby-integration-in-zapier-add-contact-from-google-sheet-to-growby-platform","status":"publish","type":"post","link":"https:\/\/www.growby.net\/blog\/google-sheet-and-growby-integration-in-zapier-add-contact-from-google-sheet-to-growby-platform\/","title":{"rendered":"Google Sheet and Growby Integration in Zapier. Add contact from google sheet to growby platform."},"content":{"rendered":"<p>The <strong>Google Sheets and Growby Integration in Zapier<\/strong> automates adding contacts from Sheets to Growby, saving time and keeping data up to date by triggering actions like new rows added.<\/p>\n<p><strong>How to get your data into your Google sheet?<\/strong><\/p>\n<p>You can integrate your Google sheet with other applications in Zapier or any third party application to write into Google sheet. Once new data is available in the Google sheet, the <strong>Zap\u00a0<\/strong>will be triggered.<\/p>\n<div class=\"hHq9Z\">\n<div data-hveid=\"CBoQAA\">\n<div class=\"gyEfO\">\n<div class=\"wDYxhc NFQFxe viOShc LKPcQc\" data-md=\"221\" data-hveid=\"CBwQAA\" data-ved=\"2ahUKEwj6joCfwKSMAxUpT2wGHSK1OaEQnKEBKAB6BAgcEAA\">\n<div class=\"ZxoDOe yGdMVd UoezFf\">\n<div class=\"UFE1qd\">\n<div class=\"oQDTXb\">\n<div data-ias=\"false\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<ul>\n<li>To integrate your Google sheet with Growby platform, please follow the blog <a href=\"https:\/\/www.growby.net\/blog\/google-sheet-integration-with-growby-platform\/\" target=\"_blank\" rel=\"noopener\">Google sheet integration with Growby platform<\/a>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Prerequisite:<\/strong><\/p>\n<ul>\n<li>You should have a Growby account and Zapier account to use this feature.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Step 1:<\/strong> Signin to your Zapier account.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 2:<\/strong> Click on Zap to start creating a Zap (A <strong data-start=\"2\" data-end=\"9\">Zap<\/strong> in Zapier is an automated workflow that connects two or more apps to perform specific tasks. It consists of a <strong data-start=\"120\" data-end=\"131\">Trigger<\/strong> and one or more <strong data-start=\"148\" data-end=\"159\">Actions<\/strong>.)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4653\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/Zapier-home.png\" alt=\"\" width=\"1918\" height=\"832\" \/><\/p>\n<p><strong>Step 3: <\/strong>Click on Trigger to add your trigger (A <strong data-start=\"2\" data-end=\"13\">Trigger<\/strong> in Zapier is the event that starts a Zap. It&#8217;s the condition or action that happens in one app that prompts Zapier to perform actions in another app.)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4656\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/Zap-creation-screen.png\" alt=\"\" width=\"1918\" height=\"912\" \/><\/p>\n<p><strong>Step 4:<\/strong> Search &#8220;<strong>Google Sheet<\/strong>&#8221; and select it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4658\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/Trigger-selection.png\" alt=\"\" width=\"1918\" height=\"916\" \/><\/p>\n<p><strong>Step 5:<\/strong> Click on &#8220;<strong>Trigger event<\/strong>&#8221; and select event that need to be triggered. Sign up with your Google account that has the Google sheet then click on continue at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4659\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/googlesheet-setup.png\" alt=\"\" width=\"1918\" height=\"910\" \/><\/p>\n<p><strong>Step 6:<\/strong> Select your Spreadsheet and worksheet you want to integrate and click on continue at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4660\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/googlesheet-configuration.png\" alt=\"\" width=\"1918\" height=\"906\" \/><\/p>\n<p><strong>Step 7:<\/strong> Click on &#8220;<strong>Test trigger<\/strong>&#8221; to test if your Google sheet is correctly integrated.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4661\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/googlesheet-test-trigger.png\" alt=\"\" width=\"1921\" height=\"910\" \/><\/p>\n<p><strong>Step 8:<\/strong> Select a test record and click on &#8220;<strong>Continue with selected record<\/strong>&#8220;. This record will be used to test the action we define later.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4662\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/Googlesheet-test.png\" alt=\"\" width=\"1918\" height=\"910\" \/><\/p>\n<p><strong>Step 9:<\/strong> Search &#8220;Growby&#8221; in the search and select &#8220;<strong>Growby<\/strong>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4664\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/Growby-selection.png\" alt=\"\" width=\"1918\" height=\"911\" \/><\/p>\n<p><strong>Step 10:<\/strong> Click on &#8220;Action event&#8221; and select &#8220;Add Contact&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4666\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/growby-action-selection.png\" alt=\"\" width=\"1918\" height=\"910\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 11:<\/strong> Go to API setup page in Growby platform and copy the ApiKey.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4667\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/growby-api-setup-page.png\" alt=\"\" width=\"1918\" height=\"968\" \/><\/p>\n<p><strong>Step 12:<\/strong> Click on account and Paste your ApiKey in the ApiKey text area then click on Continue at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4668\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/growby-setup.png\" alt=\"\" width=\"1918\" height=\"915\" \/><\/p>\n<p><strong>Step 13:<\/strong> Map or fill the Contact data and click on &#8220;Continue&#8221; at the bottom. (The data you map from the Google sheet will be saved in the Growby platform)<\/p>\n<p>Remember to map all the required fields (Required fields are indicated with &#8220;<span style=\"color: #ff0000;\">*<\/span>&#8220;).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4665\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/growby-configure.png\" alt=\"\" width=\"1934\" height=\"912\" \/><\/p>\n<p><strong>Step 14:<\/strong> Now Click on &#8220;Test step&#8221;. If the test passes, you can publish by click on the &#8220;publish&#8221; button at top right corner. If the test fails, check your data mapping in configuration page, make sure you have selected correct format for each field.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4669\" src=\"https:\/\/www.growby.net\/blog\/wp-content\/uploads\/2025\/03\/growby-test.png\" alt=\"\" width=\"1921\" height=\"923\" \/><\/p>\n<p>Once these steps are done, you have created a Zap automation which will add new contact to Growby platform whenever a new data is available in the Google sheet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Google Sheets and Growby Integration in Zapier automates adding &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Google Sheet and Growby Integration in Zapier. Add contact from google sheet to growby platform.\" class=\"read-more button\" href=\"https:\/\/www.growby.net\/blog\/google-sheet-and-growby-integration-in-zapier-add-contact-from-google-sheet-to-growby-platform\/#more-4651\" aria-label=\"More on Google Sheet and Growby Integration in Zapier. Add contact from google sheet to growby platform.\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":4859,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,4,6,1,80],"tags":[],"class_list":["post-4651","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-contact-management","category-educational","category-how-to","category-uncategorized","category-zapier","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33","resize-featured-image"],"_links":{"self":[{"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/posts\/4651"}],"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=4651"}],"version-history":[{"count":37,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/posts\/4651\/revisions"}],"predecessor-version":[{"id":4846,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/posts\/4651\/revisions\/4846"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/media\/4859"}],"wp:attachment":[{"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/media?parent=4651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/categories?post=4651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.growby.net\/blog\/wp-json\/wp\/v2\/tags?post=4651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}