Once copied, click "Edit" in the 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 Integrating 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 does not have duplicate values within the column (the column that becomes the unique key), such as email addresses or IDs. Example: A
Test → Success → The header and content of the second row of the Google Sheets were extracted in the output. This item can be quoted in the subsequent Discord notification content settings.
→ Save
Step 3: Integrate with the App "Get 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 Integrating with Discord: Click "Add Integration Account"!
Enter "Account Name" and "Access Token", then click "Add".
Action: Send Message to Text Channel
→ Next
(2/2) API Connection Settings
Enter "Channel ID.
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 above the process of the flowbot to [ON], and the setup is complete.
This completes the integration work! Even I, who have not mastered programming languages, could easily integrate using the template. Here is the template used this time.
.avif)
.png)
.png)
