Pull the contact details out of your notes

Give it a Google Doc of meeting notes, a pasted conference list or a forwarded thread, and run it whenever you like. The AI reads the text and lists every person whose email address or phone number is actually written in it, and each of them becomes a new row on the spreadsheet tab you choose.

Rows are only ever appended, and each records the date, name, email address, phone number, source document and a note. Nothing is invented: every address and number is checked against the document character for character before it is written, and anything not found there is dropped. Addresses are also checked for a valid shape. A name that does not appear the way it was reported is left blank and the note says so. The run ends by saying how many people were offered, written and dropped, and nobody is contacted.

Before the first run you need a spreadsheet tab with the headings 'Found on', 'Name', 'Email', 'Phone', 'Source document' and 'Notes', in that order.

Set notesDocument to blank.Set notesDocument to blank.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set tabName to blank.Set tabName to blank.

Set maxContacts to 50.Set maxContacts to 50.

Trim notesDocument and save it as documentLink.Trim notesDocument and save it as documentLink.

Set notesId to documentLink.Set notesId to documentLink.

If documentLink contains /d/If documentLink contains /d/

Yes

Get the first item of the last item of documentLink split by /d/ split by / and save it as notesId.Get the first item of the last item of documentLink split by /d/ split by / and save it as notesId.

Else if @documentLink contains "/"

Stop and report a problem: The 'notesDocument' step does not look like a Google Docs link. Paste the link from the address bar while the document is open, or paste just its document id.Stop and report a problem: The 'notesDocument' step does not look like a Google Docs link. Paste the link from the address bar while the document is open, or paste just its document id.

Otherwise

No steps

If notesId is emptyIf notesId is empty

Yes

Stop and report a problem: No document id could be read out of the 'notesDocument' step. Paste the link from the address bar while the document is open.Stop and report a problem: No document id could be read out of the 'notesDocument' step. Paste the link from the address bar while the document is open.

No

No steps

Round maxContacts multiplied by 1 to the nearest integer and save it as contactLimit.Round maxContacts multiplied by 1 to the nearest integer and save it as contactLimit.

Google DocsRead notesId. Save it as notes.Read notesId. Save it as notes.

Trim notes.text and save it as sourceText.Trim notes.text and save it as sourceText.

If sourceText is null or sourceText is emptyIf sourceText is null or sourceText is empty

Yes

Stop and report a problem: That Google Doc has no text in it, so there was nothing to read. Check you pasted the link to the right document.Stop and report a problem: That Google Doc has no text in it, so there was nothing to read. Check you pasted the link to the right document.

No

No steps

Set readingPrompt to You are reading one document and listing only the people whose contact details are written in it.Set readingPrompt to You are reading one document and listing only the people whose contact details are written in it. Rules: - Copy characters exactly as they appear in the text. Never correct, complete, reformat, tidy, guess or invent any part of a name, email address or phone number. - Include a person only if the text itself contains their email address or their phone number. - Return one person per line, in this form: name || email address || phone number - Keep both || separators on every line, even when a part is missing. Leave a part empty rather than filling it in. - Do not add a heading, numbering, explanation or any other text. - If the text contains no email addresses and no phone numbers, reply with the single word none. Text: sourceText.

ClaudeAsk Claude: readingPrompt. Save it as reading.Ask Claude: readingPrompt. Save it as reading. Maximum response length: 2000

Trim reading.response_text and save it as reply.Trim reading.response_text and save it as reply.

If reply is null or reply is emptyIf reply is null or reply is empty

Yes

Stop and report a problem: The document was read but nothing came back, so no rows were added. Run it again.Stop and report a problem: The document was read but nothing came back, so no rows were added. Run it again.

No

No steps

If reply in lowercase is none or reply in lowercase is none.If reply in lowercase is none or reply in lowercase is none.

Yes

Finish the run: No email addresses or phone numbers were found in that document, so no rows were added.Finish the run: No email addresses or phone numbers were found in that document, so no rows were added.

No

No steps

Set candidates to 0.Set candidates to 0.

Set contactsWritten to 0.Set contactsWritten to 0.

Set contactsRejected to 0.Set contactsRejected to 0.

Set contactsUnreadable to 0.Set contactsUnreadable to 0.

Set contactsFailed to 0.Set contactsFailed to 0.

For each replyLine in reply split by a new line:For each replyLine in reply split by a new line:

Trim replyLine and save it as lineText.Trim replyLine and save it as lineText.

If lineText is null or lineText is emptyIf lineText is null or lineText is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

Add 1 to candidates.Add 1 to candidates.

If contactsWritten is greater than or equal to contactLimitIf contactsWritten is greater than or equal to contactLimit

Yes

Skip to the next item.Skip to the next item.

No

No steps

Split lineText by || and save it as parts.Split lineText by || and save it as parts.

If the length of parts is not 3If the length of parts is not 3

Yes

Add 1 to contactsUnreadable.Add 1 to contactsUnreadable.

Skip to the next item.Skip to the next item.

No

No steps

Trim parts[0] and save it as personName.Trim parts[0] and save it as personName.

Trim parts[1] and save it as personEmail.Trim parts[1] and save it as personEmail.

Trim parts[2] and save it as personPhone.Trim parts[2] and save it as personPhone.

If personEmail is empty and personPhone is emptyIf personEmail is empty and personPhone is empty

Yes

Add 1 to contactsRejected.Add 1 to contactsRejected.

Skip to the next item.Skip to the next item.

No

No steps

If personEmail isn't empty and not personEmail is a valid email addressIf personEmail isn't empty and not personEmail is a valid email address

Yes

Add 1 to contactsRejected.Add 1 to contactsRejected.

Skip to the next item.Skip to the next item.

No

No steps

If personEmail isn't empty and sourceText doesn't contain personEmail (ignoring…If personEmail isn't empty and sourceText doesn't contain personEmail (ignoring…

Yes

Add 1 to contactsRejected.Add 1 to contactsRejected.

Skip to the next item.Skip to the next item.

No

No steps

If personPhone isn't empty and sourceText doesn't contain personPhone (ignoring…If personPhone isn't empty and sourceText doesn't contain personPhone (ignoring…

Yes

Add 1 to contactsRejected.Add 1 to contactsRejected.

Skip to the next item.Skip to the next item.

No

No steps

Set rowNote to blank.Set rowNote to blank.

If personName isn't empty and sourceText doesn't contain personName (ignoring…If personName isn't empty and sourceText doesn't contain personName (ignoring…

Yes

Change personName to blank.Change personName to blank.

Change rowNote to The name was not written this way in the document, so it has been left blank..Change rowNote to The name was not written this way in the document, so it has been left blank..

No

No steps

If a step below fails, save the error as writeErrorIf a step below fails, save the error as writeError

Try

Google SheetsAdd a row to tabName in spreadsheetUrl.Add a row to tabName in spreadsheetUrl.

Add 1 to contactsWritten.Add 1 to contactsWritten.

On error

Add 1 to contactsFailed.Add 1 to contactsFailed.

Show in the output: A contact could not be written to the spreadsheet: writeError as text.Show in the output: A contact could not be written to the spreadsheet: writeError as text.

Set runSummary to contactsWritten contacts were written from candidates the reader offered. contactsRejected were dropped because their details were not in the document, contactsUnreadable could not be read and contactsFailed failed to write.Set runSummary to contactsWritten contacts were written from candidates the reader offered. contactsRejected were dropped because their details were not in the document, contactsUnreadable could not be read and contactsFailed failed to write.

If contactsWritten is less than candidatesIf contactsWritten is less than candidates

Yes

Finish the run: runSummary.Finish the run: runSummary.

No

Show in the output: runSummary.Show in the output: runSummary.