{"id":16698,"date":"2024-01-31T21:02:10","date_gmt":"2024-01-31T21:02:10","guid":{"rendered":"https:\/\/kevinbk.com\/?p=16698"},"modified":"2024-01-31T21:02:13","modified_gmt":"2024-01-31T21:02:13","slug":"gpt-no-google-sheet-de-graca-com-apps-script","status":"publish","type":"post","link":"https:\/\/kevinbk.com\/ar\/gpt-\u0641\u064a-google-sheet-\u0645\u062c\u0627\u0646\u0627-\u0645\u0639-apps-script\/","title":{"rendered":"GPT \u0641\u064a Google Sheet \u0645\u062c\u0627\u0646\u0627 \u0645\u0639 Apps Script"},"content":{"rendered":"

\u0641\u064a \u0643\u062b\u064a\u0631 \u0645\u0646 \u0627\u0644\u0623\u062d\u064a\u0627\u0646 \u0639\u0646\u062f\u0645\u0627 \u0646\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u062a\u0643\u0627\u0645\u0644 \u0645\u0639 GPT \u0641\u064a Google Sheet\u060c \u0646\u062c\u062f \u0627\u0644\u0639\u062f\u064a\u062f \u0645\u0646 \u0627\u0644\u062e\u064a\u0627\u0631\u0627\u062a \u0627\u0644\u0645\u062a\u0627\u062d\u0629 \u0641\u064a \u0645\u062a\u0627\u062c\u0631 \u0627\u0644\u062a\u0643\u0644\u0641\u0629\u060c \u0648\u0644\u0643\u0646 \u0645\u0639\u0638\u0645\u0647\u0627 \u0645\u0643\u0644\u0641\u0629 \u0648\u0633\u0647\u0644\u0629. \u0645\u0639 \u0630\u0644\u0643\u060c \u0633\u0646\u0639\u0644\u0645 \u0643\u064a\u0641 \u064a\u0645\u0643\u0646\u0643 \u062a\u062b\u0628\u064a\u062a \u062a\u0637\u0628\u064a\u0642\u0627\u062a Script \u0645\u062c\u0627\u0646\u064a\u0629 \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 API GPT \u0641\u064a \u0627\u0644\u0635\u064a\u063a\u0629 \u0639\u0644\u0649 \u0648\u0631\u0642 \u0627\u0644\u062e\u0627\u0635 \u0628\u0643. <\/p>\n\n\n\n

\u0645\u0632\u0627\u064a\u0627 \u062f\u0645\u062c GPT \u0645\u0639 Google Sheets<\/strong><\/h2>\n\n\n\n

A. \u0627\u0644\u0634\u062e\u0635\u064a\u0629 \u0648\u0627\u0644\u0645\u0631\u0648\u0646\u0629<\/strong>: \u0639\u0644\u0649 \u0639\u0643\u0633 \u0627\u0644\u062a\u0648\u0633\u0639\u0627\u062a \u0627\u0644\u0642\u064a\u0627\u0633\u064a\u0629 \u060c \u062a\u062a\u064a\u062d \u0627\u0644\u062a\u0643\u0627\u0645\u0644 GPT \u0625\u0646\u0634\u0627\u0621 \u062d\u0644\u0648\u0644 \u0645\u062e\u0635\u0635\u0629 \u0644\u062a\u0644\u0628\u064a\u0629 \u0627\u062d\u062a\u064a\u0627\u062c\u0627\u062a \u0645\u062d\u062f\u062f\u0629. \u0647\u0630\u0627 \u064a\u0634\u0645\u0644 \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u060c \u0625\u0646\u0634\u0627\u0621 \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u060c \u062a\u0644\u0642\u0627\u0626\u064a\u0627\u062a \u0627\u0644\u0645\u0647\u0627\u0645 \u0627\u0644\u0645\u062a\u0643\u0631\u0631\u0629 \u060c \u0648\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0644\u063a\u0629 \u0627\u0644\u0637\u0628\u064a\u0639\u064a\u0629.<\/p>\n\n\n\n

B. \u062a\u0648\u0641\u064a\u0631 \u0627\u0644\u0648\u0642\u062a \u0648\u0627\u0644\u0641\u0639\u0627\u0644\u064a\u0629<\/strong>GPT \u064a\u0645\u0643\u0646 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u0645\u0647\u0627\u0645 \u0627\u0644\u062a\u064a \u0642\u062f \u062a\u062a\u0637\u0644\u0628 \u0648\u0642\u062a\u064b\u0627 \u0637\u0648\u064a\u0644\u0627\u064b\u060c \u0645\u062b\u0644 \u062c\u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0645\u0635\u0627\u062f\u0631 \u0645\u062e\u062a\u0644\u0641\u0629\u060c \u0648\u062a\u0635\u0648\u064a\u0631 \u062e\u0644\u0627\u0635\u0627\u062a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u062a\u0648\u0644\u064a\u062f \u0631\u0624\u0649 \u0645\u0646 \u0645\u062c\u0645\u0648\u0639\u0627\u062a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0639\u0642\u062f\u0629.<\/p>\n\n\n\n

C. \u062a\u062d\u0633\u064a\u0646 \u0645\u0633\u062a\u0645\u0631<\/strong>: \u064a\u062a\u0645 \u062a\u0637\u0648\u064a\u0631 \u0646\u0645\u0648\u0630\u062c GPT \u0628\u0627\u0633\u062a\u0645\u0631\u0627\u0631 \u060c \u0648\u062a\u0644\u0642\u0649 \u062a\u062d\u062f\u064a\u062b\u0627\u062a \u0648\u062a\u062d\u0633\u064a\u0646\u0627\u062a \u062a\u0632\u064a\u062f \u0645\u0646 \u0627\u0644\u0642\u062f\u0631\u0627\u062a \u0648\u0627\u0644\u0641\u0639\u0627\u0644\u064a\u0629.<\/p>\n\n\n

\n
\"AIKit<\/figure><\/div>\n\n\n

\u062a\u0648\u0633\u064a\u0639 x Script \u0627\u0644\u0634\u062e\u0635\u064a\u0629<\/h2>\n\n\n\n

\u063a\u0627\u0644\u0628\u064b\u0627 \u0645\u0627 \u062a\u0642\u062f\u0645 \u0627\u0644\u062a\u0648\u0633\u0639\u0627\u062a \u0627\u0644\u0645\u0632\u064a\u062f \u0645\u0646 \u0627\u0644\u062e\u064a\u0627\u0631\u0627\u062a\u060c \u0648\u062e\u062f\u0645\u0629 \u0627\u0644\u0625\u0646\u062a\u0631\u0646\u062a \u0627\u0644\u0645\u062e\u0635\u0635\u0629 \u0645\u0639 \u0648\u0627\u062c\u0647\u0629 \u0633\u0647\u0644\u0629 \u0627\u0644\u0648\u0635\u0648\u0644 \u0648\u0627\u0644\u062a\u0635\u0645\u064a\u0645. \u0627\u0644\u0645\u0634\u0643\u0644\u0629 \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u0647\u064a \u0627\u0644\u0633\u0639\u0631 \u0627\u0644\u0630\u064a \u062a\u0633\u062a\u062e\u062f\u0645\u0647 \u0644\u0625\u062c\u0631\u0627\u0621 \u0634\u064a\u0621 \u0628\u0633\u064a\u0637\u060c \u0627\u0633\u062a\u0634\u0627\u0631\u0629 GPT. <\/p>\n\n\n\n

\u0625\u0646 \u0625\u0646\u0634\u0627\u0621 \u0646\u0633\u062e\u0629 \u0645\u062e\u0635\u0635\u0629 \u0628\u0627\u0644\u0625\u0636\u0627\u0641\u0629 \u0625\u0644\u0649 \u062a\u0648\u0641\u064a\u0631 \u0627\u0644\u0645\u0627\u0644\u060c \u0633\u0648\u0641 \u062a\u0633\u0645\u062d \u0644\u0643 \u0644\u062a\u062e\u0635\u064a\u0635\u060c \u0648\u0636\u0639 \u0627\u0644\u0625\u0631\u0634\u0627\u062f\u0627\u062a \u0627\u0644\u0642\u064a\u0627\u0633\u064a\u0629\u060c \u0625\u0646\u0634\u0627\u0621 \u0635\u064a\u063a \u0645\u062e\u062a\u0644\u0641\u0629 \u062a\u0644\u0628\u064a\u0629 \u0627\u062d\u062a\u064a\u0627\u062c\u0627\u062a\u0643.<\/p>\n\n\n\n

\u0627\u0644\u0645\u0634\u0643\u0644\u0629 \u0627\u0644\u0643\u0628\u0631\u0649 \u0647\u064a \u0623\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 Apps Scripts Script \u060c \u062d\u062a\u0649 \u0645\u0639 \u0645\u0633\u0627\u0639\u062f\u0629 chatGPT \u060c \u0644\u0627 \u064a\u0632\u0627\u0644 \u0642\u062f \u064a\u0624\u062f\u064a \u0625\u0644\u0649 \u0623\u062e\u0637\u0627\u0621. <\/p>\n\n\n\n

\u0643\u064a\u0641\u064a\u0629 \u062f\u0645\u062c GPT \u0641\u064a Google Sheets<\/strong><\/h2>\n\n\n\n

\u064a\u062a\u0637\u0644\u0628 \u062f\u0645\u062c GPT \u0641\u064a Google Sheets \u0628\u0639\u0636 \u0627\u0644\u062e\u0637\u0648\u0627\u062a \u0627\u0644\u062a\u0642\u0646\u064a\u0629\u060c \u0628\u0645\u0627 \u0641\u064a \u0630\u0644\u0643:<\/p>\n\n\n\n

A. \u062a\u0635\u0645\u064a\u0645 API<\/strong>: \u0623\u0648\u0644\u0627\u064b \u060c \u064a\u062c\u0628 \u0639\u0644\u064a\u0643 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0648\u0635\u0648\u0644 \u0625\u0644\u0649 OpenAI GPT API. \u0647\u0630\u0627 \u0639\u0627\u062f\u0629 \u0645\u0627 \u064a\u062a\u0637\u0644\u0628 \u0625\u0646\u0634\u0627\u0621 \u062d\u0633\u0627\u0628 \u0648 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0645\u0641\u062a\u0627\u062d API.<\/p>\n\n\n\n

B. \u0627\u0633\u062a\u062e\u062f\u0627\u0645 Google Apps Script<\/strong>: \u064a\u0645\u0643\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 Google Apps Script \u060c \u0648\u0647\u064a \u0645\u0646\u0635\u0629 \u0627\u0644\u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0645\u0633\u062a\u0646\u062f\u0629 \u0625\u0644\u0649 \u062c\u0627\u0643\u0648\u0627\u0631\u062a \u0644\u0644\u062a\u0623\u0645\u064a\u0646 \u0641\u064a G Suite \u060c \u0644\u0625\u062f\u0645\u0627\u062c GPT \u0641\u064a Google Sheets. \u0647\u0630\u0627 \u064a\u062a\u0637\u0644\u0628 \u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u062a\u064a \u062a\u062f\u0639\u0648 \u0625\u0644\u0649 API GPT \u0648\u062a\u062d\u0648\u064a\u0644 \u0627\u0644\u0625\u062c\u0627\u0628\u0629.<\/p>\n\n\n\n

C. \u0627\u0644\u062a\u0645\u0648\u064a\u0644 \u0648\u0627\u0644\u062a\u062e\u0635\u064a\u0635<\/strong>: \u0645\u0639 \u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u0633\u064a\u0646\u0627\u0631\u064a\u0648\u060c \u064a\u0645\u0643\u0646\u0643 \u062a\u062b\u0628\u064a\u062a \u0627\u0644\u0645\u0647\u0627\u0645 \u0645\u062b\u0644 \u0625\u0646\u0634\u0627\u0621 \u0627\u0644\u0646\u0635\u060c \u0648\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u063a\u064a\u0631\u0647\u0627 \u0645\u0646 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0645\u0628\u0627\u0634\u0631\u0629 \u0641\u064a Google Sheets.<\/p>\n\n\n\n

\u0631\u0645\u0632 Apps Script \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 GPT \u0641\u064a Sheet<\/h2>\n\n\n\n

\u0623\u062f\u0646\u0627\u0647 \u0623\u0634\u0627\u0631\u0643 \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u0630\u064a \u0623\u0633\u062a\u062e\u062f\u0645\u0647 \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0635\u064a\u063a\u0629 \u0628\u0633\u064a\u0637\u0629 \u0645\u062b\u0644 GPT=(\u201cpromt\u201d;CE1)<\/em><\/strong>\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a\u0629 \u0645\u0646 Sheet \u064a\u0645\u0643\u0646\u0646\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629 \u0644\u0625\u0646\u0634\u0627\u0621 \u0627\u0644\u0645\u062d\u062a\u0648\u0649 \u0641\u064a \u062c\u062f\u0648\u0644\u0627\u062a\u064a. <\/p>\n\n\n\n

\u064a\u0645\u0643\u0646\u0643 \u0623\u064a\u0636\u064b\u0627 \u062a\u062e\u0635\u064a\u0635 \u0648\u062a\u0639\u062f\u064a\u0644 \u0627\u0644\u0643\u0648\u062f\u060c \u0648\u062a\u0635\u0646\u064a\u0639 \u0627\u0644\u0646\u0635\u0627\u0626\u062d \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629 \u0627\u0644\u062a\u064a \u062a\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0648\u0638\u0627\u0626\u0641 \u0645\u062e\u062a\u0644\u0641\u0629.\u0645\u0646 \u062e\u0644\u0627\u0644 \u0645\u0633\u0627\u0639\u062f\u0629 \u0627\u0644\u062f\u0631\u062f\u0634\u0629 GPT \u0633\u062a\u062a\u0645\u0643\u0646 \u0645\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 API OpenAI \u0641\u064a Google Sheet \u0645\u062c\u0627\u0646\u064b\u0627. <\/p>\n\n\n\n

var apiKey = 'SUACHAVEDEAPI';\n\nfunction GPT() {\n  var messages = [];\n  for (var i = 0; i < arguments.length; i++) {\n    var arg = arguments[i];\n    if (typeof arg === 'string' && arg.trim() !== '') {\n      messages.push({ 'role': 'user', 'content': arg.trim() });\n    } else if (Array.isArray(arg)) {\n      arg.forEach(function(cellValue) {\n        if (typeof cellValue === 'string' && cellValue.trim() !== '') {\n          messages.push({ 'role': 'user', 'content': cellValue.trim() });\n        }\n      });\n    }\n  }\n\n  if (messages.length === 0) {\n    return 'Nenhuma mensagem v\u00e1lida fornecida.';\n  }\n\n  var url = 'https:\/\/api.openai.com\/v1\/chat\/completions';\n  var headers = {\n    'Authorization': 'Bearer ' + apiKey,\n    'Content-Type': 'application\/json'\n  };\n\n  var payload = {\n    'model': 'gpt-3.5-turbo-1106', \/\/ Especificar o modelo desejado\n    'messages': messages,\n    'max_tokens': 700 \/\/ Configura\u00e7\u00e3o flex\u00edvel do n\u00famero m\u00e1ximo de tokens\n  };\n\n  var options = {\n    'method': 'post',\n    'headers': headers,\n    'payload': JSON.stringify(payload),\n    'muteHttpExceptions': true \/\/ Importante para tratar erros\n  };\n\n  try {\n    var response = UrlFetchApp.fetch(url, options);\n    var result = JSON.parse(response.getContentText());\n\n    if (response.getResponseCode() === 200 && result.choices && result.choices.length > 0) {\n      return result.choices[0].message.content; \/\/ Acessa o conte\u00fado da mensagem corretamente\n    } else {\n      Logger.log('Erro na resposta da API: ' + response.getContentText());\n      return 'Erro na resposta da API.';\n    }\n  } catch (e) {\n    Logger.log('Erro ao fazer a requisi\u00e7\u00e3o para a API: ' + e.message);\n    return 'Erro ao fazer a requisi\u00e7\u00e3o para a API.';\n  }\n}\n<\/code><\/pre>\n\n\n\n
\u0643\u064a\u0641\u064a\u0629 \u062a\u062b\u0628\u064a\u062a \u0627\u0644\u0643\u0648\u062f \u0641\u064a Apps Script <\/h2>\n\n\n\n
\u0645\u0646 \u0623\u062c\u0644 \u062f\u0645\u062c OpenAI GPT \u0645\u0639 Google Sheets \u060c \u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 Google Apps Script \u060c \u0627\u0644\u0630\u064a \u064a\u0633\u0645\u062d \u0644\u0643 \u0628\u062a\u0646\u0638\u064a\u0645 \u0627\u0644\u0645\u0647\u0627\u0645 \u0648\u0627\u0644\u062a\u0641\u0627\u0639\u0644 \u0645\u0639 API\u0627\u062a \u062e\u0627\u0631\u062c\u064a\u0629 \u0645\u062b\u0644 OpenAI. \u0623\u062f\u0646\u0627\u0647 \u060c \u0647\u0646\u0627\u0643 \u062a\u0639\u0644\u064a\u0645 \u062e\u0637\u0648\u0629 \u0628\u062e\u0637\u0648\u0629 \u062d\u0648\u0644 \u0643\u064a\u0641\u064a\u0629 \u062a\u062b\u0628\u064a\u062a \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u0645\u062e\u0635\u0635 \u0648\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0635\u064a\u063a\u0629 \u0645\u062e\u0635\u0635\u0629 \u0641\u064a Google Sheets \u0644\u0644\u062a\u0641\u0627\u0639\u0644 \u0645\u0639 GPT.<\/p>\n\n\n\n
\u0627\u0644\u062e\u0637\u0648\u0629 1: \u062a\u062b\u0628\u064a\u062a API OpenAI<\/h3>\n\n\n\n
    \n
  1. \u0627\u0630\u0647\u0628 \u0625\u0644\u0649 \u0645\u0648\u0642\u0639 OpenAI \u0648\u062e\u0644\u0642 \u062d\u0633\u0627\u0628 \u0623\u0648 \u062a\u0633\u062c\u064a\u0644 \u0627\u0644\u062f\u062e\u0648\u0644.<\/li>\n\n\n\n
  2. \u0642\u0645 \u0628\u0632\u064a\u0627\u0631\u0629 \u0642\u0633\u0645 \u0625\u062f\u0627\u0631\u0629 API \u0648\u062a\u062c\u0647\u064a\u0632 \u0645\u0641\u062a\u0627\u062d API \u062c\u062f\u064a\u062f. \u0627\u062d\u0641\u0638 \u0647\u0630\u0627 \u0645\u0641\u062a\u0627\u062d \u0644\u0623\u0646\u0643 \u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0630\u0644\u0643 \u0644\u0643\u064a \u062a\u062b\u0628\u064a\u062a \u0637\u0644\u0628\u0627\u062a\u0643.<\/li>\n<\/ol>\n\n\n\n
    \u0627\u0644\u062e\u0637\u0648\u0629 2: \u0641\u062a\u062d Google Apps Script Editor<\/h3>\n\n\n\n
      \n
    1. \u0627\u0641\u062a\u062d Google Sheets \u062c\u062f\u064a\u062f\u064b\u0627 \u0623\u0648 \u0645\u0648\u062c\u0648\u062f\u064b\u0627 \u062d\u064a\u062b \u062a\u0631\u064a\u062f \u0627\u0633\u062a\u062e\u062f\u0627\u0645 GPT.<\/li>\n\n\n\n
    2. \u0641\u064a \u0627\u0644\u0642\u0627\u0626\u0645\u0629\u060c \u0627\u0646\u0642\u0631 \u0641\u0648\u0642 \u0645\u0644\u062d\u0642\u0627\u062a<\/code> > \u062a\u0637\u0628\u064a\u0642\u0627\u062a Script<\/code>.<\/li>\n\n\n\n
    3. \u0647\u0630\u0627 \u0633\u064a\u0641\u062a\u062d \u0645\u062d\u0631\u0631 Google Apps Script \u0641\u064a \u0635\u0641\u062d\u0629 \u062c\u062f\u064a\u062f\u0629.<\/li>\n<\/ol>\n\n\n\n
      \u0627\u0644\u062e\u0637\u0648\u0629 3: \u062a\u062b\u0628\u064a\u062a \u0627\u0644\u0643\u0648\u062f<\/h3>\n\n\n\n
        \n
      1. \u0641\u064a \u0645\u0643\u062a\u0628 Apps Script\u060c \u0642\u0645 \u0628\u0625\u0632\u0627\u0644\u0629 \u0623\u064a \u0643\u0648\u062f \u0645\u0648\u062c\u0648\u062f.<\/li>\n\n\n\n
      2. \u0646\u0633\u062e \u0648\u0643\u0633\u0631 \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u0645\u0630\u0643\u0648\u0631 \u0641\u064a \u0627\u0644\u0645\u0624\u0644\u0641.<\/li>\n\n\n\n
      3. \u0627\u0633\u062a\u0628\u062f\u0644 'SUACHAVEDEAPI'<\/code> \u0639\u0644\u0649 \u0645\u0641\u062a\u0627\u062d API \u0627\u0644\u062d\u0642\u064a\u0642\u064a \u0627\u0644\u0630\u064a \u062d\u0635\u0644\u062a \u0639\u0644\u064a\u0647 \u0645\u0646 OpenAI.<\/li>\n\n\n\n
      4. \u062d\u0641\u0638 \u0627\u0644\u0643\u062a\u0627\u0628\u0629 \u0645\u0639 \u0627\u0633\u0645 \u0627\u0644\u0645\u0634\u0631\u0648\u0639 \u0630\u0627\u062a \u0627\u0644\u0635\u0644\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0644\u0641<\/code> > \u062d\u0641\u0638<\/code> \u0623\u0648 \u0623\u0644\u0648\u0627\u062d \u0627\u0644\u0634\u0627\u0634\u0629.<\/li>\n<\/ol>\n\n\n\n
        \u0627\u0644\u062e\u0637\u0648\u0629 4: \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0645\u062e\u0635\u0635\u0629 \u0641\u064a Google Sheets<\/h3>\n\n\n\n
          \n
        1. \u0639\u0648\u062f\u0629 \u0625\u0644\u0649 \u0635\u0641\u062d\u0629 Google Sheets.<\/li>\n\n\n\n
        2. \u0641\u064a \u0627\u0644\u062e\u0644\u064a\u0629 \u060c \u0623\u062f\u062e\u0644 =GPT(\"\u0627\u0644\u0637\u0628\u064a\u0639\u0629 \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0643 \u0647\u0646\u0627\")<\/code> \u064a\u0645\u0643\u0646\u0643 \u0623\u064a\u0636\u0627 \u0627\u0633\u062a\u0634\u0627\u0631\u0629 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0623\u062e\u0631\u0649 \u0627\u0644\u062a\u064a \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0627\u0644\u0646\u0635 \u0627\u0644\u0630\u064a \u062a\u0631\u064a\u062f \u0625\u0631\u0633\u0627\u0644\u0647.<\/li>\n\n\n\n
        3. \u0627\u0636\u063a\u0637 \u0639\u0644\u0649 Enter \u0648\u0627\u0646\u062a\u0638\u0627\u0631 \u0627\u0644\u0625\u062c\u0627\u0628\u0629. \u0642\u062f \u064a\u0633\u062a\u063a\u0631\u0642 \u0627\u0644\u0623\u0645\u0631 \u0628\u0636\u0639 \u062b\u0648\u0627\u0646\u060c \u0627\u0639\u062a\u0645\u0627\u062f\u0627 \u0639\u0644\u0649 \u0627\u0644\u0625\u062c\u0627\u0628\u0629 \u0645\u0646 API.<\/li>\n<\/ol>\n\n\n\n
          \u0627\u0644\u062a\u0641\u0643\u064a\u0631 \u0627\u0644\u0647\u0627\u0645<\/h3>\n\n\n\n
            \n
          • \u0627\u0644\u0645\u0639\u0627\u064a\u064a\u0631 \u0648\u0627\u0644\u062d\u062f\u0648\u062f<\/strong>: \u064a\u062d\u062a\u0648\u064a API OpenAI \u0639\u0644\u0649 \u062a\u0642\u0633\u064a\u0645\u0627\u062a \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062a\u064a \u064a\u0645\u0643\u0646 \u0623\u0646 \u062a\u0642\u062a\u0635\u0631 \u0639\u0644\u0649 \u0639\u062f\u062f \u0627\u0644\u0637\u0644\u0628\u0627\u062a \u0627\u0644\u062a\u064a \u064a\u0645\u0643\u0646\u0643 \u0625\u0631\u0633\u0627\u0644\u0647\u0627.<\/li>\n\n\n\n
          • \u062d\u0645\u0627\u064a\u0629 \u0645\u0641\u062a\u0627\u062d API<\/strong>: \u0627\u062d\u0627\u0641\u0638 \u0639\u0644\u0649 \u0645\u0641\u062a\u0627\u062d API \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u0622\u0645\u0646\u064b\u0627 \u0648\u0644\u0627 \u062a\u0634\u0627\u0631\u0643\u0647\u0627 \u062f\u0627\u062e\u0644 \u0627\u0644\u0643\u062a\u0627\u0628\u0629 \u0623\u0648 \u0628\u0623\u064a \u0634\u0643\u0644 \u0645\u0646 \u0627\u0644\u0623\u0634\u0643\u0627\u0644 \u0627\u0644\u062a\u064a \u0642\u062f \u062a\u0638\u0647\u0631 \u0628\u0634\u0643\u0644 \u0639\u0627\u0645.<\/li>\n\n\n\n
          • \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0623\u062e\u0637\u0627\u0621<\/strong>: \u064a\u062d\u062a\u0648\u064a \u0627\u0644\u0643\u0648\u062f \u0639\u0644\u0649 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0623\u062e\u0637\u0627\u0621 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u060c \u0648\u0644\u0643\u0646 \u0642\u062f \u062a\u0631\u063a\u0628 \u0641\u064a \u062a\u0648\u0633\u064a\u0639\u0647\u0627 \u0644\u062a\u0639\u0627\u0645\u0644 \u0623\u0641\u0636\u0644 \u0645\u0639 \u0623\u062e\u0637\u0627\u0621 \u0627\u0644\u0634\u0628\u0643\u0629 \u0623\u0648 \u0631\u062f\u0648\u062f \u0627\u0644\u0641\u0639\u0644 \u063a\u064a\u0631 \u0627\u0644\u0645\u062a\u0648\u0642\u0639\u0629 \u0645\u0646 API.<\/li>\n\n\n\n
          • \u062a\u062e\u0635\u064a\u0635<\/strong>: \u064a\u0645\u0643\u0646\u0643 \u062a\u0639\u062f\u064a\u0644 \u0627\u0644\u0646\u0645\u0627\u0630\u062c (\u0646\u0645\u0648\u0630\u062c<\/code>) \u060c \u0639\u062f\u062f \u0623\u0642\u0635\u0649 \u0645\u0646 \u0627\u0644\u062a\u0648\u062a\u0631\u0627\u062a ('max_tokens'<\/code>) \u0648\u063a\u064a\u0631\u0647\u0627 \u0645\u0646 \u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u062d\u0633\u0628 \u0627\u0644\u062d\u0627\u062c\u0629 \u0644\u0628\u0631\u0646\u0627\u0645\u062c\u0643.<\/li>\n<\/ul>\n\n\n\n
            \u0645\u0646 \u062e\u0644\u0627\u0644 \u0627\u062a\u0628\u0627\u0639 \u0647\u0630\u0647 \u0627\u0644\u062e\u0637\u0648\u0627\u062a \u060c \u0633\u062a\u062a\u0645\u0643\u0646 \u0645\u0646 \u062f\u0645\u062c OpenAI GPT \u0627\u0644\u0642\u0648\u064a \u0645\u0639 Google Sheets \u060c \u0645\u0645\u0627 \u064a\u0641\u062a\u062d \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u062a\u0646\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0641\u0631\u0635 \u0644\u0644\u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0648\u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u0625\u0646\u062a\u0627\u062c \u0645\u0646 \u0627\u0644\u0645\u062d\u062a\u0648\u0649 \u0648\u063a\u064a\u0631\u0647\u0627.<\/p>","protected":false},"excerpt":{"rendered":"
            \u0641\u064a \u0643\u062b\u064a\u0631 \u0645\u0646 \u0627\u0644\u0623\u062d\u064a\u0627\u0646 \u0639\u0646\u062f\u0645\u0627 \u0646\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u062a\u0643\u0627\u0645\u0644 \u0645\u0639 GPT \u0641\u064a Google Sheet \u060c \u0646\u062c\u062f \u0627\u0644\u0639\u062f\u064a\u062f \u0645\u0646 \u0627\u0644\u062e\u064a\u0627\u0631\u0627\u062a \u0627\u0644\u0645\u062a\u0627\u062d\u0629 \u0641\u064a \u0645\u062a\u0627\u062c\u0631 \u0627\u0644\u062a\u0643\u0644\u0641\u0629 \u060c<\/p>","protected":false},"author":1,"featured_media":16169,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/kevinbk.com\/wp-content\/uploads\/2023\/08\/ChatGPT-x-Bard-quais-as-diferencas.jpg","_links":{"self":[{"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/posts\/16698"}],"collection":[{"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/comments?post=16698"}],"version-history":[{"count":1,"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/posts\/16698\/revisions"}],"predecessor-version":[{"id":16699,"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/posts\/16698\/revisions\/16699"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/media\/16169"}],"wp:attachment":[{"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/media?parent=16698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinbk.com\/ar\/wp-json\/wp\/v2\/categories?post=16698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}