Athena User GuideUser Guide
Generated with DocsHound AI
Feature Overviews

Sheets

Overview

Athena Sheets are AI-first spreadsheets designed for collaboration with Athena.

Video Overview:

Features

Chat

You can with Athena in the sidebar by clicking the Chat button. When you have cells in your spreadsheet selected Athena is able to see them and reference them in chat. You can have Athena use those selected cells as input for other actions or ask for help writing formulas.

Real-Time Collaboration

Athena Sheets supports real-time collaboration. Simply send the URL of your spreadsheet to your colleague and they will be able to work in your Sheet with you.

General Spreadsheet Operations

Athena Sheets works very similarly to Google Sheets or Excel. All of the formulas that you know and love should work the same way.

=athena() function

The =athena() function in Athena Sheets allows users to leverage Athena's powerful AI capabilities directly within their spreadsheets. This function takes a user prompt as input and returns a response generated by Athena, making it easier to perform complex data analysis, generate insights, and automate tasks without leaving the sheet.

Parameters:

=ATHENA(prompt, tools, model)

  1. prompt: The prompt for Athena to follow

  2. tools - Available tools: search, enrich_person, enrich_company, code_execution. Default is "search"

  3. model - The language model to use: gpt-3.5-turbo, gpt-4o, gpt-4o-mini, groq-llama3-70b-8192. Default is gpt-4o-mini.

Use Cases

1. Using Athena internal knowledge to label, structure or enrich information from another column/

  • Field Prompt: (Cell A2)
    List three plant-based alternatives for milk products.

    Field Athena formula:
    =ATHENA(A2)

    Field Athena Value: (Response)
    Here are three popular plant-based alternatives for milk products:

    '''1. **Almond Milk**: Made from ground almonds and water, almond milk is a low-calorie option that is often fortified with vitamins and minerals.

    2. **Soy Milk**: Derived from soybeans, soy milk is high in protein and often used as a direct substitute for cow's milk in cooking and baking.

    3. **Oat Milk**: Made from oats and water, oat milk has a creamy texture and is naturally sweet. It's a popular choice for coffee and cereals.

2. Using Athena function to search and extract items

  • Category: (Cell A2)
    Oat Milk

    Company: (Cell B2)
    Oatly

    Field Label prompt: (Cell C2)
    =CONCAT("Find the pack size of ", A2 , " from " , B2 , " as a list.")

    Field Athena prompt: (Cell D2)
    =ATHENA(C2, 'search')


    Field Athena value: (Response)


    Oatly offers various pack sizes for their oat milk products. Here are the common pack sizes:


    1. 1 Liter (33.8 fl oz)


    2. 500 mL (16.9 fl oz)


    3. 200 mL (6.8 fl oz)


    4. 1.89 Liter (64 fl oz) - available in some regions


    Please note that availability may vary by location and retailer.

    Field Pack Size prompt: (Cell E5)


    =ATHENA(CONCAT("Extract only the pack sizes from your response in " , D5 , "Make sure to only include pack sizes as your answer will be passed directly to a database. Return only the unit and the size without any other text."), "search" , "gpt-4o-mini")

    Field Athena value (Response)

    1 Liter

    250 ml

    1.5 Liter

    2 Liter