Automatically Sync Event Attendees to Constant Contact

Setup Steps

Step 1: When Event Ends

1. Create new Zap → Search CE-Go
2. Select Event Ended trigger
3. Connect your CE-Go account
4. Click Test trigger

Step 2: Setup Configuration

1. Add Code by Zapier → JavaScript
2. In Input Data, add:
   • event_id → 1. Event ID
   • total_users → 1. Total Users
   • list_id → Your Constant Contact List ID (see instructions below)
3. Paste this code:

// =============================================
// 🔧 Don't change below
// =============================================

const limitPerPage = 100;
const eventId = inputData.event_id;
const listId = inputData.list_id;
const totalUsers = inputData.total_users;
const totalPages = Math.ceil(totalUsers / limitPerPage);

const pages = [];
for (let i = 1; i <= totalPages; i++) {
  pages.push(i);
}

return { 
    event_id: eventId,
    total_users: totalUsers,
    limit: limitPerPage,
    pages: pages,
    total_pages: totalPages,
    list_id: listId
};

Step 3: Check if Users Exist

1. Add Filter by Zapier
2. Set: 2. Total Users → (Number) Greater than → 0

Step 4: Loop Users Page by Page

1. Add Looping by Zapier
2. Action: Create Loop From Line Items
3. Values to Loop: pages → 2. Pages
4. Trim Whitespace: True
5. Loop counter start: 1
6. Maximum iterations: 100

Step 5: Get Event Users

1. Add CE-Go → Get Event Users
2. Configure:
   • Event ID: 2. Event Id
   • Limit: 2. Limit
   • Page: 4. Loop Iteration
   • If multiple results: Return all results as line items

Step 6: Skip if No Users on Page

1. Add Filter by Zapier
2. Set: 5. Count → (Number) Greater than → 0

Step 7: Format Contacts for Constant Contact

1. Add Code by Zapier → JavaScript
2. In Input Data, add:
   • data → 5. Step(Row) Output
   • list_id → 2. List Id
   • loop_iteration → 4. Loop Iteration
3. Paste this code:

try {
  const data = JSON.parse(inputData.data);
  const users = data.results;

  // Format contacts for Constant Contact import
  const contacts = users.map(user => {
    return {
      email: user.email.toLowerCase().trim(),
      first_name: user.first_name || "",
      last_name: user.last_name || ""
      
      // Optional fields - add if needed:
      // job_title: user.job_title || "",
      // company_name: user.company || "",
      // phone: user.phone || "",
      // street: user.address || "",
      // city: user.city || "",
      // state: user.state || "",
      // zip: user.zip || "",
      // country: user.country || ""
    };
  });

  return {
    import_data: JSON.stringify(contacts),
    list_id: inputData.list_id,
    count: contacts.length,
    page_number: inputData.loop_iteration || "1"
  };
  
} catch(e) {
  return {
    error: true,
    message: e.message,
    page_number: inputData.loop_iteration || "1"
  };
}

Step 8: Sync to Constant Contact

1. Add Constant Contact → API Request (Beta)
2. Configure:

{
  "import_data": {{7. Import Data}},
  "list_ids": ["{{7. List Id}}"]
}
		

⚠️ Important: Make sure to map {{7. Import Data}} as a field (not as text in quotes). The data is already JSON-stringified in Step 7.

Step 9: Validate Results

1. Add Code by Zapier → JavaScript
2. In Input Data:
   • response_body → 8. Response Body
   • page_number → 7. Page Number
   • contacts_count → 7. Count
3. Paste this code:

try {
  // Parse Constant Contact response from Step 8
  const response = typeof inputData.response_body === 'string' 
    ? JSON.parse(inputData.response_body) 
    : inputData.response_body;
  
  // Check if response exists
  if (!response) {
    return {
      error: true,
      error_title: "No Response from Constant Contact",
      message: "Constant Contact API did not return a response",
      page_number: inputData.page_number
    };
  }
  
  // Extract activity details
  const activityId = response.activity_id;
  const state = response.state || "unknown";
  const percentDone = response.percent_done || 0;
  
  // Check if activity was created successfully
  if (!activityId) {
    return {
      error: true,
      error_title: "Failed to Create Import Activity",
      message: response.error_message || "No activity_id returned",
      error_key: response.error_key || "unknown",
      page_number: inputData.page_number
    };
  }
  
  // Success - activity created
  return {
    error: false,
    status: "success",
    activity_id: activityId,
    state: state,
    percent_done: percentDone,
    contacts_count: inputData.contacts_count,
    page_number: inputData.page_number,
    status_url: response._links?.self?.href || '',
    message: `Import activity created successfully. ${inputData.contacts_count} contacts queued for import.`
  };
  
} catch (error) {
  return {
    error: true,
    error_title: "Failed to Validate Constant Contact Response",
    message: error.message,
    page_number: inputData.page_number
  };
}

🎉 Publish Your Zap

1. Review all steps
2. Click Publish at the top right
3. Your Zap is now live!

Success! Attendees will now automatically sync to Constant Contact when events end.

💡 Troubleshooting

Adding Custom Fields

In Step 7 code, uncomment and add fields as needed:

return {
  email: user.email.toLowerCase().trim(),
  first_name: user.first_name || "",
  last_name: user.last_name || "",
  phone: user.phone || "",
  company_name: user.company || "",
  job_title: user.job_title || ""
};

Note: Field names must match Constant Contact's field names exactly (case-sensitive).

Need Help?

• 📧 Contact CE-Go support
• 📚 Constant Contact API Documentation

Happy syncing! 🎉
You've just automated your Constant Contact workflow!