(Use Case) Google Form X Discord (⭐⭐⭐)
Tags
Empty
Date of creation
Name
(Use Case) Google Form X Discord (⭐⭐⭐)
Category
Empty
Created by
- data_popcorn
Created with reference to the contents of https://medium.com/@eyalgershon/sending-a-webhook-for-each-google-forms-submission-a0e73f72b397 .
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.