A Spreadsheet Pal
Effortlessly converse with spreadsheets; use commands to analyze, filter, or visualize your data.
Spreadsheets AI allows you to seamlessly interact with your data. Simply input commands to analyze, filter, or visualize your data without the need for complex formulas or coding. Effortlessly converse with spreadsheets and easily access the information you need. Whether you're a data analyst, business professional, or student, this plugin makes working with databases and spreadsheets a breeze. Take control of your data and uncover valuable insights with Spreadsheets AI.
How to
Comments (1)
API docs
Learn how to use Spreadsheets AI effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
-
Prompt 1: "I need to perform analysis on databases and spreadsheets."
-
Prompt 2: "Can you help me with analyzing data from a database?"
-
Prompt 3: "I want to link a Google Sheet to my conversation."
-
Prompt 4: "How can I manipulate, edit, and transform data in a Google Sheet?"
-
Prompt 5: "Can you run a query on a database and retrieve the results?"
Features and commands
| Feature/Command | Description |
|---|---|
linkDB | This command allows you to link a database in the conversation. You need to provide the database connection string, as well as the name and purpose of the database. |
linkSheet | This command allows you to link a Google Sheet to the conversation. You need to provide the name, purpose, and URL of the Google Sheet. |
manipulateSheet | This command enables you to inspect, edit, manipulate, download, and transform data in a Google Sheet. You can also install pip packages using !pip install package_name. |
queryDB | This command allows you to run a read-only query on a database. You need to provide the columns to use in the query, the ID of the data source, the query itself, and an explanation of the query. It also provides an option to plot the query results. |
useFile | This command ensures that a file is usable for an operation. It is needed before using the file in the manipulateSheet command to ensure it is available. |