{"id":6057,"date":"2017-10-31T17:06:40","date_gmt":"2017-10-31T16:06:40","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=6057"},"modified":"2017-10-31T17:06:40","modified_gmt":"2017-10-31T16:06:40","slug":"comment-creer-un-formulaire-et-transmettre-les-soumissions-a-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/how-to-create-a-form-and-forward-submissions-to-google-sheets\/","title":{"rendered":"Comment cr\u00e9er un formulaire et transmettre les soumissions \u00e0 Google Sheets ?"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Google Sheets<\/a>\u00a0<\/span>has become more versatile because of the capability to tightly integrate with the Google Apps ecosystem. A few years ago, conducting surveys was a daunting challenge. Thanks to the current cloud-based Google suite of applications, everything has just become a breeze. In this article, we demonstrate how to create a form and forward submissions to Google Sheets.<\/p>\n

Create a form<\/h3>\n

Open up\u00a0<\/span>Google Forms home page<\/a>. We have a provision to create a new form from a blank template. Alternatively, we can also use a template from the template gallery.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/create-a-form-and-forward-submissions-to-google-sheets-1.png” alt=”create a form and forward submissions to google sheets 1″ title_text=”create a form and forward submissions to google sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

For this example, we will use the blank template. And, simply create a customer satisfaction survey form to understand the pulse of customers who visited a small restaurant.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/create-a-form-and-forward-submissions-to-google-sheets-2.png” alt=”create a form and forward submissions to google sheets 2″ title_text=”create a form and forward submissions to google sheets 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Once done with the form, we are ready to send this form to the customers.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ custom_padding=”||0px|||” global_colors_info=”{}” theme_builder_area=”post_content”]

Configure submissions<\/h3>\n

But before that, we need to configure the form such that the responses are captured in a Google Sheets destination file. Click on the\u00a0<\/span>RESPONSES<\/strong>\u00a0<\/span>tab, and then on the menu options (three vertical dots<\/strong>), and then choose\u00a0<\/span>Select response destination<\/strong>.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/create-a-form-and-forward-submissions-to-google-sheets-3.png” alt=”create a form and forward submissions to google sheets 3″ title_text=”create a form and forward submissions to google sheets 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

We can either create a new spreadsheet to capture the responses or use an existing one. Let\u2019s try creating a new file, so we choose the first option and then click\u00a0<\/span>CREATE<\/strong>.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/create-a-form-and-forward-submissions-to-google-sheets-4.png” alt=”create a form and forward submissions to google sheets 4″ title_text=”create a form and forward submissions to google sheets 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

On performing the previous step, the Google Forms application creates a new spreadsheet and links the form to that sheet. In the future, if we want to unlink the form with the spreadsheet, we click on the\u00a0<\/span>RESPONSES<\/strong>\u00a0menu options (three vertical dots) and choose\u00a0<\/span>Unlink form<\/strong>. Now that the above configuration is done, we will click on the\u00a0<\/span>SEND<\/strong>\u00a0button. We get a pop up that offers various options (email, link or embed) that we may use to send the form. Here, we will opt to send via the email, key in the email addresses and click\u00a0<\/span>SEND<\/strong>\u00a0button at the bottom.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/create-a-form-and-forward-submissions-to-google-sheets-5.png” alt=”create a form and forward submissions to google sheets 5″ title_text=”create a form and forward submissions to google sheets 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Once the users start filling out the forms, the spreadsheet that we linked to this form automatically stores the users\u2019 responses.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/create-a-form-and-forward-submissions-to-google-sheets-6-1.png” alt=”create a form and forward submissions to google sheets 6″ title_text=”create a form and forward submissions to google sheets 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Congratulations! We successfully learned how to\u00a0<\/span>create a form and forward submissions to Google Sheets! These responses are automatically recorded onto the Google Sheets destination file. Of course, unless the users stop responding or we unlink the file from the form.\u00a0<\/span><\/p>\n

Learn in the following blog post\u00a0<\/span>how Google Forms can help you manage your inventory process<\/a>.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

Google Sheets\u00a0has become more versatile because of the capability to tightly integrate with the Google Apps ecosystem. A few years ago, conducting surveys was a daunting challenge. Thanks to the current cloud-based Google suite of applications, everything has just become a breeze. In this article, we demonstrate how to create a form and forward submissions […]<\/p>\n","protected":false},"author":40,"featured_media":37656,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The Google Sheets has become more versatile because of the capability to tightly integrate with the Google Apps ecosystem. A few years ago, conducting surveys was a daunting challenge. Thanks to the current cloud-based Google suite of applications, everything has just become a breeze. In this article, we demonstrate how to create a form and forward submissions to Google Sheets.\n

Create a form<\/h3>\nOpen up Google Forms home page. We have a provision to create a new form from a blank template. Alternatively, we can also use a template from the template gallery.\n\n\"Create\n\nFor this example, we will use the blank template. And, simply create a customer satisfaction survey form to understand the pulse of customers who visited a small restaurant.\n\n\"Create\n\nOnce done with the form, we are ready to send this form to the customers.\n

Configure submissions<\/h3>\nBut before that, we need to configure the form such that the responses are captured in a Google Sheets destination file. Click on the RESPONSES<\/strong> tab, and then on the menu options (three vertical dots<\/strong>), and then choose Select response destination<\/strong>.\n\n\"Create\n\nWe can either create a new spreadsheet to capture the responses or use an existing one. Let's try creating a new file, so we choose the first option and then click CREATE<\/strong>.\n\n\"Create\n\nOn performing the previous step, the Google Forms application creates a new spreadsheet and links the form to that sheet. In the future, if we want to unlink the form with the spreadsheet, we click on the RESPONSES<\/strong> menu options (three vertical dots) and choose Unlink form<\/strong>. Now that the above configuration is done, we will click on the SEND<\/strong> button. We get a pop up that offers various options (email, link or embed) that we may use to send the form. Here, we will opt to send via the email, key in the email addresses and click SEND<\/strong> button at the bottom.\n\n\"Create\n\nOnce the users start filling out the forms, the spreadsheet that we linked to this form automatically stores the users' responses.\n\n\"Create\n\nCongratulations! We successfully learn how to create a form and forward submissions to Google Sheets! These responses are automatically recorded onto the Google Sheets destination file. Of course, unless the users stop responding or we unlink the file from the form. ","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-6057","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/6057","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=6057"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/6057\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/37656"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=6057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=6057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=6057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}