Unanswered

Extract information from subject line of Gmail

(0) Share

Report

Posted on by jsurrette

I am building a new flow that pulls information from both the subject and body of the email. I have the flow for pulling the information I need from the body, but can't figure out how to extract just the information I need from the subject.

The subject line is:
Typing Test Results for John Doe: additional text here

I want to pull only "John Doe" and have it entered into a Spreadsheet.

The information is pulling from a Gmail account. This is currently what my flow looks like:

How would I trim the subject line?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

VJR 7,635 on at

Like (0)

Report

HI @jsurrette

Out of the below line which part is going to be fixed/constant?

Typing Test Results for John Doe: additional text here

1. Are the wordings "Typing Test Results for" going to be fixed?
2. Is the colon : after the name always going to be present?

Was this reply helpful? Yes No
jsurrette 22 on at

Like (0)

Report

Hello @VJR!

This is an automated email, so everything will be fixed with the exception of the name. It will always say the same thing, which is:

Typing Test Results for _____ ______: additional text here

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (1)

Report

Hi @jsurrette

In that case use a single Compose action.

Below is what is written in the above Inputs using Expression
replace(first(split(triggerBody()['text'],':')),'Typing Test Results for ','')

The part in blue bold will be your dynamic content for the entire subject line coming from Gmail.

This is the output after running the flow

Ran another time with input as:
Typing Test Results for Mr ABC: additional text here

This time it shows output as

Was this reply helpful? Yes No