How do I create a Zapier workflow that updates my Mailchimp list, assigning a unique word to a Merge field

Hi @CCDNB 

Good question.

Are you trying to have a new word and QR code generated for each Mailchimp Subscriber whenever a Campaign is scheduled in Mailchimp?

@CCDNB

That’s going to be very “costly” to do as the # of subscribers grows.

Retrieving subscribers from the Mailchimp API involves pagination that need to be looped thru. (e.g. max 1,000 records per page.)

Mailchimp API supports BATCH operations. (read more)

FYI: The Looping app only supports a max of 500 records.

Zap action steps also have timeouts you need to work around. (e.g. max 30 seconds)

If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace

@Troy Tessalone I’ve actually sorted it all out with Code, removing the loop function all together.

Action 3, retrieving the whole list of subscribers,

import requests

def retrieve_subscribers():
    api_key = '***'
    list_id = '***'

    url = f'https://*.api.mailchimp.com/3.0/lists/{list_id}/members'

    headers = {
        'Authorization': f'Bearer {api_key}',
        'Content-Type': 'application/json'
    }

    response = requests.get(url, headers=headers)
    response_data = response.json()

    return response_data['members']

subscribers = retrieve_subscribers()
return subscribers

And my Action 4 currently looks like:

const previousStep = {
  password: 'generated_password_here',
  qrCodeUrl: 'generated_qr_code_url_here'
};

const apiKey = '***';
const listId = '***';

const updateSubscriber = async (subscriber, password, qrCodeUrl) => {
  const url = `https://*.api.mailchimp.com/3.0/lists/${listId}/members/${subscriber.subscriberId}`;

  const mergeFields = {
    WORD: password,
    QR_CODE: qrCodeUrl
  };

  const response = await fetch(url, {
    method: 'PATCH',
    headers: {
      'Authorization': `Bearer ${apiKey}`,
      'Content-Type': 'application/json'
    },
    body: JSON.stringify({
      merge_fields: mergeFields
    })
  });

  const responseData = await response.json();

  return responseData;
};

const subscribers = Array.isArray(inputData) ? inputData : [inputData]; // Ensure inputData is an array

const updatedSubscribers = [];

for (const subscriber of subscribers) {
  const password = previousStep.password; // Access the generated password from the previous step
  const qrCodeUrl = previousStep.qrCodeUrl; // Access the generated QR code URL from the previous step

  const updatedSubscriber = await updateSubscriber(subscriber, password, qrCodeUrl);
  updatedSubscribers.push(updatedSubscriber);
}

return updatedSubscribers;

HOWEVER While I have this code ^ I am unsure what to do with it…

The data being collected is the Word, QR Code, and List of Subscribers. I am unsure where to inout them properly into this code to make it work properly.

@Troy Tessalone 

I’ve been trying to batch mailchimp stuff you linked to. Do you know why it’s timing me out after 10.1 seconds? Mailchimp says it should be 120.

I just wanted to say that I completed this solo talking it over with ChatGPT. ChatGPT helped me way more than a real person did.

It seems that exporting from mail service defeats the purpose of Zapier. That is what I’m trying to save time on.