{"id":3933,"date":"2023-04-23T15:42:41","date_gmt":"2023-04-23T19:42:41","guid":{"rendered":"https:\/\/leadnectar.net\/?p=3933"},"modified":"2023-04-24T22:34:54","modified_gmt":"2023-04-25T02:34:54","slug":"integrate-google-sheets-with-chat-gpt-to-generate-crm-contact-bios","status":"publish","type":"post","link":"https:\/\/leadnectar.net\/es\/integrate-google-sheets-with-chat-gpt-to-generate-crm-contact-bios\/","title":{"rendered":"Integre Google Sheets con Chat GPT para generar biograf\u00edas de contactos de CRM"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"3933\" class=\"elementor elementor-3933\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1c6d100 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c6d100\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ca37e69\" data-id=\"ca37e69\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e8f635f elementor-widget elementor-widget-text-editor\" data-id=\"e8f635f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"background-color: var( --e-global-color-b500f0a ); color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight );\">En esta publicaci\u00f3n de blog, le mostrar\u00e9 c\u00f3mo generar biograf\u00edas breves para sus contactos de CRM utilizando Google Sheets y el modelo de lenguaje GPT-3.5 Turbo.\u00a0<\/span><\/p><p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var( --e-global-color-b500f0a );\">Cre\u00e9 una secuencia de comandos que le permite pegar datos de CRM en una hoja de Google y mi secuencia de comandos podr\u00e1 leer los encabezados de las columnas y los datos correspondientes para cada contacto.\u00a0<\/span><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var( --e-global-color-b500f0a );\">\u00a1No importa cu\u00e1ntas columnas de datos tenga o el orden en que se encuentren las columnas!<\/span><\/p><p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var( --e-global-color-b500f0a );\">Siga las instrucciones para implementar esto en su propia hoja de Google.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f742286 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f742286\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f263bfe\" data-id=\"f263bfe\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6363565 elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"6363565\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;button_width&quot;:&quot;100&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"New Form\" action=\"\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"3933\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"6363565\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"Integrate Google Sheets with Chat GPT to Generate CRM Contact Bios - Lead Nectar\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"3933\"\/>\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-above\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Correo electr\u00f3nico\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-sm\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Suscribir<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<input type=\"hidden\" name=\"trp-form-language\" value=\"es\"\/><\/form>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c88b649 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c88b649\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-faa3b1a\" data-id=\"faa3b1a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52e9ad0 elementor-widget elementor-widget-heading\" data-id=\"52e9ad0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Paso 1: crea una nueva hoja de Google<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-59dde18 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"59dde18\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cadb1d8\" data-id=\"cadb1d8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7c22ac7 elementor-widget elementor-widget-text-editor\" data-id=\"7c22ac7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Vaya a https:\/\/docs.google.com\/spreadsheets, cree una hoja en blanco y as\u00edgnele un nombre.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2348b91 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2348b91\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7300e30\" data-id=\"7300e30\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c2848e elementor-widget elementor-widget-image\" data-id=\"1c2848e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"146\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/new-blank-sheet_-1024x187.png\" class=\"attachment-large size-large wp-image-3936\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/new-blank-sheet_-1024x187.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/new-blank-sheet_-300x55.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/new-blank-sheet_-768x140.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/new-blank-sheet_-1536x281.png 1536w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/new-blank-sheet_-2048x374.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-736d5f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"736d5f4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-87380f6\" data-id=\"87380f6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bd60596 elementor-widget elementor-widget-text-editor\" data-id=\"bd60596\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var( --e-global-color-b500f0a );\">Agregue la etiqueta Bios a la celda A1 y pegue sus datos de CRM en la celda B1, incluidos los encabezados. No se preocupe si los encabezados de sus columnas son diferentes a los m\u00edos: el script puede manejarlo.\u00a0<\/span><\/p><p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var( --e-global-color-b500f0a );\">Este script est\u00e1 destinado a manejar numerosos puntos de datos para cada contacto. Si s\u00f3lo proporcionas el nombre y el correo electr\u00f3nico, no esperes biograf\u00edas estelares.<\/span><\/p><p>La columna A ser\u00e1 donde generaremos la BIOS con el script, as\u00ed que la dejaremos en blanco por ahora.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-71f4258 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"71f4258\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-028b4d9\" data-id=\"028b4d9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7ef03ff elementor-widget elementor-widget-text-editor\" data-id=\"7ef03ff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Puedes usar los datos simulados que us\u00e9 para mi demostraci\u00f3n con <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/17juoxY74E3FLomqz6pBkFXQMCQ4boqNB8DrpqCaVG7Y\/edit?usp=sharing\">este enlace<\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85c0554 elementor-widget elementor-widget-image\" data-id=\"85c0554\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"255\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/crm-data-1024x326.png\" class=\"attachment-large size-large wp-image-3951\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/crm-data-1024x326.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/crm-data-300x96.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/crm-data-768x245.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/crm-data-1536x490.png 1536w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/crm-data-2048x653.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1338727 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1338727\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9f2fa6f\" data-id=\"9f2fa6f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b7b8879 elementor-widget elementor-widget-heading\" data-id=\"b7b8879\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Paso 2: abra el editor de secuencias de comandos<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1027b6e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1027b6e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-659458b\" data-id=\"659458b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-aba6070 elementor-widget elementor-widget-text-editor\" data-id=\"aba6070\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Vaya a &quot;Extensiones&quot; en la barra de men\u00fa superior y seleccione &quot;Apps Script&quot;.<\/p><div>\u00a0<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0784632 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0784632\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f70d3de\" data-id=\"f70d3de\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66c3256 elementor-widget elementor-widget-image\" data-id=\"66c3256\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"254\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/app-script-1024x325.png\" class=\"attachment-large size-large wp-image-3945\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/app-script-1024x325.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/app-script-300x95.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/app-script-768x243.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/app-script-1536x487.png 1536w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/app-script-2048x649.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6534936 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6534936\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4fbdd33\" data-id=\"4fbdd33\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7a48942 elementor-widget elementor-widget-text-editor\" data-id=\"7a48942\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Esto abre el Editor de secuencias de comandos a un proyecto sin t\u00edtulo con una funci\u00f3n en blanco en su interior.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8cc15ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8cc15ea\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f089340\" data-id=\"f089340\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5308de7 elementor-widget elementor-widget-image\" data-id=\"5308de7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"121\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/blank-script-editor-1024x155.png\" class=\"attachment-large size-large wp-image-3946\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/blank-script-editor-1024x155.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/blank-script-editor-300x45.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/blank-script-editor-768x116.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/blank-script-editor-1536x232.png 1536w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/blank-script-editor-2048x309.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e77d961 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e77d961\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3db5e6c\" data-id=\"3db5e6c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-72e54dd elementor-widget elementor-widget-text-editor\" data-id=\"72e54dd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Cambie el nombre de su proyecto y elimine la funci\u00f3n en blanco<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-38cfa64 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"38cfa64\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5d2791e\" data-id=\"5d2791e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2b9ccbc elementor-widget elementor-widget-image\" data-id=\"2b9ccbc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"127\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-generator_demo-app-1024x163.png\" class=\"attachment-large size-large wp-image-3942\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-generator_demo-app-1024x163.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-generator_demo-app-300x48.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-generator_demo-app-768x122.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-generator_demo-app-1536x244.png 1536w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-generator_demo-app-2048x326.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7ce1e11 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7ce1e11\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4f080e8\" data-id=\"4f080e8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1d721f0 elementor-widget elementor-widget-heading\" data-id=\"1d721f0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Paso 3: pegue mi script<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2f3cae1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f3cae1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4454007\" data-id=\"4454007\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ce2561 elementor-widget elementor-widget-text-editor\" data-id=\"1ce2561\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Copie el siguiente script y p\u00e9guelo en el editor. Aseg\u00farate de reemplazar <code>TU_API_KEY<\/code> con su propia clave API GPT-3.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b1b24e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b1b24e6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-16b2e95\" data-id=\"16b2e95\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4e714e5 elementor-widget elementor-widget-html\" data-id=\"4e714e5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"om-wk4rqcr4mhdczof18ofj-holder\"><\/div>\n<pre><code>\nfunction generateBioForRow() { \/\/ Accede a la hoja de c\u00e1lculo activa y a la hoja constante de celda activa = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const activeCell = SpreadsheetApp.getActiveRange(); const n\u00famero de fila = activeCell.getRow(); \/\/ Obtener los encabezados (nombres de las columnas) y el n\u00famero de columnas const headers =sheet.getRange(1, 1, 1,sheet.getLastColumn()).getValues()[0]; const numColumns = encabezados.longitud; \/\/ Construya el mensaje GPT-3 din\u00e1micamente usando todos los encabezados y valores de las columnas let request = &quot;Le proporcionar\u00e9 datos de CRM sobre una persona. Quiero que escriba una breve biograf\u00eda sobre ellos usando estos datos. Incluya solo informaci\u00f3n que sea a partir de los datos (no inventes nada). Mant\u00e9n tu respuesta por debajo de 70 tokens.:\\n&quot;; for (let col = 0; col &lt; numColumns; col++) { encabezado constante = encabezados[col]; valor constante = hoja.getRange(rowNum, col + 1).getValue(); mensaje += `${encabezado}: ${valor}\\n`; } \/\/ Definir la clave API, el modelo y otros par\u00e1metros para la llamada API GPT-3 const API_KEY = &quot;YOUR_API_KEY&quot;; modelo constante = &quot;gpt-3.5-turbo&quot;; temperatura constante = 0,2; \/\/ Establecer un valor m\u00e1s bajo para respuestas m\u00e1s deterministas const maxTokens = 100; \/\/ Establece max_tokens un poco m\u00e1s alto de lo que dijiste en tu mensaje para darle un poco de espacio \/\/ Configura el cuerpo de la solicitud con los par\u00e1metros dados const requestBody = { &quot;model&quot;: model, &quot;messages&quot;: [ { &quot;role&quot; : &quot;system&quot;, &quot;content&quot;: &quot;Eres un asistente \u00fatil&quot;. }, { &quot;rol&quot;: &quot;usuario&quot;, &quot;contenido&quot;: mensaje }, ], &quot;temperatura&quot;: temperatura, &quot;max_tokens&quot;: maxTokens }; \/\/ Configure las opciones de solicitud con los encabezados requeridos const requestOptions = { &quot;method&quot;: &quot;POST&quot;, &quot;headers&quot;: { &quot;Content-Type&quot;: &quot;application\/json&quot;, &quot;Authorization&quot;: &quot;Bearer &quot; + API_KEY } , &quot;carga \u00fatil&quot;: JSON.stringify(requestBody) }; \/\/ Enviar la solicitud al punto final de la API GPT-3 para su finalizaci\u00f3n const respuesta = UrlFetchApp.fetch(&quot;https:\/\/api.openai.com\/v1\/chat\/completions&quot;, requestOptions); \/\/ Obtener el cuerpo de la respuesta como un objeto JSON const ResponseBody = JSON.parse(response.getContentText()); \/\/ Extrae el texto generado de la respuesta const bio = ResponseBody.choices[0][&quot;message&quot;][&quot;content&quot;]; \/\/ Devuelve la biograf\u00eda generada return bio; }\n<\/code><\/pre>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-613cd89 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"613cd89\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-70b417f\" data-id=\"70b417f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2c208ec elementor-widget elementor-widget-code-highlight\" data-id=\"2c208ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\tfunction generateBioForRow() { \/\/ Accede a la hoja de c\u00e1lculo activa y a la hoja constante de celda activa = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const activeCell = SpreadsheetApp.getActiveRange(); const n\u00famero de fila = activeCell.getRow(); \/\/ Obtener los encabezados (nombres de las columnas) y el n\u00famero de columnas const headers =sheet.getRange(1, 1, 1,sheet.getLastColumn()).getValues()[0]; const numColumns = encabezados.longitud; \/\/ Construya el mensaje GPT-3 din\u00e1micamente usando todos los encabezados y valores de las columnas let request = &quot;Le proporcionar\u00e9 datos de CRM sobre una persona. Quiero que escriba una breve biograf\u00eda sobre ellos usando estos datos. Incluya solo informaci\u00f3n que sea a partir de los datos (no inventes nada). Mant\u00e9n tu respuesta por debajo de 70 tokens.:\\n&quot;; for (let col = 0; col &lt; numColumns; col++) { encabezado constante = encabezados[col]; valor constante = hoja.getRange(rowNum, col + 1).getValue(); mensaje += `${encabezado}: ${valor}\\n`; } \/\/ Definir la clave API, el modelo y otros par\u00e1metros para la llamada API GPT-3 const API_KEY = &quot;YOUR_API_KEY&quot;; modelo constante = &quot;gpt-3.5-turbo&quot;; temperatura constante = 0,2; \/\/ Establecer un valor m\u00e1s bajo para respuestas m\u00e1s deterministas const maxTokens = 100; \/\/ Establece max_tokens un poco m\u00e1s alto de lo que dijiste en tu mensaje para darle un poco de espacio \/\/ Configura el cuerpo de la solicitud con los par\u00e1metros dados const requestBody = { &quot;model&quot;: model, &quot;messages&quot;: [ { &quot;role&quot; : &quot;system&quot;, &quot;content&quot;: &quot;Eres un asistente \u00fatil&quot;. }, { &quot;rol&quot;: &quot;usuario&quot;, &quot;contenido&quot;: mensaje }, ], &quot;temperatura&quot;: temperatura, &quot;max_tokens&quot;: maxTokens }; \/\/ Configure las opciones de solicitud con los encabezados requeridos const requestOptions = { &quot;method&quot;: &quot;POST&quot;, &quot;headers&quot;: { &quot;Content-Type&quot;: &quot;application\/json&quot;, &quot;Authorization&quot;: &quot;Bearer &quot; + API_KEY } , &quot;carga \u00fatil&quot;: JSON.stringify(requestBody) }; \/\/ Enviar la solicitud al punto final de la API GPT-3 para su finalizaci\u00f3n const respuesta = UrlFetchApp.fetch(&quot;https:\/\/api.openai.com\/v1\/chat\/completions&quot;, requestOptions); \/\/ Obtener el cuerpo de la respuesta como un objeto JSON const ResponseBody = JSON.parse(response.getContentText()); \/\/ Extrae el texto generado de la respuesta const bio = ResponseBody.choices[0][&quot;message&quot;][&quot;content&quot;]; \/\/ Devuelve la biograf\u00eda generada return bio; }\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4653d8f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4653d8f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5f9f075\" data-id=\"5f9f075\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b059a46 elementor-widget elementor-widget-heading\" data-id=\"b059a46\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Paso 4: guarde y ejecute el script<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-65de411 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65de411\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-db447bb\" data-id=\"db447bb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7b3e67b elementor-widget elementor-widget-text-editor\" data-id=\"7b3e67b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Guarde el script haciendo clic en &quot;Guardar proyecto&quot; en el Editor de scripts.<\/p><p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bc77028 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bc77028\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dbb7a24\" data-id=\"dbb7a24\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-08e4656 elementor-widget elementor-widget-image\" data-id=\"08e4656\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"152\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/save-the-project-1-1024x195.png\" class=\"attachment-large size-large wp-image-3944\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/save-the-project-1-1024x195.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/save-the-project-1-300x57.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/save-the-project-1-768x146.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/save-the-project-1-1536x293.png 1536w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/save-the-project-1-2048x391.png 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d78dd47 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d78dd47\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cf1d2c\" data-id=\"7cf1d2c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b2c6853 elementor-widget elementor-widget-text-editor\" data-id=\"b2c6853\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ahora regresa a tu hoja de Google.\u00a0<\/p><p>Haga clic en la celda A2 y ejecute esta funci\u00f3n: =generateBioForRow().\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0c017f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0c017f8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ffed3f8\" data-id=\"ffed3f8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-26e7522 elementor-widget elementor-widget-image\" data-id=\"26e7522\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"310\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/generateBioForRow-1024x397.png\" class=\"attachment-large size-large wp-image-3947\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/generateBioForRow-1024x397.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/generateBioForRow-300x116.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/generateBioForRow-768x298.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/generateBioForRow.png 1510w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-035ebfe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"035ebfe\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f7a66d7\" data-id=\"f7a66d7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-efa0c86 elementor-widget elementor-widget-text-editor\" data-id=\"efa0c86\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>El script generar\u00e1 una breve biograf\u00eda basada en los datos de CRM en la fila seleccionada y devolver\u00e1 el texto de la biograf\u00eda.<\/p><p>Recomiendo ajustar el texto para que puedas ver la biograf\u00eda en el celular. Para hacer eso, haga clic en el bot\u00f3n del men\u00fa de ajuste de texto &gt;&gt; y luego haga clic en el icono de ajuste, como se ve en la imagen a continuaci\u00f3n.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cf71bf3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cf71bf3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0d41ba5\" data-id=\"0d41ba5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-76eac2f elementor-widget elementor-widget-image\" data-id=\"76eac2f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"180\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/wrap-text-1024x231.png\" class=\"attachment-large size-large wp-image-3948\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/wrap-text-1024x231.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/wrap-text-300x68.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/wrap-text-768x173.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/wrap-text.png 1250w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-08cec63 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"08cec63\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0b0bd9f\" data-id=\"0b0bd9f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-406577d elementor-widget elementor-widget-text-editor\" data-id=\"406577d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Aqu\u00ed est\u00e1 la biograf\u00eda envuelta:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bdcc09b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bdcc09b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a890f9a\" data-id=\"a890f9a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d7f195f elementor-widget elementor-widget-image\" data-id=\"d7f195f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"391\" src=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-result-1-1024x501.png\" class=\"attachment-large size-large wp-image-3950\" alt=\"\" srcset=\"https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-result-1-1024x501.png 1024w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-result-1-300x147.png 300w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-result-1-768x376.png 768w, https:\/\/leadnectar.net\/wp-content\/uploads\/2023\/04\/bio-result-1.png 1378w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a7f6ba elementor-widget elementor-widget-text-editor\" data-id=\"6a7f6ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>(estos son datos falsos\/de demostraci\u00f3n)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-54734b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"54734b2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7c0d1df\" data-id=\"7c0d1df\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4e48904 elementor-widget elementor-widget-text-editor\" data-id=\"4e48904\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Puede copiar y pegar la f\u00f3rmula generateBioForRow() en todas sus filas para generar biograf\u00edas para todos los contactos. Obviamente, tenga en cuenta los l\u00edmites de datos de Open AI.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0ff5c12 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ff5c12\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-443f324\" data-id=\"443f324\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-764c451 elementor-widget elementor-widget-heading\" data-id=\"764c451\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Paso 5: explora y experimenta<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-caa7542 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"caa7542\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7d9488e\" data-id=\"7d9488e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4ad1908 elementor-widget elementor-widget-text-editor\" data-id=\"4ad1908\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Intente ejecutar el script con diferentes datos de CRM para ver c\u00f3mo var\u00edan las biograf\u00edas generadas.\u00a0<span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var( --e-global-color-b500f0a );\">Si\u00e9ntase libre de personalizar el script y experimentar con diferentes par\u00e1metros de GPT-3.\u00a0<\/span><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var( --e-global-color-b500f0a );\">Practique la integraci\u00f3n con Zapier o publique su propia aplicaci\u00f3n web utilizando Google Sheets.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-412a974 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"412a974\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-82d3110\" data-id=\"82d3110\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-54a68a2 elementor-widget elementor-widget-heading\" data-id=\"54a68a2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Conclusi\u00f3n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5dda42d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5dda42d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9e89611\" data-id=\"9e89611\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-18f5981 elementor-widget elementor-widget-text-editor\" data-id=\"18f5981\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ahora sabe c\u00f3mo generar biograf\u00edas breves para sus contactos de CRM utilizando Google Sheets y GPT-3. Ya sea que est\u00e9 administrando un equipo de ventas, manteniendo una base de datos de clientes o ejecutando una campa\u00f1a de marketing, este script es valioso para generar contenido personalizado y atractivo. Disfr\u00fatelo y no olvide suscribirse a continuaci\u00f3n para recibir contenido l\u00edder en la industria antes de su publicaci\u00f3n.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cfaddcc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cfaddcc\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d22b09a\" data-id=\"d22b09a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-83f989b elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"83f989b\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;button_width&quot;:&quot;100&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"New Form\" action=\"\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"3933\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"83f989b\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"Integrate Google Sheets with Chat GPT to Generate CRM Contact Bios - Lead Nectar\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"3933\"\/>\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-above\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Correo electr\u00f3nico\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-sm\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Suscribir<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<input type=\"hidden\" name=\"trp-form-language\" value=\"es\"\/><\/form>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>\u00a1Hice un script en Google Sheets que puede leer los encabezados de las columnas y los datos de las filas, y responder preguntas basadas en esos datos! <\/p>","protected":false},"author":849,"featured_media":3962,"comment_status":"open","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"content-type":"","_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[21,1,13],"tags":[36,17,37,33,16],"class_list":["post-3933","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai","category-business-development","category-crm","tag-ai","tag-crm","tag-gpt","tag-integrations","tag-pipedrive"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/posts\/3933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/users\/849"}],"replies":[{"embeddable":true,"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/comments?post=3933"}],"version-history":[{"count":126,"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/posts\/3933\/revisions"}],"predecessor-version":[{"id":4099,"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/posts\/3933\/revisions\/4099"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/media\/3962"}],"wp:attachment":[{"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/media?parent=3933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/categories?post=3933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leadnectar.net\/es\/wp-json\/wp\/v2\/tags?post=3933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}