Tool | What It Does | Example Use |
---|---|---|
Get All Lists | Retrieve every list you have access to in Affinity | ”Get all lists and return list_id and title” |
Get List | Get detailed information about a specific list | ”Get list ‘Series A Pipeline’ and return title, type, and field_ids” |
Get List Entries | Retrieve entries from a list with pagination | ”Get the first 50 entries from list ‘Active Investors’ and return entry_id and entity_name” |
Get List Entry | Get details for a single list entry | ”Get entry for ‘Acme Corp’ in list ‘Portfolio Companies’ and return entity_id, list_id, and created_date” |
Create List Entry | Add a person, organization, or opportunity to a list | ”Add organization ‘TechStartup Inc’ to list ‘Due Diligence Q2’ and return entry_id” |
Delete List Entry | Remove an entity from a list | ”Remove ‘Declined Deal - Widget Co’ from list ‘Active Pipeline‘“ |
Get Fields | Retrieve all fields (columns) with optional filters | ”Get fields where type is ‘dropdown’ and return id and name” |
Get Field Values | Get field values for one entity | ”Get field values for person ‘Jane Smith’ and return field_name, value” |
Create Field Value | Create or update a field value | ”Set field ‘Deal Stage’ to ‘Term Sheet’ for opportunity ‘Series B - DataCo’ and return field_value_id” |
Update Field Value | Update an existing field value by ID | ”Update ‘Last Contact Date’ field to ‘2024-03-15’ for person ‘John Chen at Microsoft‘“ |
Delete Field Value | Clear a field value | ”Clear the ‘Next Steps’ field for opportunity ‘Seed Round - AI Startup‘“ |
Search Persons | Search people in your Affinity database | ”Search persons where title contains ‘Partner’ and return person_id, name, email” |
Get Person | Get details for a single person | ”Get person ‘Sarah Johnson at Sequoia’ and return name, title, primary_email” |
Create Person | Create a new person | ”Create person ‘Michael Lee’, email michael@techventures.com, organization ‘Tech Ventures’, and return person_id” |
Update Person | Update a person’s information | ”Update person ‘David Kim’ set title to ‘Managing Director‘“ |
Delete Person | Delete a person | ”Delete person ‘Former Employee - Test Account‘“ |
Get Person Fields | List global person fields | ”Get person fields and return id, name, type” |
Search Organizations | Search organizations | ”Search organizations where domain is ‘stripe.com’ and return organization_id, name, website” |
Get Organization | Get details for one organization | ”Get organization ‘Andreessen Horowitz’ and return name, domain, industry” |
Create Organization | Create a new organization | ”Create organization ‘NewCo Technologies’, domain newco.tech, and return organization_id” |
Update Organization | Update an organization | ”Update organization ‘StartupXYZ’ set industry to ‘Enterprise SaaS‘“ |
Delete Organization | Delete an organization | ”Delete organization ‘Duplicate - Acme Corp OLD‘“ |
Get Organization Fields | List global organization fields | ”Get organization fields and return id, name” |
Search Opportunities | Search deals/opportunities | ”Search opportunities where name contains ‘Series A’ and return opportunity_id, name, stage” |
Get Opportunity | Get details for one opportunity | ”Get opportunity ‘Series B - FinTech Co’ and return name, stage, amount” |
Create Opportunity | Create a new opportunity | ”Create opportunity ‘Seed Round - AI Platform’, organization ‘AI Platform Inc’, stage ‘Initial Meeting’, and return opportunity_id” |
Update Opportunity | Update an opportunity | ”Update opportunity ‘Series A - DataTools’ set stage to ‘Due Diligence‘“ |
Delete Opportunity | Delete an opportunity | ”Delete opportunity ‘Cancelled - Project X‘“ |
Get Notes | Retrieve notes with filters | ”Get notes created after 2024-01-01 and return note_id, content” |
Get Note | Get a specific note | ”Get note from ‘Partner meeting with Bessemer’ and return content, created_date” |
Create Note | Create a new note | ”Create note ‘Intro call - very interested in their ML approach’ for person ‘Emma Wilson at TechCo’ and return note_id” |
Update Note | Update an existing note | ”Update note for ‘Due diligence call’ content to ‘DD complete - moving to term sheet stage‘“ |
Delete Note | Delete a note | ”Delete note ‘Old meeting notes - archived‘“ |
Create Your Affinity MCP Node
Add Your Prompt
Test Your Node
Save and Reuse
Step 1: Search Opportunities
Step 2: Find CEOs
Step 3: Create Notes
Empty Outputs
Incorrect Results
Errors
Iterate with Request Changes