Retrieve records from Google Sheets that correspond to today's date and send a batch notification to Google Chat daily.

■Overview

This is a flow that retrieves records from Google Sheets that match today's date and sends a batch notification to Google Chat daily.

‍

■Recommended for

1. Those who use Google Sheets to conduct their business

・Consultants managing schedules with clients

‍

2. Those who use Google Chat as their main communication tool

・Those who utilize Google Chat for sharing documents

・Those who use Google Chat for project management communications

‍

■Benefits of using this template

Google Sheets can be edited outside the office as long as there is an internet connection.
However, manually notifying information from Google Sheets each time is inefficient and time-consuming.

This template is suitable for those who want to automate notifications via Google Chat even when outside the office.
By using this template, you can eliminate the need for manual notifications in different device environments, making notification tasks effortless.

‍

■Notes‍

・Please integrate both Google Sheets and Google Chat with Yoom.

・Integration with Google Chat is only possible with Google Workspace. For details, please refer to here.

・The maximum number of records that can be retrieved from Google Sheets is 10. If you need to retrieve more than 10, you will need the "Repeat the same process" operation.

　※The "Repeat the same process" operation is available only in the Team Plan and Success Plan.

・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use apps that are subject to restrictions.