I’m completely new to Zapier and I’m wondering if anyone can tell me if Zapier will do what I need it to or am I on the wrong path? I’m completely new to automation so please bare with me :-)
I have an airtable base that has multiple tabs set up in it (sorry if I’m using the wrong terms here...). Two of those tabs store data that we want to send to multiple wordpress websites. We need a new custom post to be created when a new entry is added to airtable, one of the tabs is to create one custom post type - the other tab creates a different custom post type. We also need it to update the posts if there is a change within airtable.
From what I’ve read so far I think Zapier will do the above for me...I’m not so sure about the updating of posts though. The next bit however I really can’t work out. Once the data is transferred to wordpress we need to be able to access the data to then be able to manually create different custom posts on an as needed basis.
The only other way I can explain it is each entry in airtable is a product with attributes, I want a custom post to be created when a new entry is added and I want that post to be updated if there is a change in airtable. I also want to display some of those products in different ways on different pages within the website at my discretion. Each website is unique with these discretionary products.
I’m truely grateful for anyone who can help a beginner get my head around how we can get this to work. :-)
Best answer by andywingraveView original
Welcome and thanks for reaching out! I’m tagging in
@andywingrave to see if he has come across a similar workflow as the one you’ve described above. @andywingrave have you seen something like this in action? Thank you in advance!
Thanks for the tag
@Liz_Roberts! Sorry for the delay in response. I was on staycation. Needed some time away from my laptop.
Sounds good so far... (tabs = "tables")
I think you should be doing this on the one table instead of multiple
You can do this by creating a field with the 'type of post', and another for your specific Wordpress site, and then creating subsequent views of these posts
What you want to do here is add a new field in your table (column in your tab) called "Wordpress reference" and then:
Once the post is created, update that field with the Wordpress post ID
I think you want two tables here:
This way you can link your products to the different websites, and even multiple if necessary
@andywingrave & @Liz_Roberts and I’m also sorry for the late response. I appreciate you breaking down my questions. From your response this will be a far to manual process for what we are after...the manual part is as I see it... creating the wordpress post and then entering the ID into airtable. Think 400+ and growing posts per website and then multiply the number of separate websites starting at around 10 and growing to around 500
I think we are needing a plugin completely built from the ground for us unfortunately.
You can actually automate the updating of the Airtable record using something like this:
Trigger: WordPress — New Post
Action: Airtable — Find Record
Action: Airtable — Update Record
When there’s a new post in WordPress, you would do a search in Airtable to find the appropriate record then you’d update that record with the ID of the post.
You’d need something to look up the post by, but I assume the title would work if you’ve created the post from the Airtable record to begin with.