Extract contacts from Gmail into a Google Sheet
A deduplicated sheet of contacts from my inbox with name, email, company, and category
Go through my Gmail [mailbox or label, e.g. all mail, or the Clients label] and pull out the people I've exchanged email with in [time range, e.g. the last 12 months]. Keep only [which contacts, e.g. addresses at these domains: example.com, or everyone outside my own company]. Check the From, To, and CC fields on each thread, and read signatures for phone, title, and company. Skip newsletters, no-reply and notification addresses, automated senders, and my own addresses. Merge duplicates so each email address appears once. Put the results in a new Google Sheet [or the sheet I link] with columns: Name, Email, Company, Title, Phone, Category [e.g. client, vendor, prospect, personal], Last contacted, Thread count. Leave a cell blank if the detail isn't in the emails. Never guess an address. Don't email anyone. If the mailbox is too large to finish, ask before narrowing the range. Finish with the total contacts found, counts per category, and the sheet link.