I'm working on a WP site that lists particular types of events across the US in different regions. I'm gathering the event data from multiple sources and adding it all to a Google Sheet. I've built out the structure of the site using ACF and have Events as a custom content type. I'm trying to wrap my head around how to use automation so that I can continuously add more events to the Google Sheet and have those events get posted to the site automatically, without posting duplicates, and with some data checks to prevent errors. I think this can be done using Zapier, or maybe WP All Import Pro, but having never set up automated workflows with either of those, I don't quite understand how it would work from a high level and how to make it all work.
Can someone who has built something like this (automated content generation) give me an overview of how it would work, which systems need to be in place for it to function, what the top plugins/integrations would be for it, and what all would need to be taken into consideration? This is more of a hobby project for now, but I can see potential for commercial possibilities.
WP All Import. It’s fairly simple to set up and run on a schedule. There is tons of doco for it and their support guys are awesome