(Use Case) Google Form X Discord (⭐⭐⭐)

Date of creation
Name
(Use Case) Google Form X Discord (⭐⭐⭐)
Created by
  • data_popcorn

Prerequisite

Create a Google survey form and write AppScript referring to the screenshot below.

Scenario

💡
One line summary
Send a message to Discord via webhook every time a Google Form is submitted.

1. How it works

1.
Webhook reception : Receive new user data from an external source via POST method.
2.
Discord Notifications : Format a welcome message for the user using the received data and send it via Discord webhook.

2. Step Setting

Duration : 15 minutes
1.
Create a Webhook URL : Set up a webhook to POST data from an external system (e.g. a form submission).
2.
Prepare your Discord webhook : Prepare the webhook URL of the Discord channel where you want to send notifications.

3. Process

Step 1: Receive Webhook

Node : (Trigger) Webhook
How to set up :
1.
Add a webhook node.
2.
Set HTTP Method to POST .
3.
Specify the Path :
Example: 462c8756-4efa-48f8-8213-caeb49faeeac
4.
Set up your webhook URL to connect to an external system (e.g. Google Forms, Zapier, etc.) to receive data.
Role : Receive new user information.

Step 2: Discord Webhook

Node : (Action) Discord
How to set up :
1.
Add a Discord node.
2.
Webhook Authentication :
Select your Discord Webhook API credentials or set up new ones.
3.
Message Format :
Create your message using the following template:
=:tada: `{{ $json.body['이메일'] }}` 님께서 새롭게 오셨습니다.({{ $json.body['n8n에 대해 어떻게 알게 되셨나요?'] }})
How do you know about email and n8n from the data you received ? Use fields to structure your message.
Role : Sends a welcome message to the Discord channel based on new user data.