{"name":"Send Instagram Statistics To Mattermost","nodes":[{"name":"Mattermost","type":"n8n-nodes-base.mattermost","position":[1030,290],"parameters":{"message":"=Bonjour ! Voici les stats de notre Instagram {{$json[\"Compte\"]}} en ce beau matin du {{$node[\"Date & Time\"].json[\"day_today\"]}} {{$node[\"Date & Time\"].json[\"data\"]}}\nLe nombre de Followers est de : {{$json[\"Followers\"]}}\nNous avons réalisé : {{$json[\"Posts\"]}} posts, \nBravo !","channelId":"xxxxxxx","attachments":[],"otherOptions":{}},"credentials":{"mattermostApi":{"id":"REPLACE_WITH_YOUR_CREDENTIAL","name":"mattermostApi, set in n8n"}},"typeVersion":1},{"name":"Date & Time","type":"n8n-nodes-base.dateTime","position":[640,290],"parameters":{"value":"={{$json[\"date_today\"]}}","custom":true,"options":{},"toFormat":"DD-MM-YYYY"},"typeVersion":1},{"name":"Cron","type":"n8n-nodes-base.cron","position":[310,290],"parameters":{"triggerTimes":{"item":[{"hour":8}]}},"typeVersion":1},{"name":"Get the date today","type":"n8n-nodes-base.function","position":[470,290],"parameters":{"functionCode":"var date = new Date().toISOString();\nvar day = new Date().getDay();\nconst weekday = [\"Dimanche\", \"Lundi\", \"Mardi\", \"Mercredi\", \"Jeudi\", \"Vendredi\", \"Samedi\"];\n\nitems[0].json.date_today = date;\nitems[0].json.day_today = weekday[day];\n\nreturn items;\n"},"typeVersion":1},{"name":"Read data on Google Sheets","type":"n8n-nodes-base.googleSheets","position":[850,290],"parameters":{"range":"cells","options":{},"sheetId":"sheetID","authentication":"oAuth2"},"credentials":{"googleSheetsOAuth2Api":{"id":"REPLACE_WITH_YOUR_CREDENTIAL","name":"googleSheetsOAuth2Api, set in n8n"}},"typeVersion":1},{"id":"747d6a6e-5184-4494-9d3e-c4b0451e2df8","name":"Set - Audit Trail","type":"n8n-nodes-base.set","position":[320,120],"parameters":{"options":{},"assignments":{"assignments":[{"id":"8e49f54d-ccfd-4e55-9ef2-bac247573a6d","name":"timestamp","type":"string","value":"={{ $now }}"},{"id":"77af3ba4-8636-44a3-aa47-254e68db6d6d","name":"execution_id","type":"string","value":"={{ $execution.id }}"}]}},"typeVersion":3.4},{"id":"6b2842d1-10be-467f-b417-b4ea8cee7156","name":"Google Sheets - Audit Log","type":"n8n-nodes-base.googleSheets","position":[460,120],"parameters":{"columns":{"mapping":[{"value":"={{ $now }}","column":"Timestamp"},{"value":"={{ $json.event || 'run' }}","column":"Event"},{"value":"={{ $execution.id }}","column":"Execution ID"}],"mappingMode":"defineBelow"},"options":{},"operation":"append","sheetName":{"__rl":true,"mode":"id","value":"Logs"},"documentId":{"__rl":true,"mode":"id","value":"YOUR_SHEET_ID"}},"credentials":{"googleSheetsOAuth2Api":{"id":"REPLACE_WITH_YOUR_CREDENTIAL","name":"googleSheetsOAuth2Api, set in n8n"}},"typeVersion":4.4},{"id":"9fbc70a2-2bc3-4f47-bbb7-76abf94c5ffe","name":"Slack - Error Alerts","type":"n8n-nodes-base.slack","position":[460,260],"parameters":{"text":"⚠️ 812 Send Instagram Statistics To Mattermost Error: {{ $json.error }} at {{ $now }}","channel":"={{ $env.SLACK_ERROR_CHANNEL }}","otherOptions":{}},"credentials":{"slackApi":{"id":"REPLACE_WITH_YOUR_CREDENTIAL","name":"slackApi, set in n8n"}},"typeVersion":2.1},{"id":"d682d4a5-851a-40d9-91b5-53f08f5b7fd9","name":"Wait - Rate Limit","type":"n8n-nodes-base.wait","position":[600,120],"parameters":{"unit":"seconds","amount":1},"typeVersion":1.1}],"connections":{"Cron":{"main":[[{"node":"Get the date today","type":"main","index":0}]]},"Date & Time":{"main":[[{"node":"Read data on Google Sheets","type":"main","index":0}]]},"Set - Audit Trail":{"main":[[{"node":"Google Sheets - Audit Log","type":"main","index":0}]]},"Get the date today":{"main":[[{"node":"Date & Time","type":"main","index":0}]]},"Google Sheets - Audit Log":{"main":[[{"node":"Wait - Rate Limit","type":"main","index":0}]]},"Read data on Google Sheets":{"main":[[{"node":"Mattermost","type":"main","index":0}]]}},"pinData":{},"settings":{"executionOrder":"v1"},"meta":{"instanceId":"danielgrey.shop","author":"Daniel Grey","createdBy":"Daniel Grey"},"author":"Daniel Grey"}