How to send records from a Google Spreadsheet 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" in the top right corner! Enter "Google Sheets" in the search box, and when the Google Sheets icon appears, click it!

Select Account is the page where you click the Google account of the Gmail address you want to integrate with Yoom!
Next, you'll be taken to a page called "Login to Yoom", so click Next.
Finally, if a page appears saying "Yoom is requesting additional access to your Google account", click Continue, and you're all set!
↓
Let's proceed to integrate My App with Microsoft Teams.
It's recommended to log in to Microsoft 365 in advance, as integration will be completed quickly if you're already logged in.
↓
Just like before, enter "Microsoft Teams" in the search box and click the Microsoft Teams icon... and without any screen transition, the integration is complete!

* 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 plans for home use and general business use (Microsoft 365 Business), and if you are not subscribed to the general 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 move on to setting up the Flowbot.

The Flowbot procedure this time consists of three steps!

Setting the Schedule Trigger

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

↓

Click on the schedule icon "When the specified schedule occurs" to transition to the above page.
Select the day of the week you want to send Google Sheets data to Microsoft Teams.
Specify the time you want to send it from the red-framed section.

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

Google Sheets Settings

First, prepare the Google Sheets to be integrated with Microsoft Teams and enter the items in advance.

This time, we created a Google Sheet to accumulate inquiry contents as shown in the image.
Once the Google Sheet is created, proceed to the next step.
↓
Click on 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 to select the spreadsheet ID.
First, enter the spreadsheet ID.

Click inside the box to display a list as shown in the image, and 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 contents of the Google Sheet.
Once entered, click 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, click Test just below, and if "Test Successful" is displayed in blue, click Save.
The Google Sheets settings are complete!

Microsoft Teams Settings

Click on the Microsoft Teams icon "Send a message to a channel".
Thanks to using the template, the necessary fields are already filled in, so just confirm that the account information is correct.

Click 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 click on the Google Sheets icon "Retrieve multiple records (up to 10)", the contents of the Google Sheets you test-sent earlier will be displayed.
Click and add the content you want to notify!

↓

This time, we set it up as shown in the image!
Adding ":" and other symbols can make it easier to read. Feel free to imitate it!

Click Test, and if "Test Successful" is displayed in blue, click Save.

‍

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

Other Automation Examples Using Google Sheets and Microsoft Teams

In addition to the integrations introduced today, various automations can be achieved 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 Also Add to 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 Spreadsheet

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

Create a Folder in Cloud Storage When a Row is Added in Google Sheets

Automatically create a folder in Google Drive or OneDrive 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 when a task is added

Automatically notify Microsoft Teams when a task is added to Trello, Asana, etc.

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

After the meeting ends 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, if you check your schedule for the next day 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.
Additionally, 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

Managing data is essential during project progress. However, checking multiple data sets each time can be burdensome.
This is 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 coding!