Once copied, click "Edit" in the top right to proceed with editing each operation.
Step 2: App Trigger "When a Row is Added"
Click the first process of the template.
(1/2) Select Integration Account and Action
App Trigger Title: When a Row is Added (Default)
App: Google Sheets (Default)
Account information for integration with Google Sheets: Click "+ Add Integration Account". A screen to log in to Google will appear. Enter the email address or phone number and password of the account to be integrated, and allow access from Yoom.
Trigger Action: When a Row is Added (Default)
→ Next
(2/2) API Connection Settings for App Trigger
Trigger Interval: You can choose from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. The selectable time varies depending on the plan. A shorter setting is generally recommended.
Proceed with the settings for the Google Sheets to be integrated.
Spreadsheet ID: Select from the candidates or specify the Spreadsheet ID. The part "/spreadsheets/d/●●●/" in the URL is the Spreadsheet ID. Click the edit field to display the candidates. Selecting one will quote the ID.
Sheet ID: Please select from the candidates. The part "/edit?gid=●●●/" in the URL is the Sheet ID. You can also quote the ID by clicking the edit field.
Table Range (Start): If you want the table range to be from A to N, specify "A".
Table Range (End): If you want the table range to be from A to N, specify "N".
Column with Unique Values: Select the column name that contains unique values within the column, such as email addresses or IDs (the column that becomes the unique key). Example: A
Test → Success → The header and the content of the second row of the Google Sheets were extracted in the output. This item can be quoted in the subsequent notification content settings for Discord.
→ Save
Step 3: Integrate with the App to "Retrieve Deal Information"
Click the second process of the template.
(1/2) Select Integration Account and Action
Title: Send Message to Text Channel
App: Discord
Account information for integration with Discord: Click "+ Add Integration Account"!
If this is your first time integrating the app, this screen will appear. Enter your login information and "Authorize" Yoom to access your Discord account.
Action: Send Message to Text Channel
→ Next
(2/2) API Connection Settings
Webhook URL: Create a Webhook URL from the edit page of the channel to be sent to, and set the created URL.
＞ Help: How to Obtain Discord's Webhook URL
Specify the content of the message to be sent.
Click the edit field to display the items output from Google Sheets earlier. I selected an arbitrary message, ID, and title.
→ Test → Success A notification was sent to the Discord channel.
Step 4: Turn the App Trigger [ON]
Turn the switch on the first process of the flow bot to [ON], and the setup is complete.
The integration work is complete! Even without mastering a programming language, I was able to easily integrate using the template. Here is the template used this time.
.avif)
.avif)
