How do I add new row in Google Sheets that includes a payment method when theres a new payment in Circle?

Question

We are launching a course in the Circle community platform
There will be three payment methods.
Depending on which payment method people use, I need to tag them in Mailerlite.

There’s no direct way to do this so…

I have set up a Zap that places the user email and their Circle tag (which depends on the payment they used) into a Google Sheet adding a new row each time
That is tested and works. So each time a member of the Circle community makes a payment, a new row is created in the Google sheet along with a tag that indicates the type of payment made.

What I can’t figure out is how to do the next step. ie take the user email and the tag from the Google sheet and add them to MailerLite so the contact is placed in a specific Group based on the tag in the Google sheet.

Any thoughts gratefully accepted.

Troy Tessalone · Accepted Answer

Hi @FunctionalDXGood question.Try using the concept of a lookup table: Formatter > Utilities > Lookup Tablehttps://help.zapier.com/hc/en-us/articles/8496305146765Or you can configure separate Zaps with a Filter step: https://zapier.com/apps/filter/help

FunctionalDX · Answer

Thanks Troy - that looks like it would do it…Appreciate it.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded