Kütüphane / E-posta Otomasyonu
E-posta Otomasyonu
OpenAI ile e-postaları yanıtlama ve Sheets'e kaydetme
Gmail'e yeni bir e-posta geldiğinde OpenAI GPT bir yanıt yazar, gönderene gönderilir ve yanıt Google Sheets'e kaydedilir.
Ne yapar
## Send a ChatGPT email reply when email received and save responses to Google Sheets 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. ### 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. On email received: 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 GPT model. 5. Save the email body and OpenAI response to a Google Sheet. If a sheet does not exist, it will be created. On feedback given: 1. Triggers off when a feedback link is clicked in the emailed GPT response. 2. The feedback, either positive or negative, for that specific GPT response is then recorded to the Google Sheet.
Adımlar
- Generate reply
- On email received
- Only continue for specific emails
- Configure
- Send reply to recipient
- Generate UUID
- Thanks for your response!
- Extract message content (advanced)
- If spreadsheet doesn't exist
- Successfully created or updated row
- Create spreadsheet
- Store spreadsheet ID
- Paste data
- If no sheet IDs
Toplam 64 adım.
Benzer otomasyonlar
E-posta OtomasyonuRoute and close school admissions leads with Gmail, HighLevel, Gemini and Sheets33 adımE-posta OtomasyonuBuild chargeback evidence packs with Gmail, Google Sheets, Calendar and DeepSeek23 adımE-posta OtomasyonuTrack special education deadlines with Google Sheets, Gmail, Calendar, and DeepSeek31 adımE-posta OtomasyonuOpenAI ile Gmail E-postalarını Otomatik Etiketleme17 adım