How to send records from Google Sheets that correspond to today's date to Microsoft Teams at a specified time

Next, let's integrate Yoom with each app.
This is called "My App Integration". Integrating Google Sheets and Microsoft Teams with My App is very easy!

My App Settings

Click on the template banner, and you'll find a "Try this template" button at the bottom of the screen. Click it.
This will take you to a page called "My Projects". From the menu on the left side of the screen, select "My Apps"!
↓
Let's start by integrating Google Sheets with My App.
Click on "Create New" at the top right! Enter "Google Sheets" in the search box, and when the Google Sheets icon appears, click it!

Select Account page: Click on the Google account with the Gmail address you want to integrate with Yoom!
Next, you'll be taken to a page called "Login to Yoom", so press Next.
Finally, if a page appears saying "Yoom is requesting additional access to your Google account", just press Continue, and you're good to go!
↓
Let's proceed to integrate My App with Microsoft Teams.
If you're already logged into Microsoft 365, the integration will be completed quickly, so we recommend logging in beforehand.
↓
Just like before, enter "Microsoft Teams" in the search box and click the Microsoft Teams icon... and the integration is completed without any screen transition!

※ If you are not logged in, a login screen will appear, and the integration will be completed once you log in.

※ Microsoft 365 (formerly Office 365) has both personal and business plans (Microsoft 365 Business), and if you are not subscribed to the business plan, authentication may fail.

With this, the integration of Google Sheets and Microsoft Teams with My App is complete!
Now that the two apps are integrated with Yoom, let's proceed to set up the Flow Bot next.

The Flow Bot setup consists of three steps!

Schedule Trigger Setup

From My Projects on the left side of the screen, click on "Retrieve records from Google Sheets that match today's date and notify Microsoft Teams daily"!
Press Edit at the top right.

↓

Press the schedule icon "When the specified schedule is reached" to move to the above page.
Select the day of the week you want to send Google Sheets data to Microsoft Teams.
Specify the time for sending in the red-framed section.

Once completed, press Save at the bottom of the screen to finish setting up the schedule trigger!

Google Sheets Setup

First, prepare the Google Sheets you want to integrate with Microsoft Teams and pre-enter the items.

This time, we created a Google Sheet to accumulate inquiry content as shown in the image.
Once the Google Sheet is created, proceed to the next step.
↓
Press the Google Sheets icon "Retrieve multiple records (up to 10)".

Check if the account information for integration is correct, and also confirm if it matches the settings shown in the image.
↓

Scroll down and select the spreadsheet ID.
First, enter the spreadsheet ID.

Click inside the box, and a list will be displayed as shown in the image. Select the Google Sheet you want to integrate with Microsoft Teams.

Next, click inside the box just like with the sheet ID and specify the tab.
For other required fields, they depend on the prepared Google Sheet, so enter them according to the content of the Google Sheet.
Once entered, press Next.

↓

Fill in the conditions for the records you want to retrieve.
This time, we will retrieve records that match today's date from the information added to Google Sheets, so set it as shown in the image.
↓
Once the boxes are filled, press Test below, and if "Test Successful" is displayed in blue, press Save.
The Google Sheets setup is complete!

Microsoft Teams Setup

Press the Microsoft Teams icon "Send a message to a channel".
Thanks to using the template, the necessary fields are already filled in, so just check if the account information is correct.

Press Next.

↓

Set the team ID and channel ID.
Just like with Google Sheets, click inside the box and select from the suggestions.
↓

The next setting is the last one! Let's decide on the content to notify Microsoft Teams.

Click inside the box, and when you press the Google Sheets icon "Retrieve multiple records (up to 10)", the content of the Google Sheets you sent in the test earlier will be displayed.

Click to add the content you want to notify!

↓

This time, we set it up as shown in the image!
Adding colons (":") and other elements to make it easier to read is a tip. Feel free to imitate it!

Press Test, and if "Test Successful" is displayed in blue, save it.

‍

This concludes the integration of Google Sheets and Microsoft Teams. Well done!
Yoom offers many other Flow Bot templates, so be sure to check them out.

Other Automation Examples Using Google Sheets and Microsoft Teams

In addition to the integrations introduced today, it is possible to achieve various automations by utilizing the APIs of Google Sheets and Microsoft Teams.

If you find something interesting, please give it a try!

‍‍Automation Examples Integrating Google Sheets and Microsoft Teams

It is possible to set up integrations such as notifying Microsoft Teams when a row is added to Google Sheets or when a row is updated in Google Sheets.
Additionally, you can add content posted in a specific room in Microsoft Teams to Google Sheets.

Automation Example Using Google Sheets

Add a Row in Google Sheets and Automatically Update the Database

When a row is added in Google Sheets, it is automatically registered in Notion, Airtable, etc.

Register survey results received by email into Google Sheets

Automatically register survey results received via Gmail or Outlook into Google Sheets.

Create a folder in cloud storage when a row is added in Google Sheets

Automatically create a folder in Google Drive, OneDrive, etc., when a row is added in Google Sheets.

Automation Example Using Microsoft Teams

Notify Microsoft Teams of Information Submitted via Form

Automatically notify Microsoft Teams of information submitted through Google Forms, HubSpot, etc.

Notify Microsoft Teams of Task Addition

Automatically notify Microsoft Teams when a task is added to platforms like Trello or Asana.

After a web meeting, transcribe and summarize the content, and notify Microsoft Teams

After a meeting on Zoom or Google Meet, automatically transcribe and summarize the content, and notify Microsoft Teams.

Benefits of Integrating Google Sheets with Microsoft Teams

1. Send Google Sheets Data to Microsoft Teams at a Specified Time!

At the specified time, it becomes possible to automatically send Google Sheets data to Microsoft Teams!

For example, even if you check tomorrow's schedule at the end of the day but shut down your computer without confirming it, setting up notifications to be sent to Microsoft Teams at a designated time might help reduce such oversights.
Moreover, since Microsoft Teams can be installed on smartphones, you can check Google Sheets data even when you're on the go!

2. Save Time!

Have you ever opened Google Sheets to check if there are any tasks due today, only to find nothing?
Checking Google Sheets itself isn't that difficult, but when this happens, many people might feel like they've wasted their time.
By integrating Google Sheets with Microsoft Teams, you only need to pay attention to notifications from Microsoft Teams, allowing you to use your time more effectively.

Conclusion

When managing a project, data management is essential. However, checking multiple data sources each time can be burdensome.
That's when you should integrate Google Sheets with Microsoft Teams to automatically retrieve and notify data! This should help reduce your workload and save time.

Take this opportunity to try app integration without any coding!