Shata Solutions
← Back to marketplace
AI Personal Assistant

Travel Planning

Build itinerary drafts from calendar trips with flights, hotels, and local logistics.

Automation overview

What this automation does

This automation starts when calendar event with out-of-city location created. It google sheets process via google sheets, then searches Gmail for flight confirmation parsing, suggests hotels near meeting address via Google Places API ranked by policy rate cap from Sheets, adds Maps link.

Trigger
Calendar event with out-of-city location created
Main actions
Google Sheets process via Google Sheets
Final outcome
searches Gmail for flight confirmation parsing, suggests hotels near meeting add…
Execution time
30–90 seconds
Apps used
5 integrations
AI-powered
No
Difficulty
Beginner
Beginner
Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger
Google Calendar
Event detected
Step 1
Google Sheets
Process via Google Sheets
Router
Gmail
Confirmation
Result
X (Twitter)
Workflow complete
Step-by-step

How each step runs

  1. 1
    Google CalendarTrigger
    Event detected

    Calendar event with out-of-city location created

  2. 2
    Gmail
    Confirmation

    searches Gmail for flight confirmation parsing, suggests hotels near meeting address via Google Places API ranked by policy rate cap from Sheets, adds Maps link

  3. 3
    Google Sheets
    Process via Google Sheets

    Google Calendar event with location different from home city triggers travel workflow

  4. 4
    Notion
    Confirmation

    searches Gmail for flight confirmation parsing, suggests hotels near meeting address via Google Places API ranked by policy rate cap from Sheets, adds Maps link

  5. 5
    X (Twitter)
    Confirmation

    searches Gmail for flight confirmation parsing, suggests hotels near meeting address via Google Places API ranked by policy rate cap from Sheets, adds Maps link

  6. 6
    X (Twitter)
    Workflow complete

    searches Gmail for flight confirmation parsing, suggests hotels near meeting address via Google Places API ranked by policy rate cap from Sheets, adds Maps link

Apps used

Connected applications

Google Calendar

Process via Google Calendar

Gmail

Confirmation

Google Sheets

Process via Google Sheets

Notion

Confirmation

X (Twitter)

Confirmation

Summary

Automation summary

Trigger
Calendar event with out-of-city location created
Inputs
Calendar event with out-of-city location created, Business Name, Notification Email, Timezone
Outputs
searches Gmail for flight confirmation parsing, suggests hotels near meeting address via Google Places API ranked by policy rate cap from Sheets, adds Maps link, Google Sheets process via Google Sheets
Business goal
Automate travel planning end-to-end with accurate app routing.
Execution frequency
Real-time on event
Estimated runtime
30–90 seconds
Error handling
Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies
Google Calendar, Gmail, Google Sheets
Benefits

Why use this automation?

Save ~13 hours/week

Remove repetitive steps from Travel Planning so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Faster response times

Events trigger immediate actions instead of waiting for someone to check a queue.

Requirements

What you need to get started

Required apps

  • Google Calendar
  • Gmail
  • Google Sheets

Required accounts

  • Active Google Calendar workspace with API access
  • Active Gmail workspace with API access
  • Active Google Sheets workspace with API access
  • Shata Automation workspace (free tier supported)

Required API keys

  • OAuth tokens for each connected integration

Permissions

  • Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
  • Write access on destination apps (email, chat, CRM, or storage)

Estimated setup time

  • 45 min including app authorization and test run
  • Difficulty: Beginner

Optional apps

  • Notion (optional)
  • X (Twitter) (optional)

Automation runtime

Activate this template

PartialSome steps run in preview until their integrations go live.

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft
0%
Activation readiness

Est. setup time: ~16 min

Required connections

  • Google Calendar(required)
    Test-onlyGoogle Calendar: workflow actions run in preview
    Missing
  • Gmail(required)
    Missing
  • Google Sheets(required)
    Missing
  • Notion(required)
    PreviewNotion: workflow actions run in preview
    Missing
  • Missing connection: Google Calendar
  • Missing connection: Gmail
  • Missing connection: Google Sheets
  • Missing connection: Notion
Manage all connections →View all installations →

Workflow summary

Trigger
Calendar event with out-of-city location created
Steps
6 nodes
Required apps
4
Optional apps
1

Trigger

Manual trigger

Run workflows on demand via Test run or Live test. Activate to enable scheduled/webhook triggers on other templates.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

PremiumBeginnerPartial45 min setup4.4790 installs · 400 reviews
Customize for My Business
Analytics

Template performance

49.6k
Views
790
Installs
691
Favorites
4.4
Avg rating
1.6%
Conversion
45 min
Setup time
94%
Success rate
101
Trending score
Most used integrations
Google CalendarGmailGoogle Sheets

Google Calendar event with location different from home city triggers travel workflow—searches Gmail for flight confirmation parsing, suggests hotels near meeting address via Google Places API ranked by policy rate cap from Sheets, adds Maps links for routes, weather OpenWeather 5-day, and compiles Notion trip page with visa reminder if international from passport expiry Sheets row.

Some steps run in preview until their integrations go live.

Required apps
Google CalendarTest-onlyGmailLiveGoogle SheetsLiveNotionPreview
Optional apps
X (Twitter)Preview
All integrations
Google CalendarGmailGoogle SheetsNotionX (Twitter)
Workflow preview

How Travel Planning runs

1
Trigger
Load travel policy
2
Process
Rule engine
3
Action
google-calendar
4
Notify
Alert & log
Google CalendarGmailGoogle SheetsNotionX
Setup steps

Get started in 5 steps

  1. 1
    Connect travel data

    Google Calendar, Gmail flight parse, Places API, Maps, OpenWeather, Notion, Sheets policy.

  2. 2
    Load travel policy

    Hotel rate cap, preferred airlines, approval required if over budget.

  3. 3
    Parse existing bookings

    Gmail confirmation emails extract PNR and hotel confirmations to itinerary.

  4. 4
    Build Notion trip page

    Sections flights, hotel, meetings, local transport, emergency contacts.

  5. 5
    Test business trip

    Create test Cairo trip from Alexandria home; verify hotel suggestions.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification EmailemailYes
TimezoneselectYes
Google Sheet IDtextNo
Sheet RangetextSheet1!A:ZNo
Gmail Search Querytextis:unreadNo
FAQ

Frequently asked questions

Book flights automatically?

Suggest only by default; booking links manual unless corporate travel API connected.

Team travel?

Shared Notion page when multiple attendees same event.

Per diem?

Sheets per diem rate for city inserted in trip page expenses section.

Itinerary changes?

Calendar update re-runs hotel and route sections incrementally.

Get started

Customize Travel Planning for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.