Typeform to Google Sheets with Conditional Notifications

Name: Typeform to Google Sheets with Conditional Notifications
Rating: 2.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

16 views

0 downloads

Googlesheetsautomationconditional-logicfeedbackgooglesheetsnotificationstypeform

This workflow triggers from Typeform submissions, appends data to Google Sheets, and sends notifications based on a severity threshold.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This n8n workflow automates the process of capturing user feedback or submissions from a Typeform form. It then appends this data to a specified Google Sheet. Based on a 'Severity' field within the submitted data, the workflow conditionally sends notifications via email and Slack to relevant parties.

Key Features

Integrates with Typeform to capture form submissions.
Appends submitted data to a designated Google Sheet.
Implements conditional logic to check a 'Severity' value.
Sends email notifications for high-severity issues.
Sends Slack notifications for high-severity issues.
Includes robust error handling for increased reliability.

How To Use

Trigger Setup: Configure the Typeform Trigger node with your Typeform formId and authorize your Typeform API credentials.
Google Sheets Configuration: Set up the Google Sheets node by providing the sheetId of your Google Sheet and the range (e.g., 'Problems!A:D'). Ensure your Google API credentials are authorized.
Conditional Logic: Adjust the If Node parameters to set the desired severity threshold. The current configuration triggers notifications if Severity is greater than 7.
Notification Setup: Configure the Send Email and Slack nodes. For Send Email, enter the recipient's email address and your SMTP server details. For Slack, specify the channel and authorize your Slack API credentials.
Data Mapping: Ensure the fields used in the Send Email and Slack nodes (e.g., Email, Name, Severity, Problem) correctly map to the data received from Typeform and available in the subsequent nodes.

Apps Used

automation

conditional-logic

feedback

googlesheets

notifications

typeform

Workflow JSON

{
  "id": "78a4e6c6-3fd0-4560-83da-ed8fcf9ce09d",
  "name": "Typeform to Google Sheets with Conditional Notifications",
  "nodes": 0,
  "category": "Googlesheets",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.