Google Sheet Smarter with AI Sheeter 

Google Sheets is a powerful and smart tool for data analysis, integration of AI Add-ons makes it even smarter. AISheeter is an AI-powered add-on that integrates large language models like ChatGPT, Claude, GROQ, and Gemini to automate spreadsheet tasks. These add-ons help to integrate LLM without writing any code. In this article, we will show how you can make Google Sheets smarter with AISheeter.

Step 1: Install AISheeter

• Open Google Workspace Marketplace >> search for AISheeter.
• Click Install and grant the necessary permissions.

Step 2: Set Up AI Sheeter

After installation, set up the AI Sheeter in Google Sheets.

• Go to the Extensions tab >> select AISheeter >> click on Show Sidebar.
• AI Sheeter will appear in the task pane. You can explore the options.

• Select Settings >> Insert your API key >> select Model >> click on Save All Settings.

You can use any API key for the LLM you wish to use. We are going to use OpenAI’s API for ChatGPT. To get OpenAI’s API key you can follow the provided steps here.

AISheeter works as an interface to analyze data or answer questions by using LLM. You can use ChatGPT, Clause, and Gemini LLM in the Google Sheets.

Step 3: Using AISheeter in Google Sheet

Let’s consider E-Commerce customer feedback data to perform some analysis using AISheeter. This will help you analyze data and provide insights like trends, anomalies, or summaries.

1. Classify the Customer Feedback in Percentage

Let’s use the AISheeter with the ChatGPT function to analyze customer feedback and categorize it into positive, neutral, and negative reviews.

• Select cell K2 to use the ChatGPT model through AISheeter.
• Insert the following prompt in the cell.

Formula:

=ChatGPT("Give me only the percentage of customer feedback from the following reviews (positive, neutral, negative): " & TEXTJOIN(", ", TRUE, J2:J51))

This formula will send the customer feedback from column J2:J51 to ChatGPT for analysis and requests only the percentage breakdown of reviews into positive, neutral, and negative categories.

Explanation:

• TEXTJOIN: It combines all feedback from cell J2:J51 into a single string, separated by commas.
• ChatGPT: Calls the AI to process the provided data.
• Prompt: The prompt explicitly asks for percentages, ensuring focused output without extra details.

Output:

2. Analyze Sales Performance

To generate a prompt specifying the Price, Quantity, and Region columns to analyze the sale performance, you will need to use additional ARRAYFORMULA to pass the information in the ChatGPT model.

• Insert a new column.
• Select cell L2 and insert the following formula.

Formula:

=ARRAYFORMULA("Price: " & E2:E51 & ", Quantity: " & F2:F51 & ", Region: " & G2:G51)

This formula will concatenate the result for each row from 2 to 51 and return the concatenated result specifying the column name with the cell value.

Output:

Let’s use the AISheeter to analyze the sales performance.

• Select cell M2 and insert the following formula.

Formula:

=ChatGPT("Analyze Sales Performance based on the given data: Price, Quantity, and Region for the range " & TEXTJOIN(", ", TRUE, L2:L51) & " and return only the summarized values, no additional text.")

This formula uses ChatGPT to analyze sales performance based on the Price, Quantity, and Region and asks for only summarized results without additional text.

• TEXTJOIN: This function concatenates all the values in L2:L51 and passes them in a format that ChatGPT can recognize.
• Prompt: The text is structured to guide the model in summarizing values, ensuring that only summarized data (such as averages, totals, or insights) is returned.

Output:

3. Analyze Sales Performance to Provide Insight and Report

Let’s perform an advanced analysis based on all the key metrics like Product, Price, Quantity, Region, Ranking, Feedback, etc.

• To concatenate the column values, insert the following formula in cell N2.

Formula:

=ARRAYFORMULA(C2:C51 & "Price: " & E2:E51 & ", Quantity: " & F2:F51 & ", Region: " & G2:G51 &", Rating: " & H2:H51 & ", Feedback: " & J2:J51 &")")

This formula will concatenate all the values along with the column name.

Output:

• For advanced analysis, we will generate a long prompt.
• Insert the following formula in cell O2.

Formula:

=ChatGPT("Analyze the sales performance based on the following data: Product Name, Quantity, Region, Price, Rating, and Customer Feedback. The data is as follows " & TEXTJOIN(", ", TRUE, N2:N51) & " and provide insights on product and regional top performance, and suggest improvement strategies with no additional text.")

This formula prompts ChatGPT to analyze the sales performance using the range N2:N51. It requests insights into the top-performing products and regions, along with improvement strategies, while ensuring no additional text is included in the response.

Output:

As it is an advanced analysis it will cover overall metrics and insight.

Product Performance:

Regional performance:

Improvement Strategies:

Things to Remember

• You can generate text-based results easily. Insert the prompt and mention the cell reference in the ChatGPT function.
• To refer to cell reference for analysis or calculation you need to ensure that AI Sheeter recognizes your cell reference and processes it correctly.
• AISheeter is an interface for sending requests to GPT models, so the data must be passed correctly as arguments.
• AISheeter response mainly depends on the prompts. Use clear and concise prompts to get accurate responses.
• Verify AI-generated results with actual results to ensure accuracy.

Conclusion

AISheeter is a useful add-on to use Google Sheets more efficiently. Users can easily integrate LLM with Google Sheets by using the API keys.  It automates repetitive tasks, provides deeper insights, and simplifies complex data analysis. By generating effective prompts, you can handle small projects or large datasets, AISheeter enhances productivity by making your spreadsheets smarter.