# Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n > At 7am n8n reads today's jobs from Google Sheets, filters out unassigned ones and emails each job to its tech. A free, beginner-friendly n8n tutorial. Source: https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail · Updated 2026-10-27 · Free from Stepthrough (https://learn.ynteractive.com) ## Practice it step by step [Start the free practice](https://learn.ynteractive.com/modules/job-alerts) [Take the free module: why it matters, practice and a quick check →](https://learn.ynteractive.com/courses/n8n-jump-start/14) 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, about 10 minutes, and nothing touches your real accounts. [Open full screen](https://learn.ynteractive.com/modules/job-alerts) Free · Live now · [Business Automations](https://learn.ynteractive.com/content/course/business-automations) · [n8n](https://learn.ynteractive.com/content/tool/n8n) · Google Sheets · Gmail · ~10 min · 56 steps · Intermediate Updated October 27, 2026. Built against the tool’s current screens and checked step by step. [How we check this lesson](https://learn.ynteractive.com/content/about#how-we-check) Every morning someone copies the day's jobs from a spreadsheet into emails, one tech at a time. In this free [n8n](https://learn.ynteractive.com/content/tool/n8n) tutorial you automate it: at 7am the workflow reads the sheet, skips any job with no tech yet, and emails each job to the tech it is assigned to. No AI, just a clean first [automation](https://learn.ynteractive.com/content/glossary/automation). ## At a glance | Question | Answer | | --- | --- | | What you build | 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. | | Tools | n8n | | Time | About 10 minutes, 56 steps in 8 parts | | Level | Intermediate | | Cost | Free | | Ways to learn it | [Practice it step by step](https://learn.ynteractive.com/modules/job-alerts), watch the video, read the guide with screenshots | ### The 8 parts, in short 1. The sheet: Look at the sheet, Meet the techs, Back to n8n. 2. Timezone: Create a workflow, Open the workflow menu, Settings, Timezone, and 2 more steps. 3. Schedule: Add the trigger, On a schedule, Pick the hour, 7am, and 1 more step. 4. Read the sheet: Add the next step, Search for Sheets, Get row(s) in sheet, Credential, and 7 more steps. 5. Skip unassigned jobs: Add a filter, Search for Filter, Filter, What to check, and 4 more steps. 6. Connect Gmail: Add the email step, Search for Gmail, Send a message, Credential, and 4 more steps. 7. Write the email: Send it to the assigned tech, Subject with data in it, Email type, Text, and 5 more steps. 8. Test and publish: Test the whole thing, Check the mail, Sent mail, Open one, and 2 more steps. **Start here first:** [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) (module 1 of Business Automations) **In the course:** [Part 9 · n8n Automation Toolkit](https://learn.ynteractive.com/content/course/part-9-n8n-automation-toolkit) (Module 74 of the [full course](https://learn.ynteractive.com/content/course)) **Part of:** [Business Automations with n8n](https://learn.ynteractive.com/content/paths/business-automations-n8n) (step 3 of 22). Next up: [n8n AI Email Responder: Draft Gmail Replies Automatically](https://learn.ynteractive.com/content/ai-email-responder-gmail-drafts-n8n) ## Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n: step-by-step guide with screenshots **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. - Tools: n8n - Time: about 10 minutes, 56 steps in 8 parts - Level: intermediate ### 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](https://learn.ynteractive.com/content/glossary/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 **Execute 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 [Execute step](https://learn.ynteractive.com/content/glossary/execute-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 **Execute 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 **Execute 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. **Part of these free courses:** [n8n Jump Start](https://learn.ynteractive.com/courses/n8n-jump-start), [AI for Trades & Home Services](https://learn.ynteractive.com/courses/ai-for-trades) ### 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?after=guide) ## Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n: video walkthrough The whole lesson in 5:10, narrated step by step. **Simulated practice environment.** Recorded in Stepthrough’s simulated practice environment, not the live tool. Practice it yourself free at learn.ynteractive.com. 5:10 · 9 chapters · 56 steps · narrated with the lesson’s own voice-over · [Watch on YouTube](https://www.youtube.com/watch?v=HBc72PBGrUk) ### Chapters Click a chapter to jump the video there. 1. [0:00 Intro: what you'll build](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=0#watch) 2. [0:13 The sheet](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=13#watch) 3. [0:51 Timezone](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=51#watch) 4. [1:14 Schedule](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=74#watch) 5. [1:32 Read the sheet](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=92#watch) 6. [2:10 Skip unassigned jobs](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=130#watch) 7. [2:53 Connect Gmail](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=173#watch) 8. [3:11 Write the email](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=191#watch) 9. [4:10 Test and publish](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=250#watch) ### Now do it yourself, free Watching is the warm-up. 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?after=video) ### Full transcript #### Intro: what you'll build [0:00](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=0#watch) Send each tech their jobs automatically. Today's jobs for rapid flow plumbing. Every morning at 7, n8n reads the sheet, skips unassigned jobs, and emails each job to its own tech. Let's build it. #### The sheet [0:13](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=13#watch) 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. [0:27](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=27#watch) 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. Now click the techs tab at the bottom. [0:42](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=42#watch) 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. #### Timezone [0:50](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=50#watch) Click create workflow. [0:52](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=52#watch) 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. Click the three dots next to the workflow name. [1:05](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=65#watch) Settings. [1:07](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=67#watch) Open the timezone dropdown. [1:08](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=68#watch) Rapid Flow is on Central time, so pick America Chicago. When you build yours, pick your own. #### Schedule [1:13](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=73#watch) Save. [1:14](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=74#watch) Now the trigger. Click add first step. [1:16](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=76#watch) On a schedule. No one has to press anything, the clock starts it. [1:20](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=80#watch) It's already set to every one day, which is what we want. But it fires at midnight. Nobody reads job emails at midnight. Open trigger at hour. [1:27](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=87#watch) Seven a m, in the Central timezone we just set. [1:30](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=90#watch) Close it. #### Read the sheet [1:31](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=91#watch) At seven, the first thing to do is read the sheet. Click the plus. [1:35](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=95#watch) Type sheets. [1:36](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=96#watch) Get rows in sheet. That reads rows. Append would add rows, which is not what we want here. [1:41](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=101#watch) Open the credential dropdown. [1:42](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=102#watch) 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. [1:51](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=111#watch) Now which spreadsheet. Open document. [1:54](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=114#watch) Today's jobs. [1:55](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=115#watch) Open sheet. [1:56](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=116#watch) Jobs. Not techs, we already have the email on every job. [2:00](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=120#watch) Don't wait for seven a m to find out if it works. Click test step and it reads the sheet right now. [2:05](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=125#watch) Six items, one for each row, with the column names as labels. Close it. #### Skip unassigned jobs [2:09](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=129#watch) 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. Click the plus after google sheets. [2:19](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=139#watch) Type filter. [2:20](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=140#watch) Filter. It keeps the items that match a condition and drops the rest. [2:24](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=144#watch) 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. [2:37](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=157#watch) Now the test. It says is equal to. Open it. [2:40](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=160#watch) 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. [2:47](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=167#watch) Test step. [2:48](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=168#watch) Six items in on the left, five out on the right. The sump pump job got dropped. Close it. #### Connect Gmail [2:53](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=173#watch) Now send them. Click the plus after the filter. [2:56](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=176#watch) Type gmail. [2:57](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=177#watch) Gmail, send a message. [2:59](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=179#watch) Gmail needs its own permission. Open the credential dropdown. [3:02](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=182#watch) Create new credential. [3:03](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=183#watch) Sign in with Google. [3:05](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=185#watch) Pick the account the emails should come from. For Rapid Flow, that is the office. [3:09](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=189#watch) Continue. #### Write the email [3:10](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=190#watch) Who gets it. Don't type one address here, or every job goes to the same person. Paste this expression instead. 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. [3:26](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=206#watch) 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. Paste this, and each email's subject becomes the job time and the customer's name. [3:40](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=220#watch) Email type is HTML. For a quick job note, plain text is simpler and reads fine on a phone. Open email type. [3:46](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=226#watch) Text. [3:47](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=227#watch) 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. Paste it in. [3:55](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=235#watch) 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. Click add option. [4:05](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=245#watch) Append n8n attribution. [4:06](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=246#watch) Switch it off. [4:08](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=248#watch) That's the email. Close it. #### Test and publish [4:09](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=249#watch) Test the whole workflow. Watch the numbers on the lines between the steps. [4:13](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=253#watch) 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. [4:26](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=266#watch) This is the office's Gmail, the account that sent them. Click sent. [4:30](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=270#watch) Five emails. Two to Dave, two to Luis, one to Tasha, and none for Kevin, because he's got no jobs today. Open the one to Luis. [4:37](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=277#watch) 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. [4:46](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=286#watch) Click 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. [5:04](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail?t=304#watch) Simple as that. We show you and you do it. Sign up below to learn AI automation for free. ## Watch the 30-second version 3 short videos from this lesson. Watch, then do it yourself in the free practice copy. ### POV: it's 7 a.m. Short with Robert · 0:18 It's 7 a.m. and you're still making coffee. Five job emails already went out, one to each tech. The job with no tech got skipped. Nobody copied a thing: n8n read the sheet and sent them. ### The n8n setting everyone misses Short with Robert · 0:15 There's one n8n setting almost everybody misses: the timezone. A new workflow runs on New York time. Three dots, Settings, Timezone. Set it first, then build your schedule. ### Your first automation should be boring Short with Robert · 0:14 Your first automation should be boring. Pick something you do by hand every day, like sending each worker their jobs for the morning, and let n8n send it at 7 a.m. Watch the full 5:10 video walkthrough ## What you will build You play the office at Rapid Flow Plumbing, which has four techs: Dave, Luis, Tasha and Kevin. Today's jobs live in a Google Sheet called Today's Jobs, with columns for 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. Of the six jobs, the last one, a sump pump estimate, has no tech yet. You build a four-step n8n workflow: a Schedule Trigger set to 7am, a Google Sheets step that reads the rows, a Filter that keeps only jobs where Tech is not empty, and a Gmail step that sends each job to that row's Tech Email. The subject reads like "8:00 AM job: Hannah Ortiz" and the message starts "Hi Dave," then lists the job, address, time and customer. Six rows go in, five get past the Filter, and five emails go out: two to Dave, two to Luis and one to Tasha. ## Who this is for This module is for trade businesses with more than one person in the field: plumbers, electricians, cleaners, landscapers and field service teams. It is also a good first n8n workflow if [AI agents](https://learn.ynteractive.com/content/n8n-ai-agent-tutorial-google-sheets) feel like too much at once. You will need an n8n account and a Google account with Sheets and Gmail. If you did the n8n AI agent module, you can reuse its Google Sheets login. ## Common mistakes this avoids - Emails at the wrong hour. The workflow timezone is set before the schedule, so 7am means 7am where your business is. - A schedule that fires at midnight. The hour is changed to 7am so techs see their jobs before heading out. - Adding rows instead of reading them. The lesson picks Get row(s) in sheet, not Append. - Emailing a job nobody is assigned to. A Filter set to Tech is not empty drops the unassigned job before Gmail runs, so nothing goes out with a blank To. - Sending every job to the same person. To is an expression for the Tech Email column, not a typed address. Because the column name has a space, it is written as $json["Tech Email"], in square brackets and quotes. - Waiting until morning to find out it is broken. Execute step checks each node right away, and Execute workflow sends the emails on demand. - Messy emails on a phone. Email Type is switched to Text and the n8n footer is turned off. ## The two ideas that make n8n click The first is expressions. Anything inside double curly brackets pulls in data from an earlier step. {{ $json.Time }} becomes 8:00 AM for the first job and 8:30 AM for the second. You write the email once and the data fills it in, even the To address. The second is that n8n runs a step once for every item it receives. The Sheets step returns six items and the Filter passes five, so the single Gmail step runs five times, one email per assigned job, each to that row's tech. You never write a loop. ## How to use this in your business Keep today's jobs in a sheet with a tech on each, and every tech gets their own list before leaving the house. If a job moves to a different tech, the office changes the name in the sheet and tomorrow's email goes to the right person. The same pattern, trigger, get data, filter, send to the right person, covers invoice reminders, daily reports and appointment reminders. One thing to know: this version sends every assigned row, every day, so keep the sheet limited to today's jobs. ## How the practice works Each step is shown on the left under Watch, then you do it on the right under Your turn, in practice copies of n8n, Google Sheets and Gmail. Every click is checked, and Do it for me finishes a step if you get stuck. No Google account is connected and no email is sent. ## Try it yourself, free Reading the steps is a start. Doing them is how it sticks. The interactive module walks you through every click in a practice copy of n8n, checks each step, and never touches your real accounts. [Start “Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n”](https://learn.ynteractive.com/modules/job-alerts) ## More videos from this lesson ### The job email that sends itself Short · 0:17 · with captions Every morning someone copies the day's jobs into emails, one tech at a time. Hand it to n8n: at 7 a.m. it reads the job sheet, skips anything unassigned and emails each tech their own jobs. No AI needed. Your first real automation, free and step by step. [All free Stepthrough videos](https://learn.ynteractive.com/content/videos) ## Frequently asked questions **Why does my n8n schedule run at the wrong time?** The schedule uses the workflow's timezone, which often defaults to America/New_York. Set your own timezone in the workflow Settings before choosing the hour. **Is this course really free?** Yes. Stepthrough is completely free, and the practice copy needs no accounts. To build it for real you need your own n8n and Google accounts, and some of those cost money once you use them for real work. **How do I send each row to a different email address in n8n?** Put the address in a column, then set the Gmail node's To field to an expression for that column, like {{ $json["Tech Email"] }}. n8n fills it in separately for every item. **How do I skip rows with a blank column in n8n?** Add a Filter node after Google Sheets, set the value to that column's expression, such as {{ $json.Tech }}, and choose the String test is not empty. Rows with a blank tech are discarded. **How do I remove "sent with n8n" from the email?** In the Gmail node, add the Append n8n Attribution option and switch it off. [Start this module free](https://learn.ynteractive.com/modules/job-alerts) - Previous in Business Automations: [n8n AI Email Responder: Draft Gmail Replies Automatically](https://learn.ynteractive.com/content/ai-email-responder-gmail-drafts-n8n) - Next in Business Automations: [Gmail AI Triage: Auto-Label Every Email and Draft Replies](https://learn.ynteractive.com/content/gmail-ai-triage-labels-drafts-n8n) ## More in Business Automations - [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets): Drop a photo of a receipt into an n8n chat. An AI agent reads it, pulls out the date, vendor and amount, picks a category, and adds a row to Google Sheets. - [A Support Agent That Answers from Your Own Docs](https://learn.ynteractive.com/content/support-agent-answers-from-your-docs-n8n): Turn an n8n chat agent into a support agent that answers only from your policies in a Google Doc, refuses what it should, and hands off to a person by email. [All 34 modules in Business Automations](https://learn.ynteractive.com/content/course/business-automations) ## More n8n tutorials - [n8n AI Agent Tutorial: Save Social Media Ideas to Google Sheets](https://learn.ynteractive.com/content/n8n-ai-agent-tutorial-google-sheets): Build an AI agent for BrightPath Marketing that generates social media post ideas and saves them to Google Sheets — chat trigger, AI Agent, system prompt, model… - [Lovable + n8n: Build a Web App with an AI Backend](https://learn.ynteractive.com/content/lovable-n8n-web-app-ai-backend): Build a contact form in Lovable and connect it to an n8n workflow — webhook trigger, AI Agent, Google Sheets, Gmail, and a Respond node that ties it all together. - [Build an AI Follow-Up Agent for HVAC Service Calls](https://learn.ynteractive.com/content/hvac-service-follow-up-ai-agent-n8n): Build an AI agent for Cedar Ridge Heating & Air that writes follow-up messages for completed service calls and saves them to Google Sheets — chat trigger, AI Agent… - [Build an AI Service Request Form for Your HVAC Company](https://learn.ynteractive.com/content/hvac-service-request-form-ai-lovable-n8n): Build a service request form in Lovable for Cedar Ridge Heating & Air and connect it to n8n — the AI agent sorts each job into repair, maintenance, install or… - [Build an AI Job Follow-Up Agent for Electricians](https://learn.ynteractive.com/content/electrician-job-follow-up-ai-agent-n8n): Build an AI agent for Oak & Wire Electric that writes follow-up messages after completed jobs and tracks them in Google Sheets — chat trigger, AI Agent, system prompt… - [Build an AI Quote Request Form for Electrical Contractors](https://learn.ynteractive.com/content/electrical-quote-request-form-ai-lovable-n8n): Build a quote request form in Lovable and connect it to an n8n workflow — webhook trigger, an AI Agent that drafts an initial estimate note, Google Sheets, Gmail, and a… ## From the blog - [How to Learn AI from Scratch: The Order That Works](https://learn.ynteractive.com/content/blog/how-to-learn-ai-from-scratch): Learn AI for work in the right order: prompts first, then real tasks with a fact check, then simple automation, then agents. Free lessons for each step. - [What Does Publish Mean in n8n? Test vs Publish, Explained](https://learn.ynteractive.com/content/blog/n8n-publish-workflow): Publishing an n8n workflow makes it run on its own when its trigger fires. How Publish differs from Execute workflow, and what to check before clicking it. - [AI for Office Managers: A Week of Tasks, Mapped](https://learn.ynteractive.com/content/blog/ai-for-office-managers): AI for office managers: a normal work week mapped to free lessons, from Monday's meeting recap to inbox drafts and receipts, plus one set of office rules. [All blog posts](https://learn.ynteractive.com/content/blog) ## Visual guides This lesson’s key ideas as quick visual guides: swipe through the slides, or read the same guide as text. - [What is automation, really?](https://learn.ynteractive.com/content/visual/term-automation): AI term of the day: automation. - [Email each tech their jobs at 7am with n8n](https://learn.ynteractive.com/content/visual/job-alerts-n8n): Every morning someone at Rapid Flow Plumbing copies the day's jobs into emails, one tech at a time. Hand it to n8n. - [Mistake to Avoid: Scheduling Before Setting the Timezone](https://learn.ynteractive.com/content/visual/mistake-scheduling-before-the-timezone): A visual tip for n8n schedules: set the workflow timezone before the schedule, so 7am means 7am where your business is. [All visual guides](https://learn.ynteractive.com/content/visual) ## Free cheat sheets Print it or save the PDF: the key steps and checks from this lesson on one page, free. - [Daily Job Alerts in n8n Cheat Sheet](https://learn.ynteractive.com/content/cheat-sheets/daily-job-alerts-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. - [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. [All free printable cheat sheets](https://learn.ynteractive.com/content/cheat-sheets) ## Terms in this lesson Plain-English definitions, each with an example from a free lesson. [Automation](https://learn.ynteractive.com/content/glossary/automation) · [Dispatching](https://learn.ynteractive.com/content/glossary/dispatching) · [Filter node](https://learn.ynteractive.com/content/glossary/filter-node) · [Get rows (reading a sheet)](https://learn.ynteractive.com/content/glossary/get-rows) · [Item (n8n)](https://learn.ynteractive.com/content/glossary/item) · Rate limit · [Schedule Trigger](https://learn.ynteractive.com/content/glossary/schedule-trigger) · [Workflow](https://learn.ynteractive.com/content/glossary/workflow) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [Appointment reminder text prompt and examples](https://learn.ynteractive.com/content/prompts/appointment-reminder-text-prompt): Appointment reminder text examples and a ChatGPT prompt that writes day-before reminders: time window, who is coming, one prep… - [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… - [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… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## More terms on this topic [Cron expression](https://learn.ynteractive.com/content/glossary/cron-expression) · [Polling](https://learn.ynteractive.com/content/glossary/polling) · [Resource and operation (n8n)](https://learn.ynteractive.com/content/glossary/resource-and-operation) · [Test step](https://learn.ynteractive.com/content/glossary/test-step) ## More prompts on this topic - [Employee recognition message prompt](https://learn.ynteractive.com/content/prompts/employee-recognition-message-prompt): Write a short, specific thank-you to an employee for the team chat or a huddle: what they did, why it mattered, in your voice… - [Internal announcement prompt](https://learn.ynteractive.com/content/prompts/internal-announcement-prompt): Announce a change to your team in under 150 words: what changes, when it starts, what each person does and who to ask, plus the… - [Invoice email prompt](https://learn.ynteractive.com/content/prompts/invoice-email-prompt): Write the short email that goes with a new invoice: what the work was, the amount, the due date and how to pay, using only your… - [Post-job care instructions prompt](https://learn.ynteractive.com/content/prompts/post-job-care-instructions-prompt): Turn your own care notes for one job type into a leave-behind sheet: what's normal, simple upkeep, what not to touch, and when… - [Referral request prompt](https://learn.ynteractive.com/content/prompts/referral-request-prompt): A ChatGPT prompt for a short, personal referral ask: thank the customer for real work, describe who you help, and mention a… - [Shift schedule announcement prompt](https://learn.ynteractive.com/content/prompts/shift-schedule-announcement-prompt): Announce a new or changed shift schedule clearly: what changes, for whom, from when, a schedule table, what stays the same, and… ## Browse related tutorials [Business Automations (34)](https://learn.ynteractive.com/content/course/business-automations) · [n8n tutorials (56)](https://learn.ynteractive.com/content/tool/n8n)