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