Pull the contact details out of your notes
Reads a page of notes and adds a row for every name, email address and phone number actually written in it.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
The integration steps this workflow runs, in the order it first runs them.
- 1Google DocsGet document text
- 2AnthropicGenerate model response
- 3Google SheetsAppend row
How it works
Everything the template sets up, and what to fill in before the first run.
Names, email addresses and phone numbers arrive buried in prose - meeting notes, a conference list someone pasted in, a forwarded thread. Point this at the Google Doc holding that text and every person whose contact details are written in it becomes a row on your spreadsheet.
Rows are only ever appended, and the columns are fixed in this order: Found on, Name, Email, Phone, Source document, Notes. Give your tab those headings before the first run.
The one thing this will not do is invent a contact. Every email address and phone number is checked against the text of the document before it is written, character for character, and anything that is not there is dropped instead of saved - because an address that was never written down is a message to a stranger. Email addresses are checked for a valid shape as well. A name that does not appear the way it was reported is left blank rather than reshaped, and the Notes column says so.
That strictness cuts both ways: a phone number the reader rewrote into another format will not match the page and is dropped too. The run finishes by saying how many people were offered, how many were written, and how many were dropped and why, so nothing goes missing quietly. Nothing is contacted - the details are only written where you pointed them.
Fill in 'notesDocument', 'spreadsheetUrl' and 'tabName'. 'maxContacts' caps how many rows one run may write.
You May Also Be Interested In
Summarise and index new documents in a Box folderChecks a Box folder hourly and gives each new PDF its own summary document and one row in your index sheet.
Track a property market over timeSearches one property site each week, records the listings that are new to you, and logs how the record has changed.
Weekly chart of how a metric has movedEvery Monday, charts the recent history of one metric from your sheet and emails you the chart with a note on what changed.
Tell me when a page I watch changesChecks the pages you list each day and emails you when the wording actually changes, with a note on what changed.
Start from a workflow that already works.
Add "Pull the contact details out of your notes" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required