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