# Daily job alerts: email each tech their jobs from Google Sheets with n8n > A free one-page cheat sheet: at 7am n8n reads today's jobs from Google Sheets, skips unassigned ones and emails each job to its tech. Source: https://learn.ynteractive.com/content/cheat-sheets/daily-job-alerts-n8n · Updated 2026-10-01 · Free from Stepthrough (https://learn.ynteractive.com) [Lesson cheat sheet](https://learn.ynteractive.com/content/cheat-sheets#kind-lesson) · One page · US letter · [n8n](https://learn.ynteractive.com/content/tool/n8n) By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 1, 2026 · From the free lesson [Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail) A free one-page cheat sheet: at 7am n8n reads today's jobs from Google Sheets, skips unassigned ones and emails each job to its tech. [Download the free PDF (76 KB)](https://learn.ynteractive.com/content/cheat-sheets/daily-job-alerts-n8n.pdf)Print this sheet Free, no sign-up and no email needed. It prints on one letter-size page; the whole sheet is below. *▶*StepthroughFree printable cheat sheet · learn.ynteractive.com Daily job alerts: email each tech their jobs from Google Sheets with n8n No AI, just a clean first automation. At 7am the workflow reads the sheet, drops jobs with no tech and emails each job to its tech. ## The sheet - **Today's Jobs**, tab **Jobs**: Customer, Address, Job, Time, Tech and Tech Email. - Tech Email is looked up from a **Techs** tab, so the office only types a first name. ## Build it 1. **Create workflow**. Before anything else: **···**, **Settings**, **Timezone**, pick yours (the lesson uses **America/Chicago**), **Save**. 2. **Add first step**, **On a schedule**. Keep every **1 day** and set **Trigger at Hour** to **7am**. 3. **+**, **Google Sheets: Get row(s) in sheet**. Pick the credential, **Document** Today's Jobs, **Sheet** Jobs. **Test step** shows six items. 4. **+**, **Filter**. In value1 use `{{ $json.Tech }}`, then under String pick **is not empty**. Six in, five out. 5. **+**, **Gmail: Send a message**. **Create new credential**, **Sign in with Google**, pick the office account. ## Write the email **To** `{{ $json["Tech Email"] }}`, in brackets and quotes because the name has a space. **Subject** Expressions for the time and customer, like "8:00 AM job: Hannah Ortiz". **Email Type** **Text**. Simpler, and it reads fine on a phone. **Message** Hi to the tech, then job, address, time and customer, each from its column. **Footer** **Add option**, **Append n8n Attribution**, switch it off. ## Test and publish - Click **Test workflow**. One Gmail step runs five times: two emails to Dave, two to Luis, one to Tasha. - Check the office account's **Sent** folder, then click **Publish**. - It sends every assigned row every day, so keep the sheet to today's jobs. **Remember:** Set the timezone before the schedule, and make To an expression. Otherwise 7am is the wrong 7am, or every job goes to one person. Practice it free: [Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n](https://learn.ynteractive.com/modules/job-alerts) at learn.ynteractive.com/modules/job-alerts. This sheet: learn.ynteractive.com/content/cheat-sheets/daily-job-alerts-n8n. Rapid Flow Plumbing is a made-up business from the lesson. By Robert Breen, October 1, 2026. ## Practice it in the free lesson **Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n**. Every morning at 7, n8n reads a plumbing company's jobs sheet, skips anything not assigned yet, and emails each job to the tech it's assigned to — customer, address, time and what's wrong. No AI… You do every step yourself in a practice copy of n8n, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts. [Start the free lesson](https://learn.ynteractive.com/modules/job-alerts) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail) ## Related terms Plain-English definitions, each with an example from a free lesson. [Schedule Trigger](https://learn.ynteractive.com/content/glossary/schedule-trigger) · [Workflow timezone](https://learn.ynteractive.com/content/glossary/workflow-timezone) · [Get rows (reading a sheet)](https://learn.ynteractive.com/content/glossary/get-rows) · [Filter node](https://learn.ynteractive.com/content/glossary/filter-node) · [Expression](https://learn.ynteractive.com/content/glossary/expression) · [Item (n8n)](https://learn.ynteractive.com/content/glossary/item) · [Publishing a workflow](https://learn.ynteractive.com/content/glossary/publish-workflow) · [Automation](https://learn.ynteractive.com/content/glossary/automation) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [Tech daily job briefing prompt](https://learn.ynteractive.com/content/prompts/tech-daily-job-briefing-prompt): Turn today's job schedule and office notes into a short morning briefing for each technician, in time order, with unassigned… - [Appointment reminder text prompt](https://learn.ynteractive.com/content/prompts/appointment-reminder-text-prompt): Write day-before reminder texts for each job on tomorrow's schedule: the time window, who's coming, one prep step and an easy… - [Automation time savings estimate prompt](https://learn.ynteractive.com/content/prompts/automation-time-savings-estimate-prompt): Estimate what one automation saves from your own numbers only: minutes before and after, setup and upkeep, costs you look up… - [Rental property repair coordination prompt](https://learn.ynteractive.com/content/prompts/rental-property-job-coordination-prompt): Coordinate a repair at a rental: a clear email to the owner or property manager about approval and billing, and a short access… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## More cheat sheets - [n8n Basics Cheat Sheet: Triggers, Items, Webhooks](https://learn.ynteractive.com/content/cheat-sheets/n8n-basics): A free one-page cheat sheet of n8n basics: triggers, expressions, items, executions, the workflow timezone and webhook test vs production URLs. - [AI Quick-Start for Electricians: Cheat Sheet](https://learn.ynteractive.com/content/cheat-sheets/ai-quick-start-electrical): A free one-page cheat sheet for electrical contractors: the free AI lessons in order, a reminder-text prompt and the calls AI must never make. - [AI Quick-Start for HVAC Companies: Cheat Sheet](https://learn.ynteractive.com/content/cheat-sheets/ai-quick-start-hvac): A free one-page cheat sheet for HVAC offices: the free AI lessons to take in order, a missed-call text prompt and what AI must never decide. [All free cheat sheets](https://learn.ynteractive.com/content/cheat-sheets) · [All free tutorials](https://learn.ynteractive.com/content)