AI Writing & Generationfree

AI Powered Guest Pre Arrival Experience Automation Using OpenAI, Google Sheets & Slack

by Rahul JoshiUpdated Aug 2026

RequiresOpenAI

Email (SMTP)

Google SheetsSlack

1/5

FLOWS

STEPS · 13

Runs on a schedule

On a schedule, drafts personalized guest pre-arrival messages with OpenAI, emails them via SMTP, logs to Google Sheets, and notifies Slack.

Sheets Row AI Email Responder

On a new Google Sheets row, generates structured content with OpenAI, emails it, and updates the sheet.

On a chat message, reads Google Sheets, calls an API over HTTP, and generates a response with OpenAI.

On a new Gmail email, classifies and extracts structured data with OpenAI and aggregates the results.