Let's connect Yoom with each app next.
This is called "My App Integration". Integrating Google Sheets and Discord with My App is very easy!
My App Settings
Click on "View Details" on the template banner, and you'll find a button at the bottom of the screen that says "Try this template".
Click it, and you'll be taken to a page called "My Project". From the menu on the left side of the screen, select "My App"!
↓
Let's start by integrating My App with Google Sheets.
Click on "Create New" at the top right! Enter "Google Sheets" in the search box, and the Google Sheets icon will appear, so click on 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 the "Login to Yoom" page, so press Next.
Finally, if you see a page that says "Yoom is requesting additional access to your Google account", just press Continue, and you're good to go!
Next, let's integrate Discord with Yoom.
↓
Enter "Discord" in the search box, and the Discord icon will appear, so click on it!
.avif)
Check the Discord My App Integration Details Page in the red frame while proceeding with the registration.
Once you have integrated the two apps, Google Sheets and Discord, with Yoom, the next step is to set up the contents of the Flowbot!
The setup procedure for this Flowbot is in three stages!
Schedule Trigger Settings
From My Project on the left side of the screen, click on "[Copy] Retrieve records from Google Sheets that match today's date and notify Discord in bulk daily"!
Press Edit at the top right.
↓
Press the schedule icon "When the specified schedule is reached" to transition to the above page.
Select the day of the week you want to send Google Sheets data to Discord.
Specify the time to send from the red-framed section.
Once completed, press Save at the bottom of the screen to finish setting up the schedule trigger!
Google Sheets Settings
First, prepare the Google Sheets to be integrated with Discord and enter the items in advance.
This time, I created a task list as shown in the image.
Once the Google Sheets is created, proceed to the next step.
↓
Press the Google Sheets icon "Retrieve multiple records (up to 300)".
Check if the account information to be integrated is correct, and also confirm if it matches the settings in the image.
↓
Move to the bottom of the screen and select the spreadsheet ID and tab name.
First, enter the spreadsheet ID.
Click inside the box to display a list, as shown in the image, and select the Google Sheets you want to integrate with Discord.
Set the tab name in the same way, and you're good to go!
↓
For other required items, they depend on the prepared Google Sheets, so enter them according to the contents of the Google Sheets.
Once entered, press Next.
↓
Fill in the conditions for the records you want to retrieve.
This time, we will retrieve those with today's date added to Google Sheets, so select "Deadline" from the dropdown.
Select "Equals" in the middle box.
For the last empty box, we want to enter today's date, 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.
Google Sheets settings are complete!
Discord Settings
Press the Discord icon "Send a message to the channel".
Thanks to using the template, the necessary items are already entered, so just check if the account information is correct.
Press Next.
↓
Set the channel ID.
Just like with Google Sheets, click inside the box and select from the suggestions.
↓
The next setting is the last! Let's decide on the content to notify Discord.
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 test-sent earlier will be displayed.
Click to add the content you want to notify!
↓
This time, I narrowed it down to the necessary data, as shown in the image, and made it a message that conveys the key points.
Adding ":" and such to make it easier to read is a tip. Please try to imitate it!
Once completed, press Test, and if "Test Successful" is displayed in blue, press Save.
This concludes the integration of Google Sheets and Discord. Well done!
Yoom has many other Flowbot templates available, so please take a look.
.avif)
.avif)
.avif)
