Connectors

/

Granola

/

Find Granola meeting contacts missing from Constant Contact
Report
Cross-Connector

Find meeting contacts missing from Constant Contact

For marketers who want to know which people met in Granola meetings are not on the mailing list, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Granola meeting contacts missing from Constant Contact
Which external people from my Granola meetings in the last 14 days are not in Constant Contact? Our domain is contoso.com.
3 of 11 external attendees are not in Constant Contact. - Priya Nair, priya@northwindtraders.com: 2 meetings, last on 12 Oct - Tom Becker, tom@fabrikam.com: 1 meeting, last on 9 Oct - Lena Ortiz, lena@adatum.com: 1 meeting, last on 8 Oct - Already in Constant Contact: 8; unchecked: 0 Want the meeting titles for each person?
Granola
Sample figures. Your results come from your own account.
granola-get-attendee
constant-contact-get-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Granola

Granola
Run it on your own Granola data.

Connect Granola, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

People you meet never reach the mailing list

People you meet rarely reach Constant Contact, because nobody compares who attended with who is on the list. By hand you search every address and guess whether a failed search means missing or a broken lookup.

Without PopdockAI

  • Read attendee lists from recent meetings
  • Remove your own colleagues
  • Search Constant Contact for every address
  • Guess whether a failed search means missing

With PopdockAI

  • External attendees of recent meetings are gathered
  • Your own domain is skipped
  • Each address is checked, failed lookups marked unchecked
  • Nothing is added or changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find external people who attended Granola meetings in the last `{lookback-days}` days (default 14) but have no Constant Contact contact. Treat addresses ending in `{internal-domain}` as internal and skip them (if empty, skip none).

**Step 1: List attendees (granola server)**

Call `granola-get-attendee` with `note-created.from` set to today minus the lookback and `max-records` 500. Group rows by `email`, keeping name, the meeting titles and the latest `note-created-at`.

**Step 2: Check Constant Contact (constant-contact server)**

For each distinct external email call `constant-contact-get-contact` with `email-address`. Record the email as missing when nothing returns.

**Step 3: Report**

A table of missing people: name, email, meetings attended (count and titles), last meeting date. Then totals: distinct external attendees, already in Constant Contact, missing.

**Rules & Guidelines:**

* Tools starting granola- (prefix) are on the granola server; tools starting constant-contact- (prefix) are on the constant-contact server.
* Read-only. This prompt only reports; do not call `constant-contact-add-contact` or any other write tool.

**Validation:**

* No attendee rows: report that no meetings were found in the window and stop.
* Ignore rows with no email.
* If a Constant Contact lookup errors, list that email as "unchecked" rather than missing.

Who it's for

One answer, three teams that use it

Marketing managers

Grow the list from real conversations

A table of missing people with their meetings shows who to invite to your list.

Which external people from my meetings in the last 30 days are not in Constant Contact? We are fabrikam.com.

Sales reps

Make sure prospects get your newsletter

People you met but who are missing from Constant Contact are listed with the last meeting date.

Who have I met this month that is not in Constant Contact? Our domain is northwindtraders.com.

Marketing operations

Trust the gaps you report

Failed lookups are marked unchecked, so you only act on real gaps.

List Granola meeting contacts from the last 60 days missing from Constant Contact, and show any unchecked.

How it works

What PopdockAI does when you ask

You say how far back to look and your AI assistant checks each external attendee in Constant Contact. Real gaps are kept apart from failed lookups, and nothing is changed.

01

Ask

You say how many days to look back and which email domain is your own.

Your AI tool

02

List

It gathers the external attendees of your recent Granola meetings.

granola-get-attendee

03

Check

It looks up each address in Constant Contact and marks failed lookups as unchecked.

constant-contact-get-contact

04

Report

You get a table of missing people with meetings and dates, plus totals.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Granola and one secure connection to your AI tool. No code, no exports.

get-data

granola-get-attendee

Returns the people who attended each Granola meeting note, so you can see who was actually in the room.
get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
Read only.Nothing in Granola Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Know who is missing from your mailing list

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation