Retrieve records from Google Sheets that correspond to today's date and send a batch notification to Microsoft Teams every day.

■Overview

This is a flow that retrieves records corresponding to today's date on Google Sheets and notifies Microsoft Teams in bulk every day.

‍

■Recommended for

1. Those who use Google Sheets to conduct their work

・Product managers managing development schedules for new projects

‍

2. Those who use Microsoft Teams as their main communication tool

・Those who use Microsoft Teams for sharing progress among members

‍

■Benefits of using this template

Google Sheets reflects changes in real-time, allowing instant confirmation of each task's progress. However, depending on the timing of confirmation, there may be discrepancies in understanding among members.

This template can notify records corresponding to today's date in bulk, reducing discrepancies in understanding among members.

‍

■Notes‍

・Please integrate both Google Sheets and Microsoft Teams with Yoom.

・Microsoft365 (formerly Office365) has plans for home use and general business use (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail.

・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 two-week free trial. During the free trial, you can use apps that are subject to restrictions.