appscript.dev

Blog

Journaux de développement et études de cas — comment naissent les automatisations.

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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 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.

Mis à jour le 29 août 2025

Blog Sheets Gmail

How I track competitors automatically every week

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

Mis à jour le 25 août 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.

Mis à jour le 21 août 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.

Mis à jour le 17 août 2025

Blog Sheets Gmail

How I run a newsletter entirely from a spreadsheet

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

Mis à jour le 13 août 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.

Mis à jour le 9 août 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.

Mis à jour le 5 août 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.

Mis à jour le 1 août 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.

Mis à jour le 28 juil. 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.

Mis à jour le 24 juil. 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.

Mis à jour le 20 juil. 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.

Mis à jour le 16 juil. 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.

Mis à jour le 12 juil. 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.

Mis à jour le 8 juil. 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.

Mis à jour le 4 juil. 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.

Mis à jour le 30 juin 2025