Skip to main content

Hello Zap Community!

I’d love some help with this one!

 

I want my zap to complete the following steps:

  1. Add new Members to Spreadsheet

New order in Thinkific (online course platform) for either of these products:

Products: Level 1: Community Member and Level 2: Fashion Designers Studio Access

Zapier uses Google Sheets Sheet name: Membership Coupon Codes

Worksheet name: 25 PERCENT OFF ONLINE COURSES

(I bulk created 100 coupon codes for Members to use on our courses.)

Zapier finds the first row (from the top down) that does not contain an email address in column H (Email).

Zapier adds the email address (of the new order) to this column H

Zapier also adds the First and Last name to the same row (Columns I and J)

 

  1. Adds New Member + their assigned coupon code to MailChimp subscribers list

Zapier uses First Name, Last name, Email address AND Coupon Code (Column 😎 as new subscriber to Mailchimp

I will then set up a flow in Mailchimp to email the new subscriber their unique code.

 

How do I do the step where Zapier finds the first row that is empty for email address, first and last name? And then add the new order's details here.

Screenshot of spreadsheet containing all codes.

 

Hi @Made team member 

Try this…

Add another column, with a static value of ‘UNCLAIMED’ for each of the 100 coupon code, then have the Zap look for that value, and update the cell to ‘ASSIGNED’.


Hi @Troy Tessalone 

Thank you so much for the suggestion!

I will try it out and let you know!

Have a great week,

Made Team Member


Hi @Troy Tessalone 

IT WORKED!

Thank you!


@Made team member 

TIP: If you get a lot of traffic/volume at the same time, then I suggest adding a Delay step to your Zap.

This is so that the triggered Zaps will process in sequential order to ensure the same code is not used more than once.

Delay After Queue: https://zapier.com/help/create/customize/add-delays-to-zaps#delay-after-queue