106 n8n Gmail + Google Sheets automations
Every free, copy-paste n8n recipe that connects Gmail and Google Sheets in one workflow. Each is a ready-to-run AI agent — import it, connect both accounts, and it runs 24/7. No code, no signup. See all Gmail or Google Sheets recipes.
Browse 106 recipes →
Build Youth Sports Schedules That Avoid Family Conflicts
Youth sports schedulers create nightmares when siblings' games overlap and families can't attend. Build schedules that respect field availability, referee assignments and family conflicts.
Prep Winery Tasting Flights From Reservation Preferences
Wineries run tastings blind to guest preferences, wasting rare pours and missing sales. Collect tasting preferences at reservation and prep each flight for the party.
Turn Wholesale Bagel Orders Into Tonight's Production Sheet
Cafés email bagel orders until 9pm and the mixer starts at 2am. Aggregate the night's wholesale orders into a production sheet the overnight baker bakes from.
Deliver Well Water Test Results With Plain-English Explanations
Well water lab reports read like chemistry homework. Send results automatically with an AI plain-English summary of what's fine, what's borderline, and what needs action.
Keep Volunteer Background Checks Current Across Your Organization
Organizations serving vulnerable populations need current background checks on every volunteer, and lapsed ones are a liability. Track each check's expiry and drive renewals before they lapse.
Alert Landscapers When the Trees They Want Are Available
Wholesale tree nurseries and landscapers miss each other on availability, losing sales on specific specimens. Match landscaper want-lists to nursery availability and alert on matches.
Match Translation Jobs to Available Linguists by Language and Field
Translation agencies waste hours matching each job to a linguist with the right language pair, subject expertise and availability. Auto-match jobs to qualified available linguists.
Never Let a Termite Bond Lapse — Renew Every Customer on Time
Termite bonds renew annually and lapsed ones are lost recurring revenue plus angry claim-time customers. Track every bond and drive renewals with escalating reminders.
Manage Swim Team Meet Entries and Qualifying Times
Swim coaches manually track qualifying times and build meet entries, a slow error-prone chore. Track swimmer times and auto-suggest optimal meet entries within the rules.
Celebrate Swim Level-Ups With Parents the Day They Happen
A kid passes a swim level and the parent hears nothing for weeks. Notify parents the day of the level-up with what it means and next-session enrollment.
Chase Subcontractor Insurance Certificates Before They Lapse On-Site
A sub working with lapsed insurance makes their claim your claim. Track every sub's certificate expiry and chase renewals before they set foot on site uncovered.
Trigger Solar Panel Cleaning When Production Drops
Solar panel cleaning services chase customers who don't realize dirty panels are costing them. Detect production drops signaling dirty panels and reach out with data-backed cleaning offers.
Manage Self-Storage Delinquency Through the Legal Lien Timeline
Self-storage operators must follow strict legal timelines for delinquent unit lien sales, and missteps void the sale. Track each delinquent unit through the required notice and lien-sale timeline.
Rehire Last Summer's Best Seasonal Staff Before Competitors Do
Every season starts with a hiring scramble — while last year's trained stars wait uninvited. Reach out to top former seasonal staff first with early rehire offers.
Track Diver Course Progression and Prompt the Next Certification
Dive shops certify open-water divers who then never advance, missing continued-education revenue. Track each diver's certifications and prompt the next course at the right moment.
Route Scholarship Applications to Reviewers by Category and Load
Scholarship committees drown in applications that must be distributed fairly to reviewers by category and balanced load. Auto-route each application to the right reviewers with balanced assignment.
Automate Scheduled Maintenance Notices Across Every Channel
Scheduled maintenance means posting to the status page, emailing customers and updating Slack — usually done inconsistently. Announce maintenance once and broadcast it everywhere on schedule.
Predict Which Net-Terms Invoices Will Pay Late and Nudge Early
B2B net-terms invoices pay late from predictable customers, hurting cash flow. Score each invoice's late-payment risk from customer history and nudge the risky ones early.
Convert High Radon Tests Into Mitigation Jobs With Careful Follow-Up
Homeowners get a scary radon number, then freeze. Follow up high results with a calm explanation, health context and a mitigation quote — most competitors never call back.
Dispatch Property Management Work Orders to the Right Vendors Fast
Property managers bottleneck maintenance by manually routing each work order to a vendor. Auto-route work orders to the right vendor by trade and property, keeping tenants happy.
Manage Recurring Commercial Pressure Washing Contracts
Commercial pressure washing thrives on recurring contracts, but scheduling them by memory means missed cycles. Track each commercial contract's frequency and auto-schedule the recurring service.
Schedule Pool Openings and Closings Without the Spring Phone Rush
Every pool owner calls the same two weeks each year. Pre-book openings and closings from last year's list and confirm dates automatically — no phone rush.
Send Parking Permit Renewal Notices Before They Lapse
Parking operations lose recurring permit revenue when permit holders forget to renew and just stop paying. Send renewal notices before permits lapse to retain permit holders.
Track Orchard Chill Hours to Predict Bloom and Plan Labor
Fruit trees need accumulated chill hours to bloom well, and growers guess at timing. Track chill hour accumulation and predict bloom timing to plan pollination and labor.
Replenish Office Coffee Service by Actual Consumption
Office coffee clients either run dry (angry) or drown in stock (cancel service). Track each office's real consumption pace and deliver exactly when their supply runs low.
Manage Recital Sign-Ups and Piece Approvals for Music Studios
Music studios coordinate recital pieces and running order across many students by email chaos. Collect piece choices, approve them, and build the running order automatically.
Send Chefs Your Weekly Mushroom Availability Before They Menu-Plan
Specialty mushroom yields vary weekly and chefs plan menus Sunday. Blast your real availability list — varieties, weights, price — right before menu planning.
Give Moving Clients a Utility Transfer Checklist and Reminders
People moving forget to transfer utilities and arrive to no power or internet. Send a personalized utility transfer checklist with timed reminders for their specific move.
Run a Motorcycle Winterization Campaign Before the Cold
Motorcycle shops go dead in winter, but bikes need winterization service first. Remind riders to book winterization before storage, filling the pre-winter weeks.
Tell Students the Moment They're Eligible for Belt Testing
Belt tests require attendance counts and time-in-rank nobody tracks well. Compute eligibility automatically and invite students the moment they qualify.
Place Language Students in the Right Class From a Placement Test
Language schools mis-place students who then quit from boredom or overwhelm. Auto-score placement tests and route each student to the class that fits their real level.
Track Plant Warranties and Schedule Replacement Visits
Landscapers warranty plants but lose track of which died within warranty, eating replacement costs unfairly or losing goodwill. Track plant warranties and handle replacement claims cleanly.
Track Electrical Safety Certificates Across Every Rental Property
Landlords must renew electrical safety certificates on strict cycles, and a lapsed one voids insurance. Track every property's certificate and book the electrician before expiry.
Keep Janitorial Supplies Stocked With Par-Level Reordering
Janitorial companies run out of supplies at sites mid-shift, disrupting cleaning. Track supply consumption per site and reorder at par levels so crews never run dry.
Motivate Riding Students With Progress Badges and Level-Ups
Riding schools lose students who don't feel progress between lessons. Track skills mastered and award progress badges that keep students and parents engaged and enrolled.
Dispatch Home Warranty Claims to the Right Contractor in Minutes
Warranty claims bounce between call centers and contractors for days. Route each new claim to the matching trade contractor instantly with the full claim context.
Batch Small Handyman Jobs by Neighborhood to Kill Windshield Time
Driving 40 minutes for a 20-minute job kills handyman margins. Hold small jobs briefly and batch them by neighborhood, offering customers a discounted batch day.
Manage Gymnastics Meet Registration and Session Assignments
Gymnastics meets involve complex registration by level, session and event that overwhelms host clubs. Handle registration and session assignments automatically for smooth meets.
Offer Gutter Guard Clients Seasonal Inspection Add-Ons
Gutter guard installers do a one-time job and miss the recurring inspection revenue guards still need. Offer past install clients seasonal inspections to catch issues and drive recurring visits.
Bring Garage Door Customers Back for Their Annual Tune-Up
A garage door needs annual spring and safety checks nobody schedules. Recall each install and repair customer at the twelve-month mark with a tune-up booking link.
Split Aggregated Food Hub Orders Back to Source Farms
Food hubs aggregate orders from many buyers and must split them back to source farms for fulfillment. Automate the split so each farm gets its exact pick list.
Schedule Workplace First Aid Kit Restocking on Compliance Cycles
Workplace first aid kits must be stocked and in-date for compliance, but nobody tracks each client's cycle. Schedule restocking visits per client and per kit's inspection cycle.
Take Firewood Orders in August and Own the Winter Season
Firewood sellers scramble every October. Invite last year's buyers to reserve their cords in late summer with early pricing, and plan deliveries from a full order book.
Assign Farmers Market Stalls by Category and Vendor Seniority
Farmers market managers reassign stalls weekly around no-shows, category balance and seniority — a headache every Friday. Automate stall assignments respecting all the rules.
Coordinate Farm-to-School Orders Across Districts and Seasons
Selling to school districts means bid sheets, seasonal availability and rigid delivery windows. Manage district orders against your harvest calendar in one coordinated flow.
Notify Distributor Customers About Backorders Before They Chase
Distributors let customers discover backorders when the order doesn't arrive, breeding frustration and calls. Proactively notify customers of backorders with expected dates and alternatives.
Deliver and Track License Keys for Every Digital Product Sale
Selling software or templates means delivering unique license keys and fielding lost-key emails. Auto-deliver a unique key per sale and let buyers self-recover it anytime.
Tell CSA Members What's in the Box — and Let Them Swap in Time
CSA members hate surprise kohlrabi. Announce each week's box contents a few days early with a swap window, and pack from the final counts.
Streamline Craft Fair Vendor Applications and Jury Scoring
Craft fair organizers drown in vendor applications that need juried scoring by category and quality. Collect applications and route them to jurors with balanced, category-aware scoring.
Keep Certified CPR and First Aid Students Renewed on Time
CPR and first aid certifications expire on cycles, and lapsed ones mean lost renewal revenue and uncertified people. Remind past students before their certification expires with renewal booking.
Track Professional CE Credits So No License Ever Lapses
Licensed professionals must earn continuing education credits by strict deadlines or lose their license. Track each person's credit progress against requirements and prompt before shortfalls.
Fill Your Chimney Sweep Calendar Before the First Cold Snap
Every chimney sweep gets slammed in October and starves in August. Invite last year's customers to book their annual sweep in late summer with early-bird slots.
Book the 11-Month Warranty Walkthrough Before Coverage Expires
New-build warranties expire at one year, and most homeowners never claim fixable defects. Offer an 11-month walkthrough that catches everything while the builder still pays.
Confirm Blind and Shade Measurements Before Ordering
Custom blind installers order wrong-sized blinds from measurement errors that can't be returned. Confirm every measurement before ordering custom blinds to eliminate costly mistakes.
Report Retainer Hours So Clients See Value and You Get Paid
Retainer clients forget the value they're getting and question the invoice, while unused hours cause rollover disputes. Send a monthly retainer report showing hours used, value delivered and rollover.
Send ABA Parents a Weekly Progress Summary They Can Understand
ABA data lives in clinical graphs parents can't read. Translate each week's session data into a plain-language progress note parents actually understand and keep.
Auto-Email Suppliers a Reorder When WooCommerce Stock Runs Out
When a WooCommerce product hits zero stock, automatically email the assigned supplier a purchase request with the SKU and reorder quantity.
Draft Purchase Orders Automatically When Warehouse Stock Runs Low
Keep shelves stocked without spreadsheets — when inventory dips below its reorder point, auto-draft a purchase order to the right supplier for review.
Assign Volunteer Shifts and Send Reminders Automatically
An n8n workflow that takes volunteer sign-ups, assigns them to open shifts, confirms by email, and reminds them the day before — so coordinators fill the schedule and reduce volunteer no-shows without a chain of manual messages.
Remind Pet Owners When Vaccines Are Due
Keep pets protected and appointments booked by reminding owners a few weeks before each vaccine's due date, with a one-tap way to schedule.
Collect Vendor Onboarding Documents Automatically and Chase Missing Ones
An n8n workflow that sends each new vendor a request for their W-9, insurance and banking details, tracks what comes back, and automatically chases whatever is missing after a few days — so procurement onboards suppliers without a spreadsheet of half-finished paperwork.
Automate Three-Way Matching of Supplier Invoices
Stop paying wrong invoices — automatically match each supplier invoice against its purchase order and goods receipt, flagging any discrepancy.
Re-Engage Online Students Who Haven't Logged In for Two Weeks
An n8n workflow that spots students who've gone quiet for two weeks mid-course and sends a warm, specific nudge that points to their next lesson — recovering learners before they drift away for good and ask for a refund.
Monitor Your Customers' Webhook Endpoints for Failures
Reduce integration support load by monitoring the health of customer webhook endpoints and proactively alerting those whose endpoint is failing.
Keep a Live Referral Leaderboard and Reward Top Advocates
Gamify referrals — maintain a live leaderboard of your top referrers and automatically reward the leaders each month to keep advocacy high.
Calculate and Notify Affiliates of Their Monthly Payouts
Pay affiliates accurately by calculating each one's qualified conversions and commissions monthly, then sending a clear payout statement.
Auto-Generate and Email Branded PDF Reports to Clients Monthly
Deliver polished monthly reports to every client automatically — pull their data, render a branded PDF, and email it without touching a template.
Auto-Generate and Email Recurring Invoices from a Google Sheet
An n8n workflow that reads a Google Sheet of recurring clients, generates each due invoice as a PDF with the right amount and line items, emails it, and marks it sent — so freelancers and agencies bill on time every month without touching invoicing software.
Automatically Send a Feedback Survey After Your Event Ends
An n8n workflow that emails attendees a short feedback survey a couple of hours after an event wraps, collects the responses to a sheet, and flags low scores for follow-up — so you capture honest impressions while they're fresh and improve the next one.
Check Passports Before You Book Flights — Not at the Airport
Passports expire silently, and many countries require 6 months' validity. Track the whole family's documents and get warned 9 months before any expiry.
Nudge SaaS Users Who Stall on a Key Onboarding Step
An n8n workflow that watches where new users get stuck in onboarding, and sends a targeted tip when someone stalls on a critical step for over a day — so friction gets a helping hand instead of quietly becoming churn.
Track Volunteer Hours and Auto-Generate Recognition Reports
Value your volunteers — log their hours from sign-ins and automatically produce recognition reports and milestone thank-yous.
Coordinate Recital Sign-Ups and Slot Assignments Automatically
Organizing a recital is chaos. Collect student sign-ups, assign performance slots, and send each family their time and running order automatically.
Send MSP Clients a Weekly Backup Verification Report
Prove your value as an MSP by verifying each client's backups completed and sending a clear weekly report, flagging any that failed.
Send Weekly Menus and Collect Meal Prep Orders Automatically
Run your meal prep business on autopilot: publish the weekly menu, collect orders by the cutoff, and generate the kitchen's prep list.
Reconcile Marketplace Seller Payouts Automatically
Pay sellers correctly — reconcile each period's marketplace sales, fees and refunds per seller and generate accurate payout statements.
Auto-Generate a Purchase Order When Stock Drops Below Reorder Point
An n8n workflow that checks inventory levels, and when an item falls below its reorder point, drafts a purchase order to the right supplier with the reorder quantity and emails it for approval — so you never stock out because someone forgot to reorder.
Remind HVAC Contract Customers of Their Seasonal Tune-Up
Maximize contract value by reminding customers to book their included seasonal tune-up before peak season hits and technicians get slammed.
Tell Parents About Missing Homework While It Still Fixes Easily
Parents usually learn about missing assignments at report-card time — months too late. Alert them within days, when a single evening can fix it.
Compile Emailed Receipts Into a Monthly Expense Report Automatically
Collect receipts that arrive in your inbox all month, extract the details with AI, and generate a tidy monthly expense report ready for reimbursement.
Never Forget an Email You're Waiting On a Reply To
You send an important email... and forget it. Track sent emails that never got a reply and get a daily list of who you should nudge.
Send a Free-Trial Expiry Nudge Sequence to Convert More Signups
An n8n workflow that watches trial start dates and sends timed nudge emails at day 3, day 7 and one day before expiry — each tailored to whether the user has activated key features — so more trials convert to paid without a sales team chasing them.
Send Franchisees a Weekly Performance Digest and Benchmarks
Help franchisees improve by sending each a weekly digest of their sales, key metrics and how they compare to the network average.
Send a Personalized Size Guide to Reduce Apparel Returns
Wrong sizes drive apparel returns. After an apparel order, send a personalized fit guide based on the item to help customers get it right.
Send Suppliers a Preorder Demand Signal to Right-Size Production
Preorders reveal real demand before you commit stock. Total preorder quantities per product and send suppliers an accurate production order.
Send a Helpful How-To Email After the Product Is Delivered
Reduce confusion and returns — once a product is delivered, email the customer a setup or how-to guide tailored to what they bought.
Reward Customers Who Refer Multiple Successful Friends
Super-referrers deserve extra. Track cumulative successful referrals per customer and unlock milestone rewards to keep them advocating.
Handle Bulk and Wholesale Quote Requests Automatically
Capture B2B demand by letting buyers request bulk quotes, auto-calculating tiered pricing, and sending a quote with a purchase path.
Automate Daily Reports for Every Child at Your Daycare
Give parents peace of mind by compiling each child's meals, naps and activities into a simple daily report sent at pickup time.
Confirm Coworking Desk Bookings and Send Access Codes
Streamline day-pass bookings by confirming each reservation and sending the member their desk assignment and door access code.
Auto-Issue a Personalized Certificate When a Student Completes a Course
An n8n workflow that fires when a student finishes your course, generates a personalized PDF certificate with their name and date, emails it, and logs the credential — so learners get instant proof of completion and you never manually make certificates again.
Never Miss a Contract Renewal Again with Automated Reminders
An n8n workflow that reads contract end dates from a Google Sheet and sends the owner a reminder 60, 30 and 7 days before each renewal — so no auto-renewal sneaks through and no revenue contract lapses because a date slipped past everyone.
Send Coaching Clients Automated Accountability Check-Ins
Keep coaching clients on track between sessions with scheduled check-ins on their goals, capturing progress for your next session.
Get Gift Reminders a Week Early — With AI Gift Ideas Included
Remembering the birthday is half the job; the gift is the other half. Get reminded a week ahead with three AI-suggested gift ideas based on notes about the person.
Remind Cyclists to Book a Spring Tune-Up Before the Rush
Every spring the workshop gets swamped. Remind past customers to book their tune-up early, smoothing demand and filling slow weeks.
Follow Up Automatically on Quotes That Go Unanswered
An n8n workflow that watches sent quotes and, when one gets no response after a few days, sends a gentle follow-up and flags the rep — so warm deals don't quietly die because everyone got busy after the quote went out.
Automatically Send a Personalized Gmail for Every New Google Sheets Row
Whenever a new row is added to your Google Sheet, this workflow instantly sends a personalized Gmail to the email address in that row. No more copying and pasting — every submission triggers a professional email automatically.
Build a Monthly Customer Cohort Retention Report Automatically
Retention is the number that decides whether your store compounds or leaks. This workflow groups customers by the month of their first order and calculates how many came back in each following month — a real cohort table, in Google Sheets, with no analyst required.
FAQ Auto-Responder: draft replies from your own answers, waiting in the thread before you open it
An n8n workflow that matches every incoming support question against your FAQ knowledge sheet, has Claude compose a reply using only your approved answers (with a strict 'say so if you don't know' rule), and saves it as a Gmail draft in the thread — you review, tweak, send.
Subscription Audit: a monthly report of every SaaS charge — and which ones you forgot you pay for
An n8n workflow that scans your bank/card notification emails all month for recurring charges, and on the 1st has Claude reconcile them into a subscription report: what you pay, what changed price, what charged twice, and what nobody has logged into since — sent to your inbox.
Overdue-Invoice Chaser: firm, polite payment reminders that escalate on schedule
An n8n workflow that scans your invoices sheet every morning, finds what's overdue, and has Claude write the right reminder for the stage — gentle at day 3, firm at day 14, final-notice at day 30 — sent from your Gmail with the invoice attached, and every send logged.
Auto-Draft a Purchase Order to Your Supplier When Shopify Stock Runs Low
Knowing you're low on stock is only half the job — you still have to reorder. This workflow watches inventory, calculates a smart reorder quantity from recent sales velocity, and drafts a ready-to-send purchase order email to the right supplier for each low SKU.
Follow-Up Sequencer: polite persistence on autopilot — day 3 and day 7 nudges from a Google Sheet
An n8n workflow that reads your outreach sheet daily, finds contacts you emailed 3 or 7 days ago with no reply, has Claude write a short varied follow-up (never the same canned bump twice), and sends it from your Gmail — replies are auto-detected and pulled out of the sequence.
Invoice Attachment Collector: every emailed invoice filed in Drive and logged in a sheet, hands-free
An n8n workflow that catches invoice and receipt emails, uploads the PDF attachments to a tidy Google Drive folder, has Claude pull the vendor, amount, and due date from the email, and appends one row per invoice to your bookkeeping sheet.
AI Newsletter Curator: your weekly industry digest, researched and drafted while you sleep
An n8n workflow that collects every article from your chosen RSS feeds all week, has Claude pick the 5 most important for your audience and write a short take on each, then drops a ready-to-send newsletter draft into your Gmail drafts every Friday morning.
Email Order Parser: turn messy order confirmation emails into a clean orders spreadsheet
An n8n workflow that watches your inbox for order confirmation emails from any marketplace, has Claude extract the order number, items, amounts, and shipping address into strict JSON, and appends every order as a clean row in Google Sheets.