Inspiration Galleryarrow_forward
Parse new order email into calendar event using AI

Parse new order email into calendar event using AI

Relay.app screenshot of: Parse new order email into calendar event using AI
Relay.app screenshot of: Parse new order email into calendar event using AI
AnneMarie Freedman
AnneMarie Freedman
Contractor
Globe iconLinkedIn logo

Use AI to parse an automated email with a new order confirmation into a detailed custom calendar event.

OpenAI integrationsOpenAI
Gmail integrationsGmail
Google Sheets integrationsGoogle Sheets
Google Calendar integrationsGoogle Calendar

Steps in this workflow

1
Email received
2
Extract with GPT-4o-mini
3
Extract with GPT-4o-mini
4
Extract with GPT-4o-mini
5
Extract with GPT-4o-mini
6
Add row to sheet
7
Create Drop-off Event
8
Create task
9
Create Pick-Up Event
10
Add row to sheet

How it works

Relay.app screenshot of: Trigger
1
Email received
App Gmail
Trigger Email received
Every workflow starts with a trigger. When the triggering action is detected, usually an action in another app, a new run of the workflow is kicked off.
Documentation
descriptionTriggers 101
smart_displayHow To Set Up A Trigger - Tutorial
Relay.app screenshot of: Step 2: Extract with GPT-4o-mini
2
Extract with GPT-4o-mini
AppOpenAI
Relay.app’s built-in AI actions, Custom Prompt steps and mini Agents make it easy to leverage AI in a predictable, controlled way.
Documentation
descriptionAI steps
descriptionPrompt tips
Relay.app screenshot of: Step 3: Extract with GPT-4o-mini
3
Extract with GPT-4o-mini
AppOpenAI
Relay.app’s built-in AI actions, Custom Prompt steps and mini Agents make it easy to leverage AI in a predictable, controlled way.
Documentation
descriptionAI steps
descriptionPrompt tips
Relay.app screenshot of: Step 4: Extract with GPT-4o-mini
4
Extract with GPT-4o-mini
AppOpenAI
Relay.app’s built-in AI actions, Custom Prompt steps and mini Agents make it easy to leverage AI in a predictable, controlled way.
Documentation
descriptionAI steps
descriptionPrompt tips
Relay.app screenshot of: Step 5: Extract with GPT-4o-mini
5
Extract with GPT-4o-mini
AppOpenAI
Relay.app’s built-in AI actions, Custom Prompt steps and mini Agents make it easy to leverage AI in a predictable, controlled way.
Documentation
descriptionAI steps
descriptionPrompt tips
Relay.app screenshot of: Step 6: Add row to sheet
6
Add row to sheet
AppGoogle Sheets
Documentation
descriptionActions 101
Relay.app screenshot of: Step 7: Create Drop-off Event
7
Create Drop-off Event
AppGoogle Calendar
Documentation
descriptionActions 101
Relay.app screenshot of: Step 8: Create task
8
Create task
AppGoogle Tasks
Documentation
descriptionActions 101
Relay.app screenshot of: Step 9: Create Pick-Up Event
9
Create Pick-Up Event
AppGoogle Calendar
Documentation
descriptionActions 101
Relay.app screenshot of: Step 10: Add row to sheet
10
Add row to sheet
AppGoogle Sheets
Documentation
descriptionActions 101
Author picture (AnneMarie Freedman)

I work in the tech industry and on the side, I contract with a company called BabyQuip. We make it easy for traveling parents or grandparents to get children's gear.

How it works is traveling parents or grandparents who need gear go and create orders for a specific date and then we fill the order.

Each time an order is placed for my gear, I get an automated confirmation email. Before using Relay.app, I'd manually create a detailed calendar event from this listing so that I could stay on top of my orders and co-ordinate with my husband and dad for the drop off.

With Relay.app, I set up a workflow using AI that automatically creates this calendar event for me. Two things that helped me get the right results are 1) I included examples in the prompt of the output I'd like to see for a given input and 2) I broke down a large AI step into multiple steps to improve accuracy.

I'm not an AI expert but I love data and spreadsheets and I love finding ways to make things easier. So glad I found Relay.app!

AnneMarie Freedman
Contractor