STARTER GUIDE:

Welcome to AI Sheets with Adon!

This powerful add-on brings the capabilities of AI directly into your Google Sheets, helping you automate tasks, generate content, and analyze data with ease. Let's get started!

Table of Contents

  1. Installation

  2. Accessing the Add-on

  3. Understanding AI Functions

  4. Using the Sidebar

  5. Workflow Copilot

  6. Tips for Best Results

  7. Subscription and Usage

1. Installation

To install AI Sheets with Adon:

  1. Open a Google Sheet

  2. Go to Extensions > Add-ons > Get add-ons

  3. Search for "AI Sheets with Adon"

  4. Click to install and grant necessary permissions

2. Accessing the Add-on

After installation:

  1. Go to Extensions > AI Sheets with Adon > Open Sidebar

  2. The sidebar will open, giving you access to all features

3. Understanding AI Functions

AI Sheets with Adon provides several custom functions:

  • =GPT(prompt, temperature): Generates text based on your prompt

  • =research(prompt, temperature, citation): Conducts research with optional citations

  • =summarize(text): Condenses long text into a summary

  • =tags(text, tags): Applies specified tags to your text

  • =sentiment(text, sentiments): Analyzes sentiment in your text

  • =edit(text, task): Edits text based on your instructions

  • =extract(text, extraction): Pulls specific information from text

To use these functions:

  1. Type = in a cell, followed by the function name

  2. Fill in the required parameters

  3. Press Enter to see the result

Example: =GPT("Write a product description for a new smartphone", 0.7)

4. Using the Sidebar

The sidebar offers quick access to key features:

  • Status: View active functions and remaining usage

  • Function Controls: Refresh, pause, or lock AI functions

  • Functions Guide: Quick reference for all available functions

  • Account Information: Check your subscription status

5. Workflow Copilot

Need help with a complex task? Use the Workflow Copilot:

  1. Click the "Workflow Copilot" tab in the sidebar

  2. Describe your task in the text area

  3. Click "Generate" to receive step-by-step instructions

Example: "I want to find the sum of the 5 largest values in cells A1:A25"

6. Tips for Best Results

  • Be specific in your prompts and instructions

  • Experiment with different temperature settings (0.0 to 1.0) to balance consistency and creativity

  • Use cell references in your prompts to dynamically update results

  • Combine AI functions with standard Google Sheets functions for powerful workflows

7. Subscription and Usage

  • Free tier: Limited daily usage

  • Paid subscription: Unlimited usage and priority support

  • Upgrade anytime through the sidebar

Remember to check your usage in the sidebar to stay within your plan limits.

Happy AI-powered spreadsheeting!