(G) LineChatBot + Google Sheets (as a memory)

Automated workflow: (G) LineChatBot + Google Sheets (as a memory). This workflow integrates 9 different services: webhook, stickyNote, httpRequest, code, lmChatGoogleGemini. It contains 24 nodes and follows best practices for error handling and security.

Workflow Structure (9 nodes)
100%
Webhook
Webhook
Set
Edit Fields
Google Sheets
Get History
Set
Prepare Prompt
No Op
AI Agent
No Op
Google Gemini Chat Model
Code
Split History
Google Sheets
Save History
Http Request
HTTP Request
Node Types:
trigger
default
transform
http
action
code
Requires credentials

Prerequisites

Required Credentials (2)

Google Palm

Used by: Google Gemini Chat Model

Docs

Google Sheets

Used by: Get History, Save History

Docs

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~35 min
Score: 48/100
Custom Code
4 Integrations

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": "[CENSORED]",
  "meta": {
    "instanceId": "workflow-06e6d19b",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:43.642905",
    "updatedAt": "2025-09-29T07:07:43.642919",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "(G) LineChatBot + Google Sheets (as a memory)",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...

Workflow Details

Nodes
17
Trigger
Webhook
Source
community
Added
Sep 29, 2025

Need Help?

Check out the official n8n documentation for detailed guides.

Related Workflows

Obsidian Notes Read Aloud: Available as a Podcast Feed

Send Notes to Webhook Setup: - Install [Post Webhook Plugin](https://github.com/Masterb1234/obsidian-post-webhook/) in O...

Openai
Webhook
Http-request
Google-sheets
23 nodesWebhook
Curated

Line Save File to Google Drive and Log File's URL

Automated workflow: Line Save File to Google Drive and Log File's URL. This workflow integrates 9 different services: we...

Google-sheets
Google-drive
Http-request
Webhook
27 nodesWebhook

AI-Generated Summary Block for WordPress Posts - with OpenAI, WordPress, Google Sheets & Slack

Automated workflow: AI-Generated Summary Block for WordPress Posts - with OpenAI, WordPress, Google Sheets & Slack. This...

Webhook
Schedule
Http-request
Google-sheets
32 nodesWebhook

AI-Generated Summary Block for WordPress Posts - with OpenAI, WordPress, Google Sheets & Slack

Automated workflow: AI-Generated Summary Block for WordPress Posts - with OpenAI, WordPress, Google Sheets & Slack. This...

Webhook
Schedule
Http-request
Google-sheets
32 nodesWebhook

Dialpad to Syncro

Production-ready workflow: Dialpad to Syncro. This workflow has been optimized for production use with comprehensive err...

Http-request
Webhook
Google-sheets
23 nodesWebhook

Webhook Workflow

Automated workflow: Webhook Workflow. This workflow integrates 7 different services: webhook, stickyNote, httpRequest, s...

Webhook
Google-sheets
Http-request
8 nodesWebhook