For the emails your Gmail search picks out, logs whether each passed the sender checks and which servers it really came through.

KDKevin Duan · 1 workflow · Updated Nov 13, 2026

UsesClaudeGmailGoogle Sheetsip-api.com

Record where incoming emails really came from

ScheduleRun every 6 hours.Run every 6 hours.
ValuesSet mailSearch to blank.Set mailSearch to blank.
ValuesSet spreadsheetUrl to blank.Set spreadsheetUrl to blank.
ValuesSet tabName to blank.Set tabName to blank.
ValuesSet checkedLabel to Headers logged.Set checkedLabel to Headers logged.
ValuesSet maxMessages to 10.Set maxMessages to 10.
ValuesSet maxRelayAddresses to 10.Set maxRelayAddresses to 10.
Dates & TimesGet today's date and save it as checkedOn.Get today's date and save it as checkedOn.
ValuesSet searchQuery to mailSearch -label:@checkedLabel.Set searchQuery to mailSearch -label:@checkedLabel.
GmailGmailList emails matching searchQuery. Save it as inbox.List emails matching searchQuery. Save it as inbox.
ValuesSet messages to an empty list.Set messages to an empty list.
Decisions & LoopsIf inbox.emails isn't emptyIf inbox.emails isn't empty
Yes
ValuesChange messages to inbox.emails.Change messages to inbox.emails.
No
No steps
ListsTake the first maxMessages multiplied by 1 items of messages and save it as checkedMessages.Take the first maxMessages multiplied by 1 items of messages and save it as checkedMessages.
Decisions & LoopsIf checkedMessages is emptyIf checkedMessages is empty
Yes
ValuesShow in the output: No mail matched that search that has not already been logged..Show in the output: No mail matched that search that has not already been logged..
No
No steps
Decisions & LoopsFor each message in checkedMessages:For each message in checkedMessages:
ValuesSet messageId to blank.Set messageId to blank.
Decisions & LoopsIf message.id isn't empty and message.id isn't blankIf message.id isn't empty and message.id isn't blank
Yes
TextTrim message.id and save it as messageId.Trim message.id and save it as messageId.
No
No steps
Decisions & LoopsIf messageId is emptyIf messageId is empty
Yes
ValuesShow in the output: Skipped a message that arrived without an id..Show in the output: Skipped a message that arrived without an id..
Decisions & LoopsSkip to the next item.Skip to the next item.
No
No steps
Decisions & LoopsIf a step below fails, save the error as headerErrorIf a step below fails, save the error as headerError
Try
GmailGmailGet the sender, subject and date of email messageId. Save it as headers.Get the sender, subject and date of email messageId. Save it as headers.
ValuesSet fromLine to no From header.Set fromLine to no From header.
Decisions & LoopsIf headers.From isn't empty and headers.From isn't blankIf headers.From isn't empty and headers.From isn't blank
Yes
TextTrim headers.From and save it as fromLine.Trim headers.From and save it as fromLine.
No
No steps
ValuesSet subjectLine to no Subject header.Set subjectLine to no Subject header.
Decisions & LoopsIf headers.Subject isn't empty and headers.Subject isn't blankIf headers.Subject isn't empty and headers.Subject isn't blank
Yes
TextTrim headers.Subject and save it as subjectLine.Trim headers.Subject and save it as subjectLine.
No
No steps
ValuesSet dateLine to no Date header.Set dateLine to no Date header.
Decisions & LoopsIf headers.Date isn't empty and headers.Date isn't blankIf headers.Date isn't empty and headers.Date isn't blank
Yes
TextTrim headers.Date and save it as dateLine.Trim headers.Date and save it as dateLine.
No
No steps
ValuesSet returnPathLine to no Return-Path header.Set returnPathLine to no Return-Path header.
Decisions & LoopsIf headers["Return-Path"] isn't empty and headers["Return-Path"] isn't blankIf headers["Return-Path"] isn't empty and headers["Return-Path"] isn't blank
Yes
TextTrim headers["Return-Path"] and save it as returnPathLine.Trim headers["Return-Path"] and save it as returnPathLine.
No
No steps
ValuesSet authLine to blank.Set authLine to blank.
Decisions & LoopsIf headers["Authentication-Results"] isn't empty and…If headers["Authentication-Results"] isn't empty and…
Yes
TextTrim headers["Authentication-Results"] and save it as authLine.Trim headers["Authentication-Results"] and save it as authLine.
No
No steps
ValuesSet receivedLine to blank.Set receivedLine to blank.
Decisions & LoopsIf headers.Received isn't empty and headers.Received isn't blankIf headers.Received isn't empty and headers.Received isn't blank
Yes
TextTrim headers.Received and save it as receivedLine.Trim headers.Received and save it as receivedLine.
No
No steps
ValuesSet spfHeaderLine to blank.Set spfHeaderLine to blank.
Decisions & LoopsIf headers["Received-SPF"] isn't empty and headers["Received-SPF"] isn't blankIf headers["Received-SPF"] isn't empty and headers["Received-SPF"] isn't blank
Yes
TextTrim headers["Received-SPF"] and save it as spfHeaderLine.Trim headers["Received-SPF"] and save it as spfHeaderLine.
No
No steps
ValuesSet originIpLine to blank.Set originIpLine to blank.
Decisions & LoopsIf headers["X-Originating-IP"] isn't empty and headers["X-Originating-IP"] isn't…If headers["X-Originating-IP"] isn't empty and headers["X-Originating-IP"] isn't…
Yes
TextTrim headers["X-Originating-IP"] and save it as originIpLine.Trim headers["X-Originating-IP"] and save it as originIpLine.
No
No steps
ValuesSet authText to authLine spfHeaderLine.Set authText to authLine spfHeaderLine.
ValuesSet spfResult to no SPF result recorded in these headers.Set spfResult to no SPF result recorded in these headers.
TextExtract the first match from authText in lowercase and save it as spfResultMatch.Extract the first match from authText in lowercase and save it as spfResultMatch.
Decisions & LoopsIf spfResultMatch isn't emptyIf spfResultMatch isn't empty
Yes
ValuesChange spfResult to spfResultMatch.Change spfResult to spfResultMatch.
No
No steps
ValuesSet dkimResult to no DKIM result recorded in these headers.Set dkimResult to no DKIM result recorded in these headers.
TextExtract the first match from authText in lowercase and save it as dkimResultMatch.Extract the first match from authText in lowercase and save it as dkimResultMatch.
Decisions & LoopsIf dkimResultMatch isn't emptyIf dkimResultMatch isn't empty
Yes
ValuesChange dkimResult to dkimResultMatch.Change dkimResult to dkimResultMatch.
No
No steps
ValuesSet dmarcResult to no DMARC result recorded in these headers.Set dmarcResult to no DMARC result recorded in these headers.
TextExtract the first match from authText in lowercase and save it as dmarcResultMatch.Extract the first match from authText in lowercase and save it as dmarcResultMatch.
Decisions & LoopsIf dmarcResultMatch isn't emptyIf dmarcResultMatch isn't empty
Yes
ValuesChange dmarcResult to dmarcResultMatch.Change dmarcResult to dmarcResultMatch.
No
No steps
ValuesSet scanText to receivedLineSet scanText to receivedLine authText originIpLine.
TextExtract all matches from scanText and save it as foundAddresses.Extract all matches from scanText and save it as foundAddresses.
ListsTake the first maxRelayAddresses multiplied by 1 items of foundAddresses with duplicates removed and save it as relayAddresses.Take the first maxRelayAddresses multiplied by 1 items of foundAddresses with duplicates removed and save it as relayAddresses.
ValuesSet relayList to no relay address appears in these headers.Set relayList to no relay address appears in these headers.
ValuesSet relayPlaces to no relay addresses to look up.Set relayPlaces to no relay addresses to look up.
ValuesSet locatedRows to an empty list.Set locatedRows to an empty list.
Decisions & LoopsIf relayAddresses isn't emptyIf relayAddresses isn't empty
Yes
TextJoin relayAddresses with , and save it as relayList.Join relayAddresses with , and save it as relayList.
Decisions & LoopsIf a step below fails, save the error as lookupErrorIf a step below fails, save the error as lookupError
Try
ip-api.comip-api.comLook up several IP addresses. Save it as located.Look up several IP addresses. Save it as located.
Decisions & LoopsIf located.results isn't emptyIf located.results isn't empty
Yes
ValuesChange locatedRows to located.results.Change locatedRows to located.results.
No
No steps
On error
ValuesChange relayPlaces to the address lookup step did not answer, so these addresses were not looked up.Change relayPlaces to the address lookup step did not answer, so these addresses were not looked up.
No
No steps
ValuesSet placeLines to an empty list.Set placeLines to an empty list.
Decisions & LoopsFor each relay in locatedRows:For each relay in locatedRows:
Values Set relayQuery to an address. Set relayQuery to an address.
Decisions & Loops If relay.query isn't empty If relay.query isn't empty
Yes
TextTrim relay.query and save it as relayQuery.Trim relay.query and save it as relayQuery.
No
No steps
Values Set relayPlace to not located. Set relayPlace to not located.
Decisions & Loops If relay.located is yes If relay.located is yes
Yes
ValuesSet placeLabel to no place on record.Set placeLabel to no place on record.
Decisions & LoopsIf relay.location_label isn't empty and relay.location_label isn't blankIf relay.location_label isn't empty and relay.location_label isn't blank
Yes
TextTrim relay.location_label and save it as placeLabel.Trim relay.location_label and save it as placeLabel.
No
No steps
ValuesSet ispName to no provider on record.Set ispName to no provider on record.
Decisions & LoopsIf relay.isp isn't empty and relay.isp isn't blankIf relay.isp isn't empty and relay.isp isn't blank
Yes
TextTrim relay.isp and save it as ispName.Trim relay.isp and save it as ispName.
No
No steps
ValuesChange relayPlace to placeLabel, run by ispName.Change relayPlace to placeLabel, run by ispName.
No
ValuesSet notLocatedReason to no reason given.Set notLocatedReason to no reason given.
Decisions & LoopsIf relay.reason isn't empty and relay.reason isn't blankIf relay.reason isn't empty and relay.reason isn't blank
Yes
TextTrim relay.reason and save it as notLocatedReason.Trim relay.reason and save it as notLocatedReason.
No
No steps
ValuesChange relayPlace to not located (notLocatedReason).Change relayPlace to not located (notLocatedReason).
Decisions & Loops If relay.hosting is yes If relay.hosting is yes
Yes
ValuesChange relayPlace to relayPlace - a data centre address, which is what mail sent through a cloud or bulk provider looks like.Change relayPlace to relayPlace - a data centre address, which is what mail sent through a cloud or bulk provider looks like.
No
No steps
Lists Add relayQuery: relayPlace to the end of placeLines and save it as placeLines. Add relayQuery: relayPlace to the end of placeLines and save it as placeLines.
Decisions & LoopsIf placeLines isn't emptyIf placeLines isn't empty
Yes
TextJoin placeLines with a new line and save it as relayPlaces.Join placeLines with a new line and save it as relayPlaces.
No
No steps
TextExtract the first match from fromLine in lowercase and save it as fromDomain.Extract the first match from fromLine in lowercase and save it as fromDomain.
TextExtract the first match from returnPathLine in lowercase and save it as pathDomain.Extract the first match from returnPathLine in lowercase and save it as pathDomain.
ValuesSet envelopeNote to A domain could not be read from both the From header and the Return-Path header..Set envelopeNote to A domain could not be read from both the From header and the Return-Path header..
Decisions & LoopsIf fromDomain isn't empty and pathDomain isn't emptyIf fromDomain isn't empty and pathDomain isn't empty
Yes
Decisions & LoopsIf fromDomain is pathDomainIf fromDomain is pathDomain
Yes
ValuesChange envelopeNote to The From address and the Return-Path are on the same domain (fromDomain).Change envelopeNote to The From address and the Return-Path are on the same domain (fromDomain).
No
ValuesChange envelopeNote to The From address is on fromDomain and the Return-Path is on pathDomain. These differ on most mailing lists, newsletters, ticketing systems and forwarded mail.Change envelopeNote to The From address is on fromDomain and the Return-Path is on pathDomain. These differ on most mailing lists, newsletters, ticketing systems and forwarded mail.
No
No steps
ValuesSet factsSender to From: fromLineSet factsSender to From: fromLine Return-Path: returnPathLine envelopeNote.
ValuesSet factsChecks to SPF: spfResultSet factsChecks to SPF: spfResult DKIM: dkimResult DMARC: dmarcResult.
ValuesSet factsRelays to Relay addresses named in the headers: relayListSet factsRelays to Relay addresses named in the headers: relayList Where those addresses resolve: relayPlaces.
ValuesSet headerFacts to factsSenderSet headerFacts to factsSender factsChecks factsRelays.
ValuesSet notePrompt to You are writing one short note for a log of email header fields.Set notePrompt to You are writing one short note for a log of email header fields. Describe only what the fields below record, in at most three sentences of plain English. Say when a field records nothing. Do not decide anything about the message, do not say what it is, and do not say what should be done about it. Do not mention anything that is not listed below. Relay addresses in other countries are ordinary: mailing lists, forwarding services and cloud providers all route mail through them. Say where an address resolves without implying anything about it. Header fields: headerFacts.
ValuesSet replyText to blank.Set replyText to blank.
Decisions & LoopsIf a step below fails, save the error as noteErrorIf a step below fails, save the error as noteError
Try
ClaudeClaudeAsk Claude: notePrompt. Save it as modelReply.Ask Claude: notePrompt. Save it as modelReply. Maximum response length: 300
Decisions & LoopsIf modelReply.response_text isn't emptyIf modelReply.response_text isn't empty
Yes
TextTrim modelReply.response_text and save it as replyText.Trim modelReply.response_text and save it as replyText.
No
No steps
On error
ValuesShow in the output: The written note step did not answer for message messageId.Show in the output: The written note step did not answer for message messageId.
ValuesSet note to The written note step returned nothing, so this row carries the header fields on their own..Set note to The written note step returned nothing, so this row carries the header fields on their own..
Decisions & LoopsIf replyText isn't emptyIf replyText isn't empty
Yes
ValuesChange note to replyText.Change note to replyText.
No
No steps
TextMatch keywords in replyText in lowercase and save it as noteWentBeyondTheFields.Match keywords in replyText in lowercase and save it as noteWentBeyondTheFields.
Decisions & LoopsIf noteWentBeyondTheFields.is_match is yesIf noteWentBeyondTheFields.is_match is yes
Yes
ValuesChange note to The written note was set aside because it went beyond describing the fields. Read the header fields in this row instead..Change note to The written note was set aside because it went beyond describing the fields. Read the header fields in this row instead..
No
No steps
Google SheetsGoogle SheetsAdd a row to tabName in spreadsheetUrl.Add a row to tabName in spreadsheetUrl.
GmailGmailAdd label checkedLabel to email messageId.Add label checkedLabel to email messageId.
On error
ValuesShow in the output: Could not read the headers for message messageId: headerError as text.Show in the output: Could not read the headers for message messageId: headerError as text.