ES | EN
AI

Send a ChatGPT email reply and save responses to Google Sheets

Google SheetsCryptoGmailOpen Ai
Nodes 6
Complexity Advanced
Category AI
n8n popularity 17,151 views in n8n library

This workflow sends a OpenAI GPT reply when an email is received from specific email recipients. It then saves the initial email and the GPT response to an automatically generated Google spreadsheet. Subsequent GPT responses will be added to the same spreadsheet. Additionally, when feedback is given for any of the GPT responses, it will be recorded to the spreasheet, which can then be used later to fine-tune the GPT model. Prerequisites OpenAI credentials Google credentials How it works This workflow is essentially a two-in-one workflow. It triggers off from two different nodes and have very different functionality from each trigger. The flow triggered from On email received node is as follows: Triggers off on the On email received node. Extract the email body from the email. Generate a response from the email body using the OpenAI node. Reply to the email sender using the Send reply to recipient node. A feedback link is also included in the email body which will trigger the On

Apps and nodes included

Step-by-Step Implementation Guide

ChatGPT responde emails y guarda datos

Este workflow responde correos electrónicos de remitentes específicos utilizando OpenAI GPT y guarda la información en Google Sheets. Registra feedback para mejorar el modelo.

Nodos Utilizados

  • Google Sheets: Guarda los datos en una hoja de cálculo de Google.
  • Crypto: Posiblemente para encriptación/desencriptación de datos.
  • Gmail: Recibe y envía correos electrónicos.
  • Código: Para la manipulación y transformación de datos.
  • OpenAI: Genera las respuestas a los correos electrónicos.
  • HTML: Posiblemente para la creación de plantillas de correo.

Pasos de Configuración

  • Conecta tu cuenta de Gmail: Autoriza el acceso a tu cuenta de Gmail.
  • Conecta Google Sheets: Autoriza el acceso a Google Sheets y configura la hoja de cálculo.
  • Configura OpenAI: Introduce tu clave API de OpenAI.
  • Define los remitentes: Especifica los remitentes a los que se responderá.
  • Personaliza el prompt de OpenAI: Ajusta el prompt para guiar la generación de respuestas.
⚡ Open and edit in Scriflow ← Browse all n8n templates

Scriflow builds and adapts n8n workflows with AI. Open this template in the editor to get the import-ready JSON.