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 Linked Account and Action
App Trigger Title: When a Row is Added (Default)
App: Google Sheets (Default)
Account Information for Linking with Google Sheets: Click "+ Add Linked Account". A screen to log in to Google will appear. Enter the email address or phone number and password of the account to be linked, and allow access from Yoom.
Trigger Action: When a Row is Added (Default)
→ Next
(2/2) API Connection Settings for App Trigger
Trigger Activation 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 linked.
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 of a column that does not have duplicate values within the column (a column that serves as a unique key), such as an email address or ID. Example: A
Test → Success → The header and content of the second row of the Google Sheets were extracted as output. This item can be quoted in the subsequent Discord notification content settings.
→ Save
Step 3: Integrate with App to "Retrieve Deal Information"
Click the second process of the template.
(1/2) Select Linked Account and Action
Title: Send Message to Text Channel
App: Discord
Account Information for Linking with Discord: Click "+ Add Linked Account"!
If this is your first time linking an 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
Channel ID: Please specify the target channel ID.
Next,specify the content of the message to be sent.
Click the edit field to display the items output from Google Sheets earlier.
→ Test → Success A notification sent to the Discord channel.
Step 4: Turn the App Trigger [ON]
Finally, "Turn on the trigger" to complete the setup.
This completes the integration work! Even without mastering a programming language, I was able to easily integrate using the template. Here is the template used this time.
.avif)
.avif)
.avif)
