🚀 SheetBase - Google Sheets as Database & AI Memory for n8n

Transform Google Sheets into a powerful database with AI Agent memory - 100% Free, No API Quotas!

✨ Key Features

✅ 100% Free Forever - No API costs, no quotas, no hidden fees
⚡ Ultra Fast - 0-1ms response with intelligent caching
🧠 AI Agent Memory - Persistent memory for chatbots
🔍 Fuzzy Search - Advanced keyword matching
👥 Collaborative - Real-time multi-user editing
🚀 Production Ready - Tested with 50,000+ rows

📦 Installation

Via n8n Community Nodes
Settings → Community Nodes → Install → n8n-nodes-sheetbase

Or manually
cd ~/.n8n
npm install n8n-nodes-sheetbase
pm2 restart n8n

text

🎯 3 Powerful Nodes

1. SheetBase (Basic)

Read data via CSV URL - Perfect for static lookups

2. SheetBase Tool (LangChain)

AI Agent tool for database queries

3. SheetBase Memory (NEW! 🧠)

AI Agent persistent memory with two modes:

• Simple Mode: Read-only CSV search
• Advanced Mode: Full CRUD with Apps Script

🚀 Quick Start

Simple Mode (2 minutes)

1. Create Google Sheet: user_name | user_id | user_preference | user_small_history | user_timestamp
2. File → Share → Publish to web → CSV
3. Copy URL to SheetBase Memory node

Advanced Mode (10 minutes)

1. Create Google Sheet
2. Extensions → Apps Script
3. Paste this code:

function doGet(e) {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const data = sheet.getDataRange().getValues();
const headers = data;
const rows = data.slice(1);

const operation = e.parameter.operation || 'search';
const userId = e.parameter.user_id || '';
const keywords = e.parameter.keywords || '';

let results = rows.map((row, idx) => {
let obj = { __row: idx + 2 };
headers.forEach((h, i) => obj[h] = row[i]);
return obj;
}).filter(r => r.user_id === userId);

if (operation === 'search' && keywords) {
const keywordList = keywords.toLowerCase().split(/\s+|,/).filter(k => k.length > 0);
results = results.filter(r => {
const searchText = JSON.stringify(r).toLowerCase();
return keywordList.some(keyword => searchText.includes(keyword));
});
}

return ContentService.createTextOutput(JSON.stringify({
success: true,
data: results,
count: results.length
})).setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const data = JSON.parse(e.postData.contents);

if (data.operation === 'create') {
const v = data.values;
sheet.appendRow([v.user_name, v.user_id, v.user_preference, v.user_small_history, v.user_timestamp]);
return ContentService.createTextOutput(JSON.stringify({ success: true })).setMimeType(ContentService.MimeType.JSON);
}

if (data.operation === 'update') {
const u = data.updates;
sheet.getRange(data.rowNumber, 3).setValue(u.user_preference);
sheet.getRange(data.rowNumber, 4).setValue(u.user_small_history);
sheet.getRange(data.rowNumber, 5).setValue(u.user_timestamp);
return ContentService.createTextOutput(JSON.stringify({ success: true })).setMimeType(ContentService.MimeType.JSON);
}

if (data.operation === 'delete') {
sheet.deleteRow(data.rowNumber);
return ContentService.createTextOutput(JSON.stringify({ success: true })).setMimeType(ContentService.MimeType.JSON);
}
}

text

4. Deploy → New deployment → Web app → Anyone → Deploy
5. Copy URL to SheetBase Memory node

💡 Use Cases

• 🤖 AI Chatbots - Remember user preferences
• 💼 CRM - Customer database without costs
• 📝 Content Management - Blog posts, documentation
• 🛍️ E-commerce - Product catalogs
• 📊 Data Collection - Forms, surveys, leads
• 🌐 IoT - Sensor data logging

⚡ Performance

Real test: 50,000 rows searched in under 1 second!

📞 Support & Contact

Created by Charles Lepoittevin

• 📧 Email: charleslepoittevin34@gmail.com
• 💼 LinkedIn: charles-lepoittevin
• 📘 Facebook: Charles Lepoittevin
• 💻 GitHub: @CharlesMagicDev

Get Help

• 🐛 Bug Reports: Open GitHub issue
• 💬 Questions: Email or LinkedIn
• ⭐ Like it? Star the repo!

📜 License

MIT License - Free for personal and commercial use

Made with ❤️ by Charles Lepoittevin
_{If SheetBase saves you time or money, consider ⭐ starring the repo!}