This workflow follows the Emailsend → Google Drive 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": "12-backup-diario",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 3 * * *"
}
]
}
},
"id": "cron-backup",
"name": "Cron 03:00 Di\u00e1rio",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
250,
300
]
},
{
"parameters": {
"method": "GET",
"url": "={{ $vars.SAAS_URL }}/api/export/full",
"options": {
"response": {
"response": {
"responseFormat": "json"
}
}
}
},
"id": "export-data",
"name": "Exportar Dados SaaS",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
450,
300
]
},
{
"parameters": {
"jsCode": "const data = $input.first().json;\nconst date = new Date().toISOString().split('T')[0];\nconst filename = `backup_base_agency_${date}.json`;\n\nreturn {\n json: {\n filename,\n content: JSON.stringify(data, null, 2),\n date,\n size: JSON.stringify(data).length\n }\n};"
},
"id": "prepare-backup",
"name": "Preparar Backup",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
650,
300
]
},
{
"parameters": {
"resource": "file",
"operation": "upload",
"name": "={{ $json.filename }}",
"parents": [
"backups"
],
"binaryData": false,
"fileContent": "={{ $json.content }}"
},
"id": "save-drive",
"name": "Salvar Google Drive",
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
850,
300
],
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"fromEmail": "={{ $vars.AGENCY_EMAIL }}",
"toEmail": "admin@agenciabase.tech",
"subject": "=\u2705 Backup Di\u00e1rio - {{ $now.format('dd/MM/yyyy') }}",
"emailType": "text",
"message": "=Backup realizado com sucesso!\\n\\nArquivo: {{ $json.filename }}\\nTamanho: {{ Math.round($json.size / 1024) }} KB\\nData: {{ $now.format('dd/MM/yyyy HH:mm') }}\\n\\nO arquivo foi salvo no Google Drive na pasta 'backups'."
},
"id": "notify-email",
"name": "Notificar Admin",
"type": "n8n-nodes-base.emailSend",
"typeVersion": 2.1,
"position": [
1050,
300
],
"credentials": {
"smtp": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Cron 03:00 Di\u00e1rio": {
"main": [
[
{
"node": "Exportar Dados SaaS",
"type": "main",
"index": 0
}
]
]
},
"Exportar Dados SaaS": {
"main": [
[
{
"node": "Preparar Backup",
"type": "main",
"index": 0
}
]
]
},
"Preparar Backup": {
"main": [
[
{
"node": "Salvar Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Salvar Google Drive": {
"main": [
[
{
"node": "Notificar Admin",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"tags": [
"backup",
"sistema"
]
}
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.
googleDriveOAuth2Apismtp
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
12-backup-diario. Uses httpRequest, googleDrive, emailSend. Scheduled trigger; 5 nodes.
Source: https://github.com/gabrielkendy/agenciabase/blob/cd61434f6cec21ef170654b7311b2510dccc74af/n8n-workflows/12-backup-diario.json — 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.
Birthday Automation - Production (Fixed). Uses stopAndError, httpRequest, emailSend, bannerbear. Scheduled trigger; 86 nodes.
This workflow is an improvement of this workflow by Greg Brzezinka.
The Sora 2 API allows seamless generation of CGI ads, turning text prompts into stunning videos. This workflow automates the entire process from video generation to upload, notification, and file shar
N8N-Self-Updater. Uses ssh, emailSend, httpRequest. Scheduled trigger; 27 nodes.
Create CGI ads effortlessly by integrating the Google Veo3 API for video generation and uploading to Google Drive with seamless email notifications. On form submission: Triggers the workflow when a fo