{"id":36325,"date":"2022-07-25T16:52:45","date_gmt":"2019-12-13T12:43:11","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=36325"},"modified":"2025-03-05T10:08:12","modified_gmt":"2025-03-05T10:08:12","slug":"send-specific-data-to-google-drive","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/","title":{"rendered":"Send specific data of your forms to Google Sheets with 123FormBuilder"},"content":{"rendered":"\n<p>When you integrate with Google Sheets all the data is imported in the form&#8217;s spreadsheet. Sometimes you need only certain information about your users. In this article, you will learn how to send specific data to Google Sheets.<\/p>\n\n\n\n<p>For this to work you will need to create a Zapier account and enable the Webhooks integration.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-does-it-work\">How does it work?<\/h2>\n\n\n\n<p>To summarize the whole process, you will create a zap between <b>WebHooks<\/b> and&nbsp;<b>Google Sheets<\/b> and use the Webhook link on your form.<\/p>\n\n\n\n<p>Webhooks are automated ways for different apps to send messages to each other.<\/p>\n\n\n\n<p>Webhooks are triggered by specific events and in our case, it will be a form submission. When you create the zap, a Webhook link is provided by Zapier. That link will be placed on your 123FormBuilder form.<\/p>\n\n\n\n<p>Let&#8217;s jump right into it to have a better understanding.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-setting-up-the-connection\">Setting up the connection<\/h2>\n\n\n\n<p>Open up your Zapier account and click on&nbsp;<b>Make a zap.<\/b><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/makeazap.png\" alt=\"make zap\" style=\"width:379px;height:auto\" \/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p>Next,&nbsp;search for&nbsp;<b>Webhooks<\/b>.<\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/webhookszapier.png\" alt=\"webhooks zapier\" style=\"width:419px;height:auto\" \/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p>At <b>Choose Trigger Event<\/b> select <b>Catch a Hook<\/b>. Click Continue.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/catchhook.jpg\" alt=\"webhooks google drive\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Copy the<b> Custom Webhook URL<\/b>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/webhookurl.jpg\" alt=\"webhooks google drive\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Go to your form&#8217;s <a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/applications\/\"><b>Integrations<\/b><\/a> section. Search for Webhooks integration and paste the Webhooks link copied earlier.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-402.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"413\" src=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-402-1024x413.png\" alt=\"Webhooks 123FormBuilder integration\" class=\"wp-image-48299\" srcset=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-402-1024x413.png 1024w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-402-300x121.png 300w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-402-768x310.png 768w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-402-1536x620.png 1536w, https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2023\/11\/image-402.png 1906w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Now, form submissions are the trigger. You could add <a href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/google-docs\/\"><b>Google Sheets<\/b><\/a> as well.<\/p>\n\n\n\n<p>Make a test submission on your form to&nbsp;help Zapier find the data. Complete the form with relevant data, you need to identify&nbsp;it&nbsp;later in this guide.<\/p>\n\n\n\n<p>Go back to your zap settings. Below <b>Find Data<\/b> click on <b>Test &amp; Continue<\/b>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/finddatawebhook.jpg\" alt=\"webhooks shopify\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In the second part of the zap, search and add <b>Google Sheets<\/b>.<\/p>\n\n\n\n<p>At <b>Choose Action Event<\/b> select <b>Create Spreadsheet row<\/b>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/createspreadsheetrow.png\" alt=\"webhooks google drive\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Next, connect your <b>Google Sheets<\/b> account and select the form&#8217;s spreadsheet.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/customizespreadsheet.png\" alt=\"webhooks google drive\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Open up the Google spreadsheet created by your form. Insert a new blank sheet (a new tab) into the existing Google Spreadsheet.&nbsp;Type the title for each column into the blank cells at the top of the table.<br>The column name doesn&#8217;t need to be exactly as your field label.<\/p>\n\n\n\n<p>In your zap&#8217;s settings at <b>Worksheet<\/b>&nbsp;click on&nbsp;the new sheet created.<\/p>\n\n\n\n<p>The columns from the new sheet are listed below. Click the <b>Insert a field<\/b> icon and associate it with the corresponding form field.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/worksheetfields.png\" alt=\"webhooks google drive\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In the dropdown are first displayed the labels (control name) and not the field&#8217;s input value. Continue to scroll down until you&nbsp;see the data entered in your test submission (<b>control value<\/b> IDs). Map each field with its proper value.<\/p>\n\n\n\n<p>Click <b>Continue<\/b> and <b>Test &amp; Continue<\/b>. Toggle <b>On<\/b> the zap in the top-right corner and you&#8217;re done setting up the zap.<\/p>\n\n\n\n<p>Make another test submission and check your new sheet. Only the selected columns will be populated.<\/p>\n\n\n\n<p>Every time you receive an entry both sheets will be populated. The original one can not be deleted.<\/p>\n\n\n\n<p><b>Additional Note!<\/b> If you have an order form with payments enabled you can send the data in the last sheet only when the payment is completed.<\/p>\n\n\n\n<p>To do so, go to <b>Integrations,<\/b> and at Webhook enable the option called&nbsp;<b>Trigger Webhooks only after payment is completed<\/b>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/triggerwebhooks.png\" alt=\"webhooks google drive\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you integrate with Google Sheets all the data is imported in the form&#8217;s spreadsheet. Sometimes you need only certain information about your users. In this article, you will learn how to send specific data to Google Sheets. For this to work you will need to create a Zapier account and enable the Webhooks integration. [&hellip;]<\/p>\n","protected":false},"author":49,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[93,83],"tags":[943,944,945],"class_list":["post-36325","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-advanced","category-applications","tag-google-drive","tag-webhooks","tag-zapier"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Help: Send specific data to Google Sheets | 123FormBuilder<\/title>\n<meta name=\"description\" content=\"You can set up a connection between Google Drive Webhooks and 123FormBuilder to have a worksheet only with the fields you need.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Send specific data of your forms to Google Sheets with 123FormBuilder\" \/>\n<meta property=\"og:description\" content=\"You can set up a connection between Google Drive Webhooks and 123FormBuilder to have a worksheet only with the fields you need.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-13T12:43:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-05T10:08:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/makeazap.png\" \/>\n<meta name=\"author\" content=\"Julia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Help: Send specific data to Google Sheets | 123FormBuilder","description":"You can set up a connection between Google Drive Webhooks and 123FormBuilder to have a worksheet only with the fields you need.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/","og_locale":"en_US","og_type":"article","og_title":"Send specific data of your forms to Google Sheets with 123FormBuilder","og_description":"You can set up a connection between Google Drive Webhooks and 123FormBuilder to have a worksheet only with the fields you need.","og_url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2019-12-13T12:43:11+00:00","article_modified_time":"2025-03-05T10:08:12+00:00","og_image":[{"url":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/makeazap.png","type":"","width":"","height":""}],"author":"Julia","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julia","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#article","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/"},"author":{"name":"Julia","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843"},"headline":"Send specific data of your forms to Google Sheets with 123FormBuilder","datePublished":"2019-12-13T12:43:11+00:00","dateModified":"2025-03-05T10:08:12+00:00","mainEntityOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/"},"wordCount":536,"commentCount":0,"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#primaryimage"},"thumbnailUrl":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/makeazap.png","keywords":["google drive","webhooks","zapier"],"articleSection":["Advanced","Third Party Apps"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/","name":"Help: Send specific data to Google Sheets | 123FormBuilder","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#primaryimage"},"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#primaryimage"},"thumbnailUrl":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/makeazap.png","datePublished":"2019-12-13T12:43:11+00:00","dateModified":"2025-03-05T10:08:12+00:00","author":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843"},"description":"You can set up a connection between Google Drive Webhooks and 123FormBuilder to have a worksheet only with the fields you need.","breadcrumb":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#primaryimage","url":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/makeazap.png","contentUrl":"https:\/\/staticresources123.s3-us-west-2.amazonaws.com\/docs\/makeazap.png"},{"@type":"BreadcrumbList","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/send-specific-data-to-google-drive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/"},{"@type":"ListItem","position":2,"name":"Send specific data of your forms to Google Sheets with 123FormBuilder"}]},{"@type":"WebSite","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/","name":"123FormBuilder Knowledge Base","description":"Search our documentation platform for answers, service specifications and 3rd-party integrations.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/cc469207f9fad9e280a743a5dc96a843","name":"Julia","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b07bbd30c86170f8eb191468f69aaeab7b6cfddcd35ceaf4099ab76a5dccb06?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2FJulia%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","caption":"Julia"},"url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/author\/julia-unguras123formbuilder-com\/"}]}},"_links":{"self":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/36325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/comments?post=36325"}],"version-history":[{"count":34,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/36325\/revisions"}],"predecessor-version":[{"id":49760,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/36325\/revisions\/49760"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/media?parent=36325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/categories?post=36325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/tags?post=36325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}