Totally Free! New Update: Now featuring compatibility with GPT-4o mini, o1-preview and o1-mini! With Easy GPT for Sheets™, integrate the power of ChatGPT from OpenAI directly into Google Sheets™. Our add-on opens up a new world of possibilities for task automation, data analysis, and content generation, all from the comfort of your spreadsheets. Easy GPT for Sheets™ is offered at no cost for installation and use, allowing you to fully leverage the power of artificial intelligence directly in Google Sheets™. The only thing you need to activate this powerful integration is an OpenAI API key. It's important to note that, although our add-on is free, using the OpenAI API is subject to its own fees and might incur additional costs. Supported Models: - GPT-3.5 Turbo: Ideal for quick and efficient responses in your Google Sheets™ spreadsheets. - GPT-4: Provides enhanced capabilities and deeper understanding for high-quality text generation in GPT for Sheets™. - GPT-4o: Our latest integration, providing even more precise and context-aware responses, ideal for complex queries and in-depth analysis. - GPT-4o mini: Harness advanced intelligence at a lower cost, ideal for high-volume and cost-sensitive tasks like extensive summarizations in your spreadsheets. - o1-preview: Features powerful reasoning capabilities and broader world knowledge, making it ideal for solving more complex tasks in your spreadsheets. - o1-mini: A faster and more lightweight model, designed to tackle coding tasks efficiently while maintaining a competitive performance level. - DALL·E 2 and DALL·E 3: Specialized in generating high-quality images from textual descriptions. Use these models to visually interpret prompts and add creative content directly into your spreadsheets. - Other cutting-edge models from OpenAI are also available in Easy GPT for Sheets™, giving you the flexibility to choose the best for your task. Expanded Functions of Easy GPT for Sheets™: - GPT(prompt): Use any question or prompt to generate text, code, or analysis based on advanced GPT models. - GPT_SUMMARIZE(text, length): Condenses large blocks of text into concise summaries, retaining key points. - GPT_TRANSLATE(text, language): Translates texts between multiple languages, relying on context for accuracy. - GPT_CLASSIFY(text, options): Identifies and classifies text into defined categories, ideal for sentiment analysis and more. - GPT_EXPAND(text): Turns brief instructions or ideas into full textual developments, perfect for drafting or outlining. - GPT_ASK(text, question): Formulates specific questions based on the provided text to get detailed and contextualized answers. - GPT_COMPARE(text1, text2): Performs a comparative analysis between two text segments, highlighting similarities, differences, and points of interest. - GPT_TRENDS(text): Examines a dataset or text to identify emerging trends, patterns, and predominant themes. - GPT_REPHRASE(text): Enhances the text by restructuring it to increase its clarity, impact, or suitability to a particular style. - GPT_TAGS(text, options, number of tags): Generates descriptive tags to organize and categorize text, facilitating its analysis and retrieval. - GPT_TABLE(prompt): Creates structured tables from your instructions, filling cells with AI-generated data for analysis or reports. - GPT_VLIST(prompt): Develops vertical lists based on your prompts, ideal for tasks, steps to follow, or idea listings. - GPT_EDIT(text, type of edition): Modifies the text according to a specified type of editing, such as corrections, tone adjustments, or stylistic adaptations. - GPT_IMAGE(description, [model], [size], [quality]): This function generates a URL of an image based on a textual description. Specify the model (like DALL·E 2 or DALL·E 3), image size, and quality to customize the output. - IMAGE(GPT_IMAGE(...)): Utilizes the URL returned by GPT_IMAGE to directly embed the generated image into a spreadsheet cell. This function seamlessly integrates visual content into your sheets, enhancing the presentation and utility of your data. Syntax: =IMAGE(GPT_IMAGE("description", "model", "size", "quality")). This is perfect for visual data representation and adds a dynamic element to your spreadsheets. - GPT_ANALYZE_IMAGE(image_url, question, [model], [temperature]): Analyzes an image from a given URL and answers specific questions about its content. Modify the analysis depth by selecting different models and adjusting the temperature setting for varied response characteristics. New Chatbot Feature: The integrated chatbot offers real-time assistance directly within your Google Sheets™, answering questions and helping with data analysis and spreadsheet content inquiries. With Easy GPT for Sheets™, take your spreadsheets to the forefront of artificial intelligence technology. From dynamic content creation to in-depth data analysis, transform your workflows intuitively and effectively. Start today and explore a world of possibilities with just your OpenAI API key.