\n \n \n\n\n\n"
},
"executeOnce": true,
"typeVersion": 1.2
},
{
"id": "12bd72f5-3028-4572-b59e-1cc143e44a86",
"name": "Everyday @ 9am",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-720,
460
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "ca62c507-bce5-4a63-be0e-e60591408668",
"name": "Everyday @ 8.30am",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-720,
-220
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8,
"triggerAtMinute": 30
}
]
}
},
"typeVersion": 1.2
},
{
"id": "032bec7e-5aff-4103-b81e-e5bc4a88ddde",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
-420
],
"parameters": {
"color": 7,
"width": 700,
"height": 480,
"content": "## 1. Fetch Latest AI Grants, Ignore Those Already Seen\n[Learn more about the Remove Duplicates node](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.removeduplicates/)\n\nA cool feature of n8n's remove duplicates node is that it works across executions. What this means for this template is that the node will help us keep track of grant IDs to know if we've already processed them and if so, filter them out so we won't have duplicate alerts."
},
"typeVersion": 1
},
{
"id": "07147665-3571-4512-adce-2727dcb95240",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-520
],
"parameters": {
"color": 7,
"width": 1000,
"height": 720,
"content": "## 2. Quickly Determine Eligibility Using AI\n[Learn more about the Information Extractor node](https://docs.n8n.io/integrations/builtin/cluster-nodes/root-nodes/n8n-nodes-langchain.information-extractor/)\n\nQualifying Leads requires a lot of contextual reasoning taking into account many factors such as commercials, location and eligibility criteria. Whilst it's not guaranteed AI can or will solve this for your particular requirements, it can however get you a good distance of the way there!\n\nAI in this template intends to reduce time (and therefore cost) for a team member needs to spend per grant listing or increase their coverage of grants which they would otherwise miss due to capacity."
},
"typeVersion": 1
},
{
"id": "f4758b4d-727a-4ce8-b071-3388eb16b219",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
-280
],
"parameters": {
"color": 7,
"width": 520,
"height": 480,
"content": "## 3. Save Results to Grant Tracker\n[Learn more about the Airtable Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.airtable/)\n\nIn n8n, it's easy to send your data anywhere to manage yourself, share with your team or reuse with other workflows. Here for demonstration purposes, we'll just store each grant as a row in our Airtable database.\n\nCheck out the sample Airtable here: https://airtable.com/appiNoPRvhJxz9crl/shrRdP6zstgsxjDKL"
},
"typeVersion": 1
},
{
"id": "a7861a21-021f-4629-b863-2163c7436d13",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
240
],
"parameters": {
"color": 7,
"width": 620,
"height": 500,
"content": "## 4. Generate Latest AI Grants Alert Email\n[Learn more about the HTML Template node](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.html/)\n\nUsing our freshly collected AI grants, it would be nice if we can share them with our team members via email. A nicely formatted email digest can be generated using the HTML template node, with added links for greater impact.\n\nHere in this demonstration, we will loop through all eligible new grants and compile them into a newsletter format using the HTML node.\n"
},
"typeVersion": 1
},
{
"id": "4d09af53-92cb-4288-86d7-dcf695bfb358",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
240
],
"parameters": {
"color": 7,
"width": 640,
"height": 500,
"content": "## 5. Send to a list of Subscribers\n[Learn more about the Gmail node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.gmail/)\n\nFinally, we can source a list of subscribers to send our generated email newsletter.\n\nHere, our subscriber list is another table alongside our grants table that we can import that list using the Airtable node. You can use any email provider that supports HTML but for this demonstration, we're using Gmail for simplicity sake."
},
"typeVersion": 1
},
{
"id": "784d59f3-5b1f-4404-bc04-4bd58cf03585",
"name": "Get Subscribers",
"type": "n8n-nodes-base.airtable",
"position": [
240,
500
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appiNoPRvhJxz9crl",
"cachedResultUrl": "https://airtable.com/appiNoPRvhJxz9crl",
"cachedResultName": "US Grants.gov Tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblaS91hyhguntfaC",
"cachedResultUrl": "https://airtable.com/appiNoPRvhJxz9crl/tblaS91hyhguntfaC",
"cachedResultName": "Subscribers"
},
"options": {},
"operation": "search",
"filterByFormula": "AND({Status} = 'Active')"
},
"credentials": {
"airtableTokenApi": {
"id": "Und0frCQ6SNVX3VV",
"name": "Airtable Personal Access Token account"
}
},
"executeOnce": true,
"typeVersion": 2.1
},
{
"id": "3be0788b-90ef-4648-aa25-1170208a685d",
"name": "Send Subscriber Email",
"type": "n8n-nodes-base.gmail",
"position": [
480,
500
],
"webhookId": "37eeec7a-1982-4137-8473-313bfb6c5b42",
"parameters": {
"sendTo": "={{ $json.Email }}",
"message": "={{ $('Generate Email').first().json.html }}",
"options": {},
"subject": "Daily Newletter for Intersting US Grants"
},
"credentials": {
"gmailOAuth2": {
"id": "Sf5Gfl9NiFTNXFWb",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "14a65482-b314-4a2f-9ce3-87e3aae126f9",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
300
],
"parameters": {
"color": 7,
"width": 460,
"height": 200,
"content": "## Scheduled Triggers\n[Learn more about Scheduled Triggers](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.scheduletrigger)\n\nScheduled triggers are a great way to run this template automatically in the morning ready for your team before they start their working day.\n\nFeel free to adjust the interval to a time which suits you!"
},
"typeVersion": 1
},
{
"id": "b172eb7a-58bc-4d4a-be22-796d34a59897",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
-620
],
"parameters": {
"width": 460,
"height": 900,
"content": "## Try It Out!\n\n### This n8n templates demonstrates how to automatically ingest a source of leads at regular intervals and take advantage of n8n's remove duplicates node to simplify duplicate detection.\nAdditionally after the leads are captured, a simple alerts notification can be generated and shared with team members.\n\n### How it works\n* A scheduled trigger is set to fetch a list of AI grants listed on the grants.gov website in the past day.\n* A Remove Duplicates node is used to track Grant IDs to filter out those already processed by the workflow.\n* New grants are summarized and analysed by AI nodes to determine eligibility and interest which is then saved to an Airtable database.\n* Another scheduled trigger starts a little later than the first to collect and summarize the new grants\n* The results are then compiled into an email template using the HTML node, in the form of a newsletter designed to alert and brief team members of new AI grants.\n* This email is then sent to a list of subscribers using the gmail node.\n\n## How to use\n* Make a copy of sample Airtable here: https://airtable.com/appiNoPRvhJxz9crl/shrRdP6zstgsxjDKL\n* The filters for fetching the grants is currently set to the \"AI\" category. Feel free to change this to include more categories.\n* Not interested in grants, this template can works for other sources of leads just change the endpoint and how you're defining the item ID to track.\n\n\n### Need Help?\nJoin the [Discord](https://discord.com/invite/XPKeKXeB7d) or ask in the [Forum](https://community.n8n.io/)!\n\nHappy Hacking!"
},
"typeVersion": 1
},
{
"id": "f9849413-4dad-44dc-92ec-8879d123bfd3",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
40
],
"parameters": {
"width": 320,
"height": 120,
"content": "### Add your company details here!\nCompany details are added in the system prompt to help the AI determine eligibility. The more details the better!"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Save to Tracker",
"type": "main",
"index": 0
}
]
]
},
"Everyday @ 9am": {
"main": [
[
{
"node": "Get New Eligible Grants Today",
"type": "main",
"index": 0
}
]
]
},
"Generate Email": {
"main": [
[
{
"node": "Get Subscribers",
"type": "main",
"index": 0
}
]
]
},
"Grants to List": {
"main": [
[
{
"node": "Only New Grants",
"type": "main",
"index": 0
}
]
]
},
"Get Subscribers": {
"main": [
[
{
"node": "Send Subscriber Email",
"type": "main",
"index": 0
}
]
]
},
"Only New Grants": {
"main": [
[
{
"node": "Get Grant Details",
"type": "main",
"index": 0
}
]
]
},
"Save to Tracker": {
"main": [
[]
]
},
"Everyday @ 8.30am": {
"main": [
[
{
"node": "AI Grants since Yesterday",
"type": "main",
"index": 0
}
]
]
},
"Get Grant Details": {
"main": [
[
{
"node": "Summarize Synopsis",
"type": "main",
"index": 0
},
{
"node": "Eligibility Factors",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Summarize Synopsis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Eligibility Factors",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Summarize Synopsis": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Eligibility Factors": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"AI Grants since Yesterday": {
"main": [
[
{
"node": "Grants to List",
"type": "main",
"index": 0
}
]
]
},
"Get New Eligible Grants Today": {
"main": [
[
{
"node": "Generate Email",
"type": "main",
"index": 0
}
]
]
}
}
}