{"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 {{$('Date & Time').first().json[\"day_today\"]}} {{$('Date & Time').first().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.scheduleTrigger","position":[310,290],"parameters":{"rule":{"interval":[{"field":"cron","cronExpression":"0 8 * * *"}]}},"typeVersion":1.2},{"name":"Get the date today","type":"n8n-nodes-base.code","position":[470,290],"parameters":{"jsCode":"const now = new Date();\nconst weekday = ['Dimanche','Lundi','Mardi','Mercredi','Jeudi','Vendredi','Samedi'];\nreturn [{ json: { ...$input.first().json, date_today: now.toISOString(), day_today: weekday[now.getDay()] } }];"},"typeVersion":2},{"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"}