Uploaded March 2025 | Updated November 2026, 5 hours ago
In this video, we're doing to walk through how to streamline getting data from Excel files on your Google Drive into Google Sheets, including archiving or deleting the processed Excel files and how to add a trigger to make the script run automatically.
You can download the final Google Sheet and Apps Script here: bit.ly/4kh5aVD
In this video, we're doing to walk through how to streamline getting data from Excel files on your Google Drive into Google Sheets, including archiving or deleting the processed Excel files and how to add a trigger to make the script run automatically.
You can download the final Google Sheet and Apps Script here: bit.ly/4kh5aVD







![How to Create a Slack Webhook and Post from Apps Script
In todays video, Ill show you how to create a webhook in Slack so you can post messages to Slack from Google Apps Script.
***SLACK LINKS***
Create a new app: https://api.slack.com/apps
Message Formatting: https://docs.slack.dev/messaging/formatting-message-text
Block Kit Builder: https://app.slack.com/block-kit-builder
***** Sample Google Apps Script to Post Message to Slack *****
function sendMessageToSlack() {
let webhookURL = WEBHOOK_URL;
let name = Sheets Ninja;
let body = {
blocks: [
{
type: section,
text: {
type: mrkdwn,
text: `Hey, Slack!nnThis is a test message.nnThanks ${name} for your contributions!`
}
}
]
}
let params = {
method: POST,
content-type: application/json,
payload: JSON.stringify(body)
}
UrlFetchApp.fetch(webhookURL, params);
} How to Create a Slack Webhook and Post from Apps Script](https://i.ytimg.com/vi/ho_O9Ora8JI/mqdefault.jpg)


