Best answer

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

  • 23 March 2023
  • 2 replies
  • 31 views

Userlevel 1

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. 

icon

Best answer by Troy Tessalone 23 March 2023, 18:03

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @FunctionalDX 

Good question.

Try using the concept of a lookup table: Formatter > Utilities > Lookup Table

https://help.zapier.com/hc/en-us/articles/8496305146765

 

Or you can configure separate Zaps with a Filter step: https://zapier.com/apps/filter/help

 

 

Userlevel 1

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