← 공개 라이브러리

Community partner outreach and contact list update

by MASTER

Verify and clean partner contact information, create a short personalized outreach message, and send initial emails when preparing to re-engage community organizations.

Fecit 앱에 저장하기
이 루틴을 Fecit 앱에서 열어 내 라이브러리에 추가하세요.

내용 미리보기

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.

⏱ 30분 ★ 쉬움
현재

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
단계
  1. 01
    Audit contact list
    Open 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분
  2. 02
    Verify contact details
    For 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분
  3. 03
    Draft outreach templates
    Write 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분
  4. 04
    Send emails and log outreach
    Personalize 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분