Send a ChatGPT Email Reply and Save Responses to Google Sheets

This workflow sends an OpenAI GP reply when an email is received from specific email recipients. It then saves the initial email and the GP response to an automatically generated Google spreadsheet. Subsequent GP responses will be added to the same spreadsheet. Additionally, when feedback is given for any of the GP responses, it will be recorded to the spreadsheet, which can then be used later to fine-tune the GP model. ## Prerequisites - [OpenAI credentials](https://docs.n8n.io/integrations/builtin/credentials/openai/) - [Google credentials](https://docs.n8n.io/integrations/builtin/credentials/google/) ## How it works This workflow is essentially a two-in-one workflow. It triggers off from two different nodes and has very different functionality from each trigger. The flow triggered from the `On email received` node is as follows: 1. Triggers off on the `On email received` node. 2. Extract the email body from the email. 3. Generate a response from the email body using the `OpenAI` node. 4. 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 feedback given` node. This is used to fine-tune the GP model. 5. Save the email body and OpenAI response to a Google Sheet. If a sheet does not exist, it will be created. The flow triggered from the `On feedback given` node is as follows: 1. Triggers off when a feedback link is clicked in the emailed GP response. 2. The feedback, either positive or negative, for that specific GP response is then recorded to the Google Sheet.