Automatiser le contrôle et la validation des factures fournisseurs

				
					{"meta":{"instanceId":"82a17fa4a0b8e81bf77e5ab999d980f392150f2a9541fde626dc5f74857b1f54"},"nodes":[{"id":"4ea39a4f-d8c1-438f-9738-bfbb906a3d7a","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[1200,1020],"parameters":{"width":253,"height":342,"content":"## Send customer feedback to OpenAI for sentiment analysis"},"typeVersion":1},{"id":"6962ea41-7d15-4932-919f-21ac94fa1269","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[1960,1180],"parameters":{"width":253,"height":342,"content":"## Add new feedback to google sheets"},"typeVersion":1},{"id":"4c8a8984-2d8e-4139-866b-6f3536aced07","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[800,1600],"parameters":{"width":1407,"height":254,"content":"## Instructionsn1. Connect Google sheetsn2. Connect your OpenAi account (api key + org Id)n3. Create a customer feedback form, use an existing one or use the one below as example. nAll set!nnn- Here is the example google sheet being used in this workflow: https:\/\/docs.google.com\/spreadsheets\/d\/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4\/edit?usp=sharing. You can download it to your account."},"typeVersion":1},{"id":"d43a9574-626d-4817-87ba-d99bdd6f41dc","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[800,1160],"parameters":{"width":253,"height":342,"content":"## Feedback form is submitted"},"typeVersion":1},{"id":"76dab2dc-935f-416e-91aa-5a1b7017ec1b","name":"Sticky Note6","type":"n8n-nodes-base.stickyNote","position":[1600,1180],"parameters":{"width":253,"height":342,"content":"## Merge form data and OpenAI result"},"typeVersion":1},{"id":"9772eac1-8df2-4305-9b2c-265d3c5a9a4a","name":"Add customer feedback to Google Sheets","type":"n8n-nodes-base.googleSheets","position":[2020,1320],"parameters":{"columns":{"value":{"Category":"={{ $json['What is your feedback about?'] }}","Sentiment":"={{ $json.text }}","Timestamp":"={{ $json.submittedAt }}","Entered by":"=Form","Customer Name":"={{ $json.Name }}","Customer contact":"={{ $json['How do we get in touch with you?'] }}","Customer Feedback":"={{ $json['Your feedback'] }}"},"schema":[{"id":"Timestamp","type":"string","display":true,"required":false,"displayName":"Timestamp","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Category","type":"string","display":true,"required":false,"displayName":"Category","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Customer Feedback","type":"string","display":true,"required":false,"displayName":"Customer Feedback","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Customer Name","type":"string","display":true,"required":false,"displayName":"Customer Name","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Customer contact","type":"string","display":true,"required":false,"displayName":"Customer contact","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Entered by","type":"string","display":true,"required":false,"displayName":"Entered by","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Urgent?","type":"string","display":true,"required":false,"displayName":"Urgent?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Sentiment","type":"string","display":true,"required":false,"displayName":"Sentiment","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":[]},"options":[],"operation":"append","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https:\/\/docs.google.com\/spreadsheets\/d\/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4\/edit#gid=0","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"list","value":"1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4","cachedResultUrl":"https:\/\/docs.google.com\/spreadsheets\/d\/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4\/edit?usp=drivesdk","cachedResultName":"CustomerFeedback"}},"credentials":{"googleSheetsOAuth2Api":{"id":"3","name":"Google Sheets account"}},"typeVersion":4.1},{"id":"12084971-c81b-4a0e-814e-120867562642","name":"Merge sentiment with form content","type":"n8n-nodes-base.merge","position":[1680,1320],"parameters":{"mode":"combine","options":[],"combinationMode":"multiplex"},"typeVersion":2.1},{"id":"235edf5b-7724-4712-8dc5-d8327a0620b8","name":"Classify feedback with OpenAI","type":"n8n-nodes-base.openAi","position":[1280,1180],"parameters":{"prompt":"=Classify the sentiment in the following customer feedback:  {{ $json['Your feedback'] }}","options":[]},"credentials":{"openAiApi":{"id":"s2iucY0IctjYNbrb","name":"OpenAi account"}},"typeVersion":1},{"id":"af4b22aa-0925-40b1-a9ac-298f9745a98e","name":"Submit form with customer feedback","type":"n8n-nodes-base.formTrigger","position":[860,1340],"webhookId":"e7bf682e-48e8-40de-9815-cd180cdd1480","parameters":{"options":{"formSubmittedText":"Your response has been recorded"},"formTitle":"Customer Feedback","formFields":{"values":[{"fieldLabel":"Name","requiredField":true},{"fieldType":"dropdown","fieldLabel":"What is your feedback about?","fieldOptions":{"values":[{"option":"Product"},{"option":"Service"},{"option":"Other"}]},"requiredField":true},{"fieldType":"textarea","fieldLabel":"Your feedback","requiredField":true},{"fieldLabel":"How do we get in touch with you?"}]},"formDescription":"Please give feedback about our company orproducts."},"typeVersion":1}],"connections":{"Classify feedback with OpenAI":{"main":[[{"node":"Merge sentiment with form content","type":"main","index":0}]]},"Merge sentiment with form content":{"main":[[{"node":"Add customer feedback to Google Sheets","type":"main","index":0}]]},"Submit form with customer feedback":{"main":[[{"node":"Classify feedback with OpenAI","type":"main","index":0},{"node":"Merge sentiment with form content","type":"main","index":1}]]}}}