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 →
{
"active": false,
"connections": {
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "busca matr\u00edculas",
"type": "main",
"index": 0
}
]
]
},
"busca matr\u00edculas": {
"main": [
[
{
"node": "Confere de Datas",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2025-07-01T15:27:09.357Z",
"id": "mt3QPuoUuq9o8HO9",
"isArchived": false,
"meta": {
"templateCredsSetupCompleted": true
},
"name": "fomracao",
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
0,
0
],
"id": "5d4cb833-5d55-4565-8bf1-dcb7075bccd4",
"name": "When clicking \u2018Test workflow\u2019"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "https://docs.google.com/spreadsheets/d/1_0ElM1Ygp8VYdLBEe1og5GB56-bAuBCLjasyzEdtPa4/edit?gid=0#gid=0",
"mode": "url"
},
"sheetName": {
"__rl": true,
"value": 781285383,
"mode": "list",
"cachedResultName": "alunos",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_0ElM1Ygp8VYdLBEe1og5GB56-bAuBCLjasyzEdtPa4/edit#gid=781285383"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
220,
0
],
"id": "44fc69cf-8f55-4966-acb2-99469c870265",
"name": "busca matr\u00edculas",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"leftValue": "={{ $json[\"Data de expira\u00e7\u00e3o\"].toDateTime().diffTo($now, 'days').round() }}",
"rightValue": 30,
"operator": {
"type": "number",
"operation": "equals"
},
"id": "33e8d2bf-4585-4e41-aace-fdf1b127e74a"
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "3O DIAS"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "3422bd72-1411-4401-ae06-8ba444ef2786",
"leftValue": "={{ $json[\"Data de expira\u00e7\u00e3o\"].toDateTime().diffTo($now, 'days').round() }}",
"rightValue": 15,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "15 DIAS"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "87801f82-7719-4834-9d17-f6565b022499",
"leftValue": "={{ $json[\"Data de expira\u00e7\u00e3o\"].toDateTime().diffTo($now, 'days').round() }}",
"rightValue": 7,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "7 DIAS"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "2082a47b-eb01-459c-a88d-452fc7b31b40",
"leftValue": "={{ $json[\"Data de expira\u00e7\u00e3o\"].toDateTime().diffTo($now, 'days').round() }}",
"rightValue": 1,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "1 DIA"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "25abd313-f112-45a0-b8da-a34860e126da",
"leftValue": "={{ $json[\"Data de expira\u00e7\u00e3o\"].toDateTime().diffTo($now, 'days').round() }}",
"rightValue": 0,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "HOJE"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.switch",
"typeVersion": 3.2,
"position": [
460,
-40
],
"id": "d65ebe00-e34e-4488-b6b4-0e7fbbdd4387",
"name": "Confere de Datas"
}
],
"settings": {
"executionOrder": "v1"
},
"shared": [
{
"updatedAt": "2025-07-01T15:27:09.357Z",
"createdAt": "2025-07-01T15:27:09.357Z",
"role": "workflow:owner",
"workflowId": "mt3QPuoUuq9o8HO9",
"projectId": "AxNpta0sA2v4gJ2a"
}
],
"staticData": null,
"tags": [],
"triggerCount": 0,
"updatedAt": "2025-07-01T18:00:47.352Z",
"versionId": "3cae8d3c-27ad-4020-adae-64aa145bbf39"
}
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.
googleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
fomracao. Uses googleSheets. Event-driven trigger; 3 nodes.
Source: https://github.com/bmaworkflows/n8n-backups/blob/73cbd8c70e5aeefea062158ad0ded12484657dae/workflows/fomracao.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.
Description: Easily collect keywords and country input, run automated keyword research via the Semrush Keyword Research API on RapidAPI, and store results in Google Sheets for seamless tracking and an
Task: Make sure that data is in the right format before injecting it into a database/spreadsheet/CRM/etc.
This n8n template provides a practical and efficient way to manage your n8n workflows using Google Sheets as a user-friendly interface. It demonstrates how to leverage a simple spreadsheet to control
This workflow automatically takes a long property URL from your Google Sheet, shortens it, generates a QR code, and then updates your sheet with the new links. 0. Google Sheets (New/Updated Row Trigge
typeform feedback workflow. Uses typeformTrigger, googleSheets. Event-driven trigger; 5 nodes.