Skip to content

Instantly share code, notes, and snippets.

@SocialismTools
Created March 17, 2022 05:21
Show Gist options
  • Save SocialismTools/1e6c71f625d369ba7ce218c2594355c8 to your computer and use it in GitHub Desktop.
Save SocialismTools/1e6c71f625d369ba7ce218c2594355c8 to your computer and use it in GitHub Desktop.
{
"nodes": [
{
"parameters": {},
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
120,
300
]
},
{
"parameters": {
"httpMethod": "POST",
"path": "8f7a7cd5-0f1e-4103-ac59-10baca760abb",
"options": {}
},
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
300,
300
],
"webhookId": "8f7a7cd5-0f1e-4103-ac59-10baca760abb",
"alwaysOutputData": false,
"retryOnFail": true,
"notesInFlow": true,
"continueOnFail": true,
"notes": "Has test and production URLs"
},
{
"parameters": {
"operation": "append",
"sheetId": "1G8hvQ8lS135cPAKUlJNEVZRL8IBFWR6q-yJ6LUCYU14",
"range": "Outreach Log 2!A:K",
"options": {
"valueInputMode": "USER_ENTERED"
}
},
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
900,
200
],
"executeOnce": true,
"credentials": {
"googleApi": {
"id": "5",
"name": "Google account"
}
}
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"string": [
{
"name": "Email",
"value": "={{$json[\"body\"][0][\"osdi:submission\"][\"person\"][\"email_addresses\"][0].address}}"
},
{
"name": "Name",
"value": "={{$json[\"body\"][0][\"osdi:submission\"][\"person\"][\"custom_fields\"][\"First Name\"]}}"
},
{
"name": "Status",
"value": "Drag formula down here"
},
{
"name": "How?",
"value": "AN Intake form"
},
{
"name": "Start",
"value": "={{new Date().toLocaleDateString()}}"
},
{
"name": "Intake Notes",
"value": "={{$json[\"body\"][0][\"osdi:submission\"][\"person\"][\"custom_fields\"][\"note\"]}}"
}
],
"boolean": [
{
"name": "Programming",
"value": "={{parseInt($json[\"body\"][0][\"osdi:submission\"][\"person\"][\"custom_fields\"][\"programming\"])== 1 ? \"TRUE\" : \"FALSE\"}}"
},
{}
]
},
"options": {
"dotNotation": true
}
},
"name": "Set",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
720,
200
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$json[\"body\"][0][\"osdi:submission\"][\"person\"][\"custom_fields\"][\"wants_to_volunteer\"]}}",
"value2": "1"
}
],
"number": [],
"boolean": []
},
"combineOperation": "any"
},
"name": "IF",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
500,
300
],
"notesInFlow": true,
"notes": "If the person says they want to volunteer, put them in the outreach log."
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "IF",
"type": "main",
"index": 0
}
]
]
},
"Set": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"IF": {
"main": [
[
{
"node": "Set",
"type": "main",
"index": 0
}
]
]
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment