You don't have access to this class

Keep learning! Join and start boosting your career

Aprovecha el precio especial y haz tu profesión a prueba de IA

Antes: $249

Currency
$209
Suscríbete

Termina en:

0 Días
12 Hrs
47 Min
15 Seg

¿Cómo crear listas con GPT?

15/18
Resources

How to integrate predefined characteristics and conditionals into spreadsheets?

Imagine being able to generate customized lists based on specific characteristics and conditionals, using the ease of a spreadsheet. This is a powerful technique that will allow you to get precise results tailored to your needs. Let's explore how to do this using an example with GPT list and you will see how elements already learned in this course come together.

What are the key elements for setting up the instructions?

To start, you need to set up a clear structure in your spreadsheet. Here are some recommendations:

  • Column A: Describe the type of results you are looking for.
  • Column B: Detail the instruction or conditional that will guide the result.

At the bottom of your sheet keep examples of instructions for reference or future inspiration.

How to run the GPT list formula?

Column G of your spreadsheet is where the GPT list formula is executed. Instead of inserting instructions directly, it uses cells with preset characteristics. For example, to create a specific listing, include data such as:

  • Company type: it can be a corporation or any business structure of interest.
  • Role: You can act as an artificial intelligence expert, movie narrator, business consultant, etc.
  • Country: Mexico, Colombia, Chile, among others.
  • Company activity: Area or sector of expertise.
  • Currency: Useful for lists related to finance.

How to customize the result?

By changing the cells and the instruction in B2, you can achieve specific customizations in your listing. Let's see a practical example:

  1. Instruction: "Create a list of 5 skills needed for an artificial intelligence project".
  2. Added configuration: Add to the preset characteristics the business activity, country and currency.

In this way, the listing you obtain will consider these parameters, amplifying the accuracy of the generated content.

What are examples of custom instructions?

Different industries require different approaches. Here are some applications:

  • Financial sector: Define a bank chart of accounts structure based on the company and its context.
  • Metrics analysis: Find key metrics to analyze the financial health of a company, adapting parameters such as country and company type.

Recommendations for maximizing the use of the GPT list

Do not underestimate the importance of saving your instructions. This will allow you to reuse and refine them over time. Always consider the context of your work, whether in finance, marketing, publishing, etc., to define the most relevant variables.

Now it is your turn to explore this versatile tool. Use the material provided in the course resources as a basis and experiment with adjusting features and categories to discover the potential of this methodology. Keep learning and expanding your skills to make the most of the available technology solutions!

Contributions 11

Questions 3

Sort by:

Want to see more contributions, questions and answers from the community?

todo ese prompt con esa estructura se puede poner en la pagina de openai no entiendo cual es la diferencia de usarlo de esa manera en google sheets
Es posible utilizar celdas como instrucción y características preestablecidas para obtener resultados más precisos.
También los puedes hacer con Gemini
Excelente herramienta, el único problema es el numero de tokens limitado en el plan gratuito.
Se puede utilizar celdas como instrucción y caracterisiticas preestablecidad para dar un resultado más preciso.
Magia pura. Te amo Platzi.
Esta clase es super útil. Porque no hay mas comentarios desde hace un año?
![](https://static.platzi.com/media/user_upload/image-33697694-89d7-4de8-97bc-b53188a6e4fd.jpg)
En SheetGPT no funciona
Este es un curso sobre Google Sheets ¿Con sería más lógico guardar las hojas en Google? cada ejercicio debo descargarlo de Office365, subirlo a Google Sheets y cambiarle el formato, no tiene sentido
ALGUIEN ROTE ALGUNOS PROMPTS PARA ECOMMERCE Y MARKETING PORFA