appscript.dev

Blog

Registros de desenvolvimento e estudos de caso — como as automações reais são feitas.

Blog Drive Sheets Gmail

How I automated my year-end accounting prep

Pulling Northwind's year together for tax season — receipts, invoices, expenses, in one folder.

Atualizado em 24 de out. de 2025

Blog Forms Sheets

How I built a customer-feedback loop with AI

Collecting, analysing, and acting on Northwind input — what used to take a quarter now takes a week.

Atualizado em 20 de out. de 2025

Blog Drive

How I migrated 10,000 files into a sane folder structure

A one-time Northwind Drive cleanup that actually stuck — naming rules enforced by script.

Atualizado em 16 de out. de 2025

Blog Sheets

How I built a team OKR tracker that updates itself

Northwind's quarterly goals wired to live data — no quarterly OKR-update meeting needed.

Atualizado em 12 de out. de 2025

Blog Sheets Calendar Gmail

How I automated grant-application tracking for a nonprofit

Deadlines, reporting, and renewals for a charity Northwind helps — never miss a submission window again.

Atualizado em 8 de out. de 2025

Blog Sheets Gmail

How I track my rental properties in one spreadsheet

Rent, expenses, and reminders for Northwind's owner's property side gig — fully self-managed.

Atualizado em 4 de out. de 2025

Blog Gmail

How I built an AI assistant that triages my inbox overnight

Sorting and drafting Northwind replies while I sleep — I wake up to a queue, not a heap.

Atualizado em 30 de set. de 2025

Blog Drive Docs

How I automated my podcast publishing checklist

From Northwind's recording to release — chapters, show notes, transcript, in one chain.

Atualizado em 26 de set. de 2025

Blog Sheets Gmail

How I built a real-time inventory system for a small shop

Stock, reorders, and alerts for Northwind's side shop — Sheets does it well enough.

Atualizado em 22 de set. de 2025

Blog Docs Sheets Gmail Drive

How I generated 200 personalized certificates in minutes

A real Northwind event-day automation — 200 attendees, 200 PDFs, sent in under five minutes.

Atualizado em 18 de set. de 2025

Blog Gmail Sheets

How I built a lightweight help desk in Gmail and Sheets

Tickets, SLAs, and reporting for Northwind — no Zendesk, no monthly fee.

Atualizado em 14 de set. de 2025

Blog Sheets

How I automated social media for a small business

Northwind scheduling posts from a content calendar — write once, ship to 4 platforms.

Atualizado em 10 de set. de 2025

Blog Sheets Gmail

How I built a goal tracker that emails me every morning

Northwind accountability on autopilot — what I committed to, what I did, side by side.

Atualizado em 6 de set. de 2025

Blog Sheets Gmail

How I digitized a paper-based approval process

Moving Northwind's print-and-sign requests into email and Sheets — same governance, no paper.

Atualizado em 2 de set. de 2025

Blog Calendar Forms Gmail

How I built an appointment-booking system for free

Calendar, forms, and email working together for Northwind — replaced Calendly with 80 lines of script.

Atualizado em 29 de ago. de 2025

Blog Sheets Gmail

How I track competitors automatically every week

A Northwind monitoring system with AI summaries — knows when rivals ship, hires, raises.

Atualizado em 25 de ago. de 2025

Blog Sheets Gmail Drive

How I automated expense reports for a 20-person team

Northwind contractors: receipts to reimbursement, hands-off — built in a week, saved everyone hours per month.

Atualizado em 21 de ago. de 2025

Blog Sheets

How I built a CRM my whole team actually uses

Keeping Northwind's pipeline simple and friction-free in Sheets — the boring tool that finally got adopted.

Atualizado em 17 de ago. de 2025

Blog Sheets Gmail

How I run a newsletter entirely from a spreadsheet

Northwind newsletter: subscribers, sending, and analytics in one place — no Mailchimp.

Atualizado em 13 de ago. de 2025

Blog Sheets

How I built a reading list that summarizes articles for me

Saving Northwind reading and digesting links with AI — a triage layer between the firehose and my brain.

Atualizado em 9 de ago. de 2025

Blog Sheets Drive Gmail

How I automated my Shopify order fulfillment

Northwind side shop: orders to packing slips to shipping labels — hands-off from cart to mailbox.

Atualizado em 5 de ago. de 2025

Blog Sheets Gmail

How I monitor 40 websites for free

A scrappy Apps Script uptime monitor for Northwind clients' sites — every 10 minutes, alerts on first failure.

Atualizado em 1 de ago. de 2025

Blog Sheets Docs

How I built an AI content pipeline in Sheets

Idea to published Northwind post, semi-automated — keyword in column A, published draft in column F.

Atualizado em 28 de jul. de 2025

Blog Sheets Docs Gmail

How I cut weekly reporting from three hours to three minutes

Automating Northwind's recurring management report — the one nobody wanted to write.

Atualizado em 24 de jul. de 2025

Blog Sheets Gmail

How I built a personal finance dashboard

Pulling every account into one live Northwind treasury view — a Sunday-afternoon build that pays itself back monthly.

Atualizado em 20 de jul. de 2025

Blog Drive Docs Gmail

How I automated my freelance client onboarding

Northwind's folders, contracts, and welcome emails in one click — from sale to setup in 30 seconds.

Atualizado em 16 de jul. de 2025

Blog Sheets Gmail

How I built a job-application tracker that chases follow-ups

Never losing a lead in the pipeline — Northwind's hiring funnel finally has memory.

Atualizado em 12 de jul. de 2025

Blog Sheets Gmail

How I replaced a $50/month SaaS tool with Apps Script

Rebuilding a paid CRM inside a spreadsheet for Northwind — saved $600/year, got exactly the features I needed.

Atualizado em 8 de jul. de 2025

Blog Gmail Sheets Docs Drive

How I automated my entire invoicing workflow

From Northwind's timesheet to a sent invoice with no manual steps — a six-week project I should have done years ago.

Atualizado em 4 de jul. de 2025

Blog Gmail Sheets

How I built a credit-card transaction tracker with Claude

Parsing Northwind's alert emails into weekly spend summaries — a weekend project, real failures, real code.

Atualizado em 30 de jun. de 2025