Scenario: Update data in a Google Sheet to send a message to a Discord channel via the HTTP module. This scenario watches an existing Google Sheet and is triggered when data from a row is modified.
Level of difficulty: Easy
Implementation Time: Approximately 20 Minutes
Prerequisites: The following is needed to set up this scenario:
----
Hey Gamer! Pardon me if you’re not but you must be aware that Discord is designed for gaming communities. Either way, once you’re through with this short tutorial, do leave a response to let me know what you’re using Discord and this integration for.
The scenario for this tutorial contains only two modules and looks like this:
As mentioned under prerequisites, you must have a Google Sheet configured with column names and some sample data. If you don’t, please create one before you proceed. This is what mine looks like:
Discord gives you the ability to create one or more webhooks for each text channel. If you’re not familiar with the process, follow the 3-step instructions below or else, jump to Step 3.
Keep this URL handy, we will need it while setting up the HTTP module in our Integromat scenario.
Head over to your Integromat dashboard to create a new scenario.
Note that the first row or header row is always assumed to contain the column names. Hence, if you enter 1, entries will be watched starting the row below the header row.
The HTTP module is the second and the last module in the scenario that performs the action of sending a message to a discord channel.
{
“content” : “Houston, this is a message for Discord”
}
Click here to learn more about executing webhooks on Discord.
Since the trigger is a Google Sheet with columns containing data, we can use the column names to include the contents of each cell in the message that is sent to the channel. We may also use line breaks (\n) in the message. Below is what I have composed:
{
“content” : “**Incoming Status Update**\nName: {{firstname}} {{lastname}}\nMission: {{mission}}\nStatus: {{status}}”
}
That’s it. Now update some data in your sheet and run your module once to make sure everything works fine as shown below:
Hope you were able to implement this scenario with ease.