{"id":3834,"date":"2020-05-04T13:44:57","date_gmt":"2020-05-04T06:44:57","guid":{"rendered":"https:\/\/www.jetorbit.com\/blog\/?p=3834"},"modified":"2022-09-09T15:07:05","modified_gmt":"2022-09-09T08:07:05","slug":"menghubungkan-contact-form-7-dengan-google-spread-sheet","status":"publish","type":"post","link":"https:\/\/www.jetorbit.com\/blog\/menghubungkan-contact-form-7-dengan-google-spread-sheet\/","title":{"rendered":"Menghubungkan Contact Form 7 dengan Google Spread Sheet"},"content":{"rendered":"<p>Pada tutorial kali ini kita akan membahas yakni cara Menghubungkan Contact Form 7 dengan Google Spread Sheet dengan mudah.<\/p>\n<p>Sebelum Itu mari kita bahas terlebih dahulu apa itu Contact Form 7 dan Google Spread Sheet ?<\/p>\n<h2>Apa Itu Contact Form 7<\/h2>\n<p><b>Contact Form 7<\/b>&nbsp;adalah salah satu plugin WordPress yang paling terkenal untuk membuat&nbsp;<b>contact form<\/b> atau Formulir kontak. Dengan <b>Contact Form 7<\/b>, Anda bisa mengkustomisasi&nbsp;<b>form<\/b> dan konten emailnya dengan Fleksibel menggunakan markup simpel. Plugin ini juga mendukung CAPTCHA dan Akismet untuk mem-filter spam .<\/p>\n<h2>Apa Itu Google Spread Sheet<\/h2>\n<p>Google Spreadsheet yakni dapat digunakan untuk mempercantik data Anda dengan bagan dan grafik berwarna-Warni. Formula terpadu, tabel pivot, dan opsi pemformatan yang dapat menghemat waktu dan menyederhanakan Tugas umum spreadsheet. Semuanya secara&nbsp; gratis dapat anda nikmati.<\/p>\n<p>Sudah sedikit mengerti bukan ? jadi kita akan menghubungkan keduanya menjadi satu, baik kita langsung saja Menuju tutorialnya<\/p>\n<h2>Prasyarat<\/h2>\n<p>Sebelum kita memulai integrasi atau menghubungkan keduanya silahkan anda terlebih dahulu menyiapkan syarat-Syarat berikut :<\/p>\n<ol>\n<li>Instal Dan mengaktifkan Plugin Contact form 7<\/li>\n<li>Dapat mengakses code google anda.<\/li>\n<li>Mepunyai akun email.<\/li>\n<li>Dapat mengakses google Spreadsheet.<\/li>\n<\/ol>\n<h2>Cara Menghubungkan Contact Form 7 dengan Google Spread Sheet<\/h2>\n<p>Setelah Syarat-syarat Diatas Sudah Anda Penuhi Kita akan langsung Menuju Tutorialnya<\/p>\n<h3>1. Install PLugin Contact Form 7<\/h3>\n<p>Untuk langkah pertama silahkan anda bisa menginstal plugin contact Form 7 terlebih dahulu langkah-langkahnya Sebagai berikut :<\/p>\n<ul>\n<li>Login pada Dashboard WordPress anda<\/li>\n<li>Kemudian tambahkan plugin baru<strong> plugin &gt; Add New<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3837 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf2.png\" alt=\"\" width=\"158\" height=\"273\"><\/a><\/p>\n<ul>\n<li>Kemudian anda tulis pada kolom pencarian &#8220;Contact Form 7 google sheet&#8221;<\/li>\n<li>Kemudian klik Install Now pada &#8220;CF7 Google Sheets Connector&#8221;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/CF3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3838 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/CF3.png\" alt=\"\" width=\"1347\" height=\"594\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/CF3.png 1347w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/CF3-300x132.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/CF3-1024x452.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/CF3-768x339.png 768w\" sizes=\"auto, (max-width: 1347px) 100vw, 1347px\" \/><\/a><\/p>\n<ul>\n<li>Kemudian Klik Activate Setelah Terinstall<\/li>\n<li>Setelah anda Activate maka akan terdapat menu &#8220;Contact&#8221; pada Menu di sebelah Kiri<\/li>\n<\/ul>\n<blockquote><p>catatan :<\/p>\n<p>sebelum menginstal &#8220;CF7 google sheet conector&#8221; anda harus menginstal plugin &#8220;contact form 7&#8221; terlebih dahulu.<\/p><\/blockquote>\n<h3>2. Membuat Google Spread Sheet<\/h3>\n<p>Setelah plugin berhasil di activate berikutnya adalah membuat contact Form caranya cukup mudah yakni :<\/p>\n<ul>\n<li>Klik&nbsp; <strong>Contact &gt; Contact Form&nbsp;<\/strong>kemudian akan terdapat 1 form silahkan langsung anda klik <strong>edit<\/strong> saja<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3839 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf4.png\" alt=\"\" width=\"1350\" height=\"315\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf4.png 1350w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf4-300x70.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf4-1024x239.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf4-768x179.png 768w\" sizes=\"auto, (max-width: 1350px) 100vw, 1350px\" \/><\/a><\/p>\n<ul>\n<li>Setelah itu silahkan anda buka terlebih dahulu <a href=\"http:\/\/Drive.google.com\" target=\"_blank\" rel=\"noopener\">Drive.google.com<\/a><\/li>\n<li>Pada bagian Kiri atas&nbsp; KLik <strong>New &gt; google Spread Sheet<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3840 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf5.png\" alt=\"\" width=\"496\" height=\"383\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf5.png 496w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf5-300x232.png 300w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/a><\/p>\n<ul>\n<li>Berikutnya beri Nama Spread Sheet anda<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3841 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf6.png\" alt=\"\" width=\"1365\" height=\"485\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf6.png 1365w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf6-300x107.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf6-1024x364.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf6-768x273.png 768w\" sizes=\"auto, (max-width: 1365px) 100vw, 1365px\" \/><\/a><\/p>\n<ul>\n<li>Kemudian masuk kembali Pada halaman Edit <strong>Contact Form &gt; google Sheet<\/strong> dan masukan nama Form tadi<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/Screenshot_5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3842 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/Screenshot_5.png\" alt=\"\" width=\"1340\" height=\"529\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/Screenshot_5.png 1340w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/Screenshot_5-300x118.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/Screenshot_5-1024x404.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/Screenshot_5-768x303.png 768w\" sizes=\"auto, (max-width: 1340px) 100vw, 1340px\" \/><\/a><\/p>\n<ul>\n<li>Berikutnya memebrikan nama <strong>google Tab Id&nbsp;<\/strong>caranya silahkan anda masuk pada halaman spread sheet di Google drive klik sheet1 dan ganti nama<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3843 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf9.png\" alt=\"\" width=\"1365\" height=\"622\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf9.png 1365w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf9-300x137.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf9-1024x467.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf9-768x350.png 768w\" sizes=\"auto, (max-width: 1365px) 100vw, 1365px\" \/><\/a><\/p>\n<ul>\n<li>Masukan juga nama Tab tadi di di halaman contact&nbsp; form<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3844 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf10.png\" alt=\"\" width=\"1325\" height=\"558\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf10.png 1325w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf10-300x126.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf10-1024x431.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf10-768x323.png 768w\" sizes=\"auto, (max-width: 1325px) 100vw, 1325px\" \/><\/a><\/p>\n<ul>\n<li>KLik save setelah selesai<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3845 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf11.png\" alt=\"\" width=\"1339\" height=\"538\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf11.png 1339w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf11-300x121.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf11-1024x411.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf11-768x309.png 768w\" sizes=\"auto, (max-width: 1339px) 100vw, 1339px\" \/><\/a><\/p>\n<h3>3. Menghubungkan Form dengan Google Access Code<\/h3>\n<p>Setelah anda selesai membuat form google spreadsheet berikutnya adalah menghubungkannya dengan google acces Code pertama silahkan anda klik <strong>google sheet<\/strong> pada menu contact.<\/p>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3847 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf12.png\" alt=\"\" width=\"1332\" height=\"521\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf12.png 1332w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf12-300x117.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf12-1024x401.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf12-768x300.png 768w\" sizes=\"auto, (max-width: 1332px) 100vw, 1332px\" \/><\/a><\/p>\n<p>Lalu bagaimana cara untuk Mendapatkan Acces code tersebut ? caranya cukup mudah berikut bisa anda simak<\/p>\n<ul>\n<li>Klik Gett code<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3848 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf13.png\" alt=\"\" width=\"1324\" height=\"357\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf13.png 1324w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf13-300x81.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf13-1024x276.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf13-768x207.png 768w\" sizes=\"auto, (max-width: 1324px) 100vw, 1324px\" \/><\/a><\/p>\n<ul>\n<li>Anda akan diarahkan menuju akun google, gunakan akun google yangsebelumnya anda gunakan untuk Membuat spread sheet di google drive<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3849 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf14.png\" alt=\"\" width=\"462\" height=\"619\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf14.png 462w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf14-224x300.png 224w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<ul>\n<li>Klik izinkan atau allow<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3850 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf15.png\" alt=\"\" width=\"414\" height=\"308\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf15.png 414w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf15-300x223.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/a><\/p>\n<ul>\n<li>Terus klik izinkan atau allow jika ada notifikasi untuk mengizinkan.<\/li>\n<li>Berikutnya maka anda akan emndapatkan kode seperti ini<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3851 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf16.png\" alt=\"\" width=\"527\" height=\"559\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf16.png 527w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf16-283x300.png 283w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/a><\/p>\n<ul>\n<li>Silahkan anda copy dan pastekan di google sheet tadi<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3852 size-full\" src=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf17.png\" alt=\"\" width=\"1324\" height=\"407\" srcset=\"https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf17.png 1324w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf17-300x92.png 300w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf17-1024x315.png 1024w, https:\/\/www.jetorbit.com\/blog\/wp-content\/uploads\/2020\/05\/cf17-768x236.png 768w\" sizes=\"auto, (max-width: 1324px) 100vw, 1324px\" \/><\/a><\/p>\n<ul>\n<li>Kemudian klik save<\/li>\n<\/ul>\n<p>Sekarang anda sudah berhasil menghubungkan google spread sheet dengan contact form anda sekarang anda dapat Memanage dan mengedit contact form sesuka anda.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada tutorial kali ini kita akan membahas yakni cara Menghubungkan Contact Form 7 dengan Google Spread Sheet dengan mudah. Sebelum Itu mari kita bahas terlebih dahulu apa itu Contact Form 7 dan Google Spread Sheet ? Apa Itu Contact Form 7 Contact Form 7&nbsp;adalah salah satu plugin WordPress yang paling terkenal untuk membuat&nbsp;contact form atau &#8230; <a title=\"Menghubungkan Contact Form 7 dengan Google Spread Sheet\" class=\"read-more\" href=\"https:\/\/www.jetorbit.com\/blog\/menghubungkan-contact-form-7-dengan-google-spread-sheet\/\" aria-label=\"Read more about Menghubungkan Contact Form 7 dengan Google Spread Sheet\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":7520,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[9],"tags":[673,283,7,674],"class_list":["post-3834","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-contact-form","tag-domain-murah","tag-hosting-murah","tag-spread-sheet","infinite-scroll-item","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"_links":{"self":[{"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/posts\/3834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/comments?post=3834"}],"version-history":[{"count":8,"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/posts\/3834\/revisions"}],"predecessor-version":[{"id":12144,"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/posts\/3834\/revisions\/12144"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/media\/7520"}],"wp:attachment":[{"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/media?parent=3834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/categories?post=3834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jetorbit.com\/blog\/wp-json\/wp\/v2\/tags?post=3834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}