A client needed their payroll automated — they track teacher hours and lessons in another system, and wanted pay calculated and updated in Google Sheets automatically. Normally, I’d spin this up through n8n, but today I found out about Google Apps Script. Turns out, it’s perfect for this - you can host your code directly inside Sheets, make API requests, run calculations, triggers every Monday at 9am, and automate everything natively. Built the whole workflow and deployed it for free, no extra tools or subscriptions needed.

RAG Excel Out of memory issue Hi guys, have been stuck on this issue for a few days now using google sheets as the data base for rag etc and wanted to ask: 1. I keep running into Out of memory in n8n when sending my excel data (around 2k lines) and dont know how to curb this problem. 2. Whenever querying using abbreviation from word, doc pdfs it works very well. But when asked using the database the rag fails miserably any idea how to curb these issues. E.g. The product name is NORDICTRACK X32i 40% INCLINE 6.5CHP 22” HD iFIT-ENABLED TOUCHSCREEN BLUETOOTH HEART-RATE MONITORING SMART TREADMILL. but when you ask it for x32i touchscreen it returns as no result found.