{"id":20904,"date":"2021-04-26T15:38:19","date_gmt":"2021-04-26T08:38:19","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=20904"},"modified":"2021-10-01T12:34:59","modified_gmt":"2021-10-01T05:34:59","slug":"google-sheets-wordpress","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/google-sheets-wordpress\/","title":{"rendered":"Cara Mengintegrasikan Google Sheets pada WordPress"},"content":{"rendered":"\n<p>Pada panduan ini, kami akan berbagi cara mengintegrasikan Google sheets pada WordPress. Berikut informasi selengkapnya. <\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Mengintegrasikan Google Sheets pada WordPress<\/h2>\n\n\n\n<p>Google Sheets adalah software berbasis web yang dikembangkan oleh Google untuk melakukan pengolahan data, membuat tabel dan melakukan perhitungan sederhana. Dalam artikel ini kita akan membahas cara mengintegrasikan Google Sheets WordPress dengan plugin Contact Form 7.<\/p>\n\n\n\n<p>Untuk mengintegrasikan Google Sheets WordPress, kita membutuhkan plugin tambahan seperti Contact Form 7 dan Google sheets connector. Berikut langkah-langkah integrasinya.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Langkah 1. Install plugin CF7 Google Sheets Connector<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Login admin WordPress<\/li><li>Masuk ke menu Plugin &gt; Add New &gt; kemudian cari Contact Form 7<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"277\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-1024x277.png\" alt=\"Langkah 1. Install plugin CF7 Google Sheets Connector - image 1\" class=\"wp-image-24535\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-1024x277.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-300x81.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-768x208.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-370x100.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-270x73.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-570x154.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50-740x200.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-50.png 1252w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Lalu install plugin CF7 Google sheets connector dengan cara yang sama&nbsp;<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"364\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-1024x364.png\" alt=\"Langkah 1. Install plugin CF7 Google Sheets Connector - image 2\" class=\"wp-image-24536\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-1024x364.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-300x107.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-768x273.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-370x131.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-270x96.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-570x203.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51-740x263.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-51.png 1227w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>Install dan aktifkan kedua plugin tersebut<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Langkah 2. Mendapatkan access code spreadsheet<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Masuk ke plugin Google sheets<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-52.png\"><img loading=\"lazy\" decoding=\"async\" width=\"670\" height=\"362\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-52.png\" alt=\"Langkah 2. Mendapatkan access code spreadsheet image 1\" class=\"wp-image-24537\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-52.png 670w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-52-300x162.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-52-370x200.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-52-270x146.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-52-570x308.png 570w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li>Kemudian akan muncul tampilan untuk memilih akun gmail, silahkan dipilih akun gmail nya<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-53.png\"><img loading=\"lazy\" decoding=\"async\" width=\"503\" height=\"316\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-53.png\" alt=\"Langkah 2. Mendapatkan access code spreadsheet image 2\" class=\"wp-image-24538\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-53.png 503w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-53-300x188.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-53-370x232.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-53-270x170.png 270w\" sizes=\"auto, (max-width: 503px) 100vw, 503px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Kemudian plugin akan meminta permissions, bisa di allow semua<\/li><li>Lalu akan muncul code access nya, kemudian copy code tersebut<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-54.png\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"261\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-54.png\" alt=\"Langkah 2. Mendapatkan access code spreadsheet image 3\" class=\"wp-image-24539\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-54.png 610w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-54-300x128.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-54-370x158.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-54-270x116.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-54-570x244.png 570w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li>Dan paste di kolom berikut, dan klik save<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55.png\"><img loading=\"lazy\" decoding=\"async\" width=\"749\" height=\"322\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55.png\" alt=\"Langkah 2. Mendapatkan access code spreadsheet image 4\" class=\"wp-image-24540\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55.png 749w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55-300x129.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55-370x159.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55-270x116.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55-570x245.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-55-740x318.png 740w\" sizes=\"auto, (max-width: 749px) 100vw, 749px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Langkah 3. Membuat file spreadsheet&nbsp;<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Buka google drive akun yang dipilih sebelumnya<\/li><li>Buat new file dengan Google sheets<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56.png\"><img loading=\"lazy\" decoding=\"async\" width=\"806\" height=\"424\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56.png\" alt=\"Langkah 3. Membuat file spred image 1\" class=\"wp-image-24541\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56.png 806w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56-300x158.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56-768x404.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56-370x195.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56-270x142.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56-570x300.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-56-740x389.png 740w\" sizes=\"auto, (max-width: 806px) 100vw, 806px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Pastikan nama file tidak ada karakter unik<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-57.png\"><img loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"196\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-57.png\" alt=\"Langkah 3. Membuat file spred image 2\" class=\"wp-image-24542\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-57.png 697w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-57-300x84.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-57-370x104.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-57-270x76.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-57-570x160.png 570w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>Buat field pada kolom sesuai dengan data yang diinginkan, pastikan nama field juga tidak ada karakter unik lainnya.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58.png\"><img loading=\"lazy\" decoding=\"async\" width=\"817\" height=\"232\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58.png\" alt=\"Langkah 3. Membuat file spred image 3\" class=\"wp-image-24543\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58.png 817w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58-300x85.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58-768x218.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58-370x105.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58-270x77.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58-570x162.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-58-740x210.png 740w\" sizes=\"auto, (max-width: 817px) 100vw, 817px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li>Kemudian bagian nama tab, bisa direname atau dibiarkan default<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59.png\"><img loading=\"lazy\" decoding=\"async\" width=\"855\" height=\"616\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59.png\" alt=\"Langkah 3. Membuat file spred image 4\" class=\"wp-image-24544\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59.png 855w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59-300x216.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59-768x553.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59-370x267.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59-270x195.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59-570x411.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-59-740x533.png 740w\" sizes=\"auto, (max-width: 855px) 100vw, 855px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Langkah 4. Setting pada sisi Contact Form 7<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Silahkan login admin WordPress<\/li><li>Masuk ke menu contact lalu buat form baru&nbsp;<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60.png\"><img loading=\"lazy\" decoding=\"async\" width=\"854\" height=\"564\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60.png\" alt=\"Langkah 4. Setting pada sisi Contact Form 7 image 1\" class=\"wp-image-24545\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60.png 854w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60-300x198.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60-768x507.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60-370x244.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60-270x178.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60-570x376.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-60-740x489.png 740w\" sizes=\"auto, (max-width: 854px) 100vw, 854px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Setelah membuat form baru, silahkan klik edit dan sesuaikan nama field dengan yang ada pada file spreadsheet yang telah dibuat sebelumnya.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-61.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"381\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-61.png\" alt=\"Langkah 4. Setting pada sisi Contact Form 7 image 2\" class=\"wp-image-24546\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-61.png 624w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-61-300x183.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-61-370x226.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-61-270x165.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-61-570x348.png 570w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>Jika ingin melakukan edit terhadap respon yang ditampilkan ketika pengunjung website sudah mengirim data melalui form. Bisa dilakukan melalui Contact &gt; Edit (form) &gt; Messages &gt; Edit sesuai dengan respon yang di inginkan.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62.png\"><img loading=\"lazy\" decoding=\"async\" width=\"921\" height=\"398\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62.png\" alt=\"Langkah 4. Setting pada sisi Contact Form 7 image 3\" class=\"wp-image-24547\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62.png 921w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62-300x130.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62-768x332.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62-370x160.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62-270x117.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62-570x246.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-62-740x320.png 740w\" sizes=\"auto, (max-width: 921px) 100vw, 921px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li>Kemudian masuk ke menu Google Sheets, lalu setting dengan menyesuaikan pada file spreadsheet yang telah dibuat.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-63.png\"><img loading=\"lazy\" decoding=\"async\" width=\"706\" height=\"348\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-63.png\" alt=\"Langkah 4. Setting pada sisi Contact Form 7 image 4\" class=\"wp-image-24548\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-63.png 706w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-63-300x148.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-63-370x182.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-63-270x133.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-63-570x281.png 570w\" sizes=\"auto, (max-width: 706px) 100vw, 706px\" \/><\/a><\/figure>\n\n\n\n<p>Note :&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Google Sheet Name : Isikan dengan nama file spreadsheet<\/li><li>Google Sheet Id : Masukan id di url nya&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"261\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-1024x261.png\" alt=\"Langkah 4. Setting pada sisi Contact Form 7 image 5\" class=\"wp-image-24549\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-1024x261.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-300x76.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-768x196.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-370x94.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-270x69.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-570x145.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64-740x188.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-64.png 1041w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Google sheet Tab Name : Isikan dengan nama tab pada file spreadsheet<\/li><li>Google Tab Id : Isikan dengan tab id pada file<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65.png\"><img loading=\"lazy\" decoding=\"async\" width=\"906\" height=\"200\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65.png\" alt=\"Langkah 4. Setting pada sisi Contact Form 7 image 6\" class=\"wp-image-24550\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65.png 906w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65-300x66.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65-768x170.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65-370x82.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65-270x60.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65-570x126.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-65-740x163.png 740w\" sizes=\"auto, (max-width: 906px) 100vw, 906px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Langkah 5. Halaman Form<\/strong><\/h3>\n\n\n\n<p>Langkah selanjutnya membuat halaman yang akan digunakan untuk form yang telah dibuat.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Buka halaman menu contact lalu copy kan script form sesuai dengan telah dibuat sebelumnya.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"355\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-1024x355.png\" alt=\"Langkah 5. Halaman Form image 1\" class=\"wp-image-24551\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-1024x355.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-300x104.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-768x266.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-370x128.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-270x94.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-570x198.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66-740x256.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-66.png 1235w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li>Masuk ke halaman edit yang akan kita gunakan untuk halaman form pada pengunjung website<\/li><li>Kemudian paste script kode yang sebelumnya di copy ke halaman tersebut. Maka akan muncul tampilan seperti dibawah ini.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"560\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-1024x560.png\" alt=\"Langkah 5. Halaman Form image 2\" class=\"wp-image-24552\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-1024x560.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-300x164.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-768x420.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-370x202.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-270x148.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-570x312.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67-740x405.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-67.png 1033w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>Selanjutnya, silahkan coba akses halaman form nya dan coba input data, dan klik Daftar<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68.png\"><img loading=\"lazy\" decoding=\"async\" width=\"980\" height=\"658\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68.png\" alt=\"Langkah 5. Halaman Form image 3\" class=\"wp-image-24553\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68.png 980w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68-300x201.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68-768x516.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68-370x248.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68-270x181.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68-570x383.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-68-740x497.png 740w\" sizes=\"auto, (max-width: 980px) 100vw, 980px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li>Maka akan muncul respon bahwa data berhasil dikirim.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"946\" height=\"335\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1.png\" alt=\"Langkah 5. Halaman Form image 4\" class=\"wp-image-24647\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1.png 946w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1-300x106.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1-768x272.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1-370x131.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1-270x96.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1-570x202.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/image-1-740x262.png 740w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\"><li>Terakhir, periksa data pada file spreadsheet. Jika berhasil maka data akan masuk ke file tersebut. Seperti tampilan berikut<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69.png\"><img loading=\"lazy\" decoding=\"async\" width=\"761\" height=\"264\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69.png\" alt=\"Cara Mengintegrasikan Google Sheets pada WordPress result\" class=\"wp-image-24554\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69.png 761w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69-300x104.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69-370x128.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69-270x94.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69-570x198.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/09\/image-69-740x257.png 740w\" sizes=\"auto, (max-width: 761px) 100vw, 761px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\"><li>Selesai<\/li><\/ol>\n\n\n\n<p>Demikian cara mengintegrasikan Google Sheets pada WordPress, terima kasih.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada panduan ini, kami akan berbagi cara mengintegrasikan Google sheets pada WordPress. Berikut informasi selengkapnya. Mengintegrasikan Google Sheets pada WordPress Google Sheets adalah software berbasis web yang dikembangkan oleh Google untuk melakukan pengolahan data, membuat tabel dan melakukan perhitungan sederhana. Dalam artikel ini kita akan membahas cara mengintegrasikan Google Sheets WordPress dengan plugin Contact Form [&hellip;]<\/p>\n","protected":false},"author":340,"featured_media":20978,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[463],"tags":[1584,14],"class_list":{"0":"post-20904","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"tag-google-sheets","9":"tag-wordpress"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/04\/banner-blog-Apa-itu-HTTP2-dan-Bagaimana-Cara-Kerjanya-2-1.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-5ra","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/20904","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/340"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=20904"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/20904\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/20978"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=20904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=20904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=20904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}