I'm currently trying to import a field of checkboxes from mail chimp into a google sheet. Currently, if someone selects a checkbox from the form it is imported as “true” and if not, “false.” What I want is to import only the text associated with checked boxes, and not any text associated with unchecked boxes into a single cell in the google sheet. Is there a way to do this?
+14Hi
For us to have more info, post screenshots about the data you are referring to that is available in the Zap steps.
+6Hi
Welcome to the Community.
To import only the text associated with checked boxes from Mailchimp into a Google Sheet, you can use a Formatter step in Zapier to filter out unchecked options. Start by setting up your Mailchimp trigger, such as "New Subscriber" or "Updated Subscriber." Then, add a Formatter step using the "Utilities" action and select "Replace" as the transform. In the input field, map the checkbox field from Mailchimp, set "false" as the value to find, and replace it with a blank space. This effectively removes unchecked items from the data. Finally, use a "Create Spreadsheet Row" action in Google Sheets and map the cleaned-up field to the appropriate cell. This method works if checkbox data is sent as a string of "true"/"false" values—if it's sent as a boolean array instead, you may need to use "Line-item to Text" to convert it first.
I hope this helps! Please let me know if you have any other questions or if there's anything else I can assist you with.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
