# Product capabilities of the Agent in Sheets and Excel The [Agent](https://autosheet.com/docs/resources/guides/concepts#agent) in GPT for Sheets – Autosheet and GPT for Excel – Autosheet allows you to tackle common tasks in bulk with conversational AI. This page provides practical examples of how to make the most out of the Agent's various capabilities. ## How to use the Agent examples To try out the use cases in GPT for Sheets – Autosheet or GPT for Excel – Autosheet, use the built-in examples from the add-on sidebar. **G Sheets** 1. Create a [new spreadsheet](https://sheet.new/). 2. In the menu bar, select **Extensions > GPT for Sheets – Autosheet > Open**. ![Launch GPT for Sheets – Autosheet](https://autosheet.com/docs/article-images/gpt-for-sheets/launch.png) 3. In the sidebar, click **Examples** and select the example you want to try out. ![Agent examples](https://autosheet.com/docs/article-images/gpt-for-sheets/agent-examples.png) 4. Click the send button to start the example. ![Agent example](https://autosheet.com/docs/article-images/gpt-for-sheets/agent-try-examples-send.png) The following video shows the entire process. [Video: agent-try-examples.mp4](https://autosheet.com/docs/video/gpt-for-excel/agent-try-examples.mp4) **MS Excel** 1. Create a new blank workbook. 2. On the [ribbon](https://support.microsoft.com/en-US/Office/foundations-experiences/show-or-hide-the-ribbon-in-office), select **Home > GPT for Excel Word – Autosheet**. ![GPT for Excel Word – Autosheet on the Home ribbon](https://autosheet.com/docs/article-images/gpt-for-excel/launch.png) > **Info** > > If **GPT for Excel Word – Autosheet** is not visible on the ribbon, or if it's grayed out, select **Home > Add-ins > My Add-ins > GPT for Excel Word – Autosheet**. [Learn more.](https://autosheet.com/docs/gpt-for-excel/troubleshooting/add-in-not-working#add-in-button-is-grayed-out) 3. In the sidebar, click **Examples** and select the example you want to try out. ![Agent examples](https://autosheet.com/docs/article-images/gpt-for-excel/agent-examples.png) 4. Click the send button to start the example. ![Agent example](https://autosheet.com/docs/article-images/gpt-for-excel/agent-try-examples-send.png) The following video shows the entire process. [Video: agent-try-examples.mp4](https://autosheet.com/docs/video/gpt-for-excel/agent-try-examples.mp4) ## Content generation ### SEO (h1, metas, FAQs) Use the Agent to generate SEO-friendly content for your website. Bulk-generate meta titles and descriptions, headers, FAQs, image alt texts, and more. In this example, the Agent is used to generate titles and descriptions for car spare parts, then generate FAQs about them. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=Qe2I1VpHLyQ) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=VPoUovSewbU) ## Translation ### Translate to multiple languages Use the Agent to translate spreadsheet content to multiple languages in bulk. You can provide specific instructions for the translation, and even use a glossary stored in another sheet to have the translation follow your brand's terminology. In this example, the Agent is used to translate the content of column A to the languages provided in row 1. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=at-491HcnbQ) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=FnHi14cv-44) ### Feedback analysis Use the Agent to categorize, filter, tag and analyze customer feedback and survey responses. This can include sentiment analysis, key topic extraction, brand and product mention identification, and more. In this example, the Agent is used to translate support tickets to a common language, classify them based on sentiment, and define their relevance to product quality. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=Y_HE1M0AqZo) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=5nH6PuStsnw) ## Web search ### Market research Use the Agent to generate market overviews or company profiles in bulk by fetching information from the web. In this example, the Agent is used to research the companies in column A, and find their website, CEO name, and other information. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=holyvG0116o) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=zPCHhHl3yp8) ## Data preparation ### Data prep (inventory) Use the Agent to prepare your data for analysis or reporting. This can include cleaning, transforming, or formatting your data to make it more useful for your purposes. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=I9FGbcugALc) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=iLcIxcV_oJk) ## Data analysis ### ICP fitness Use the Agent to filter your leads and find companies and contacts that match your ideal customer profile, based your own criteria. In this example, the Agent is used to analyze the leads based on their industry fit, role fit, location, and company size. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=0My2eacaGMw) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=4nIlAQ5x1Yc) ### Feedback analysis Use the Agent to categorize, filter, tag and analyze customer feedback and survey responses. This can include sentiment analysis, key topic extraction, brand and product mention identification, and more. In this example, the Agent is used to translate support tickets to a common language, classify them based on sentiment, and define their relevance to product quality. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=Y_HE1M0AqZo) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=5nH6PuStsnw) ## Formulas ### Generate and autofill formulas Use the Agent to generate, troubleshoot, and explain spreadsheet formulas without writing any formula code yourself. Simply describe in your own words what calculation or logic you need, and the Agent creates the appropriate formulas. This is particularly useful for complex nested formulas or functions you're unfamiliar with. In this example, the Agent is used to generate a formula to calculate the seniority of employees in years and months. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=llZGP194qEg) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=et71Qn4q42o) ## Categorization ### E-commerce Use the Agent to generate product descriptions, product listings, and other content for your e-commerce website. In this example, the Agent is used to generate a title and description for the products in column A, then categorize them and extract the main features. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=PWe0zD813kA) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=Etq2L22K0Q8) ### Google Shopping (titles & categories) Use the Agent to generate optimized content for your Google Shopping listings or for other product catalogs or paid ads. In this example, the Agent is used to improve product titles and assign categories based on the official Google Shopping guidelines. **G Sheets** [Watch video on YouTube](https://www.youtube.com/watch?v=krsTEzs6V8M) **MS Excel** [Watch video on YouTube](https://www.youtube.com/watch?v=fRc06mDN7Po) ## What's next? - Use the Agent in [GPT for Sheets – Autosheet](https://autosheet.com/docs/gpt-for-sheets/agent) or [GPT for Excel – Autosheet](https://autosheet.com/docs/gpt-for-excel/agent). - Learn about the [Agent's business applications](https://autosheet.com/docs/resources/guides/agent-use-cases/business-applications).