{"id":979,"date":"2023-07-24T15:01:52","date_gmt":"2023-07-24T15:01:52","guid":{"rendered":"https:\/\/patris.ai\/?p=979"},"modified":"2023-07-31T18:47:04","modified_gmt":"2023-07-31T18:47:04","slug":"skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt","status":"publish","type":"post","link":"https:\/\/patris.ai\/en\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/","title":{"rendered":"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<blockquote>\n<p>Dieser Use-Case zeigt einen schnellen Ansatz, um KI in Ihrem Keyword-Rechercheprozess zu nutzen. Der Prozess dauert etwa 5 Minuten und erm\u00f6glicht eine unendliche Anzahl von Keywords. Dies ist der erste Teil unserer SEO-Reihe, in der wir von der Keyword-Recherche \u00fcber das Keyword-Clustering bis hin zur v\u00f6llig autonomen Erstellung von Inhalten in Ihrem pers\u00f6nlichen Schreibstil gehen werden.<\/p>\n<\/blockquote>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h2>1. Neuen Patris Assistenten erstellen<\/h2>\n<p>Erstellen Sie im Dashboard unter Modules \u00fcber die <strong><em>Create new +<\/em><\/strong> Schaltfl\u00e4che einen neuen Assistenten.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/ezgif.com-video-to-gif.gif&#8220; title_text=&#8220;Modul erstellen&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;30px||||false|false&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h3>1.1 Einrichtung des Assistenten<\/h3>\n<p>Geben Sie dem Assistenten zur Wiedererkennung eine interne Bezeichnung unter <em><strong>ChatBot Name<\/strong><\/em> und <em><strong>Description<\/strong><\/em>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/Bildschirm\u00adfoto-2023-07-30-um-18.50.23.png&#8220; title_text=&#8220;Bildschirm\u00adfoto 2023-07-30 um 18.50.23&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;30px||||false|false&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h3>1.2 Prompt<\/h3>\n<p>Nun erstellen wir ein Prompt um den Assistenten in seiner Ausf\u00fchrung zu briefen. Je genauer das Briefing, desto besser die Ergebnisse.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/Bildschirm\u00adfoto-2023-07-30-um-18.51.40.png&#8220; title_text=&#8220;Bildschirm\u00adfoto 2023-07-30 um 18.51.40&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;30px||||false|false&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h3>1.4 Temperature &amp; OpenAI Model<\/h3>\n<p>Um die besten Ergebnisse zu erzielen, haben wir die Version von ChatGPT von der Standardversion 3.5 turbo auf die <strong>Version 4<\/strong> ge\u00e4ndert. Vor allem bei komplexeren Aufgaben zeigt GPT-4 deutlich bessere Ergebnisse, ist aber auch teurer in der Abfrage.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/image11.png&#8220; title_text=&#8220;image11&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Zum Schluss speichern wir den Assistenten \u00fcber den &#8222;Submit&#8220; Button und \u00f6ffnen den Assistenten \u00fcber die <em><strong>Open<\/strong>&#8211;<\/em>Schaltfl\u00e4che.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/Bildschirm\u00adfoto-2023-07-28-um-18.02.22.png&#8220; title_text=&#8220;Bildschirm\u00adfoto 2023-07-28 um 18.02.22&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Wir testen, ob der Bot die erwarteten Ergebnisse liefert. Ist dies nicht der Fall, \u00e4ndern Sie die Eingabeaufforderung, um sie an Ihre speziellen Bed\u00fcrfnisse anzupassen.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;50px||||false|false&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h2>2. Google Sheet verbinden<\/h2>\n<p>Der n\u00e4chste Schritt besteht darin, das Google Sheet zu \u00f6ffnen, in dem Sie den Keyword Research Bot verwenden m\u00f6chten.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/image4.png&#8220; title_text=&#8220;image4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p><span style=\"font-weight: 400;\">Nun gehen wir auf <em><strong>Erweiterungen<\/strong><\/em> &gt;<em><strong> Apps Script.<\/strong><\/em><\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/image2.png&#8220; title_text=&#8220;image2&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Nun f\u00fcgen wir das bereitgestellte Script ein.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/image3.png&#8220; title_text=&#8220;image3&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_dmb_code_snippet code=&#8220;ZnVuY3Rpb24gY2FsbFBhdHJpc0FJKGlkLCBtZXNzYWdlKSB7CnZhciB1cmwgPSAnaHR0cHM6Ly90ZXN0LnBhdHJpcy5haS9hcGkvdjEvY2hhdC8nICsgaWQ7CnZhciBkYXRhID0gewonbWVzc2FnZSc6IG1lc3NhZ2UsCn07CnZhciBvcHRpb25zID0gewonbWV0aG9kJyA6ICdwb3N0JywKJ2hlYWRlcnMnOiB7CidDb250ZW50LVR5cGUnOiAnYXBwbGljYXRpb24vanNvbicKfSwKJ3BheWxvYWQnIDogSlNPTi5zdHJpbmdpZnkoZGF0YSkKfTsKdHJ5IHsKdmFyIHJlc3BvbnNlID0gVXJsRmV0Y2hBcHAuZmV0Y2godXJsLCBvcHRpb25zKTsKdmFyIGpzb24gPSByZXNwb25zZS5nZXRDb250ZW50VGV4dCgpOwp2YXIgZGF0YSA9IEpTT04ucGFyc2UoanNvbik7CnJldHVybiBkYXRhLmFuc3dlci5jb250ZW50Owp9IGNhdGNoKGVycm9yKSB7CkxvZ2dlci5sb2coZXJyb3IpOwpyZXR1cm4gZXJyb3I7Cn0KfQo=&#8220; style=&#8220;atelier-cave-light&#8220; linenums=&#8220;on&#8220; copy_button=&#8220;on&#8220; copy_button_tooltip=&#8220;Kopieren&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; body_font_size=&#8220;14px&#8220; border_radii=&#8220;on|12px|12px|12px|12px&#8220; border_width_all=&#8220;2px&#8220; border_color_all=&#8220;#0536fc&#8220; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_dmb_code_snippet][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Dr\u00fccken Sie das Speicher-Icon\u00a0<img loading=\"lazy\" decoding=\"async\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAACoAAAAoCAYAAACIC2hQAAAMPmlDQ1BJQ0MgUHJvZmlsZQAASImVVwdYU8kWnluSkEBCCSAgJfQmiNQAUkJooXcEGyEJEEqMgaBiRxYVXAsqFrChqyIKVkDsiJ1FsffFgoqyLhbsypsU0HVf+d75vrn3v\/+c+c+Zc+eWAUD9OFcszkU1AMgTFUjiQgIYY1JSGaSnAAEooAAa0OLy8sWsmJgIAG3w\/Hd7dx16Q7viINP6Z\/9\/NU2+IJ8HABIDcTo\/n5cH8X4A8GqeWFIAAFHGm08pEMswbEBbAhOEeIEMZypwtQynK\/BuuU9CHBviNgBU1LhcSSYAtEuQZxTyMqEGrQ9iJxFfKAJAnQGxb17eJD7EaRDbQB8xxDJ9ZvoPOpl\/00wf0uRyM4ewYi5yUwkU5otzudP+z3L8b8vLlQ7GsIJNLUsSGiebM6zbzZxJ4TKsBnGvKD0qGmItiD8I+XJ\/iFFKljQ0UeGPGvLy2bBmQBdiJz43MBxiQ4iDRblREUo+PUMYzIEYrhB0qrCAkwCxHsQLBPlB8UqfjZJJccpYaGOGhM1S8me5EnlcWaz70pxEllL\/dZaAo9THaEVZCckQUyC2KBQmRUFMg9gxPyc+XOkzuiiLHTXoI5HGyfK3gDhOIAoJUOhjhRmS4Dilf1le\/uB8sY1ZQk6UEu8tyEoIVdQHa+Nx5fnDuWCXBCJW4qCOIH9MxOBc+ILAIMXcsWcCUWK8UueDuCAgTjEWp4hzY5T+uJkgN0TGm0Hsml8YrxyLJxXABanQxzPEBTEJijzxomxuWIwiH3wpiABsEAgYQApbOpgEsoGwo7epF14peoIBF0hAJhAAByUzOCJZ3iOCx3hQBP6ESADyh8YFyHsFoBDyX4dYxdEBZMh7C+UjcsATiPNAOMiF11L5KNFQtCTwGDLCf0TnwsaD+ebCJuv\/9\/wg+51hQSZCyUgHIzLUBz2JQcRAYigxmGiLG+C+uDceAY\/+sDnjTNxzcB7f\/QlPCJ2Eh4RrhC7CrYnCYslPWUaCLqgfrKxF+o+1wK2gphsegPtAdaiM6+IGwAF3hXFYuB+M7AZZtjJvWVUYP2n\/bQY\/3A2lH9mJjJKHkf3JNj+PpNnR3IZUZLX+sT6KXNOH6s0e6vk5PvuH6vPhOfxnT2wBtg87g53AzmGHsSbAwI5hzVg7dkSGh1bXY\/nqGowWJ88nB+oI\/xFv8M7KKpnvVOfU4\/RF0VcgmCp7RwP2JPE0iTAzq4DBgl8EAYMj4jmOYDg7ObsAIPu+KF5fb2Ll3w1Et\/07N+8PAHyODQwMHPrOhR0DYI8HfPwPfudsmPDToQrA2YM8qaRQweGyAwG+JdThk6YPjIE5sIHzcQbuwBv4gyAQBqJBAkgBE2D2WXCdS8AUMAPMBaWgHCwFK8FasAFsBtvBLrAXNIHD4AQ4DS6AS+AauANXTzd4AfrAO\/AZQRASQkXoiD5iglgi9ogzwkR8kSAkAolDUpA0JBMRIVJkBjIPKUcqkLXIJqQW2YMcRE4g55BO5BbyAOlBXiOfUAxVQ7VRI9QKHYkyURYajiag49FMdDJahJagi9HVaA26E21ET6AX0GtoF\/oC7ccAporpYqaYA8bE2Fg0loplYBJsFlaGVWI1WD3WAu\/zFawL68U+4kScjjNwB7iCQ\/FEnIdPxmfhi\/C1+Ha8EW\/Dr+AP8D78G4FKMCTYE7wIHMIYQiZhCqGUUEnYSjhAOAWfpW7COyKRqEu0JnrAZzGFmE2cTlxEXEdsIB4ndhIfEftJJJI+yZ7kQ4omcUkFpFLSGtJO0jHSZVI36YOKqoqJirNKsEqqikilWKVSZYfKUZXLKk9VPpM1yJZkL3I0mU+eRl5C3kJuIV8kd5M\/UzQp1hQfSgIlmzKXsppSTzlFuUt5o6qqaqbqqRqrKlSdo7padbfqWdUHqh\/VtNTs1Nhq49SkaovVtqkdV7ul9oZKpVpR\/amp1ALqYmot9ST1PvUDjU5zpHFofNpsWhWtkXaZ9lKdrG6pzlKfoF6kXqm+T\/2ieq8GWcNKg63B1ZilUaVxUOOGRr8mXXOUZrRmnuYizR2a5zSfaZG0rLSCtPhaJVqbtU5qPaJjdHM6m86jz6NvoZ+id2sTta21OdrZ2uXau7Q7tPt0tHRcdZJ0pupU6RzR6dLFdK10Obq5ukt09+pe1\/00zGgYa5hg2MJh9cMuD3uvN1zPX0+gV6bXoHdN75M+Qz9IP0d\/mX6T\/j0D3MDOINZgisF6g1MGvcO1h3sP5w0vG753+G1D1NDOMM5wuuFmw3bDfiNjoxAjsdEao5NGvca6xv7G2cYrjI8a95jQTXxNhCYrTI6ZPGfoMFiMXMZqRhujz9TQNNRUarrJtMP0s5m1WaJZsVmD2T1zijnTPMN8hXmreZ+FiUWkxQyLOovblmRLpmWW5SrLM5bvraytkq3mWzVZPbPWs+ZYF1nXWd+1odr42Uy2qbG5aku0Zdrm2K6zvWSH2rnZZdlV2V20R+3d7YX26+w7RxBGeI4QjagZccNBzYHlUOhQ5\/DAUdcxwrHYscnx5UiLkakjl408M\/Kbk5tTrtMWpzujtEaFjSoe1TLqtbOdM8+5yvmqC9Ul2GW2S7PLK1d7V4HretebbnS3SLf5bq1uX9093CXu9e49HhYeaR7VHjeY2swY5iLmWU+CZ4DnbM\/Dnh+93L0KvPZ6\/eXt4J3jvcP72Wjr0YLRW0Y\/8jHz4fps8unyZfim+W707fIz9eP61fg99Df35\/tv9X\/KsmVls3ayXgY4BUgCDgS8Z3uxZ7KPB2KBIYFlgR1BWkGJQWuD7gebBWcG1wX3hbiFTA85HkoIDQ9dFnqDY8ThcWo5fWEeYTPD2sLVwuPD14Y\/jLCLkES0RKKRYZHLI+9GWUaJopqiQTQnenn0vRjrmMkxh2KJsTGxVbFP4kbFzYg7E0+Pnxi\/I\/5dQkDCkoQ7iTaJ0sTWJPWkcUm1Se+TA5MrkrvGjBwzc8yFFIMUYUpzKik1KXVrav\/YoLErx3aPcxtXOu76eOvxU8efm2AwIXfCkYnqE7kT96UR0pLTdqR94UZza7j96Zz06vQ+Hpu3iveC789fwe8R+AgqBE8zfDIqMp5l+mQuz+zJ8suqzOoVsoVrha+yQ7M3ZL\/Pic7ZljOQm5zbkKeSl5Z3UKQlyhG1TTKeNHVSp9heXCrumuw1eeXkPkm4ZGs+kj8+v7lAG\/7It0ttpL9IHxT6FlYVfpiSNGXfVM2poqnt0+ymLZz2tCi46Lfp+HTe9NYZpjPmzngwkzVz0yxkVvqs1tnms0tmd88JmbN9LmVuztzfi52KK4rfzkue11JiVDKn5NEvIb\/UldJKJaU35nvP37AAXyBc0LHQZeGahd\/K+GXny53KK8u\/LOItOv\/rqF9X\/zqwOGNxxxL3JeuXEpeKll5f5rdse4VmRVHFo+WRyxtXMFaUrXi7cuLKc5WulRtWUVZJV3WtjljdvMZizdI1X9Zmrb1WFVDVUG1YvbD6\/Tr+usvr\/dfXbzDaUL7h00bhxpubQjY11ljVVG4mbi7c\/GRL0pYzvzF\/q91qsLV869dtom1d2+O2t9V61NbuMNyxpA6tk9b17By389KuwF3N9Q71mxp0G8p3g93S3c\/3pO25vjd8b+s+5r76\/Zb7qw\/QD5Q1Io3TGvuaspq6mlOaOw+GHWxt8W45cMjx0LbDpoerjugcWXKUcrTk6MCxomP9x8XHe09knnjUOrH1zskxJ6+2xbZ1nAo\/dfZ08OmTZ1hnjp31OXv4nNe5g+eZ55suuF9obHdrP\/C72+8HOtw7Gi96XGy+5HmppXN059HLfpdPXAm8cvoq5+qFa1HXOq8nXr95Y9yNrpv8m89u5d56dbvw9uc7c+4S7pbd07hXed\/wfs0ftn80dLl3HXkQ+KD9YfzDO494j148zn\/8pbvkCfVJ5VOTp7XPnJ8d7gnuufR87PPuF+IXn3tL\/9T8s\/qlzcv9f\/n\/1d43pq\/7leTVwOtFb\/TfbHvr+ra1P6b\/\/ru8d5\/fl33Q\/7D9I\/PjmU\/Jn55+nvKF9GX1V9uvLd\/Cv90dyBsYEHMlXPmvAAYbmpEBwOttAFBTAKDD\/RllrGL\/JzdEsWeVI\/CfsGKPKDd3AOrh\/3tsL\/y7uQHA7i1w+wX11ccBEEMFIMEToC4uQ21wrybfV8qMCPcBG6O+puelg39jij3nD3n\/fAYyVVfw8\/lfMip8NcP\/qQ0AAACKZVhJZk1NACoAAAAIAAQBGgAFAAAAAQAAAD4BGwAFAAAAAQAAAEYBKAADAAAAAQACAACHaQAEAAAAAQAAAE4AAAAAAAAAkAAAAAEAAACQAAAAAQADkoYABwAAABIAAAB4oAIABAAAAAEAAAAqoAMABAAAAAEAAAAoAAAAAEFTQ0lJAAAAU2NyZWVuc2hvdM7Ol04AAAAJcEhZcwAAFiUAABYlAUlSJPAAAAHUaVRYdFhNTDpjb20uYWRvYmUueG1wAAAAAAA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4OnhtcHRrPSJYTVAgQ29yZSA2LjAuMCI+CiAgIDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+CiAgICAgIDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiCiAgICAgICAgICAgIHhtbG5zOmV4aWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20vZXhpZi8xLjAvIj4KICAgICAgICAgPGV4aWY6UGl4ZWxZRGltZW5zaW9uPjQwPC9leGlmOlBpeGVsWURpbWVuc2lvbj4KICAgICAgICAgPGV4aWY6UGl4ZWxYRGltZW5zaW9uPjQyPC9leGlmOlBpeGVsWERpbWVuc2lvbj4KICAgICAgICAgPGV4aWY6VXNlckNvbW1lbnQ+U2NyZWVuc2hvdDwvZXhpZjpVc2VyQ29tbWVudD4KICAgICAgPC9yZGY6RGVzY3JpcHRpb24+CiAgIDwvcmRmOlJERj4KPC94OnhtcG1ldGE+CvR8RYQAAAAcaURPVAAAAAIAAAAAAAAAFAAAACgAAAAUAAAAFAAAAS+J0ieAAAAA+0lEQVRYCWL8DwQMQwAwjjqUyrE0GqJUDlCG0RCle4gePXaCYfuOXQzPX7xg+PePeiWZgoIcQ2lRPgMXFxdRfsIb9SBHzpm3kCiDyFFEimPxOrSmronh6bPn5LiBaD3EOhavQ5PTsuDR7ehgx6CqokS0A\/Ap3LZ9F8OTp8\/gSohxLF6HJqZkwg1LS0lgsLQwh\/MpYXz+\/IWhq6efJMeS7FBkx5Pq2PlzpsO1kOrYAXMoyMW4HFtfUwn3EIwxoA7F5VjkkB80DgU55PiJkwyz5iyAuYlh1KHwoCDAwBZSIC00CdFZc+YTcA5u6bSURKySNHEoVpsoFCTGoQAAAAD\/\/wZOaW0AAAFYSURBVGP8DwQMOEBiSiZcJi0lgcHSwhzOpybj+ImTDLPmLIAbOX\/OdDgbxmAckQ69fecuw7YduxgePHgIDggFBXkGLw83BlUVZVjAYKXpGqIgB65Zu4EBPSUxMjIyhAQHgB2M1ZVAQbo5FBSS7Z29GI6EOQzk2MryYpwhSzeHTpwyneHChUswd2GlDQz0GPJzEJkTWRHdHFpYUsHw4cNHZLsx2AIC\/Az9PR0Y4iCBUYeiB8uQifohk5lAITwkiidYUhgSBT7MseTQFOf65LQshn\/\/IG0WRwc7YIGtRI47COq5fecew\/4Dh8DqmJgYGebOmoahB2+jpKauieHps+cYmmgpIC0lydDSVIdhBV6HHj12gmHOvIUYmmgpkJIUz2BtZYFhBV6HglSDHLsd2OB4\/uIFPBlgmEKhACi6JSUkGDyBLS1sjgQZT9ChFLqBatpHHUq1oIQaBADCuBynsQ7INwAAAABJRU5ErkJggg==\" width=\"27\" height=\"26\" \/> und schlie\u00dfen Sie das Fenster. Gehen Sie zur\u00fcck zum Testchat und kopieren Sie die ID aus dem URL-Teil nach dem Modul\/. Es handelt sich um eine zuf\u00e4llige Kombination aus Zahlen und Buchstaben<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/image12.png&#8220; title_text=&#8220;image12&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Geben Sie diese Formel in eine Zelle ein: =callPatrisAI(&#8222;69ed64ca82e7eb327f163e1c437d55bb&#8220;, A2)<br \/>Ersetzen Sie die ID durch Ihre eigene ID.<\/p>\n<p>[\/et_pb_text][et_pb_dmb_code_snippet code=&#8220;PWNhbGxQYXRyaXNBSSgiSUhSRSBJRCIsIEEyKQ==&#8220; style=&#8220;atelier-cave-light&#8220; linenums=&#8220;on&#8220; copy_button=&#8220;on&#8220; copy_button_tooltip=&#8220;Kopieren&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; body_font_size=&#8220;14px&#8220; border_radii=&#8220;on|12px|12px|12px|12px&#8220; border_width_all=&#8220;2px&#8220; border_color_all=&#8220;#0536fc&#8220; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_dmb_code_snippet][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/image8.png&#8220; title_text=&#8220;image8&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;20px||20px||true|false&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Nun wenden wir die callPatrisAI Formel auf alle Zellen an.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8220;https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/image7.png&#8220; title_text=&#8220;image7&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|10px|10px|10px|10px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;30px||||false|false&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Dies gibt Ihnen einen guten Einstieg in die systematische Nutzung von ChatGPT mit Ihren Google Sheets-Daten. Dieser Ansatz kann mit jeder Eingabeaufforderung verwendet werden und Sie k\u00f6nnen die Funktion mit jeder beliebigen Eingabeaufforderung verwenden.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>","protected":false},"excerpt":{"rendered":"<p>Dieser Use-Case zeigt einen schnellen Ansatz, um KI in Ihrem Keyword-Rechercheprozess zu nutzen. Der Prozess dauert etwa 5 Minuten und erm\u00f6glicht eine unendliche Anzahl von Keywords. Dies ist der erste Teil unserer SEO-Reihe, in der wir von der Keyword-Recherche \u00fcber das Keyword-Clustering bis hin zur v\u00f6llig autonomen Erstellung von Inhalten in Ihrem pers\u00f6nlichen Schreibstil gehen [&hellip;]<\/p>","protected":false},"author":1,"featured_media":980,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false,"footnotes":""},"categories":[19,20],"tags":[],"dipi_cpt_category":[],"class_list":["post-979","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets","category-seo"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.12 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT - patris<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/patris.ai\/en\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT - patris\" \/>\n<meta property=\"og:description\" content=\"Dieser Use-Case zeigt einen schnellen Ansatz, um KI in Ihrem Keyword-Rechercheprozess zu nutzen. Der Prozess dauert etwa 5 Minuten und erm\u00f6glicht eine unendliche Anzahl von Keywords. Dies ist der erste Teil unserer SEO-Reihe, in der wir von der Keyword-Recherche \u00fcber das Keyword-Clustering bis hin zur v\u00f6llig autonomen Erstellung von Inhalten in Ihrem pers\u00f6nlichen Schreibstil gehen [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/patris.ai\/en\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/\" \/>\n<meta property=\"og:site_name\" content=\"patris\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T15:01:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-31T18:47:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/keyword.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"patrisadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"patrisadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/\",\"url\":\"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/\",\"name\":\"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT - patris\",\"isPartOf\":{\"@id\":\"https:\/\/patris.ai\/#website\"},\"datePublished\":\"2023-07-24T15:01:52+00:00\",\"dateModified\":\"2023-07-31T18:47:04+00:00\",\"author\":{\"@id\":\"https:\/\/patris.ai\/#\/schema\/person\/935c3e0824e7d20aaeda8d2067367bdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/patris.ai\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/patris.ai\/#website\",\"url\":\"https:\/\/patris.ai\/\",\"name\":\"patris\",\"description\":\"Einfache KI L\u00f6sung f\u00fcr den Mittelstand\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/patris.ai\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/patris.ai\/#\/schema\/person\/935c3e0824e7d20aaeda8d2067367bdb\",\"name\":\"patrisadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/patris.ai\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b9bfe077f0b85aa7e9312b80d645ef69e4a72040c389d0211eb846749c86341?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b9bfe077f0b85aa7e9312b80d645ef69e4a72040c389d0211eb846749c86341?s=96&d=mm&r=g\",\"caption\":\"patrisadmin\"},\"sameAs\":[\"https:\/\/patris.ai\"],\"url\":\"https:\/\/patris.ai\/en\/blog\/author\/patrisadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT - patris","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:\/\/patris.ai\/en\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/","og_locale":"en_US","og_type":"article","og_title":"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT - patris","og_description":"Dieser Use-Case zeigt einen schnellen Ansatz, um KI in Ihrem Keyword-Rechercheprozess zu nutzen. Der Prozess dauert etwa 5 Minuten und erm\u00f6glicht eine unendliche Anzahl von Keywords. Dies ist der erste Teil unserer SEO-Reihe, in der wir von der Keyword-Recherche \u00fcber das Keyword-Clustering bis hin zur v\u00f6llig autonomen Erstellung von Inhalten in Ihrem pers\u00f6nlichen Schreibstil gehen [&hellip;]","og_url":"https:\/\/patris.ai\/en\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/","og_site_name":"patris","article_published_time":"2023-07-24T15:01:52+00:00","article_modified_time":"2023-07-31T18:47:04+00:00","og_image":[{"width":1000,"height":800,"url":"https:\/\/patris.ai\/wp-content\/uploads\/2023\/07\/keyword.png","type":"image\/png"}],"author":"patrisadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"patrisadmin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/","url":"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/","name":"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT - patris","isPartOf":{"@id":"https:\/\/patris.ai\/#website"},"datePublished":"2023-07-24T15:01:52+00:00","dateModified":"2023-07-31T18:47:04+00:00","author":{"@id":"https:\/\/patris.ai\/#\/schema\/person\/935c3e0824e7d20aaeda8d2067367bdb"},"breadcrumb":{"@id":"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/patris.ai\/blog\/skalierte-seo-keyword-recherche-mit-google-sheets-und-chatgpt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/patris.ai\/"},{"@type":"ListItem","position":2,"name":"Skalierte SEO-Keyword-Recherche mit Google Sheets und ChatGPT"}]},{"@type":"WebSite","@id":"https:\/\/patris.ai\/#website","url":"https:\/\/patris.ai\/","name":"patris","description":"Einfache KI L\u00f6sung f\u00fcr den Mittelstand","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/patris.ai\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/patris.ai\/#\/schema\/person\/935c3e0824e7d20aaeda8d2067367bdb","name":"patrisadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/patris.ai\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b9bfe077f0b85aa7e9312b80d645ef69e4a72040c389d0211eb846749c86341?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b9bfe077f0b85aa7e9312b80d645ef69e4a72040c389d0211eb846749c86341?s=96&d=mm&r=g","caption":"patrisadmin"},"sameAs":["https:\/\/patris.ai"],"url":"https:\/\/patris.ai\/en\/blog\/author\/patrisadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/posts\/979","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/comments?post=979"}],"version-history":[{"count":24,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/posts\/979\/revisions"}],"predecessor-version":[{"id":1034,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/posts\/979\/revisions\/1034"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/media\/980"}],"wp:attachment":[{"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/media?parent=979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/categories?post=979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/tags?post=979"},{"taxonomy":"dipi_cpt_category","embeddable":true,"href":"https:\/\/patris.ai\/en\/wp-json\/wp\/v2\/dipi_cpt_category?post=979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}