Platform Sync(Google Sheets, Airtable) with WordPress Custom Post Types
We would like to request the development of a new feature for our platform(Google Sheets, Airtable) that allows seamless synchronization with WordPress custom post types. The goal is to facilitate efficient content management across our main platform and our WordPress site by enabling the following actions:
Update: When changes are made to an entity on our platform, the corresponding custom post type in WordPress should be updated automatically. This includes text changes, category adjustments, and any metadata associated with the post.
Add: Whenever a new entity is created on our platform, a new custom post type entry should be added to WordPress with all the relevant details. This should trigger the correct taxonomies, metadata, and any associated fields without manual intervention.
Delete: If an entity is deleted from our platform, the corresponding WordPress custom post type should also be deleted to ensure consistency across our content ecosystem.
Key Features:
Two-way real-time sync between the platform and WordPress custom post types.
Support for all native WordPress custom fields and taxonomies.
Compatibility with popular WordPress custom post type plugins.
An intuitive mapping interface to link platform entities with WordPress custom post types.
Conflict resolution settings to manage data discrepancies between the two systems.
Robust error handling and logging for troubleshooting sync issues.
Secure data transfer to maintain privacy and integrity of the content.
I think this is very important too. I would like to automate updates on my directory website, among others. they all use custom fields, but not acf. They are toolset types custom fields. +1
I need support for custom post types and custom fields in Wordpress.
Most Wordpress users use plugins such as ACF and METABOX to implement custom post types and fields.
We would also like to see support for triggers such as update and delete as well as new post.
By managing Wordpress posts and custom post types in Google Sheets, it is no longer necessary to log into Wordpress and even those who are not good at PC operation can manage their tokyo in a familiar UI.
I don’t see much of an issue with connecting the core WP components, (e.g., Featured image, Content, Author). However, the bigger lift would be for custom taxonomies and custom fields. This would need a way to point to the custom taxonomies and a way to map the custom fields.
Another issue can be with relational records. Especially when they reside in a separate table.
Sorry I haven’t made a video yet, but you need make sure that ACF allows the REST api you can modify this within the ACF settings. Also make sure you assign the field to a a post or page just whatever you need. But here below is an example you can use for a Custom API for wordpress.
I’ve been trying to set up the custom api call to GET and POST. I can do the title and content in the query parameters, but can’t seem to get the acf fields. I tried different syntax here, but i’m afraid I’m missing something. any clues?
OK so put this all in the body area. Can we pass dynamic values in there? when I click the dynamic switcher, it changes to a single field for values. Thanks for your help!
You can pass previous steps values in JSON without dynamic switcher (see image). Create JSON body and it will open Data to Insert Panel for data mapping.
thank you, that helped! I am afraid my syntax formatting is still off. I am trying to post (into a custom WP post type) the contents of a spreadsheet. I can get the title and content to go thru fine from sheets to WP, but the ACF fields show empty when the format is correct and the ACF fields show while format is incorrect (where i change the content above). Thanks for the help.
Unless anyone has suggestions on improving this, i do have acf fields working