Chat with GSheet
Easily link your G Sheet and use AI to analyze your data, transform and visualize it.
Chat with GSheet plugin allows users to perform conversational analysis on their G Sheet data. The plugin integrates with G Sheet data and provides an interactive platform for analysis. Users can generate insights and extract data using natural language inputs. There's no need for complex queries or programming skills. This plugin can save a lot of time and increase productivity for individuals and businesses dealing with large G Sheet files. With Chat with GSheet, users can easily analyze, filter and sort their data in real-time, all through a simple conversation.
How to
Comments (0)
API docs
Learn how to use Chat with GSheet effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
-
Prompt 1: "I want to perform analysis on the data in my Google Sheet."
-
Prompt 2: "Can you help me link my Google Sheet to this conversation?"
-
Prompt 3: "I need to run a query on the Google Sheet that's linked to this conversation."
Features and commands
| Feature/Command | Description |
|---|---|
get_sheet_instructions | This command provides instructions on how to use the Google Sheets chat plugin. It returns helpful text to guide the user in interacting with the plugin. |
linkSheet | This command allows you to link a Google Sheet to the conversation. You need to provide the URL of the Google Sheet to be linked. |
manipulateSheet | This command allows you to run a Python pandas query on the linked Google Sheet. You need to provide the query code in pandas format, modifying the DataFrame, and set any outputs using the output variable. If you want to generate plots, the code should save the plot in base64 format to the image_base64 variable. |