Just learnt this about Google Sheets - hope this helps someone!

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.

27 comments