AI Agents

Automate Google Sheets

11 nodes 236 154 Webhook
Download

Workflow Description

This template integrates an intelligent agent with Google Sheets, receiving requests via webhook, processing them with natural language understanding and contextual memory, then writing results directly to the spreadsheet. Supports semantic search via vector database.

How it works

  1. 1.Receive webhook request and convert to processable text format
  2. 2.Split text and convert to semantic vectors using Cohere embeddings
  3. 3.Search Pinecone database and query Hugging Face model while maintaining context
  4. 4.Write results directly to Google Sheets

Use cases

  • Process queries related to data and automatically log results to a centralized sheet
  • Build a smart search engine that connects multiple data sources and records findings in a table

Requirements

  • Cohere API key and configured Pinecone vector database
  • Google account with accessible spreadsheet

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Text Splitter Embeddings Vector Store Memory Lm Chat Hf AI Agent Google Sheets

Details

Trigger Webhook
Nodes 11
Apps 7
Views 236
Downloads 154

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (11)

/

Sticky

Sticky Note

#1

Webhook

Webhook

#2

Splitter

Text Splitter Character Text Splitter

#3

Embeddings

Embeddings Cohere

#4

Insert

Vector Store Pinecone

#5

Query

Vector Store Pinecone

#6

Tool

Tool Vector Store

#7

Memory

Memory Buffer Window

#8

Chat

Lm Chat Hf

#9

Agent

Agent

#10

Sheet

Google Sheets

#11