How it works
To connect Google Sheets and AWS SES, you don't need a developer: a ready-made scenario links them in minutes.
- Starts when: Schedule Trigger
- Then: Read inbox messages
- Check: Loop Over Items
- Then: Html to Markdown
- Then: AI Agent - checks if e mail is FAQ related
- Check: Q&A e-mail ?
- If yes: Remove from inbox
- Then: Add Label FAQ Waiting
- If no: AI Agent - checks if e-mail is Inbound related
- Check: Inbound e-mail ?
- If yes: Remove from inbox 2
- Then: Add Label Inbound
- Then: Google Gemini Chat Model
- Then: Google Sheets
- Starts when: Schedule Trigger1
- Then: Read messages from FAQ Waiting folder
- Check: Loop Over Items1
- Then: Markdown1
- Then: AI Agent - draft a reply to FAQ Question
- Then: Remove from FAQ Waiting
- Then: Add Label FAQ Draft
- Then: Set E-mail Fields
- Then: Draft reply
- Then: Google Gemini Chat Model1
- Then: Google Gemini Chat Model2
- Then: Q&A table as a resource
You can launch this Google Sheets + AWS SES integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.