Curated

(5/5)

Chat with Google Sheet

Sub-workflow: Custom tool This can be called by the agent above. It returns three different types of data from the Google Sheet, which can be used together for more complex queries without returning the whole sheet (which might be too big for GPT to handle)

Integrations Used (6)

Workflow Structure (14 nodes)

100%

Langchain.chat Trigger

Chat Trigger

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.agent

AI Agent

Langchain.tool Workflow

List columns tool

Langchain.tool Workflow

Get column values tool

Langchain.tool Workflow

Get customer tool

Execute Workflow Trigger

Set

Set Google Sheet URL

Google Sheets

Get Google sheet contents

Switch

Check operation

Set

Get column names

Set

Prepare column data

Filter

Code

Prepare output

Node Types:

trigger

action

transform

code

default

logic

Requires credentials

Prerequisites

Required Credentials (2)

Google Sheets

Used by: Get Google sheet contents

Docs

OpenAI

Used by: OpenAI Chat Model

Docs

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~45 min

Score: 63/100

Custom Code

Conditional Logic

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "id": "ZVUQL1bUQ8gBCZTl",
  "meta": {
    "instanceId": "23e6ce638471979c8a2c72a9fb50e44f4f2bfd5a9fc2f5b7f5c842b9abeb9393"
  },
  "name": "Chat with Google Sheet",
  "tags": [],
  "nodes": [
    {
      "id": "89af21df-1125-4df6-9d43-a643e02bb53f",
      "name": "Execute Workflow Trigger",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        540,
        1240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
...