This workflow corresponds to n8n.io template #5284 — 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 →
{
"name": "Daily Govt Exam Quiz Delivery",
"nodes": [
{
"name": "Daily Trigger",
"type": "n8n-nodes-base.cron",
"position": [
250,
300
],
"parameters": {
"cronExpression": "0 6 * * *"
},
"typeVersion": 1
},
{
"name": "Fetch Question",
"type": "n8n-nodes-base.googleSheets",
"position": [
450,
300
],
"parameters": {
"range": "Sheet1!A2:F",
"sheetId": "YOUR_GOOGLE_SHEET_ID",
"valueRenderMode": "FORMATTED_VALUE"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 2
},
{
"name": "Format Quiz",
"type": "n8n-nodes-base.function",
"position": [
650,
300
],
"parameters": {
"functionCode": "\nconst data = items[Math.floor(Math.random() * items.length)].json;\nreturn [{\n json: {\n question: data.question,\n options: `A. ${data.optionA}\\nB. ${data.optionB}\\nC. ${data.optionC}\\nD. ${data.optionD}`,\n correct: data.correctAnswer,\n explanation: data.explanation || \"No explanation provided.\",\n fullText: `\ud83e\udde0 *Daily Quiz Question*\\n\\n*Q:* ${data.question}\\n\\n${data.optionA ? \"A. \" + data.optionA : \"\"}\\n${data.optionB ? \"B. \" + data.optionB : \"\"}\\n${data.optionC ? \"C. \" + data.optionC : \"\"}\\n${data.optionD ? \"D. \" + data.optionD : \"\"}\\n\\n*Answer:* ${data.correctAnswer}\\n\ud83d\udcd8 Explanation: ${data.explanation || \"N/A\"}`\n }\n}];"
},
"typeVersion": 1
},
{
"name": "Send Email",
"type": "n8n-nodes-base.emailSend",
"position": [
850,
100
],
"parameters": {
"text": "={{$json[\"fullText\"]}}",
"subject": "Your Daily Govt Exam Quiz",
"toEmail": "user@example.com",
"fromEmail": "user@example.com"
},
"credentials": {
"smtp": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "Send to Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
850,
300
],
"parameters": {
"text": "={{$json[\"fullText\"]}}",
"chatId": "YOUR_TELEGRAM_CHAT_ID"
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "Send via Twilio",
"type": "n8n-nodes-base.twilio",
"position": [
850,
500
],
"parameters": {
"to": "+1234567890",
"from": "+1234567890",
"message": "={{$json[\"fullText\"]}}"
},
"credentials": {
"twilioApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
}
],
"active": false,
"connections": {
"Format Quiz": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Send to Telegram",
"type": "main",
"index": 0
}
],
[
{
"node": "Send via Twilio",
"type": "main",
"index": 0
}
]
]
},
"Daily Trigger": {
"main": [
[
{
"node": "Fetch Question",
"type": "main",
"index": 0
}
]
]
},
"Fetch Question": {
"main": [
[
{
"node": "Format Quiz",
"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.
googleApismtptelegramApitwilioApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
💡 How It Works: ⏰ Triggers daily at 6:00 AM 📊 Fetches one random question from your Google Sheet 🧠 Formats question, options, correct answer, and explanation 📤 Sends it to:
Source: https://n8n.io/workflows/5284/ — 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.
This workflow continuously monitors the TikTok Ads Library for new creatives from specific advertisers or keyword searches, scrapes them via Apify, logs them into Google Sheets, and sends concise noti
This workflow automates plant care reminders and records using Google Sheets, Telegram, and OpenWeather API.
Apollo Data Enrichment Using Company Id to automatically finds contacts for companies listed in your Google Sheet, enriches each person with emails and phone numbers via Apollo’s API, and writes verif
🌸 Affirmation Sender + Weekly Gratitude Digest v2
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.