> ## Documentation Index
> Fetch the complete documentation index at: https://resources.athenaintel.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Sheets

<Tabs>
  <Tab title="Overview">
    Athena Sheets enable you with AI-driven spreadsheets, facilitating effortless interaction with Athena and simultaneous real-time collaboration with your team members.

    Using Sheets, you can explore datasets, derive insights, and work collaboratively, within a straightforward and easy-to-navigate interface.

    <Frame caption="Spreadsheet Automation with Sheets Agent">
      <iframe title="vimeo-player" src="https://player.vimeo.com/video/1055382664" width="640" height="360" frameborder="0" referrerpolicy="strict-origin-when-cross-origin" allow="autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share" allowfullscreen />
    </Frame>

    <video autoPlay muted loop playsInline className="w-full aspect-video" src="https://mintcdn.com/athenaintelligence-e46bc9d3/tccVZbz4-WY4xy6A/images/Sheets.mp4?fit=max&auto=format&n=tccVZbz4-WY4xy6A&q=85&s=89d2dafad893ba833e9109276f969789" data-path="images/Sheets.mp4" />

    ## Key Features

    ### AI-Powered Editing and Analysis

    Use the Chat to provide instructions for Athena to edit and manage your spreadsheets based on your requirements. Athena can perform complex data transformations, create formulas, generate summaries, and analyze trends automatically.

    ### User Interface Integration

    Connect your Sheets data to interactive User Interfaces and dashboards. Build custom applications that read from and write to your spreadsheets, enabling dynamic data collection forms, reporting dashboards, and business process applications that stay synchronized with your data.

    ### Agent Operating Procedures (AOPs) Execution

    Execute pre-configured AI workflows directly from your spreadsheets. AOPs can process spreadsheet data, perform analysis, generate reports, and automate complex multi-step operations on your data without manual intervention.

    ### Import/Export

    * Quickly bring in data from different formats, such as XLSX and CSV, into your spreadsheets.

    * Save your spreadsheets in widely-used formats like XLSX and CSV, making it simple to share and distribute your work.

    ### Real-Time Collaboration

    Collaborate with your team in real-time by simultaneously viewing and editing spreadsheets side-by-side. Multiple users can work on the same sheet while Athena assists with data analysis and formula creation.

    ### Data Visualization and Charting

    Create interactive charts and visualizations from your spreadsheet data. Generate figures that can be embedded in documents, dashboards, or shared as standalone assets for data-driven decision making.
  </Tab>

  <Tab title="AOPs in Sheets">
    Execute your AOPs inside Sheets and get more insights in the form of structured data.

    <Frame>
      <iframe title="vimeo-player" src="https://player.vimeo.com/video/1136068466?h=e5b14b5dbd" width="640" height="360" frameborder="0" referrerpolicy="strict-origin-when-cross-origin" allow="autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share" allowfullscreen />
    </Frame>

    <p>
      The `=AOP()` function executes an Agent Operating Procedure (AOP) directly from your spreadsheet and displays the returned value in the cell. This enables you to run pre-configured AI workflows on spreadsheet data without leaving Sheets.
    </p>

    <CodeBlock filename="Syntax">
      \=AOP(AOP\_ID, "var1", "var1\_value", "var2", "var2\_value")
    </CodeBlock>

    <CodeBlock filename="Parameters">
      AOP\_ID: The asset ID of the AOP you want to execute (required)

      <br />

      "var1", "var1\_value": Variable name and value pairs to pass as inputs to the AOP (optional)

      <br />

      Additional variable pairs can be added as needed
    </CodeBlock>

    <p>
      Variable values can be:

      * **Cell references**: Reference other cells in your spreadsheet (e.g., C4, B2)
      * **Literal values**: Provide direct string, number, or boolean values
      * **Formulas**: Use the result of other spreadsheet formulas
    </p>

    ## Example Usage:

    <Tabs>
      <Tab title="Execute AOP without inputs">
        <Steps>
          <Step title="Create or identify an AOP">
            First, create an AOP in the AOP Library or identify the asset ID of an existing AOP you want to execute.
          </Step>

          <Step title="Use `=AOP()` in a cell">
            In any cell inside the sheet, enter the AOP function with the AOP asset ID and press **Enter**.

            <CodeBlock filename="Example">
              \=AOP("asset\_55ed8502-1233-4f10-b79d-c43c2eb1b251")
            </CodeBlock>

            <Frame>
              <img src="https://mintcdn.com/athenaintelligence-e46bc9d3/tccVZbz4-WY4xy6A/images/aop-sheets1.png?fit=max&auto=format&n=tccVZbz4-WY4xy6A&q=85&s=3e6e7ce6e259b39e5c697ea982fa54da" width="974" height="646" data-path="images/aop-sheets1.png" />
            </Frame>

            <Info>The AOP will execute and the result will be displayed in the cell.</Info>
          </Step>
        </Steps>
      </Tab>

      <Tab title="Execute AOP with cell reference inputs">
        <Steps>
          <Step title="Prepare your data">
            Organize your data in spreadsheet cells. For example, put a company name in cell C4.
          </Step>

          <Step title="Use `=AOP()` with variable inputs">
            Pass cell references as variable values to the AOP. The AOP will use the data from the referenced cells.

            <CodeBlock filename="Variable Input">
              \=AOP("asset\_55ed8502-1233-4f10-b79d-c43c2eb1b251", "company", A4)
            </CodeBlock>

            <Frame>
              <img src="https://mintcdn.com/athenaintelligence-e46bc9d3/tccVZbz4-WY4xy6A/images/aop-sheets2.png?fit=max&auto=format&n=tccVZbz4-WY4xy6A&q=85&s=e4512ee43edf5fa13ddc6a1fcae19271" width="1730" height="960" data-path="images/aop-sheets2.png" />
            </Frame>

            <Info>In this example, the AOP receives a variable named "company\_name" with the value from cell A4.</Info>
            You can also use a document as an input for an AOP run.

            <CodeBlock filename="Document Input">
              \=AOP("asset\_55ed8502-1233-4f10-b79d-c43c2eb1b251", "document", A4)
            </CodeBlock>

            <Frame>
              <img src="https://mintcdn.com/athenaintelligence-e46bc9d3/tccVZbz4-WY4xy6A/images/aop-sheets3.png?fit=max&auto=format&n=tccVZbz4-WY4xy6A&q=85&s=8565f2e12a0767c7a29274dc982ea4fc" width="1604" height="962" data-path="images/aop-sheets3.png" />
            </Frame>

            <Info>In this example, the AOP receives a document input ("document") with the value from cell A4.</Info>
          </Step>
        </Steps>
      </Tab>

      <Tab title="Execute AOP with multiple inputs">
        <Steps>
          <Step title="Identify required variables">
            Check your AOP configuration to see what input variables it expects.
          </Step>

          <Step title="Pass multiple variable pairs">
            Provide multiple variable name and value pairs to pass multiple inputs to the AOP.

            <CodeBlock filename="Example">
              \=AOP("asset\_55ed8502-1233-4f10-b79d-c43c2eb1b251", "document", A4, "company\_name", B4)
            </CodeBlock>

            <Frame>
              <img src="https://mintcdn.com/athenaintelligence-e46bc9d3/tccVZbz4-WY4xy6A/images/aop-sheets4.png?fit=max&auto=format&n=tccVZbz4-WY4xy6A&q=85&s=797a039dc5cb3762423fe71c69a31523" width="2366" height="958" data-path="images/aop-sheets4.png" />
            </Frame>

            <Info>This example passes two variables: document input (from cell A4), company\_name (from cell B4).</Info>
          </Step>
        </Steps>
      </Tab>

      <Tab title="Use with literal values">
        <Steps>
          <Step title="Use `=AOP()` with direct values">
            You can pass literal string, number, or boolean values directly without using cell references.

            <CodeBlock filename="Example">
              \=AOP("asset\_55ed8502-1233-4f10-b79d-c43c2eb1b251", "product", "Enterprise Plan", "price\_limit", 10000)
            </CodeBlock>

            <Frame>
              <img src="https://mintcdn.com/athenaintelligence-e46bc9d3/tccVZbz4-WY4xy6A/images/aop-sheets5.png?fit=max&auto=format&n=tccVZbz4-WY4xy6A&q=85&s=9b4762b8a9ff1c6c789c5d85c088cf81" width="1768" height="634" data-path="images/aop-sheets5.png" />
            </Frame>

            <Info>This example passes literal values directly to the AOP without referencing cells.</Info>
          </Step>
        </Steps>
      </Tab>
    </Tabs>
  </Tab>

  <Tab title="Deep Citations">
    When extracting data from documents into Sheets, Athena automatically generates deep-linked citations that trace every value back to its source. The Data Sources panel provides a comprehensive view of all citations, enabling you to verify and navigate to the exact location in the original document where each piece of information was extracted.

    <Frame caption="Deep Citations in Sheets - Track citations and extracted data from source documents">
      <img src="https://mintcdn.com/athenaintelligence-e46bc9d3/Bhc4CCWi5T7k6gBJ/images/deep-citations-sheets.png?fit=max&auto=format&n=Bhc4CCWi5T7k6gBJ&q=85&s=231884ed4dce1321c82e45cc90738036" width="3456" height="1982" data-path="images/deep-citations-sheets.png" />
    </Frame>

    ## How Deep Citations Work

    When Athena extracts information from PDFs, documents, or other assets into your spreadsheet, each extracted value is automatically linked to its source location. The Data Sources panel displays all citations with:

    * **Citation count**: See the total number of citations extracted (e.g., 380 citations)
    * **Source document reference**: Each citation shows the source file (e.g., Meta.pdf)
    * **Exact location**: Page numbers and specific text excerpts from the source
    * **Quick navigation**: Click any citation to jump directly to that location in the source document

    ## Using the Data Sources Panel

    The Data Sources panel appears alongside your spreadsheet when working with extracted data. It provides:

    * **Citations tab**: Lists all citations with their source references and page numbers
    * **Snips tab**: View extracted snippets and their source locations
    * **Side-by-side view**: Open the source document alongside your spreadsheet to verify data in context
    * **Source preview**: Hover over citations to see the exact text that was extracted

    This citation system ensures complete traceability for compliance, auditing, and verification workflows, making it easy to validate any data point back to its original source.
  </Tab>
</Tabs>