Analyze Google Sheets Data with OpenAI Data Agent

n8n Data Management Analytics AI

Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.

Welcome to Ozki Your Data Analyst Agent V1.

The Ozki Data Analyst Agent is designed to analyze data from Google Sheets. To use it, you'll need to provide the URL of your Google Sheet file. The agent will then process the data and provide you with analysis results, including key performance indicators (KPIs).

Configuration:

- Configure your credentials on the OpenAI model or select the n8n free OpenAI credits.

- Set up your agent memory. Use Simple Memory as default.

- Set your credentials to Google Sheets. Log in with the Google Sheet tool.

Instructions:

Start with a "Hi" to get the instructions.

Ozki needs your Google Sheet URL, which you can get from the address bar of your browser when you have the file open.

Follow the conversation with Ozki for your data analysis results.

Tools used: OpenAI, Google Sheets

Download the workflow template (JSON)

Original tutorial

Want this running in your business? KOBA42 builds and operates automations like this one.