Email & Gmail automation
Automate inbox triage, mail merges, scheduled reports, and attachment handling with Gmail and Google Apps Script.
Mail merge
Send personalised email at scale from a Sheet.
5 articles
Build a newsletter sender with open tracking
Send to a Subscribers sheet and log opens with a 1x1 tracking pixel served from a web app.
Updated Jul 15, 2025
Throttle bulk sends to stay under Gmail quotas
Batch and pace large merges across days using script properties and a daily-cap counter.
Updated Jul 8, 2025
Personalize cold outreach at scale safely
Merge from a prospect sheet with per-row custom intro lines, paced to stay clear of spam filters.
Updated Jul 1, 2025
Send a personalized renewal reminder series
Drip three escalating emails to a client before a retainer renewal date.
Updated Jun 22, 2025
Mail merge with personalized PDF attachments
Send personalised emails from a Clients sheet, each with a custom-generated PDF attached.
Updated Jun 15, 2025
Scheduled reports
Recurring email reports driven by your data.
14 articles
Send meeting follow-ups with the notes attached
After a Calendar event ends, email attendees the linked notes Doc automatically.
Updated May 19, 2026
Embed inline charts in a status email
Render a Sheets chart as an image inside the email body, not as an attachment.
Updated May 12, 2026
Send HTML email from a Google Doc template
Use a styled Doc as the source for branded, on-brand HTML email — no design tool needed.
Updated May 5, 2026
Parse bank-alert emails into an expense ledger
Convert transaction alerts from Northwind's bank into categorised spend rows automatically.
Updated Apr 28, 2026
Generate a printable address book from contacts
Export Northwind's Google Contacts to a formatted Doc you can actually print.
Updated Apr 21, 2026
Email a weekly "what changed" report from a Sheet
Diff the Projects sheet week over week and email the team the rows that changed.
Updated Apr 14, 2026
Assemble a quarterly business review by email
Combine multi-tab Northwind reports into one client-ready QBR message and send it.
Updated Apr 7, 2026
Email yourself a morning briefing
Combine today's calendar, the weather, and your task list into one 7am digest.
Updated Sep 2, 2025
Email yourself a daily inbox-zero scorecard
Count unread, awaiting-reply, and snoozed threads and email yourself a 7am scorecard.
Updated Aug 26, 2025
Email a PDF snapshot of a dashboard daily
Render a Sheets dashboard tab to PDF every morning and deliver it to stakeholders' inboxes.
Updated Aug 19, 2025
Send recurring invoice emails on the first
Generate and dispatch monthly retainer invoices from the Clients sheet on the 1st of each month.
Updated Aug 12, 2025
Generate and email weekly client status updates
Pull each client's project data and send a tailored progress note from a Doc template.
Updated Aug 5, 2025
Send birthday and work-anniversary emails
Trigger personalised greetings from an HR roster sheet on the day they fall.
Updated Jul 29, 2025
Send a weekly digest of unreplied emails
Surface inbox threads you haven't answered in a single Monday-morning summary.
Updated Jul 22, 2025
Inbox automation
Auto-label, triage, and reply to messages.
33 articles
Convert long email threads into a summary note
Collapse a thread's history into a Doc for handover — perfect for client transitions or vacation cover.
Updated Jun 6, 2026
Pull event RSVPs from emails into a Sheet
Parse yes/no replies to event invites and tally attendance automatically.
Updated Jun 2, 2026
Turn forwarded emails into project tasks
Forward to [email protected] and a row lands in the Projects sheet under the right client.
Updated May 30, 2026
Turn starred emails into a task list
Sync every starred thread into the Northwind Tasks sheet automatically.
Updated May 26, 2026
Alert when a label hits a backlog threshold
Warn the Northwind team in Slack when a Gmail label has more than N unread threads.
Updated Mar 31, 2026
Rank email templates by reply rate
Log every templated send and compute which subject lines and bodies actually earn replies.
Updated Mar 24, 2026
Notify the team when a Sheet row is marked done
Email stakeholders the instant a Projects row flips to `done`.
Updated Mar 17, 2026
Build a help-desk SLA timer from Gmail
Track first-response time per support thread and flag breaches against Northwind's 4-hour SLA.
Updated Mar 10, 2026
Build an email-to-text urgent alert channel
Push critical Gmail notifications to a phone via Twilio for moments your inbox isn't enough.
Updated Mar 3, 2026
Build a vacation-coverage auto-router
Reassign a teammate's incoming mail to a designated cover while they're away.
Updated Feb 24, 2026
Bridge a Gmail label to a Slack channel
Notify the Northwind #alerts Slack channel whenever priority-flagged email arrives.
Updated Feb 17, 2026
De-duplicate and merge your Gmail contacts
Find near-duplicate contacts in Google Contacts and consolidate them into one canonical record.
Updated Feb 10, 2026
Quarantine phishing-pattern emails
Flag suspicious sender and link patterns into a review label so they never sit in the active inbox.
Updated Feb 3, 2026
Auto-translate incoming foreign-language emails
Append an English translation as a draft reply so the team can respond fluently in the original language.
Updated Jan 27, 2026
Auto-label and route emails by language
Detect the message language and send each thread to the localised support owner.
Updated Jan 20, 2026
Pre-stage overnight draft replies for review
Run an AI drafting pass overnight so the support team starts the day with replies queued, not blank threads.
Updated Jan 13, 2026
Auto-reply to out-of-hours support emails
Detect messages arriving outside Northwind's London business hours and send a holding reply.
Updated Jan 6, 2026
Build an email-based approval system
Let managers approve Northwind expense requests by clicking a link in an email — no portal needed.
Updated Dec 23, 2025
Build a shared team-inbox triage system
Round-robin assign incoming support@ mail to teammates by labelling each thread with an owner.
Updated Dec 16, 2025
Tag VIP senders and prioritize their threads
Maintain a VIP list in a Sheet and auto-star and label their incoming mail.
Updated Dec 9, 2025
Bulk-unsubscribe from senders you never open
Score senders by open rate over 90 days and stage unsubscribe actions for the worst offenders.
Updated Dec 2, 2025
Detect bounced emails and clean your list
Read delivery-failure notices in your inbox and mark dead addresses on the Subscribers sheet.
Updated Nov 25, 2025
Chase unsigned contracts automatically
Track sent agreements in a Sheet and follow up on the ones still open with escalating reminders.
Updated Nov 18, 2025
Auto-respond to job applications with next steps
Acknowledge applicants on receipt, log them to a hiring sheet, and email the next step in the process.
Updated Nov 11, 2025
Attachments
Save, generate, and route Gmail attachments.
3 articles
Auto-forward receipts to your accountant
Route anything that looks like a receipt to a fixed address on a monthly schedule.
Updated Jun 16, 2026
Auto-file quotes and proposals you receive
Detect inbound proposal PDFs and store them in Drive by client.
Updated Jun 13, 2026
Forward attachments to Drive and reply with the link
Strip large attachments out of incoming threads, save them to Drive, and reply with the link.
Updated Jun 9, 2026