appscript.dev

Blog

Registros de desarrollo y casos prácticos: cómo se crean las automatizaciones reales.

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.

Actualizado 24 oct 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.

Actualizado 20 oct 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.

Actualizado 16 oct 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.

Actualizado 12 oct 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.

Actualizado 8 oct 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.

Actualizado 4 oct 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.

Actualizado 30 sept 2025

Blog Drive Docs

How I automated my podcast publishing checklist

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

Actualizado 26 sept 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.

Actualizado 22 sept 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.

Actualizado 18 sept 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.

Actualizado 14 sept 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.

Actualizado 10 sept 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.

Actualizado 6 sept 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.

Actualizado 2 sept 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.

Actualizado 29 ago 2025

Blog Sheets Gmail

How I track competitors automatically every week

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

Actualizado 25 ago 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.

Actualizado 21 ago 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.

Actualizado 17 ago 2025

Blog Sheets Gmail

How I run a newsletter entirely from a spreadsheet

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

Actualizado 13 ago 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.

Actualizado 9 ago 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.

Actualizado 5 ago 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.

Actualizado 1 ago 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.

Actualizado 28 jul 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.

Actualizado 24 jul 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.

Actualizado 20 jul 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.

Actualizado 16 jul 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.

Actualizado 12 jul 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.

Actualizado 8 jul 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.

Actualizado 4 jul 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.

Actualizado 30 jun 2025