10studio.matrixlead.com Open in urlscan Pro
47.91.255.78  Public Scan

Submitted URL: https://mail.matrixlead.com/campaigns/ld845xvkoxfd4/track-url/xt0229tekcac6/cc7076908090453ee61467d1f88a1d23aa6d69fa
Effective URL: https://10studio.matrixlead.com/docs/spreadsheet-ai-sheets
Submission: On January 03 via api from ES — Scanned from ES

Form analysis 0 forms found in the DOM

Text Content

Skip to main content

10 Studio
Documentation
 * Introduction
 * Getting Started
 * AI-aided Formula Editor
 * Formula Editor
 * Spreadsheet Verificator
 * Bottleneck Detector
 * Spreadsheet Optimizer
 * Funfun
 * AutoXL

Live DemoAI-aided Formula Editor
Persons
 * Get 10 Studio
 * Follow Free Videos and Contents
 * Request a Help

Businesses
 * Get 10 Studio Together
 * Build Tailored Apps
 * Audit and Validate Spreadsheets
 * Data Analysis and Visualization
 * Training and Lecture
 * Other Services

Spreadsheet Language and Programming
 * Course in English
 * Course in Chinese

Sign OutSign In
English
 * English
 * 简体中文



 * 10 Studio
 * Getting Started
 * AI-aided Formula Editor
 * Spreadsheet AI
   * For Microsoft Excel
   * For Google Sheets
 * Formula Editor
 * Spreadsheet Verificator
 * Bottleneck Detector
 * Spreadsheet Optimizer
 * Funfun
 * AutoXL
 * Support
 * Legal

 * 🏠
 * Spreadsheet AI
 * For Google Sheets

On this page


SPREADSHEET AI FOR SHEETS™


AI CHAT COPILOT IN GOOGLE SHEETS WHO UNDERSTANDS YOUR WORKBOOK AND ASSISTS WITH
COUNTLESS SPREADSHEET TASKS.




INTRODUCTION

Spreadsheet AI for Sheets™ aims to be an AI-assisted software solution suite for
a wide range of spreadsheet tasks. Currently, it mainly offers a chat copilot
integrated into Google Sheets™, which provides the following features:

 * An interactive chat copilot that can discuss any questions you may have.
 * It can learn the contents of your workbook for a more collaborative
   experience.
 * Over 20 spreadsheet example tasks that the chat copilot can accomplish.


HIGHLIGHTED FEATURES

You can ask the chat copilot anything related to Google Sheets™ and
spreadsheets, engage in conversations in your favorite language, and accomplish
tasks in a step-by-step manner similar to working with ChatGPT. Additionally, we
have developed built-in features to make the chat copilot better assist you in
common spreadsheet tasks.


IMPORT THE CONTENTS OF YOUR WORKBOOK TO THE CHAT COPILOT

You can share your workbook's contents with the chat copilot. This enables both
you and the chat copilot to refer directly to ranges or cells in your worksheet,
such as "A1:D10" or "B2", during your conversations.

To do this, select a range in your worksheet and then click on Import the Values
of the Selection, Import the Formulas of the Selection, or Import Values &
Formulas of the Selection. Once the content is imported, the chat copilot will
be equipped to answer questions based on it. You can verify the imported content
by asking questions like give me the value of B2 or give me the formulas of
A1:D10, etc.


OVER 20 EXAMPLE TASKS

This versatile AI chat copilot allows you to accomplish countless spreadsheet
tasks. To help you get started and make the most of its capabilities, we offer
over 20 example tasks, such as data enrichment, data analysis, formula creation,
and verification, among others.


IQ POINTS AND PRICING

Interacting with the chat copilot requires the use of virtual IQ points.

 * Welcome bonus IQ: every user will be automatically granted free welcome bonus
   IQ points to get started.
 * Purchase IQ: users can buy packs of 150 IQ, 300 IQ, or 500 IQ for continued
   use.


CONSUMPTION OF IQ POINTS

The number of IQ points consumed by a request is calculated based on two
factors:

 1. The total length of tokens of the prior dialogs, the current question, and
    the returned answer. The length of tokens is highly correlated with the
    length of the texts. Thus, the longer these texts are, the more IQ points
    the request will consume.
 2. The model consulted (either GPT-3.5 or GPT-4). For requests of the same
    length, GPT-3.5 consumes less IQ points than GPT-4.

Examples:

 * a knowledge question can cost 1 IQ point
 * a data enrichment can cost 3 IQ points
 * a data transformation can cost 5 IQ points
 * a data analysis can cost 6 IQ points


EFFICIENT USE OF IQ POINTS

Here are some tips for using IQ points efficiently:

 * Open a New chat for each separate issue. When calculating the consumption of
   IQ points for a request, all prior dialogs in the same chat are taken into
   account. Therefore, subsequent requests in an ongoing chat are likely to
   consume more IQ points.

 * Use GPT-3.5 by default. If GPT-3.5 does not provide a satisfying answer,
   consider switching to GPT-4. Additionally, GPT-3.5 is much quicker than
   GPT-4; GPT-4 excels especially in tasks involving formulas.

 * Find solutions using small sets of data before applying them to larger sets.
   Sending a request with a large amount of data can be costly and is not always
   necessary. You can first send a request using a small subset of your data,
   collaborate with the chat copilot to find a solution, and then apply that
   solution to the full data set.


INSTALLATION

You have two options to install the add-on:

 * Go to
   https://workspace.google.com/marketplace/app/spreadsheet_ai_for_sheets/906514510049,
   and click on the Install button.
 * In your Google Sheets, click on the Extensions tab => Add-ons => Get add-ons,
   then Google Workspace Marketplace will be opened in a dialog window. Search
   "Spreadsheet AI for Sheets™", then click on the Install button.


UNINSTALLATION

In your Google Sheets, click on the Extensions tab => Add-ons => Manage add-ons,
then you will see a card for "Spreadsheet AI for Sheets™" in a dialog window.
Click on the 3 dots and select Uninstall.


PRIVACY POLICY

By using Spreadsheet AI, you accept our privacy policy and terms of service.


VIDEO

Previous
For Microsoft Excel
Next
Tool
 * Introduction
 * Highlighted features
   * Import the contents of your workbook to the chat copilot
   * Over 20 example tasks
 * IQ points and pricing
   * Consumption of IQ points
   * Efficient use of IQ points
 * Installation
 * Uninstallation
 * Privacy Policy
 * Video

Documentation
 * Try samples
 * Installation

Philosophy and Research
 * Fundamentals of Spreadsheet Languages

Community
 * LinkedIn
 * Bilibili
 * Twitter

Company
 * About Us
 * ❤ We are hiring!