Category: GAS

Slack had a convenient API “Outgoing Webhook” that we can use when we want to “write messages posted to a Slack channel into a Google Spreadsheet. Previously, we have completed the preparation of “Outgoing Webhook”, so we will continue to make it. Create a new GAS Once the “Outgoing Webhook” in Slack is ready, the…

Slack has a convenient API “Outgoing Webhook” that you can use when you want to write messages posted on Slack’s channel to Google Spreadsheet. Up to the last time, preparations for “Outgoing Webhook” have been completed, so let’s continue. Create a new gas Once Slack’s “Outgoing Webhook” is ready, we will prepare the GAS side.…

Slack has a convenient API “Outgoing Webhook” that you can use when you want to write messages posted on Slack’s channel to Google Spreadsheet. What are Outgoing Webhooks? An API/service for sending Slack messages to external services in the Slack App directory. Outgoing WebhooksOutgoing webhooks was a quirky way to send your own server a…

For example, it is a method that can be used when you want to delete the label created in Gmail at once. Function to delete Gmail label｜deleteLabel() GAS has a function for removing Gmail labels. You can use this to delete currently created labels. Get current labels (GmailApp.getUserLabels) First, get the current label. Labels can be…

How to create Gmail labels with GAS (GoogleAppsScript). GmailApp.createLabel(label name) You can create a label by using ‘GmailApp.createLabel(name)’. Just by executing this, the label name of the argument is newly created. Create a function that creates labels Create a function that creates labels. I’ll try it. At the time of execution, as usual, a confirmation…

I was able to get it using GAS when I wanted to get a list of the data of the images saved in the Google Photos album. That’s the way. It can be obtained by implementing a combination of GoogleAppsScript and Google Cloud Platform. What is Google Cloud Platform? Google Cloud Platform is a cloud computing service provided…

This is a method of setting the time in Chatwork and making a reservation post. Chatwork itself doesn’t seem to have scheduled posts (probably?), but you can use GoogleAppsScript to create scheduled posts for Chatwork. Get Chatwork API Token First of all, you will need an API token called “Chatwork API Token”. Get a new API…

Slack has a convenient API called “Outgoing Webhook” that you can use when you want to “write messages posted to a Slack channel into a Google Spreadsheet. Outgoing Webhooks Outgoing webhooks was a quirky way to send your own server a webhook when messages met a narrow set of criteria. We recommend building Slack apps…

It’s a familiar and convenient Google Spreadsheet, but this time it’s a synchronization script? I will show you how to create a state like this. For example, if you want to synchronize the state of two files (to make the data in the sheet the same state), it seems that such a function is not found in…

Anyway, these days I want to automate various things, but this time it is a method of “notifying LINE when a specific email arrives in Gmail and marking it as read”. Use LINE Notify This time, I will try using “LINE Notify”, which has been indebted to me before. LINE NotifyLINE Notify is a convenient…

Inquiry form creation Usually when you try to create a contact form 1. 2. Set up a server. Build a contact form in PHP I think that’s what it feels like. The method is to use Google Form as a hub and create an inquiry form. Create Google Form First, create a Google Form that will serve…

This application has not been verified This app has not been verified.This app has not been verified by Google. Please continue only if you are a trusted developer with whom you are familiar. If you are a developer, please send a confirmation request to prevent this screen from appearing. This is what to do if…