Automated Typeform Feedback Sorting and Google Sheets Logging - n8n Workflow

• Individuals running surveys or collecting course feedback via Typeform who need automated data sorting.


• Data analysts looking to implement powerful data filtering logic using an n8n node without manual intervention.


• Teams seeking robust n8n templates to automate data hygiene and categorization.


• Users who rely on Google Sheets for structured reporting and feedback analysis.

Manually sifting through survey responses and categorizing feedback is time-consuming and prone to human error. This specialized n8n workflow addresses this challenge by providing immediate, criteria-based routing for Typeform submissions. Once a user completes the feedback form, the n8n trigger instantly starts the process. The core value of this n8n template lies in its filtering logic: submissions are analyzed based on a key metric (like 'usefulness' score). If the score meets a predefined threshold, it's routed as positive feedback; otherwise, it’s routed as negative. This powerful n8n node configuration ensures that your data is structured and ready for immediate analysis in Google Sheets, saving significant operational time.

This highly efficient n8n workflow starts immediately upon the submission of a Typeform entry.

1. Triggering the Flow: The workflow begins with the Typeform n8n trigger, configured to listen for new submissions from a specific feedback form (noted as 'course feedback').


2. Data Extraction and Preparation: The payload is routed to a specialized Set n8n node. This node cleans up the complex Typeform JSON, extracting and renaming key fields like the usefulness score and the user's written opinion. This prepares the data for subsequent conditional checks.


3. Conditional Filtering: An IF n8n node executes the core logic. It checks the extracted usefulness score. The criteria are set to determine if the score is greater than or equal to 3.


4. Positive Feedback Path (True): If the score meets the criteria (True Branch), the data is routed to the first Google Sheets n8n node, which appends the submission details to the designated 'positivefeedback' sheet.


5. Negative Feedback Path (False): If the score fails the criteria (False Branch), the data is routed to a secondary Google Sheets n8n node, which appends the data to the 'negativefeedback' sheet. This completes the automated feedback classification and logging process within this robust n8n workflow.

To deploy this automated feedback n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and import it into your n8n instance via the 'New' menu -> 'Import from JSON'.


2. Typeform Credential Setup: Configure the Typeform Trigger n8n node. You will need to select or create a Typeform API credential and specify the formId corresponding to your course feedback survey.


3. Google Sheets Credential Setup: Configure the Google Sheets n8n node (both instances). You must provide a valid OAuth2 credential for Google Sheets that has write access to the target spreadsheets.


4. Specify Sheet IDs: In both Google Sheets n8n node instances, update the sheetId parameter to point to your desired spreadsheet file and verify the range is correct (e.g., positive_feedback!A:C).


5. Activate the n8n Trigger: Ensure the Typeform n8n trigger is correctly linked to a webhook on your Typeform setup. Activate the n8n workflow to start listening for new submissions.

Typeform Trigger n8n node
Function: Serves as the starting point, acting as an n8n trigger for new Typeform submissions.
Key Configuration: Configured with a specific formId (e.g., yxcvbnm) and listening for 'course feedback' submissions.

Set n8n node ('capture typeform data')
Function: Cleans and formats the incoming Typeform payload, essential for reliable downstream processing. This crucial n8n node simplifies data access.
Key Configuration: Extracts complex input fields and maps them to simple keys: usefulness (from 'How useful was the course?') and opinion (from 'Your opinion on the course:'). The keepOnlySet option ensures only the cleaned data proceeds.

IF n8n node ('filter feedback')
Function: Implements the core business logic, filtering submissions based on score.
Key Configuration: Checks if the value of the extracted usefulness field is 'largerEqual' to 3. This conditional n8n node routes the flow accordingly.

Google Sheets n8n node ('positive feedback')
Function: Appends the data items that met the filter criteria (positive feedback).
Key Configuration: Operation set to append. Targets a specific sheet ID and the range positivefeedback!A:C.

Google Sheets1 n8n node ('negative feedback')
Function: Appends the data items that failed the filter criteria (negative feedback).
* Key Configuration: Operation set to append. Targets a different sheet ID and the range negativefeedback!A:C for separate logging.