Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello,

I have been trying to make this work for a couple of days with no luck.

I have three tabs importing information from Wordpress:

Tab 1 ( Users ) - collect user registrations from WP Forms in Wordpress - User ID / Username / Name / Country / Company Name / VAT Number / Address

 

Tab 2 ( Entries) - collects information when there is a new post in Wordpress - User ID / Post Name / Category / Author Name / Post Status

 

Tab 3 ( Payments) - gets payment information through Stripe, when a user subscribes (allowing them to post) 

User ID / Payment Date / Amount / Country / Company Name / VAT Number / Address / Submitted / Reviewed / Published 


The flow is : Register > Payment > Submit entry

Now , it comes the hard part: Cross information between the tabs when there is an update:

  • Whenever there is a new payment in Tab 3 - Search for the same USER ID in Tab 1 (Users) and update fields Company Name, VAT Number and and Address in Tab 3 ( Payments)
  • Whenever there is a new entry in Tab 2 (Entries) it will update that same USER ID row information in Tab 3 ( Payments) and put an X in the Submitted column 
  • Whenever a Post Status is changed in Tab 2 (Entries) to Reviewed , it will update the same USER ID row in Tab 3 (Payments) and put an X in the Reviewed Column 
  • Whenever a Post Status is changed in Tab 2 (Entries) to Published , it will update the same USER ID row in Tab 3 (Payments) and put an X in the Published Column 

I have been trying to do this for days and going crazy with the Zaps , Lookups and Filters. I am new with Zapier so I would really really love any help with this.

thank you so much in advance.


 

Hi @loop2022 

Please post screenshots with how your Zap steps are configured, thanks.

 

General concept is to find then update a row in the GSheet.

 

Terms & Conditions