Sk developer This workflow corresponds to n8n.io template #8248 — we link there as the canonical source.
This workflow follows the Emailsend → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "c0dd2da3-624a-4730-8711-dc495ed587d0",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "5f323b68-04ad-4dd6-bdd9-58de3b01dbef",
"name": "Fetch Udemy Coupons",
"type": "n8n-nodes-base.httpRequest",
"position": [
208,
0
],
"parameters": {
"url": "https://udemy-coupons-and-courses.p.rapidapi.com/featured.php",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "page",
"value": "1"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "udemy-coupons-and-courses.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "6c2dc08a-8ee6-4865-b29a-d43b25c5d303",
"name": "Check API Success",
"type": "n8n-nodes-base.if",
"position": [
448,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f251122a-946f-4d41-a0fc-f5ecd3fa03f3",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.body.success }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b6e4ffb5-a99a-452e-be88-371f97857a35",
"name": "Filter Free Courses",
"type": "n8n-nodes-base.code",
"position": [
688,
-16
],
"parameters": {
"jsCode": "const courses = $input.first().json.courses;\nconst freeCourses = courses.filter(course => course.sale_price === 0);\nreturn freeCourses;\n"
},
"typeVersion": 2
},
{
"id": "b9789ce1-8fe2-4e11-a22c-83d59b3e5c83",
"name": "Send Error Notification",
"type": "n8n-nodes-base.emailSend",
"position": [
688,
336
],
"parameters": {
"html": "=Hello,\n\nAn error occurred while trying to fetch Udemy coupons from the API.\n\nPlease check the API and the workflow to resolve the issue.\n",
"options": {},
"subject": "Udemy Coupons Fetch Error - Immediate Attention Required",
"toEmail": "user@example.com",
"fromEmail": "user@example.com"
},
"credentials": {
"smtp": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "b0cafa14-748d-4e5a-aa7c-5bbb6b32dbc3",
"name": "Sync Courses to Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
992,
-16
],
"parameters": {
"columns": {
"value": {
"id": "={{ $json.id }}",
"name": "={{ $json.name }}",
"slug": "={{ $json.slug }}",
"image": "={{ $json.image }}",
"price": "={{ $json.price }}",
"store": "={{ $json.store }}",
"views": "={{ $json.views }}",
"rating": "={{ $json.rating }}",
"category": "={{ $json.category }}",
"language": "={{ $json.language }}",
"lectures": "={{ $json.lectures }}",
"sale_price": "={{ $json.sale_price }}",
"sale_start": "={{ $json.sale_start }}",
"subcategory": "={{ $json.subcategory }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "price",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sale_price",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sale_price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lectures",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "lectures",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "views",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "views",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "language",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subcategory",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subcategory",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "slug",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "slug",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "store",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "store",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sale_start",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sale_start",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Courses"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "4f577854-770c-46f2-b477-6f7c6a0cc522",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
-144
],
"parameters": {
"height": 304,
"content": "### Schedule Trigger \nTriggers the workflow on an hourly schedule. \nStarts the process of fetching Udemy coupons automatically."
},
"typeVersion": 1
},
{
"id": "4813d9c9-db84-49a3-b037-d95f73d7869a",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-144
],
"parameters": {
"height": 304,
"content": "### Fetch Udemy Coupons \nSends a POST request to fetch featured Udemy courses via API. \nIncludes necessary headers and form-data for the API call."
},
"typeVersion": 1
},
{
"id": "139c1e96-3220-4e02-b736-f52dcb7614a3",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
-144
],
"parameters": {
"height": 304,
"content": "### Check API Success \nChecks if the API response indicates a successful fetch. \nRoutes workflow either to filter courses or send an error notification.\n"
},
"typeVersion": 1
},
{
"id": "ce832f7f-34c1-40fe-bdea-ef35e9904f0d",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
672,
-144
],
"parameters": {
"height": 304,
"content": "\n### Filter Free Courses \nFilters out only free courses where sale price is zero. \nPrepares data for syncing with Google Sheets."
},
"typeVersion": 1
},
{
"id": "e9259da8-1aae-45b1-b5fb-40b369e99136",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
208
],
"parameters": {
"height": 272,
"content": "### Send Error Notification \nSends an email alert if the API fetch fails. \nNotifies the admin to check the workflow or API."
},
"typeVersion": 1
},
{
"id": "306c4dda-14aa-4bc8-8956-bcc2d950da37",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
-144
],
"parameters": {
"height": 304,
"content": "### Sync Courses to Google Sheet \nAdds or updates filtered courses into the Google Sheet. \nEnsures the sheet is always up-to-date with latest free courses."
},
"typeVersion": 1
},
{
"id": "4fd417e8-389d-43b3-98f8-cc1178c9c6a4",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-912,
-288
],
"parameters": {
"width": 608,
"height": 592,
"content": "## Automated Udemy Coupon Fetching & Google Sheets Sync\n\n### Description\n\nFetches free Udemy courses hourly via API and syncs them with Google Sheets, sending error alerts if needed.\n\n### Summary\n\nAutomates fetching featured Udemy coupons, filters only free courses, and updates a Google Sheet. Sends email notifications on API errors for quick fixes.\n\n### Node Overview\n\n1. **Schedule Trigger:** Runs workflow hourly.\n2. **Fetch Udemy Coupons:** Requests featured courses via API.\n3. **Check API Success:** Confirms successful data fetch.\n4. **Filter Free Courses:** Selects courses with sale price zero.\n5. **Send Error Notification:** Emails admin on API failure.\n6. **Sync Courses to Google Sheet:** Updates Google Sheet with free courses.\n\n"
},
"typeVersion": 1
}
],
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Fetch Udemy Coupons",
"type": "main",
"index": 0
}
]
]
},
"Check API Success": {
"main": [
[
{
"node": "Filter Free Courses",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Error Notification",
"type": "main",
"index": 0
}
]
]
},
"Fetch Udemy Coupons": {
"main": [
[
{
"node": "Check API Success",
"type": "main",
"index": 0
}
]
]
},
"Filter Free Courses": {
"main": [
[
{
"node": "Sync Courses to Google Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleApismtp
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow fetches free Udemy courses hourly via the Udemy Coupons and Courses API on RapidAPI, filters them, and updates a Google Sheet. It sends alerts on errors for smooth monitoring. Schedule Trigger: Runs the workflow every hour automatically. Fetch Udemy Coupons: Sends…
Source: https://n8n.io/workflows/8248/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
Gmail, Google Drive, Google Sheets +1
Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google
Google Sheets, HTTP Request, WhatsApp +1
This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store.
Google Sheets, HTTP Request, Gmail
This n8n template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.
Google Sheets, HTTP Request, Google Drive +1
I created this workflow with care for marketing professionals and agencies who manage multiple Meta Ads (Facebook) accounts and want to track ad account balances automatically — no more logging in eve
HTTP Request, Google Sheets, Gmail