1. Introduction to GPTs

What is a GPT?

GPTs are customized versions of ChatGPT that users can configure for specific tasks by combining instructions, knowledge, and capabilities. These AI models can assist in various fields, from language learning to technical support, providing highly specialized assistance.

Who Can Create a GPT?

Currently, only paid users (Plus, Team, and Enterprise) can create a GPT. This feature is powered by GPT-4o and is accessible at:
➡️ https://chatgpt.com/gpts/editor

2. How to Create a GPT

Follow these steps to build your own GPT.

Step 1: Access the GPT Editor

1. Go to https://chatgpt.com/gpts/editor.
2. Click on "Create a GPT".

3. You will enter the GPT Builder chat.

Step 2: Define Your GPT’s Purpose

In the Create tab, describe your GPT’s function by providing a clear instruction.
For example:

• "Create an AI that helps generate visuals for new products."
• "Develop a software engineer GPT that helps format my code."

The AI will generate an initial setup based on your request.

Step 3: Configure Your GPT

To fine-tune your GPT’s behavior, go to the Configure tab. Here, you can:

• Set a name and description for your GPT.
• Choose its abilities, such as:
• Web browsing
• Image generation (DALL·E)
• Advanced data analysis
• Upload files to add extra knowledge.
• Define prompt starters to guide user interactions.

Step 4: Add Custom Branding

To personalize your GPT further, you can:

• Upload an image or generate one using GPT Builder.
• Provide detailed behavioral instructions (e.g., "Always use a formal tone").
• Add custom actions (integrate APIs or external data sources).

How to Improve the Accuracy of Instructions for GPT

If you need a more precise understanding of instructions, it is recommended to use the following method:

1. Copy the text-based instruction from the created GPT (e.g., description, behavior rules, or examples).

2. Paste it into a chat with GPT and ask it to convert it into JSON format.

3. Copy JSON cod

4. Replace the original instructions in the GPT settings with the JSON version

Why is this useful?

• JSON helps structure instructions and make them less ambiguous.
• GPT will follow the given parameters more accurately since they will be clearly defined.
• It becomes easier to edit and update instructions in the future.

Step 5: Publish Your GPT

Once your GPT is ready:

1. Click "Create" to activate it.

2. Choose whether to share it publicly in the GPT Store or keep it private.

Your GPT is now live.

Example: Brand Constructor - helps define clear brand positioning, select the perfect name, design a logo:

https://chatgpt.com/g/g-67be58289ad881918939a95b65d4346d-brand-constructor

3. Examples of GPTs

Many companies and individuals create GPTs for various tasks. Here are some well-known examples:

• Canva GPT – Helps users design visual content.

• Translator

• Zapier AI Actions – Automates tasks by integrating AI with various software.
• Research Assistant GPT – Provides academic insights by analyzing large datasets.
• Coding Helper GPT – Assists developers with debugging and writing code.
• Customer Support GPT – Automates responses to customer queries.

GPTs are widely used in industries like education, productivity, and entertainment to solve niche problems or improve efficiency.

4. Advanced Settings & Customization

For greater control over your GPT’s behavior, explore these advanced options:

Custom Instructions

You can refine your GPT’s responses by adding:

• Behavioral guidelines (e.g., "Always use concise responses").
• Topics to avoid (e.g., "Do not give financial advice").
• File-based knowledge (upload up to 20 files).

*for example: upload instructions about your company or a file with an example lexicon and manner of communication of a specific author or yourself

New Capabilities

Activate additional features:

• Web Browsing – Allows real-time internet searches.
• DALL·E Image Generation – Enables image creation.
• Advanced Data Analysis – Supports complex calculations.

Custom Actions & API Integration

For developers:

• Connect GPTs to third-party services using APIs.

• Use OpenAPI schemas to integrate plugins.

5. Managing Your GPTs

Step 1: Access the Management Dashboard

1. In your account settings, click "Manage workspace" at the bottom left.
2. Select "GPTs" to view all published GPTs.

Step 2: Edit Ownership and Access

1. In the GPTs table view, modify settings for each GPT.
2. Adjust ownership or access permissions.
3. Filter GPTs by capabilities (e.g., web browsing, image generation).

Step 3: Monitor GPT Usage

1. Check the "Chats" column to see usage data.
• Example: If the count shows 10+ or 100+, it means the GPT has had 10-20 or 100-200 conversations.

6. Frequently Asked Questions (FAQ)

How Many Files Can I Upload to a GPT?

You can upload up to 20 files to a custom GPT.

Can I Make My GPT Public?

Yes. You can choose to publish it in the GPT Store or keep it private.

Do I Need Coding Skills to Create a GPT?

No coding is required, but developers can add custom API actions.

Can Free Users Create a GPT?

No. Only Plus, Team, and Enterprise users can access GPT Builder.

What is the GPT Store?

The GPT Store is a marketplace where users can search for, explore, and use custom GPTs.

Can GPTs Be Integrated into Websites?

No, GPTs are only available at https://chatgpt.com.
They cannot be embedded into platforms like WordPress or Squarespace.

Can GPTs Generate Images?

Yes, but only paid users can access DALL·E-powered image generation.

7. Final Thoughts

Creating a GPT is fast and highly customizable, whether for personal productivity, education, or business automation. With advanced features like API integration, data analysis, and web browsing, you can build a powerful AI assistant tailored to your needs.

8. P.S.:

How to Create and Configure Your AI Chatbot – Prompts and More

Creating an effective AI assistant requires clear goals, precise instructions, and a well-structured setup. This guide explains how to define roles for your chatbot, create and customize its prompts, and refine its behavior so that it delivers accurate and helpful responses.

8.1. Define the Chatbot's Purpose

Before you build your AI assistant, determine its main objective. Ask yourself:

• What tasks should the bot perform?
• Who is its target audience?

For example, your bot might be designed for customer support, providing product information, collecting feedback, or guiding users through a sales process. Defining clear goals will help you craft specific instructions and choose the right settings.

8.2. Set Up and Personalize Prompts

8.2.1. Define Clear Roles

Create a role for your chatbot that outlines what it should do. For instance:

• "You are an AI assistant specializing in marketing and AI. Your role is to spark interest in artificial intelligence, answer questions about its applications, and suggest relevant solutions."

8.2.2. Be Specific in Your Instructions

Include details such as:

• A limit on response length (for example, “Answer in no more than 100 words”).
• Specific keywords or methodologies to use (e.g., SOSTAC, JTBD, or CJM for marketing-related prompts).
• Which websites or links are allowed—restrict responses to only approved URLs.

8.2.3. Use Structured Prompts for Consistency

For more consistent output, copy your text instructions from the chatbot and convert them into a JSON format with keys such as “instructions,” “rules,” and “examples.” Replace the original text with the JSON version in the chatbot’s settings. This structured format reduces ambiguity and helps the AI follow the specified parameters more closely.

8.3. Guidelines for Different Scenarios

8.3.1. Marketing Consultant Chatbot

• Role: Engage in conversation, ask about the user’s business, and suggest AI solutions.
• Example Prompt:
  "Hello! You are an AI assistant specializing in marketing and AI. Your goal is to spark interest in artificial intelligence. Keep responses brief, no more than 100 words, and ask questions to learn about the user's business needs. When asked, respond: 'I am an AI assistant here to help businesses integrate AI for better efficiency and growth.'"
• Additional Points:
  Use structured strategies like SOSTAC, JTBD, or CJM to guide responses and include only approved links.

8.3.2. Real Estate and Investment Consultant Chatbot

• Role: Provide detailed information about investment opportunities and guide users to official resources.
• Example Prompt:
  "You are an AI assistant for the 'Project Name.' Your task is to explain the investment opportunities and features of the project. Provide detailed descriptions and, when necessary, share a verified link to the project's presentation."
• Additional Points:
  Offer comprehensive project details and ensure that all links direct to official and verified sources.

8.3.3. Sales Agent Chatbot

• Role: Actively promote products and persuade users to make a purchase.
• Example Prompt:
  "You are an AI salesperson representing (Product Name). Your sole focus is to provide information about this product and persuade the user to purchase it. Only answer questions related to the product, and if asked about pricing, direct the user to the official link likecentre.ru."
• Additional Points:
  Restrict responses to sales-related topics and avoid discussing unrelated matters. Maintain a consistent, assertive tone to drive the sale.

8.4. Additional Recommendations

8.4.1. Enhancing Instruction Accuracy

To ensure the chatbot strictly adheres to your guidelines:

• Copy the text-based instructions you want to use.
• Convert them into a JSON format with clearly defined keys such as "instructions", "rules", and "examples".
• Replace the original instructions with the JSON version in your chatbot’s configuration.

Why do this?

• It structures your instructions and minimizes ambiguity.
• The chatbot will follow the defined parameters more accurately.
• It makes editing and updating instructions easier in the future.

8.4.2. Controlling the Bot's Behavior

• Restrict external link sharing to only those URLs that are approved.
• Regularly test the bot's responses to ensure it remains within the desired scope.
• Set clear guidelines to maintain a professional and brand-aligned tone.

8.5. Conclusion

Configuring an AI chatbot involves more than just writing prompts—it requires a careful balance of clear instructions, structured guidelines, and regular testing. By defining its purpose, setting precise rules, and using a structured format for your instructions, your chatbot will be better equipped to provide accurate and valuable responses. Use these best practices to create a robust, reliable AI assistant tailored to your needs.

1. Introduction to Gamma AI

Gamma AI is an AI-powered platform that enables users to quickly create professional presentations, documents, and even web pages without any design or programming skills. By combining intelligent text generation with customizable design templates and multimedia integration, Gamma significantly speeds up the content creation process, allowing you to focus on your ideas rather than formatting.

Key Advantages:

• Speed and Efficiency: Automatically generate slide structures and designs in just minutes.
• Professional Look: Built-in templates and themes ensure a consistent, high-quality design.
• Collaboration: Work on projects in real time with multiple users.

2. Core Capabilities

2.1. AI-Generated Drafts and Outlines

• Instant Outlines: Simply provide a topic or brief description, and Gamma will generate a structured plan with headings and subheadings.
• Text Enhancement: Tools are available to boost expressiveness, expand or condense text, and highlight key points.

2.2. Visual Themes and Design Templates

• Professional Templates: A wide library of ready-made themes automatically applies harmonious fonts, color schemes, and layouts.
• Dynamic Updates: As you edit your content, Gamma automatically adjusts slide designs to maintain a professional appearance.

2.3. Multimedia Integration

• Rich Media Options: Easily add images, GIFs, videos, and audio files by either uploading your own files or selecting from Gamma’s library.
• Data Visualization: Insert charts, tables, and other graphics to present information visually.

2.4. Collaboration Features

• Real-Time Editing: Multiple users can work on the same project simultaneously and see changes in real time.
• Comments and Feedback: Leave comments directly on slides for effective collaboration and quick revisions.

2.5. Export and Sharing Options

• Flexible Export: Share finished projects by exporting them as PDFs or by publishing a shareable link for browser viewing.
• Branding: On paid plans, you can remove Gamma watermarks and add your own branding to exported files.

3. Practical Use Cases

• Business Presentations:
  Create professional presentations for sales pitches, project updates, and employee training.
• Educational Content:
  Develop lecture slides, study materials, and lesson plans with a detailed structure.
• Marketing Materials:
  Generate campaign proposals, interactive reports, and landing pages optimized for advertising.
• Portfolios and Client Proposals:
  Prepare presentations to showcase projects, portfolios, and creative ideas.
• Quick Mini-Sites:
  Use Gamma’s new features to quickly create small websites, for instance, for event registration or announcements.

4. Registration and Workspace Setup

4.1. Registration

1. Go to https://gamma.app/ and click “Sign up for free”.
2. Register using your Google account or email. If you register by email, make sure to confirm your account by clicking the link in the confirmation email.

4.2. Creating a Workspace

1. Enter the name of your workspace.
2. Select the project type: personal or team.
3. Specify the purpose (e.g., “For work”, “For school”, or “For personal”).
4. Click “Get started” to access the dashboard.

5. Creating a New Project

5.1. Starting a Project

1. In the Gamma dashboard, click “Create new AI”.

2. Choose the type of document:

• Presentation
• Document
• Web page

3. Enter your project’s topic (Gamma supports English and many other languages).

5.2. Choosing a Creation Mode

When starting a project, you have three modes available:

• Generate:
  Best for generating a first draft and brainstorming ideas. Simply input your topic, and the AI will create an initial version that you can refine.
• Paste in text:
  Converts your notes or pre-written text (e.g., from ChatGPT) into Gamma’s format.
• Import file or URL:
  Allows you to import existing presentations, documents, or web pages. Supported sources include URLs, Google Drive, Google Docs, Google Slides, Microsoft Word, PowerPoint, and PDF files. During import, text is split into cards (slides) or segmented by headings.

5.3. Selecting a Design Theme

1. After generation or import, Gamma will prompt you to choose a visual theme.
2. Select your desired style and click “Continue” – the service will automatically generate slides with text, structure, and illustrations.

6. Importing Content

6.1. Direct Import

1. On the main screen, click the Import button.
2. Choose a source:
• URL (webpage, blog, public Notion document)
• Google Drive, Google Docs, Google Slides, Microsoft Word, PowerPoint, or PDF.
3. Gamma will import the text without preserving original styles. Each slide in a presentation becomes an individual card, and documents are split by headings.

6.2. AI-Assisted Import

1. Click “New with AI” and select Import.
2. Gamma will transform the imported text, create new layouts, and apply its own styles.
3. If you encounter issues with Google Drive imports, export your file in .docx or .pptx format and then import it.

7. Cards in Gamma

7.1. What is a Card?

A card in Gamma acts as a container for content, similar to slides, sections, or canvases.

7.2. Adding New Cards

You can add cards manually or use AI to generate them.

Manually Adding a Card

• Click the plus (+) sign between existing cards.
• A new card will be created at that position.

Using AI to Add a Card

1. Click the sparkle icon.
2. If your Gamma already contains content, AI will suggest relevant topics.
3. If the suggestions don’t fit, enter a custom description.
4. Adjust the language and choose a preferred content template.

7.3. Adding Multiple Cards

Currently, you can only add one card at a time.

7.4. Card Templates

• Click the down arrow next to the sparkle icon to browse pre-made card templates.

7.5. Is There a Limit on Cards?

• You can add unlimited cards.
• Free plan users may run out of AI credits, but can always add cards manually.

7.6. Adjusting Card Size

• Cards in Gamma are flexible by default—they expand or shrink to fit content.
• To set a minimum height:
• Open Page Settings and adjust the aspect ratio (e.g., 16:9).
• If a fixed ratio is set, dotted guidelines will help adjust content.
• https://intercom.help/gamma-faq/en/articles/8293901-how-to-control-card-sizes-and-use-other-page-setup-options-in-gamma

8. Editing Content with AI

8.1. Editing a Single Card

1. Select the card you want to edit and click the sparkle icon (sparkle AI) in the top left corner.

1. In the AI chat window that opens, enter commands to:
• Fix spelling and grammar,
• Translate text,
• Add a smart summary,
• Or perform any other custom changes.
2. Note: For Free and Plus users, the AI edits one card at a time. To edit another card, simply switch to it.

8.2. Editing All Cards (for Pro Users)

1. Pro subscribers can edit the entire presentation at once.
2. A new “Edit all cards with AI” feature appears at the top of the screen. Click the sparkle icon to open the AI chat for all cards.
3. Enter a command that will be applied across all cards (for example, change the tone or translate all content).

Limitations

• Changes cannot be made while the AI is generating content—please wait until the process is complete.
• The single-card editing function is available for Free and Plus users only.

9. Generating Images with AI

9.1. Launching Image Generation

1. In a card, type the command /ai or use the button on the right panel to generate an image.
2. A settings window for image generation will open.

9.2. Configuring the Prompt

1. If there is already text in the card, click the “Enhance” button to automatically optimize your prompt.
2. Alternatively, enter your own prompt and then click “Enhance” to improve it.
3. Specify the style, dimensions, and other parameters so the image fits your project’s design.

About AI image style prompts read https://help.gamma.app/en/articles/10186279-about-ai-image-style-prompts

9.3. Generating and Adjusting the Image

1. Click “Generate” to start the process.
2. Wait a few seconds for the AI to create the image.
3. If the result is unsatisfactory, adjust the prompt and generate the image again.

9.4. Adjusting AI Image Style via the Theme Editor

1. Open the theme editor in Gamma.
2. Navigate to the section for AI image style settings.
3. Add or modify keywords (such as brand colors or stylistic preferences) to ensure a consistent visual style in future AI-generated images.

10. What is a Custom Theme?

In Gamma, themes determine the visual style of your presentation, document, or webpage—including colors, fonts, card styles, and accent images.

Pro tip: Custom themes are automatically shared with all users in your workspace.

Creating a Custom Theme

You have two options:

1. Edit an existing theme:
   Click the three dots at the bottom right of an existing theme and select "Customize this theme".

2. Create a new theme:
Click the "New theme" button under Themes.

Importing a Theme

When you opt to import a file in the theme editor, you can upload a PowerPoint file or a file from Google Drive. Gamma will extract the colors, fonts, and logo from your file and create a Gamma theme.

Building a New Theme

You can build your own stunning theme using Gamma’s step-by-step theme builder. The builder will guide you through five steps:

• Choose your theme and background colors.
• Select your fonts.
• Define your design style.
• Upload your logo.
• Save your theme to use as often as you'd like.

Editing an Existing Theme

To edit an existing theme:

1. Click the three dots at the bottom right of the theme.
2. Select "Customize this theme".
3. In the theme editor, adjust your:
• Colors
• Fonts
• Logo
• Design elements
• Images

Using Your Own Colors

To customize a theme with your own color palette:

1. Click "Edit theme".
2. Navigate to "Colors".
3. Customize colors for elements like links, buttons, and backgrounds by entering a Hex code or clicking the colored box to open the color wheel.

Customizing Font Colors and Typography

To customize font colors:

• Click "Fonts" and change the colors for headings and body text (gradients are also supported).

Additional typography controls in custom themes include:

• Line height
• Letter spacing
• Base size
• Uppercasing (headings only)

These settings help adjust your typography if the default values don't match your brand guidelines.

Using Your Logo

To add your own logo:

1. Go to Themes > Edit Theme > Logo.
2. Import your logo. It will then appear in the bottom left corner of all decks using that theme.

Adjusting the Design

You can fine-tune the design of cards, blocks, content, buttons, and links by adjusting:

• Roundness: How round or sharp your cards and content are.
• Stroke and shadow: Option to add outlines or hard shadows to cards.
• Block colors and fill: More precise control over the colors of smart layouts and other elements.

Setting a Consistent Image Style

To ensure a consistent style for AI-generated images:

• Include specific keywords associated with your custom theme. These keywords will be appended to your prompts when generating AI images.
• You can also add specific accent images to be used as part of your custom theme.

11. See https://help.gamma.app/en/ for how to create a website and other instructions.

12. Additional Features and Updates

Gamma is continuously evolving. Here are the key updates added over the past year (dates removed):

https://ideas.gamma.app/changelog

• Right-click menu for images:
  Right-click on any image to access options like cut, copy, crop, add a comment, etc.

• Export to Google Slides:
  Directly export presentations to Google Slides for easier collaboration.
• Post directly to LinkedIn:
  Share presentations directly on LinkedIn without needing to export to PDF.

• AI-powered charts and tables:
  Create charts and tables automatically to visualize your data.

• Export single cards:
  Option to export individual cards in PDF, PowerPoint, or PNG formats.
• RTL language support:
  Support for right-to-left languages such as Arabic, Farsi, Hebrew, and Urdu.
• Social content formats:
  New content formats optimized for social media.
• Content scaling:
  Automatically resize content to fit fixed formats like 16:9.

• Advanced theme editor features:
  Import themes from PPT or Google Slides, new step-by-step theme builder, shareable theme links, and editable AI image style keywords.
• Meta (Facebook) Pixel integration:
  Add Meta Pixel to Gamma sites.

• QR code embedding:
  Quickly create and embed QR codes in your projects.

• Generate charts:
  Request a chart during card generation that comes pre-populated with data.

• Improved Instagram embedding:
  Enhanced functionality for embedding Instagram posts and reels.
• Beautiful, interactive diagrams:
  New freeform canvas for detailed diagram creation.

• Card notes and presenter view:
  Ability to add notes to each card and view them in the presenter mode.
• AI Websites:
  Create websites using AI without any design or programming skills.
• Animations:
  Add animations to your presentations and websites through the page setup.

13. Tips for Using Gamma

• Formulate precise prompts:
  The more specific your query, the more accurate the AI's output.
• Use the Enhance function:
  Optimize your prompts for more relevant images and texts.
• Experiment with creation modes:
  Try different approaches (Generate, Paste, Import) to achieve the best results.
• Monitor credit usage:
  If you’re on the free plan, keep an eye on your credit consumption (e.g., 400 credits at signup) and consider upgrading to Plus or Pro if necessary.
• Collaborate effectively:
  Invite colleagues for joint editing and use the “edit all cards” feature (for Pro) to speed up your workflow.
• Stay updated:
  Gamma is continuously evolving, so keep an eye on new features that can significantly improve your work process.
  https://ideas.gamma.app/changelog

14. Conclusion

This comprehensive step-by-step guide covers every aspect of using Gamma—from a detailed introduction and feature overview to registration, project creation, content import, AI-driven editing, image generation, and the utilization of the latest updates throughout the year. Gamma offers a robust set of tools for creating high-quality presentations, documents, and web pages with minimal time and effort. Use this guide as a foundation for mastering Gamma, experiment with its various features, and tailor the service to meet your needs. Happy creating and best of luck with your projects!

First, you will see examples of how to use ChatGPT (for generating ideas, descriptions, and text summaries). Then we’ll go step by step through the installation process and expense-control tips.

1. Examples of Using ChatGPT in Google Sheets

https://www.youtube.com/watch?v=MS326x_v7BE&t=102s

1.1. Generating a Content Plan

• Formula:

=GPT_LIST("Come up with 5 topics for articles about healthy eating")

• Result: you get several ideas for future posts or articles (all in one cell as a list). You can instantly move them to your editorial calendar.

1.2. Expanding a Topic / Article Structure

• Formula:

=GPT("Expand on the topic: " & A2 & ", suggest 3 subheadings")

• Example: if A2 says “Vegetarian Recipes,” you’ll get a mini outline of the article, including subheadings and key points.

1.3. Summarizing Long Text

• Formula:

=GPT_SUMMARIZE(A2)

• Result: ChatGPT returns the main ideas from a large volume of text stored in A2. Useful for analyzing lengthy reviews or articles.

1.4. Creating a Product Description

• Formula:

=GPT("Write a short, compelling product description for: " & A2)

• Result: a quick promotional text based on the product name/characteristics in cell A2.

1.5. Getting Hints on Google Sheets Formulas

• Formula:

=GPT("Explain how the VLOOKUP function works in Google Sheets, with an example")

• Result: a concise guide inside your spreadsheet—no need to search external docs.

2. Installing the “GPT for Sheets and Docs” Add-On

1. Open Google Workspace Marketplace

• Either go to Google Workspace Marketplace,

• Or in your Google Sheet, click “Extensions” → “Add-ons” / “Get add-ons.”

2. Find and install “GPT for Sheets and Docs”

https://workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654?hl=ru

• Type the add-on name in the search bar, open its page.

• Click Install and confirm the requested permissions.

3. Check that it appears

• Back in Google Sheets, open “Extensions” and see if “GPT for Sheets and Docs” is listed.

Note. All add-ons are installed at your own risk. Please check the add-on ratings and user reviews in the Marketplace to ensure reliability.

3. Getting an API Key from the OpenAI Platform

1. Go to https://platform.openai.com/

• This is the developer dashboard, not the ChatGPT site (chat.openai.com).

2. Create or log in to your account

• If necessary, add a payment method in the "Billing" → "Payment methods" section (in case you don't have free credit).
First "Settings" - then "Billing" → "Payment methods"

3. Create an API key

• In the "API Keys" section (direct link), click "Create new secret key".

• !!!!!! Copy the key and store it securely (it won’t be shown again in full).

4. Linking the API Key to the Add-On

1. Open your Google Sheet

• It can be new or an existing one.

* Save the file in Google Sheets format if it is not already converted.

2. Insert the key

• Go to “Extensions” → “GPT for Sheets and Docs” → “Set API key.”

• Paste the copied key.

3. Check

• If everything is correct, the add-on will connect to OpenAI and be ready for use.

5. Main ChatGPT Formulas

5.1. =GPT("Your query")

• Sends a string query directly to ChatGPT, returns text.

• Example:

=GPT("List the main dishes of Mediterranean cuisine")

5.2. =GPT_LIST("Your query")

• Returns a list (each item on a new line).

• Example:

=GPT_LIST("Give me 5 content ideas about eco-tourism")

5.3. =GPT_SUMMARIZE(A2)

• Summarizes text in cell A2.

• Example:

=GPT_SUMMARIZE(A2)

Tip: Combine formulas with cell references. For example:

=GPT("Expand on the topic: " & A2 & ", specify target audience and style")

* You can find the rest of the commands in this tab along with a video explanationем

* We recommend setting the token and temperature settings to the default values.

6. Managing Costs and Tariffs

1. Within the add-on

• “GPT for Sheets and Docs” may provide a small trial balance. After it ends, you’ll need a paid plan (go to “Extensions” → “GPT for Sheets and Docs” → “Billing”).

2. OpenAI Dashboard

• On https://platform.openai.com/ , check “Usage” to see how many tokens you’ve used

• You can set limits in “Billing” → “Usage Limits.”

7. Avoiding Unnecessary Requests

1. Pause all GPT functions

• The add-on menu may let you pause all GPT formulas, so they don’t recalculate on every sheet change.

2. Replace a formula with its result

• After you get what you need, convert the formula to static text (Edit → “Paste special” → “Values only”) so no new tokens are spent on recalculation.

3. Highlight GPT cells

• Some versions of the add-on mark cells that contain GPT formulas, helping you see where costs might accrue.

8. Security and the Key

1. Don’t publish your API key

• Avoid making a public document containing your key.

• If working in a team, consider giving each person their own key.

2. Watch your spending

• Check your OpenAI usage to ensure you’re not incurring unexpected costs.

• Remove or pause GPT formulas that are no longer needed.

3. Be specific in your prompts

• The more accurately you phrase the query (e.g., number of points, writing style), the less chance you’ll get unnecessary or overly long responses.

By setting up “GPT for Sheets and Docs” and linking it to your OpenAI API key, you can easily generate content plans, article ideas, product descriptions, or even get formula help—all within your Google Sheets. Enjoy faster workflows and text generation in one convenient place!