Export Partiful RSVPs and questionnaire answers to Google Sheets

1. Open the event in Partiful, go to the Guest List and tap EXPORT CSV in the top right corner.
2. Choose which RSVP types the file should hold, for example Going only, and download it.
3. For a quick look without a file, open the Guest Questionnaire settings and tap View Responses to read the answers guest by guest.
4. Open the CSV, find the people who are not in the members sheet yet and paste their rows with RSVP and answers.
5. Repeat for every event. Partiful names are often just a first name, so deciding which "Sam" in the sheet a new row belongs to is guesswork.

Export everyone who is Going to my supper club and add the new people, with their dietary answers, to the members Google Sheet.

1. 01

   Choose events and statuses

   The agent takes the events you mean from list_events, past ones too when you ask for a whole season, and requests the export for the statuses the sheet tracks: Going for attendance, Waitlist when you measure demand. Can't Go stays out unless you ask.

2. 02

   Match people already in the sheet

   Each guest is compared with the sheet by the full name from the questionnaire first, then by the Partiful name. A bare first name with two possible matches is never merged; it goes on a list for you.

3. 03

   Append, never overwrite

   New people become new rows and known people get the event added to their history. Cells you edited by hand stay untouched, and someone who switched to Can't Go is updated, not deleted.

4. 04

   Sum up the answers when you need them

   For a dinner or a catering order, the agent reads list_guests for Going guests and groups free-text answers: "vegetarian", "veggie" and "no meat" become one line, while anything that sounds like an allergy is listed with the person's name.

5. 05

   Count the blanks

   Guests who RSVP'd before a question existed have no answer to it, and phone numbers are never in the data. The agent reports both, so you know whom to ask directly.

Supper club, October: 31 Going exported.
Members sheet: 6 new rows, 23 members updated with the October dinner.
Not merged: "Sam" fits Sam Ortiz and Sam Lee, tell me which.
Dietary answers (Going): 5 vegetarian, 2 vegan, 1 gluten-free.
Allergies by name: Leo Park (peanuts), Ines Duarte (shellfish).
4 guests have no answer: they RSVP'd before the question was added.

• Partiful names are often only first names, and Partiful itself tells hosts to ask for full names in the Guest Questionnaire when an event needs them.
• Partiful does not show hosts their guests' phone numbers under its Privacy Policy, so a phone number reaches your sheet only if your Guest Questionnaire asked for it.
• Guest Questionnaire answers in Partiful are visible only to hosts, and guests who RSVP'd before a question was added must RSVP again to answer it.
• Partiful questionnaire questions are Short Answer, Dropdown or a request for socials, so free-text answers such as allergies need grouping before they add up.

Every tool here only reads, so it can run weekly from n8n, Make, Zapier or cron without waiting for your OK.

Sources: Partiful Help: Can I download the names of my guests? · Partiful Help: How do I ask questions to my guests? · Partiful Help: Collecting guest info (dietary restrictions, names of +1s) · Partiful Help: What information can I see about my guests?

curl https://cotlet.dev/api/v1/partiful/export_guest_list \
  -H "Authorization: Bearer $COTLET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"event_id":"evt_hK3vQ9xL","statuses":["going"]}'

{
  "event_id": "evt_hK3vQ9xL",
  "statuses": [
    "going"
  ],
  "guests": 28,
  "download_url": "https://cotlet.dev/api/v1/files/exports/partiful/evt_hK3vQ9xL-going.csv"
}

MCP: add https://cotlet.dev/mcp/v1 with the same key; the tool is partiful_export_guest_list. Example data.

• Send a Partiful Text Blast to guests by RSVP status
• Approve pending Partiful guests by their questionnaire answers
• Re-invite past guests to a recurring Partiful event
• Partiful API and MCP server: every tool
• All use cases