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