Walkthrough: How to Use Google Sheets on Cognis
Welcome to the walkthrough of using Google Sheets on Cognis. If you’re new here, Cognis is a Multi-LLM Agentic Ai System that allows you to leverage AI intelligence to execute tasks through clicks and prompts. It doubles down as a centralised workspace for all your work-related actions. Visit Cognis Ai to know more about Cognis.
In this walkthrough, we’re going to break down the step-by-step process of:
- Installing the Google Sheets integration,
- Setting it up,
- And how to launch and use it.
So let’s dive straight into it.
Pre-Setup: Getting Started with Cognis
So in the first step, you fire up Cognis by either registering or logging in via this link.
To register, please follow these steps:
- Fill in your details
- Log in after your registration is complete
- Verify your email address
- Access Cognis
- Click on Setup Instantly to Configure the best LLMs in a single click
You can begin with the free tier of Cognis without having to submit any kind of payment information.
Step 1: Installing and Setting Up the Google Sheets Integration
Once you land on Cognis, you can follow the steps below to install the Content Writing Assistant:
- On the lower left side, click on the ‘Explore Integrations’ tab
- On the integrations page, the second integration is Google Sheets
- Click on the ‘install’ button on the Google Sheets Integration to complete the installation
- After it’s installed successfully, click on the ‘Settings’ button at the bottom right side
- Click on ‘My Connected Apps,’ and once the page opens, you’ll find ‘User Setup Pending’ on the Google Sheet card
- Then click on the gear symbol on the Google Sheet card to begin the setup
- Click on ‘User Setup’ and in the next pop-up screen, click on ‘Attach Connector’
- Now, on the Configure Data Source Page, click on ‘Add New Data Source’
- Choose ‘Google Sheets’ and the ‘Next’ button on the bottom left
- To use the Connector, you’ll need to configure your Third Party Account by clicking on the ‘Configure Third Party Account’ button
- In the ‘Provider’ page, choose ‘Google’ from the dropdown
- Then click the ‘Link Account’ Button
- Authenticate your chosen account through Google
- Once done, you’ll be taken back to the Configure page.
- In case you see a cross symbol beside the email address of your Third Party Account, click ‘Re-Authorize’ to complete authorization
- Enter the name for the connector in the box at the top (Example name: My Sheets Account)
- Check the box next to your email ID
- Then click ‘Submit’ at the bottom left corner
- On the ‘Configured Data Sources’ Screen, click on the Google Sheet card
- Then click the button ‘Attach Connector’
- The Google Sheet card on the My Connected page will show “User Setup Completed’
Step 2: Launching the Google Sheet Integration on Cognis
To launch the Google Sheet integration on Cognis, you can use a couple of methods as follows:
- Direct Prompt: You can directly prompt Cognis with a related prompt that mentions Google Sheets. For example, I want to analyze my last quarter sales report sheet/Google Sheet
- Using the Direct to Button: The direct to button located on top of the right-hand side of the chatbox helps in guiding Cognis to open your integration in case it’s missed. Follow the steps below:
- Click on the ‘Direct to’ button located on the right side, just above the chatbox
- Choose ‘Google Sheets’
- Then, enter your prompt to directly send the prompt to the Google Sheets integration via Cognis
Once you send across your first prompt, Cognis responds by asking you to select a Sheet. Click on the ‘Select Sheet’ button to open the sheet selector and pick your sheet.
Then Cognis will analyze the sheet and ask you to select a subsheet. Click on the subsheet you want to access from the options presented by Cognis.
Step 3: How to Use Cognis’ Google Sheets Integration
Once you’ve selected the sheet you want to operate on, you can ask Cognis for a number of operations.
Let’s take an example workflow and find out how Cognis works in practice. (You can watch the interactive demo below for a clearer understanding.)
Example: Analyze my last Quarter’s Sales Report and highlight the top-performing designs and regions and their correlations
The steps you have to undertake in Cognis are as follows:
- Prompt Cognis with ‘Analyze my Google Sheet’
- Select the correct sheet by clicking on the ‘Select Sheet’ button
- Select the correct corresponding Sub-sheet by clicking on the options Cognis provides
- Once Cognis finishes analyzing the sub-sheet, enter your actual task/action you want Cognis to perform. In this example, we say ‘Analyze my last Quarter’s Sales Report and highlight the top-performing designs and regions and their correlations’
- You can click the ‘Preview Sheet’ button at the top right corner to preview the sheet in its native interface
- Cognis also provides drop-down table views of the new data that it wants to add, and asks for your confirmation
- If you’re satisfied with the result, click on the ‘Proceed’ button to add the newly analyzed rows and data to your Google Sheet
- Cognis automatically updates the requested analysis of our example in the Google Sheet directly
Switching LLMs and Using Branching on Cognis while using Google Sheets
One of Cognis’ core functionalities is the ability for users to switch between LLMs seamlessly, whether at the beginning of a chat or at the message level. When you switch LLMs, a new branch is created, which initiates a new chat but stores the chat with the previous LLM in Cognis’ history. Allowing you to A/B test responses and find the one that fits your task perfectly.
There are two ways to use the Multi-LLM and Branching in Cognis.
1. Switching Models for the same chat for different tasks
You can switch between different models for a specific set of tasks. For example, in the same chat branch, you can switch between GPT 5 for writing and Gemini 2.5 Pro for analyzing big sets of data.
In this scenario, a new branch is not created. How to use this:
- Click on the Button at the top right side of your chat window where the Model Name is written
- Access the list of models from the drop-down and select a different model
- Once you’ve selected the new model, continue your chat as usual with the new model
You can switch back to the previous model using the same process again, or you can switch to a different model. In this scenario, you can switch between as many models as you’d like.
2. Creating Branches with Different Models to A/B Test Responses
You can switch between different models to A/B test and check the response quality of the respective models in the same chat window. A new branch is created each time you switch a model.
For example, you can use GPT 5 and Gemini 2.5 Pro to conduct the same data analysis to check which model did a better job.
In this scenario, each model change leads to the creation of a new branch in the same chat window. How to use this feature:
- Below your message to Cognis, you’ll find a four-star icon made of four circles; click it to open the model selector
- Choose the model you want to switch to and click on the model name from the drop-down
- The message is automatically resent to the new model, and Cognis creates a demarcation of the moment in the chat where you branched with numbered options for accessing each respective branch
- You can click on the branch numbers to switch between different model responses
- You can continue the chat, and beside each response sent by Cognis, a branch icon appears, which, when clicked, will take you back to the origin point of when you branched the last time during the chat
Get started with Cognis Ai here and make Google Sheets operations a cakewalk!
Frequently Asked Questions
Cognis is a workflow automation platform and AI chat assistant built to simplify your worklife. It uses Agentic AI and intelligent agents to automate repetitive tasks, create complete workflows, and act as your artificial intelligence personal assistant. With features like intuitive UI, near-zero hallucination for LLMs, and support for multiple AI models, Cognis combines the best of AI and automation into a single interface.
You can use multiple LLMs inside Cognis AI. The platform is designed as a multi-LLM orchestration layer, so you’re not locked into one provider. Supported LLMs include OpenAI models (GPT-5, GPT-4o, GPT-4 Turbo, GPT-3.5 series, o-mini family). Anthropic Claude models (Claude 3.5 Sonnet, Claude 3 Opus, Claude 3 Haiku) Google Gemini models (Gemini 1.5 Pro, Gemini 1.5 Flash), DeepSeek (latest V3 and V3.1 reasoning models) and more models to be added soon.
Most AI apps or automation apps are single-function. Cognis combines AI chat, agent software, and workflow automation platform capabilities in one. Instead of juggling multiple AI programs or AI tools free/paid, you get one artificial intelligence app where agentic AI manages context, memory, and execution/
Indie Builders who hate administrative work. Startups with small teams and big dreams. Professionals needing a chatgpt AI assistant or artificial intelligence personal assistant. Developers who want to create an AI or experiment with AI programs in one place. Enterprises wanting to level up by automating workflows without the hassle of 2 AM 'nothing's working with the other' calls.
Yes. Cognis includes monitoring to reduce AI bias across Chat GPT-4, Chat GPT-3.5, and other best AI models. It helps ensure fair, transparent outputs when you use it as your AI assistant or automation app.
External References
- Cognis Ai (Beta) is live now. Explore the power of a Multi-LLM Agentic Ai platform that reduces your work time by 5x. Read the Launch Note.
Walkthroughs
Contact Us
Fill up the form and our team will get back to you within 24 hrs