Realtime database update from 3rd party apps (notion, airtable, sheet, etc)
Can I achieve Realtime database update from spreadsheet?
My requirements:
I have many posts with custom fields that have certain values. I have all these values stored on a spreadsheet (GoogleSheets, Airtable, Notion - you name it!). lets say a value is changed on the spreadsheet and this value was used in 20 different posts. Is there a way that I can automate this task and update it in realtime somehow without having to manually edit every post? is this possible in WordPress?
Example
product A has custom field
with value
of Red. This was used on 20 different posts. The value came from a sheet and now it is changed to Blue.
Now I want to update Product A and wherever the value
was used to be Red will be changed to Blue automatically since it is linked with my Spreadsheet.
I would really like to hear your suggestions.
Topic automation automatic-updates bulk-import database Wordpress
Category Web