Permettez à vos collaborateurs de soumettre leurs notes de frais via un formulaire ou une appli mobile, avec validation et intégration directe en comptabilité.
Permettez à vos collaborateurs de soumettre leurs notes de frais via un formulaire ou une appli mobile, avec validation et intégration directe en comptabilité.
{
"nodes": [
{
"name": "Get Content Ideas",
"type": "n8n-nodes-base.googleSheets",
"position": [
200,
300
],
"parameters": {
"range": "Sheet1!A:C",
"sheetId": "YOUR_GOOGLE_SHEET_ID"
},
"credentials": {
"googleSheetsOAuth2Api": "YOUR_GOOGLE_SHEETS_CREDENTIALS"
},
"typeVersion": 1
},
{
"name": "Generate Post with OpenAI",
"type": "n8n-nodes-base.openAi",
"position": [
500,
300
],
"parameters": {
"model": "gpt-4",
"prompt": "Create a social media post for {{$node["Get Content Ideas"].json["Platform"]}} based on this idea: {{$node["Get Content Ideas"].json["Idea"]}}. Keep it engaging and concise."
},
"credentials": {
"openAIApi": "YOUR_OPENAI_CREDENTIALS"
},
"typeVersion": 1
},
{
"name": "Check Platform",
"type": "n8n-nodes-base.if",
"position": [
800,
300
],
"parameters": {
"conditions": {
"string": [
{
"value1": "{{$node["Get Content Ideas"].json["Platform"]}}",
"value2": "Twitter",
"operation": "equal"
}
]
}
},
"typeVersion": 1
},
{
"name": "Post to Twitter",
"type": "n8n-nodes-base.twitter",
"position": [
1000,
200
],
"parameters": {
"text": "{{$node["Generate Post with OpenAI"].json["text"]}}"
},
"credentials": {
"twitterOAuth1Api": "YOUR_TWITTER_CREDENTIALS"
},
"typeVersion": 1
},
{
"name": "Update Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
300
],
"parameters": {
"range": "Sheet1!D:F",
"values": "Posted,{{$node["Generate Post with OpenAI"].json["text"]}},{{Date.now()}}",
"sheetId": "YOUR_GOOGLE_SHEET_ID",
"updateOperation": "append"
},
"credentials": {
"googleSheetsOAuth2Api": "YOUR_GOOGLE_SHEETS_CREDENTIALS"
},
"typeVersion": 1
}
],
"connections": {
"Check Platform": {
"main": [
[
{
"node": "Post to Twitter",
"type": "main"
}
]
]
},
"Post to Twitter": {
"main": [
[
{
"node": "Update Google Sheet",
"type": "main"
}
]
]
},
"Get Content Ideas": {
"main": [
[
{
"node": "Generate Post with OpenAI",
"type": "main"
}
]
]
},
"Generate Post with OpenAI": {
"main": [
[
{
"node": "Check Platform",
"type": "main"
}
]
]
}
}
}