Community partner outreach and contact list update
Verify and clean partner contact information, create a short personalized outreach message, and send initial emails when preparing to re-engage community organizations.
내용 미리보기
Verify and clean partner contact information, create a short personalized outreach message, and send initial emails when preparing to re-engage community organizations.
The contact spreadsheet contains outdated or incomplete entries and no recent outreach has been sent to priority partners.
Several entries are missing emails or current roles and finding up-to-date contact info takes time; without a short template personalizing each message is slow.
The spreadsheet will have verified contact details for priority partners, a concise outreach message ready, and recent sends logged with follow-up reminders scheduled.
- • Computer with internet — 1
- • Spreadsheet app — 1
- • Email client — 1
- 01 Audit contact listOpen the spreadsheet, scan the top-priority 20 rows, mark entries missing email, role, or organization link, and flag duplicates in a new 'To update' column.⏱ 5분
- 02 Verify contact detailsFor each flagged row, search the organization site and LinkedIn to confirm name, role, and email; update fields in the sheet and note source URL in a 'Verified source' column.⏱ 10분
- 03 Draft outreach templatesWrite one short base email (3–5 sentences) and two 1–2 sentence variants for different partner types, include subject line, clear ask, and two possible CTAs (meeting link or reply).⏱ 8분
- 04 Send emails and log outreachPersonalize and send the prepared message to the top 5 verified contacts, record date and message variant in the spreadsheet, and create calendar or task reminders for follow-up in 7–14 days.⏱ 8분