Collect project intake requests with a webhook, Google Sheets and Gmail
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Normaliser et valider (Code): runs custom JavaScript code
- Données de démonstration (Code): runs custom JavaScript code
- Données valides ? (If): checks a condition and branches into true / false
- Ajouter au registre (Google Sheets): append
- Réponse erreur (Code): runs custom JavaScript code
- Accusé de réception client (Gmail): uses Gmail
- Réponse succès (Code): runs custom JavaScript code
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Webhook
n8n-nodes-base.webhook - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow receives project intake requests via a webhook, validates and normalizes the submitted fields, logs the request to Google Sheets, and sends an acknowledgement email via Gmail, returning a JSON success or error response to the…