# Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n: step-by-step guide with screenshots > Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n in n8n, in 56 steps with a screenshot of each one. A free how-to guide, plus a… Source: https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail/guide · Updated 2026-10-02 · Free from Stepthrough (https://learn.ynteractive.com) Updated October 2, 2026 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, just a clean first automation. **About the screenshots.** They come from Stepthrough’s simulated practice environment (a practice copy of n8n), not the live tool, so no real account appears. The buttons and labels match the real screens the lesson was built against. Practice it yourself free at learn.ynteractive.com. ## How do you want to learn? - [Practice it step by step: Interactive, in a practice copy of n8n, about 10 min](https://learn.ynteractive.com/modules/job-alerts) - [Watch the video: 5:10, narrated, with chapters](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail/video) - [Read the guide: 56 steps with screenshots](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail/guide) Lesson overview: [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) - Tools: n8n - Time: about 10 minutes, 56 steps in 8 parts - Level: beginner, no coding needed ## Part 1: The sheet ### Step 1: Look at the sheet In this module you're the office at Rapid Flow Plumbing. They've got a few techs, and every morning someone copies the day's jobs into emails, one tech at a time. Let's make n8n do it at seven, on its own. First, look at the sheet. Switch to the today's jobs tab. ![N8n in Stepthrough’s practice copy, step 1 of 56 (Look at the sheet): the cursor is on “Today's Jobs”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-01.webp) **Step 1 of 56.** You're the office at Rapid Flow Plumbing. Switch to the **Today's Jobs** tab. ### Step 2: Meet the techs Six jobs today. Customer, address, job and time, plus two new columns: tech, and tech email. Remember those column names, we'll use them. Notice the last job, the sump pump estimate, has no tech yet. ![Google Sheets in Stepthrough’s practice copy, step 2 of 56 (Meet the techs): the cursor is on “Tech”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-02.webp) **Step 2 of 56.** Six jobs, each with a **Tech** and a **Tech Email**. The last one has no tech yet. Click the **Techs** tab at the bottom. ### Step 3: Back to n8n Four techs, each with their own email. The tech email column on the jobs tab just looks it up from here, so the office only types a first name. Back to n8n. ![Google Sheets in Stepthrough’s practice copy, step 3 of 56 (Back to n8n): the cursor is on “Tech Email”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-03.webp) **Step 3 of 56.** Four techs, each with an email. The **Tech Email** column on the Jobs tab looks them up from here. Switch back to **n8n**. ## Part 2: Timezone ### Step 4: Create a workflow ![The n8n overview page in Stepthrough’s practice copy, step 4 of 56 (Create a workflow): the cursor is on “Create workflow”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-04.webp) **Step 4 of 56.** Click **Create workflow**. ### Step 5: Open the workflow menu Before we build anything, one setting that trips everyone up. A schedule runs on the workflow's timezone, and it defaults to New York. If you're not on Eastern time, seven a m will be the wrong seven a m. ![The n8n workflow editor in Stepthrough’s practice copy, step 5 of 56 (Open the workflow menu): the cursor is on “···”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-05.webp) **Step 5 of 56.** Before anything else, set the timezone. Click the **···** next to the workflow name. ### Step 6: Settings Settings. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 6 of 56 (Settings): the cursor is on “Settings”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-06.webp) **Step 6 of 56.** Click **Settings**. ### Step 7: Timezone ![The n8n workflow settings in Stepthrough’s practice copy, step 7 of 56 (Timezone): the cursor is on “Timezone”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-07.webp) **Step 7 of 56.** Open the **Timezone** dropdown. ### Step 8: Pick your timezone Rapid Flow is on Central time, so pick America Chicago. When you build yours, pick your own. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 8 of 56 (Pick your timezone): the cursor is on “America/Chicago”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-08.webp) **Step 8 of 56.** Choose **America/Chicago**. For your own business, pick your own timezone. ### Step 9: Save settings Save. ![The n8n workflow settings in Stepthrough’s practice copy, step 9 of 56 (Save settings): the cursor is on “Save”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-09.webp) **Step 9 of 56.** Click **Save**. ## Part 3: Schedule ### Step 10: Add the trigger Now the trigger. ![The n8n workflow canvas in Stepthrough’s practice copy, step 10 of 56 (Add the trigger): the cursor is on “Add first step”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-10.webp) **Step 10 of 56.** Click **Add first step**. ### Step 11: On a schedule On a schedule. No one has to press anything, the clock starts it. ![The n8n node list in Stepthrough’s practice copy, step 11 of 56 (On a schedule): the cursor is on “On a schedule”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-11.webp) **Step 11 of 56.** Choose **On a schedule**. ### Step 12: Pick the hour It's already set to every one day, which is what we want. But it fires at midnight. Nobody reads job emails at midnight. ![An n8n node’s settings window in Stepthrough’s practice copy, step 12 of 56 (Pick the hour): the cursor is on “1 day”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-12.webp) **Step 12 of 56.** It runs every **1 day** already. Open **Trigger at Hour**. ### Step 13: 7am Seven a m, in the Central timezone we just set. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 13 of 56 (7am): the cursor is on “7am”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-13.webp) **Step 13 of 56.** Choose **7am**. ### Step 14: Close the node Close it. ![An n8n node’s settings window in Stepthrough’s practice copy, step 14 of 56 (Close the node): the cursor is on “Close the node”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-14.webp) **Step 14 of 56.** Close the trigger. ## Part 4: Read the sheet ### Step 15: Add the next step At seven, the first thing to do is read the sheet. ![The n8n workflow canvas in Stepthrough’s practice copy, step 15 of 56 (Add the next step): the cursor is on “+”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-15.webp) **Step 15 of 56.** Click the **+** after the Schedule Trigger. ### Step 16: Search for Sheets ![The n8n node list in Stepthrough’s practice copy, step 16 of 56 (Search for Sheets): the sheets is filled in (“sheets”).](https://learn.ynteractive.com/content/guide/job-alerts/step-16.webp) **Step 16 of 56.** Type **sheets**. ### Step 17: Get row(s) in sheet Get rows in sheet. That reads rows. Append would add rows, which is not what we want here. ![The n8n node list in Stepthrough’s practice copy, step 17 of 56 (Get row(s) in sheet): the cursor is on “Google Sheets: Get row(s) in sheet”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-17.webp) **Step 17 of 56.** Choose **Google Sheets: Get row(s) in sheet**. ### Step 18: Credential ![An n8n node’s settings window in Stepthrough’s practice copy, step 18 of 56 (Credential): the cursor is on “Credential”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-18.webp) **Step 18 of 56.** Open the **Credential** dropdown. ### Step 19: Reuse your Google login Pick google sheets account. You connected it back in Module 2, so n8n already has permission. If you skipped that, create a new one and sign in with Google. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 19 of 56 (Reuse your Google login): the cursor is on “Google Sheets account”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-19.webp) **Step 19 of 56.** Choose **Google Sheets account**, the one from Module 2. ### Step 20: Pick the document Now which spreadsheet. ![An n8n node’s settings window in Stepthrough’s practice copy, step 20 of 56 (Pick the document): the cursor is on “Document”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-20.webp) **Step 20 of 56.** Open the **Document** dropdown. ### Step 21: Today's Jobs Today's jobs. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 21 of 56 (Today's Jobs): the cursor is on “Today's Jobs”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-21.webp) **Step 21 of 56.** Choose **Today's Jobs**. ### Step 22: Pick the tab ![An n8n node’s settings window in Stepthrough’s practice copy, step 22 of 56 (Pick the tab): the cursor is on “Sheet”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-22.webp) **Step 22 of 56.** Open the **Sheet** dropdown. ### Step 23: Jobs Jobs. Not techs, we already have the email on every job. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 23 of 56 (Jobs): the cursor is on “Jobs”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-23.webp) **Step 23 of 56.** Choose **Jobs**. ### Step 24: Test the step Don't wait for seven a m to find out if it works. ![An n8n node’s settings window in Stepthrough’s practice copy, step 24 of 56 (Test the step): the cursor is on “Test step”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-24.webp) **Step 24 of 56.** Click **Test step** to read the sheet now. ### Step 25: Close the node Six items, one for each row, with the column names as labels. Close it. ![An n8n node’s settings window in Stepthrough’s practice copy, step 25 of 56 (Close the node): the cursor is on “Close the node”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-25.webp) **Step 25 of 56.** Six items, one per row. Close the node. ## Part 5: Skip unassigned jobs ### Step 26: Add a filter Before we send anything, remember that sump pump job with no tech? If we email it, there's nobody to send it to. So we'll drop any job without a tech. ![The n8n workflow canvas in Stepthrough’s practice copy, step 26 of 56 (Add a filter): the cursor is on “+”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-26.webp) **Step 26 of 56.** Click the **+** after Google Sheets. ### Step 27: Search for Filter ![The n8n node list in Stepthrough’s practice copy, step 27 of 56 (Search for Filter): the filter is filled in (“filter”).](https://learn.ynteractive.com/content/guide/job-alerts/step-27.webp) **Step 27 of 56.** Type **filter**. ### Step 28: Filter Filter. It keeps the items that match a condition and drops the rest. ![The n8n node list in Stepthrough’s practice copy, step 28 of 56 (Filter): the cursor is on “Filter”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-28.webp) **Step 28 of 56.** Choose **Filter**. ### Step 29: What to check The condition has three parts: a value, a test, and something to compare it to. For the value, paste this. It's an expression, in double curly brackets, that points at the tech column. Underneath you can see what it gives for the first row: Dave. ![An n8n node’s settings window in Stepthrough’s practice copy, step 29 of 56 (What to check): the expression is filled in (“{{ $json.Tech }}”).](https://learn.ynteractive.com/content/guide/job-alerts/step-29.webp) **Step 29 of 56.** In **value1**, paste the expression for the **Tech** column. ### Step 30: The test Now the test. It says is equal to. ![An n8n node’s settings window in Stepthrough’s practice copy, step 30 of 56 (The test): the cursor is on “is equal to”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-30.webp) **Step 30 of 56.** Open the operator dropdown. It says **is equal to**. ### Step 31: is not empty Under string, pick is not empty. So, keep the job if the tech isn't blank. There's nothing to compare to, so the second box goes away. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 31 of 56 (is not empty): the cursor is on “String”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-31.webp) **Step 31 of 56.** Under **String**, choose **is not empty**. ### Step 32: Test the filter Test step. ![An n8n node’s settings window in Stepthrough’s practice copy, step 32 of 56 (Test the filter): the cursor is on “Test step”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-32.webp) **Step 32 of 56.** Click **Test step**. ### Step 33: Close the node Six items in on the left, five out on the right. The sump pump job got dropped. Close it. ![An n8n node’s settings window in Stepthrough’s practice copy, step 33 of 56 (Close the node): the cursor is on “Close the node”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-33.webp) **Step 33 of 56.** Six in, five out. The job with no tech was dropped. Close the node. ## Part 6: Connect Gmail ### Step 34: Add the email step Now send them. ![The n8n workflow canvas in Stepthrough’s practice copy, step 34 of 56 (Add the email step): the cursor is on “+”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-34.webp) **Step 34 of 56.** Click the **+** after the Filter. ### Step 35: Search for Gmail ![The n8n node list in Stepthrough’s practice copy, step 35 of 56 (Search for Gmail): the gmail is filled in (“gmail”).](https://learn.ynteractive.com/content/guide/job-alerts/step-35.webp) **Step 35 of 56.** Type **gmail**. ### Step 36: Send a message Gmail, send a message. ![The n8n node list in Stepthrough’s practice copy, step 36 of 56 (Send a message): the cursor is on “Gmail: Send a message”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-36.webp) **Step 36 of 56.** Choose **Gmail: Send a message**. ### Step 37: Credential Gmail needs its own permission. ![An n8n node’s settings window in Stepthrough’s practice copy, step 37 of 56 (Credential): the cursor is on “Credential”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-37.webp) **Step 37 of 56.** Open the **Credential** dropdown. ### Step 38: New credential Create new credential. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 38 of 56 (New credential): the cursor is on “Create new credential”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-38.webp) **Step 38 of 56.** Click **Create new credential**. ### Step 39: Sign in with Google Sign in with Google. ![The Google sign-in window in Stepthrough’s practice copy, step 39 of 56 (Sign in with Google): the cursor is on “Sign in with Google”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-39.webp) **Step 39 of 56.** Click **Sign in with Google**. ### Step 40: Pick the office account Pick the account the emails should come from. For Rapid Flow, that is the office. ![The Google sign-in window in Stepthrough’s practice copy, step 40 of 56 (Pick the office account): the cursor is on “the office account”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-40.webp) **Step 40 of 56.** Pick the account the emails should come from. ### Step 41: Allow access Continue. ![The Google sign-in window in Stepthrough’s practice copy, step 41 of 56 (Allow access): the cursor is on “Continue”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-41.webp) **Step 41 of 56.** Click **Continue**. ## Part 7: Write the email ### Step 42: Send it to the assigned tech Who gets it. Don't type one address here, or every job goes to the same person. It points at the tech email column, so each job goes to its own tech. The column name has a space in it, so it goes in square brackets and quotes. Underneath, the first one comes out as Dave's address. ![An n8n node’s settings window in Stepthrough’s practice copy, step 42 of 56 (Send it to the assigned tech): the expression is filled in (“{{ $json"Tech Email" }}”).](https://learn.ynteractive.com/content/guide/job-alerts/step-42.webp) **Step 42 of 56.** In **To**, paste the expression for the **Tech Email** column. ### Step 43: Subject with data in it Now the subject. Look at the input on the left, those are the rows from the sheet. The parts in double curly brackets are expressions. Instead of typing a name, you point at a column. ![An n8n node’s settings window in Stepthrough’s practice copy, step 43 of 56 (Subject with data in it): the subject is filled in (“{{ $json.Time }} job: {{ $json.Customer }}”).](https://learn.ynteractive.com/content/guide/job-alerts/step-43.webp) **Step 43 of 56.** Paste the subject. The **{{ }}** parts pull in each row’s time and customer. ### Step 44: Email type Email type is HTML. For a quick job note, plain text is simpler and reads fine on a phone. ![An n8n node’s settings window in Stepthrough’s practice copy, step 44 of 56 (Email type): the cursor is on “Email Type”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-44.webp) **Step 44 of 56.** Open **Email Type**. It says HTML. ### Step 45: Text Text. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 45 of 56 (Text): the cursor is on “Text”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-45.webp) **Step 45 of 56.** Choose **Text**. ### Step 46: The message And the message. It says hi to the tech by name, then the job, address, time and customer, each one pulled from its own column. ![An n8n node’s settings window in Stepthrough’s practice copy, step 46 of 56 (The message): the message is filled in (“Hi {{ $json.Tech }}, Job: {{ $json.Job }}…”).](https://learn.ynteractive.com/content/guide/job-alerts/step-46.webp) **Step 46 of 56.** Paste the message: a hello to the tech, then job, address, time and customer, each from its column. ### Step 47: Add an option One small thing. By default n8n adds a line at the bottom saying the email was sent with n8n. The tech doesn't need that. ![An n8n node’s settings window in Stepthrough’s practice copy, step 47 of 56 (Add an option): the cursor is on “Add option”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-47.webp) **Step 47 of 56.** Click **Add option**. ### Step 48: Append n8n Attribution Append n8n attribution. ![A dropdown menu in n8n in Stepthrough’s practice copy, step 48 of 56 (Append n8n Attribution): the cursor is on “Append n8n Attribution”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-48.webp) **Step 48 of 56.** Choose **Append n8n Attribution**. ### Step 49: Turn it off Switch it off. ![An n8n node’s settings window in Stepthrough’s practice copy, step 49 of 56 (Turn it off): the cursor is on “off”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-49.webp) **Step 49 of 56.** Click the toggle to turn it **off**. ### Step 50: Close the node That's the email. Close it. ![An n8n node’s settings window in Stepthrough’s practice copy, step 50 of 56 (Close the node): the cursor is on “Close the node”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-50.webp) **Step 50 of 56.** Close the Gmail node. ## Part 8: Test and publish ### Step 51: Test the whole thing Test the whole workflow. Watch the numbers on the lines between the steps. ![The n8n workflow editor in Stepthrough’s practice copy, step 51 of 56 (Test the whole thing): the cursor is on “Test workflow”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-51.webp) **Step 51 of 56.** Click **Test workflow**. ### Step 52: Check the mail Six rows came out of the sheet, and five made it past the filter. Here's the idea that makes n8n click: we built one Gmail step, but it ran five times, once for every item it was given, each time with that row's tech email. You never write a loop. Switch to Gmail. ![The n8n workflow editor in Stepthrough’s practice copy, step 52 of 56 (Check the mail): the cursor is on “5 items”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-52.webp) **Step 52 of 56.** Six rows in, **5 items** out of the Filter. Switch to the **Gmail** tab. ### Step 53: Sent mail This is the office's Gmail, the account that sent them. ![Gmail in Stepthrough’s practice copy, step 53 of 56 (Sent mail): the cursor is on “Sent”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-53.webp) **Step 53 of 56.** This is the office account that sent them. Click **Sent**. ### Step 54: Open one Five emails. Two to Dave, two to Luis, one to Tasha, and none for Kevin, because he's got no jobs today. ![Gmail in Stepthrough’s practice copy, step 54 of 56 (Open one): the cursor is on “Marcus Bell”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-54.webp) **Step 54 of 56.** Five emails: two to Dave, two to Luis, one to Tasha. Open **Marcus Bell**'s, the one to Luis. ### Step 55: Back to n8n Sent to Luis's address. Hi Luis, clogged kitchen drain, two twenty Elm Street, eight thirty. Straight from the sheet, no copying. Back to n8n. ![Gmail in Stepthrough’s practice copy, step 55 of 56 (Back to n8n): the cursor is on “n8n”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-55.webp) **Step 55 of 56.** Sent to Luis's address, with his job straight from the sheet. Switch back to **n8n**. ### Step 56: Publish From now on it runs every morning at seven, whether you're at your desk or not. If the office moves a job to a different tech, they just change the name in the sheet, and tomorrow's email goes to the right person. One thing to know: it sends every assigned row, every day, so the office keeps that sheet to today's jobs. ![The n8n workflow editor in Stepthrough’s practice copy, step 56 of 56 (Publish): the cursor is on “Publish”, highlighted.](https://learn.ynteractive.com/content/guide/job-alerts/step-56.webp) **Step 56 of 56.** Click **Publish**. It now runs every day at 7am on its own. ## Now do it yourself, free Reading the steps is a start. Doing them is how it sticks. The interactive lesson puts you in a practice copy of n8n: you do every step yourself, it checks your work, and “Do it for me” finishes any step you get stuck on. Nothing touches your real accounts. [Practice “Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n” step by step](https://learn.ynteractive.com/modules/job-alerts) [Watch the 5:10 video walkthrough](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail/video) · [Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n: lesson overview](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail) · [All free tutorials](https://learn.ynteractive.com/content)