{"id":52647,"date":"2025-03-12T14:00:00","date_gmt":"2025-03-12T13:00:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=52647"},"modified":"2025-08-07T21:29:54","modified_gmt":"2025-08-07T19:29:54","slug":"envoyer-des-notifications-slack-a-partir-dune-feuille-de-calcul-google","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/send-slack-notifications-from-a-google-sheets\/","title":{"rendered":"Comment envoyer des notifications Slack \u00e0 partir d'une feuille de calcul Google Sheets en utilisant Apps Script ?"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]
\n

Note:<\/strong> This post was originally published in our community forum.<\/p>\n<\/blockquote>\n

In the modern workplace, automating routine tasks is key to efficiency. One common task is sending notifications based on spreadsheet data, such as birthdays or anniversaries. Slack, a popular communication tool for teams, can be integrated with Google Sheets to send automated notifications, making it easier to celebrate special occasions or remind team members of important dates.<\/p>\n

In this blog post, we\u2019ll guide you through the process of setting up Slack notifications from a Google Spreadsheet using Google Apps Script, and how to create a Slack app for this purpose.<\/p>\n

Creating a Slack app for notifications<\/strong><\/h2>\n

Before diving into the script, you need to set up a Slack app to send notifications to your workspace. Here\u2019s how:<\/p>\n

    \n
  1. Start by visiting the Slack API website<\/strong>\u00a0<\/span>at\u00a0<\/span>https:\/\/api.slack.com\/apps<\/a>. Log in if prompted.<\/li>\n
  2. Create a New App<\/strong>: Click on \u201cCreate New App.\u201d Choose \u201cFrom scratch\u201d and give your app a name. Select the workspace where you want the app installed.<\/li>\n
  3. Enable Incoming Webhooks<\/strong>: After creating your app, go to \u201cIncoming Webhooks\u201d in the \u201cFeatures\u201d section and toggle it on. This allows your app to send messages to a Slack channel.<\/li>\n
  4. Generate a Webhook URL<\/strong>: Click \u201cAdd New Webhook to Workspace,\u201d choose a channel (like #general) for notifications, and click \u201cAllow.\u201d Copy the webhook URL provided.<\/li>\n<\/ol>\n

    This URL is what you\u2019ll use in your Google Apps Script to send messages from your spreadsheet to Slack.<\/p>\n

    Automating Slack notifications with Google Apps Script<\/strong><\/h2>\n

    With your Slack app and webhook ready, the next step is to automate notifications from a Google Spreadsheet. Assume you have a spreadsheet with Column A for emails, Column B for names, and Column C for birthdays.<\/p>\n

      \n
    1. Open Your Spreadsheet<\/strong>: Go to the spreadsheet from which you want to send notifications.<\/li>\n
    2. Access the Apps Script Editor<\/strong>: Click on\u00a0<\/span>Extensions<\/code><\/strong>\u00a0<\/span>>\u00a0<\/span>Apps Script<\/code><\/strong>\u00a0<\/span>and clear any existing code.<\/li>\n
    3. Paste the Script<\/strong>: Use the following Google Apps Script, replacing\u00a0<\/span>'YOUR_WEBHOOK_URL_HERE'<\/code><\/strong>\u00a0<\/span>with your actual webhook URL from Slack.\n
         function<\/span> sendSlackNotifications<\/span>(<\/span>) {\n     var<\/span> webhookUrl = 'YOUR_WEBHOOK_URL_HERE'<\/span>;\n     var<\/span> sheet = SpreadsheetApp<\/span>.getActiveSpreadsheet<\/span>().getSheetByName<\/span>('Sheet1'<\/span>);\n     var<\/span> data = sheet.getDataRange<\/span>().getValues<\/span>();\n     var<\/span> today = new<\/span> Date<\/span>();\n     today.setHours<\/span>(0<\/span>,0<\/span>,0<\/span>,0<\/span>);\n   \n     data.forEach<\/span>(function<\/span>(row, index<\/span>) {\n       \/\/ Skip header row<\/span>\n       if<\/span> (index === 0<\/span>) return<\/span>; \n       var<\/span> email = row[0<\/span>], name = row[1<\/span>], birthday = new<\/span> Date<\/span>(row[2<\/span>]);\n       birthday.setHours<\/span>(0<\/span>,0<\/span>,0<\/span>,0<\/span>);\n   \n       if<\/span> (birthday.getTime<\/span>() === today.getTime<\/span>()) {\n         var<\/span> payload = JSON<\/span>.stringify<\/span>({ text<\/span>: `\ud83c\udf89 Happy Birthday, ${name}<\/span> (${email}<\/span>)! \ud83c\udf89`<\/span> });\n         var<\/span> options = { method<\/span>: 'post'<\/span>, contentType<\/span>: 'application\/json'<\/span>, payload<\/span>: payload };\n         UrlFetchApp<\/span>.fetch<\/span>(webhookUrl, options);\n       }\n     });\n   }<\/code><\/pre>\n<\/li>\n
    4. Save and Run the Script<\/strong>: Click the disk icon to save, then click the play button to run your script manually.<\/li>\n
    5. Automate Daily Notifications<\/strong>: To have this script run daily, click on the clock icon (Triggers) and set a time-based trigger for the\u00a0<\/span>sendSlackNotifications<\/code><\/strong>\u00a0<\/span>function.<\/li>\n<\/ol>\n
      Final thoughts<\/strong><\/h3>\n
      Integrating Slack with Google Sheets through Apps Script is a powerful way to automate notifications. Whether you\u2019re celebrating birthdays, tracking project milestones, or reminding team members of important dates, this setup simplifies communication and ensures no special occasion goes unnoticed. Always remember to keep your webhook URL secure and test your setup thoroughly before rolling it out to your entire team. With a little setup, your team\u2019s communication can become more efficient and engaging.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"
      Note: This post was originally published in our community forum. In the modern workplace, automating routine tasks is key to efficiency. One common task is sending notifications based on spreadsheet data, such as birthdays or anniversaries. Slack, a popular communication tool for teams, can be integrated with Google Sheets to send automated notifications, making it […]<\/p>\n","protected":false},"author":49,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-52647","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=52647"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/52647\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=52647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=52647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=52647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}