Curated

(5/5)

Summarize Google Sheets form feedback via OpenAI's GPT-4

1. Create a Google Sheet document This tutorial uses Google Sheet document connected to Google Forms, but a standalone Sheet document will work too Adapt initial trigger to your needs: run manually or at some time intervals [Link to the Google Sheets template](https://docs.google.com/spreadsheets/d/1Kcr1oFRrfNQJczmJDpwClOSYpvSnwbeX-pdUo91-I/edit?usp=sharing)

Integrations Used (3)

Google Sheets

OpenAI

Gmail

Workflow Structure (6 nodes)

100%

Manual Trigger

When clicking "Test workflow"

Google Sheets

Get Google Sheets records

Aggregate

Aggregate responses into arrays

Open Ai

Summarize via GPT model

Markdown

Convet from Markdown to HTML

Gmail

Send via Gmail

Node Types:

trigger

action

transform

default

Requires credentials

Prerequisites

Required Credentials (3)

Gmail

Used by: Send via Gmail

Docs

Google Sheets

Used by: Get Google Sheets records

Docs

OpenAI

Used by: Summarize via GPT model

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Moderate

Some experience helpful. Multiple integrations or logic.

Setup time: ~30 min

Score: 35/100

6 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "id": "Lwvu2jjMU2irTyAY",
  "meta": {
    "instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a"
  },
  "name": "Summarize Google Sheets form feedback via OpenAI's GPT-4",
  "tags": [
    {
      "id": "y9tvM3hISJKT2jeo",
      "name": "Ted's Tech Talks",
      "createdAt": "2023-08-15T22:12:34.260Z",
      "updatedAt": "2023-08-15T22:12:34.260Z"
    }
  ],
  "nodes": [
    {
      "id": "cd80cd2f-a6e1-48eb-ba05-0f8f1a0875e5",
      "name": "When clicking \"Test workflow\"",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
...