Logo and icon for Chat with GSheet, a ChatGPT plugin with description: Easily link your G Sheet and use AI to analyze your data, transform and visualize it.. Find out more on Plugin Surf, the best plugin database.

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.

Learn how to use Chat with GSheet effectively! Here are a few example prompts, tips, and the documentation of available commands.

Example prompts

  1. Prompt 1: "I want to perform analysis on the data in my Google Sheet."

  2. Prompt 2: "Can you help me link my Google Sheet to this conversation?"

  3. Prompt 3: "I need to run a query on the Google Sheet that's linked to this conversation."

Features and commands

Feature/CommandDescription
get_sheet_instructionsThis 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.
linkSheetThis command allows you to link a Google Sheet to the conversation. You need to provide the URL of the Google Sheet to be linked.
manipulateSheetThis 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.

Configuration

User authenticationNo user authentication
API documentation

For AI

Namechat_with_gsheet
DescriptionPerform analysis on G Sheet data.

Updates

First added20 June 2023

Similar plugins