{"id":1941,"date":"2023-01-23T14:28:45","date_gmt":"2023-01-23T13:28:45","guid":{"rendered":"https:\/\/webmasterei-prange.de\/tutorial-chatgpt-with-google-spreadsheets-for-product-texts\/"},"modified":"2025-10-06T12:28:23","modified_gmt":"2025-10-06T10:28:23","slug":"tutorial-chatgpt-with-google-spreadsheets-for-product-texts","status":"publish","type":"post","link":"https:\/\/webmasterei-prange.de\/en\/tutorial-chatgpt-with-google-spreadsheets-for-product-texts\/","title":{"rendered":"Tutorial: ChatGPT with Google Spreadsheets for product texts"},"content":{"rendered":"\n<p>Use ChatGPT to create automated text quickly and easily. With Google Spreadsheets you can use it to generate product texts, meta titles and meta descriptions based on product data, but also for data from WebCrawlers and other analysis tools. Use the template in the article to quickly and easily create product texts based on your product feed.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"toc_Wie_funktioniert_chatGPT_fur_Google_Spreadsheets\">How does chatGPT for Google Spreadsheets work?<\/h2>\n\n<p>The formula<\/p>\n\n<pre class=\"wp-block-preformatted\">CHATGPT(prompt, max_tokens, temperature, api_key)<\/pre>\n\n<p>generates texts based on product data that are available in tabular form in Google Spreadsheets. The prompt can be linked with text operators.<\/p>\n\n<p>The parameters (are entered on the \u201cSetup\u201d worksheet):<br\/> \u2022 <strong>prompt<\/strong> : The command line, formulated in natural language.<br\/> \u2022 <strong>max_tokens<\/strong> : How many tokens can be used by the API. In English, approximately four tokens are used per word.<br\/> \u2022 <g id=\"gid_2\">temperature<\/g> : The number of iterations used in text generation. The fewer iterations, the more &#8220;simple&#8221; the text becomes.<br\/> \u2022 <strong>api_key<\/strong> : API key from openAI  <\/p>\n\n<p>In the example of the table, the relevant product data brand, product type, size, color and target group exist. These are transformed in cell G to a &#8220;prompt&#8221;, i.e. a command to ChatGPT. Cell H then generates the response using the ChatGPT formula. The application goals are shown here using product data as an example, but it is also conceivable with data from WebCrawlers and other analysis tools.<\/p>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"275\" src=\"https:\/\/webmasterei-prange.de\/wp-content\/uploads\/2025\/09\/chatgpt-formel-1200x322.png-1024x275.webp\" alt=\"Chatgpt formula 1200x322.png\" class=\"wp-image-1246\"\/><\/figure>\n\n<h2 class=\"wp-block-heading\">Work quickly with ChatGPT &amp; Google Spreadsheets? Here is the template to copy.<\/h2>\n<style>.wp-block-kadence-advancedbtn.kb-btns1245_292386-86{gap:var(--global-kb-gap-xs, 0.5rem );justify-content:center;align-items:center;}.kt-btns1245_292386-86 .kt-button{font-weight:normal;font-style:normal;}.kt-btns1245_292386-86 .kt-btn-wrap-0{margin-right:5px;}.wp-block-kadence-advancedbtn.kt-btns1245_292386-86 .kt-btn-wrap-0 .kt-button{color:#555555;border-color:#555555;}.wp-block-kadence-advancedbtn.kt-btns1245_292386-86 .kt-btn-wrap-0 .kt-button:hover, .wp-block-kadence-advancedbtn.kt-btns1245_292386-86 .kt-btn-wrap-0 .kt-button:focus{color:#ffffff;border-color:#444444;}.wp-block-kadence-advancedbtn.kt-btns1245_292386-86 .kt-btn-wrap-0 .kt-button::before{display:none;}.wp-block-kadence-advancedbtn.kt-btns1245_292386-86 .kt-btn-wrap-0 .kt-button:hover, .wp-block-kadence-advancedbtn.kt-btns1245_292386-86 .kt-btn-wrap-0 .kt-button:focus{background:#444444;}<\/style>\n<div class=\"wp-block-kadence-advancedbtn kb-buttons-wrap kb-btns1245_292386-86\"><style>ul.menu .wp-block-kadence-advancedbtn .kb-btn1245_3200f4-fd.kb-button{width:initial;}<\/style><a class=\"kb-button kt-button button kb-btn1245_3200f4-fd kt-btn-size-standard kt-btn-width-type-auto kb-btn-global-fill  kt-btn-has-text-true kt-btn-has-svg-false  wp-block-kadence-singlebtn\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Wi-UI37dfiME63TLGvjgL4SR09xAPuO96TOf40CFnfY\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"kt-btn-inner-text\">ChatGPT Template with Google Spreadsheets<\/span><\/a><\/div>\n\n<h2 class=\"wp-block-heading has--font-size\">For nerds: The formula for use in Google Apps Scripts<\/h2>\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"js\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/**\n  * Returns a text Choice from Chat GPT.\n  *\n  * @param  {string}  instruction of what to do.\n  * @param  {url}  url for what page.\n  * @param  {max_tokens}  max_tokens how many API tokens to use max.\n  * @param  {temperature}  temperature set the temperature.\n  * @return Returns a text Choice from Chat GPT\n  * @customfunction\n  *\/\nfunction CHATGPT(prompt,max_tokens,temperature,apikey) {\n  \/\/ add your apiKey from OpenAi here. Found at: https:\/\/beta.openai.com\/account\/api-keys \n  \/\/ increase temperature for more randomness, and variations of the output. Max tokens set at 240 characters (could be lower). \n  \/\/ using Keyword: as a stop sequence so that it only generates one result.\n\n  const parameters = {\n  'prompt': prompt,\n  'max_tokens': max_tokens,\n  'temperature': temperature,\n  'stop': '[\"Keyword:\"]',\n  'model':'text-davinci-003'\n  };\n  Logger.log(parameters)\n  const options = {\n  'method': 'post',\n  'contentType': 'application\/json',\n  'payload': JSON.stringify(parameters),\n  'headers': {\n  Authorization: 'Bearer ' + apikey,\n  },\n  };\n\n  \/\/ fetch from GPT-3 - Engines can be changed. eg.  https:\/\/api.openai.com\/v1\/engines\/curie\/completions\n  \/\/ worth exploring each individual Engine in more detail here:https:\/\/beta.openai.com\/docs\/engines\n\n  const response = UrlFetchApp.fetch('https:\/\/api.openai.com\/v1\/completions', options,);\n  Logger.log(response)\n    \n  var responseText = JSON.parse(response.getContentText())['choices'][0]['text']\n  responseText = responseText.replace(\"$.*\\n\",\"\").replace(\"$\\n\",\"\")\n  Logger.log(responseText)\n  return responseText;\n}<\/pre>\n\n<p><a href=\"https:\/\/gist.github.com\/Webmasterei\/6019ac9fb4dab2231c82d8d09cab2036#file-chatgpt_google_spreadsheets-js\">chatgpt_google_spreadsheets.js<\/a> hosted with \u2764 by <a href=\"https:\/\/github.com\/\">GitHub<\/a><\/p>\n\n<p>With ChatGPT you can automate text quickly and easily. We have shown you how to use it using Google Spreadsheets as an example. For example, you can use it to generate product texts, meta titles and meta descriptions based on product data. But you can also use it for data from WebCrawlers and other analytics tools.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use ChatGPT to create automated text quickly and easily. With Google Spreadsheets you can use it to generate product texts, meta titles and meta descriptions based on product data, but also for data from WebCrawlers and other analysis tools. Use the template in the article to quickly and easily create&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","slim_seo":{"title":"ChatGPT + Google Spreadsheets: Automatically generate product texts","description":"How to use ChatGPT in a spreadsheet: Generate product texts, meta titles & descriptions directly from your product feed \u2013 with template & Apps Script instructions."},"footnotes":""},"categories":[31],"tags":[],"class_list":["post-1941","post","type-post","status-publish","format-standard","hentry","category-google-shopping"],"taxonomy_info":{"category":[{"value":31,"label":"Google Shopping"}]},"featured_image_src_large":false,"author_info":{"display_name":"admin","author_link":"https:\/\/webmasterei-prange.de\/en\/author\/admin\/"},"comment_info":0,"category_info":[{"term_id":31,"name":"Google Shopping","slug":"google-shopping","term_group":0,"term_taxonomy_id":31,"taxonomy":"category","description":"","parent":0,"count":7,"filter":"raw","cat_ID":31,"category_count":7,"category_description":"","cat_name":"Google Shopping","category_nicename":"google-shopping","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts\/1941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/comments?post=1941"}],"version-history":[{"count":1,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts\/1941\/revisions"}],"predecessor-version":[{"id":1943,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts\/1941\/revisions\/1943"}],"wp:attachment":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/media?parent=1941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/categories?post=1941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/tags?post=1941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}