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.
Mis à jour le 15 juil. 2025
Throttle bulk sends to stay under Gmail quotas
Batch and pace large merges across days using script properties and a daily-cap counter.
Mis à jour le 8 juil. 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.
Mis à jour le 1 juil. 2025
Send a personalized renewal reminder series
Drip three escalating emails to a client before a retainer renewal date.
Mis à jour le 22 juin 2025
Mail merge with personalized PDF attachments
Send personalised emails from a Clients sheet, each with a custom-generated PDF attached.
Mis à jour le 15 juin 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.
Mis à jour le 19 mai 2026
Embed inline charts in a status email
Render a Sheets chart as an image inside the email body, not as an attachment.
Mis à jour le 12 mai 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.
Mis à jour le 5 mai 2026
Parse bank-alert emails into an expense ledger
Convert transaction alerts from Northwind's bank into categorised spend rows automatically.
Mis à jour le 28 avr. 2026
Generate a printable address book from contacts
Export Northwind's Google Contacts to a formatted Doc you can actually print.
Mis à jour le 21 avr. 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.
Mis à jour le 14 avr. 2026
Assemble a quarterly business review by email
Combine multi-tab Northwind reports into one client-ready QBR message and send it.
Mis à jour le 7 avr. 2026
Email yourself a morning briefing
Combine today's calendar, the weather, and your task list into one 7am digest.
Mis à jour le 2 sept. 2025
Email yourself a daily inbox-zero scorecard
Count unread, awaiting-reply, and snoozed threads and email yourself a 7am scorecard.
Mis à jour le 26 août 2025
Email a PDF snapshot of a dashboard daily
Render a Sheets dashboard tab to PDF every morning and deliver it to stakeholders' inboxes.
Mis à jour le 19 août 2025
Send recurring invoice emails on the first
Generate and dispatch monthly retainer invoices from the Clients sheet on the 1st of each month.
Mis à jour le 12 août 2025
Generate and email weekly client status updates
Pull each client's project data and send a tailored progress note from a Doc template.
Mis à jour le 5 août 2025
Send birthday and work-anniversary emails
Trigger personalised greetings from an HR roster sheet on the day they fall.
Mis à jour le 29 juil. 2025
Send a weekly digest of unreplied emails
Surface inbox threads you haven't answered in a single Monday-morning summary.
Mis à jour le 22 juil. 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.
Mis à jour le 6 juin 2026
Pull event RSVPs from emails into a Sheet
Parse yes/no replies to event invites and tally attendance automatically.
Mis à jour le 2 juin 2026
Turn forwarded emails into project tasks
Forward to [email protected] and a row lands in the Projects sheet under the right client.
Mis à jour le 30 mai 2026
Turn starred emails into a task list
Sync every starred thread into the Northwind Tasks sheet automatically.
Mis à jour le 26 mai 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.
Mis à jour le 31 mars 2026
Rank email templates by reply rate
Log every templated send and compute which subject lines and bodies actually earn replies.
Mis à jour le 24 mars 2026
Notify the team when a Sheet row is marked done
Email stakeholders the instant a Projects row flips to `done`.
Mis à jour le 17 mars 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.
Mis à jour le 10 mars 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.
Mis à jour le 3 mars 2026
Build a vacation-coverage auto-router
Reassign a teammate's incoming mail to a designated cover while they're away.
Mis à jour le 24 févr. 2026
Bridge a Gmail label to a Slack channel
Notify the Northwind #alerts Slack channel whenever priority-flagged email arrives.
Mis à jour le 17 févr. 2026
De-duplicate and merge your Gmail contacts
Find near-duplicate contacts in Google Contacts and consolidate them into one canonical record.
Mis à jour le 10 févr. 2026
Quarantine phishing-pattern emails
Flag suspicious sender and link patterns into a review label so they never sit in the active inbox.
Mis à jour le 3 févr. 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.
Mis à jour le 27 janv. 2026
Auto-label and route emails by language
Detect the message language and send each thread to the localised support owner.
Mis à jour le 20 janv. 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.
Mis à jour le 13 janv. 2026
Auto-reply to out-of-hours support emails
Detect messages arriving outside Northwind's London business hours and send a holding reply.
Mis à jour le 6 janv. 2026
Build an email-based approval system
Let managers approve Northwind expense requests by clicking a link in an email — no portal needed.
Mis à jour le 23 déc. 2025
Build a shared team-inbox triage system
Round-robin assign incoming support@ mail to teammates by labelling each thread with an owner.
Mis à jour le 16 déc. 2025
Tag VIP senders and prioritize their threads
Maintain a VIP list in a Sheet and auto-star and label their incoming mail.
Mis à jour le 9 déc. 2025
Bulk-unsubscribe from senders you never open
Score senders by open rate over 90 days and stage unsubscribe actions for the worst offenders.
Mis à jour le 2 déc. 2025
Detect bounced emails and clean your list
Read delivery-failure notices in your inbox and mark dead addresses on the Subscribers sheet.
Mis à jour le 25 nov. 2025
Chase unsigned contracts automatically
Track sent agreements in a Sheet and follow up on the ones still open with escalating reminders.
Mis à jour le 18 nov. 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.
Mis à jour le 11 nov. 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.
Mis à jour le 16 juin 2026
Auto-file quotes and proposals you receive
Detect inbound proposal PDFs and store them in Drive by client.
Mis à jour le 13 juin 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.
Mis à jour le 9 juin 2026