How can I automate daily content updates for a puzzle answer site using Airtable?

Hey ​@chris_brown! Thanks for submitting such a great question! Because your question hasn't yet received an answer/solution from the Community, we've created s support case on your behalf with our Airtable Expert Team to get you the quickest response possible. Please check your email for follow-up and your case reference number—and continue to follow this thread as new community members tend to share answers and add knowledgeable responses regularly.

Hi ​@chris_brown, 

I hope you are doing well. I do a lot of work on integrating websites with Airtable, so this caught my eye.

You have a few options here, but since you are already using wordpress for this site you can definitely automate a post from Airtable. The tricky part is that your content is not just straight forward text but it is more complex. What you could do is create HTML with inline CSS that matches your exact post template. You can use this in your Airtable record as a formula and then putting all the different components of your answer into their individual fields, you could place those answers into that big HTML formula. Then you could use Zapier or an API to create a post in your wordpress with the html content you had in the formula in Airtable. I believe you can update some settings in your wordpress blog to allow for rending html you put directly into your post. 

I’m not a big fan of wordpress, so if you would ever would want to completely revamp your website to a more modern react based solution, I can show you some examples of the work I’ve done. Here’s my website, some of the areas here like testimonials, case studies, team members all come from Airtable directly. Feel free to reach out and we can chat more about how to get your answers into your website in a more automated way!