# Detailed assistance for setting up an automated workflow with Make, Google Sheets, Content.ai, and WordPress **URL:** \ **Category:** Questions\ **Tags:** wordpress, http, google-sheets, api, ai, connections\ **Created:** [April 26, 2024, 11:47am UTC](https://community.make.com/t/detailed-assistance-for-setting-up-an-automated-workflow-with-make-google-sheets-content-ai-and-wordpress/35212 "2024-04-26T11:47:54Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![gaetanseo](https://avatars.discourse-cdn.com/v4/letter/g/50afbb/32.png) [@gaetanseo](https://community.make.com/u/gaetanseo)\ **Post date:** [April 26, 2024, 11:47am UTC](https://community.make.com/t/detailed-assistance-for-setting-up-an-automated-workflow-with-make-google-sheets-content-ai-and-wordpress/35212/1 "2024-04-26T11:47:54Z")
Hello everyone, I am currently working on an ambitious project to automate the creation and publication of blog articles on WordPress using Make, Content.ai, and WordPress. However, I am facing some difficulties in properly configuring my workflow, and I would greatly appreciate your help in guiding me in the right direction. Here is a detailed overview of the process I want to implement: 1. Google Sheets Module (Make): I want to set up a scenario in Make to retrieve article titles from a Google Sheets file. This scenario should run automatically at regular intervals, for example, every 2-3 minutes. It is essential that the scenario progressively moves through the Google Sheets file to retrieve a new title with each execution in Make. 1. Content Module (Content.ai): Here is the link to the Content.ai API documentation: Docs API - Contents.ai After retrieving the article titles, I want Make to use them as input to generate content using the Content.ai API. It is crucial that the Content.ai module retrieves the article titles from Google Sheets and generates a complete blog article from each title. Additionally, I want the Content.ai module to take the article titles in order after each execution of the first Make scenario, without always taking the first title. WordPress Module (Make): Once the blog articles are generated, I want Make to automatically detect their availability. Then, I want Make to use the detected articles to automatically publish them on WordPress. It is imperative that every blog article created in Content.ai is automatically detected and published on WordPress via the Make automation process. If anyone has expertise in using Make, Content.ai, and WordPress and can guide me step by step in configuring these modules, it would be extremely valuable to me. Thank you in advance for your help! ---
**Author:** ![Michaela-Inactive](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/michaela-inactive/32/29_2.png) [@Michaela-Inactive](https://community.make.com/u/Michaela-Inactive)\ **Post date:** [April 26, 2024, 11:57am UTC](https://community.make.com/t/detailed-assistance-for-setting-up-an-automated-workflow-with-make-google-sheets-content-ai-and-wordpress/35212/2 "2024-04-26T11:57:22Z")
Hello @gaetanseo welcome to the community πŸ‘‹ I just wanted to let you know that I translated your question to English since that’s the official language of the community. By keeping the content in one language, we give everybody the chance to step in and help you. > πŸ‡ΊπŸ‡Έ **Translation** > > Hello everyone, > > I am currently working on an ambitious project to automate the creation and publication of blog articles on WordPress using Make, Content.ai, and WordPress. However, I am facing some difficulties in properly configuring my workflow, and I would greatly appreciate your help in guiding me in the right direction. > > Here is a detailed overview of the process I want to implement: > > **1. Google Sheets Module (Make):** > > - I want to set up a scenario in Make to retrieve article titles from a Google Sheets file. > > - This scenario should run automatically at regular intervals, for example, every 2-3 minutes. > > - It is essential that the scenario progressively moves through the Google Sheets file to retrieve a new title with each execution in Make. > > **2. Content Module (Content.ai)**: Here is the link to the Content.ai API documentation: [Docs API - Contents.ai](https://www.contents.ai/docs-api/) > > - After retrieving the article titles, I want Make to use them as input to generate content using the Content.ai API. > > - It is crucial that the Content.ai module retrieves the article titles from Google Sheets and generates a complete blog article from each title. > > - Additionally, I want the Content.ai module to take the article titles in order after each execution of the first Make scenario, without always taking the first title. > > **WordPress Module (Make):** > > - Once the blog articles are generated, I want Make to automatically detect their availability. > > - Then, I want Make to use the detected articles to automatically publish them on WordPress. > > - It is imperative that every blog article created in Content.ai is automatically detected and published on WordPress via the Make automation process. > > If anyone has expertise in using Make, Content.ai, and WordPress and can guide me step by step in configuring these modules, it would be extremely valuable to me. Thank you in advance for your help! ---
**Author:** ![gaetanseo](https://avatars.discourse-cdn.com/v4/letter/g/50afbb/32.png) [@gaetanseo](https://community.make.com/u/gaetanseo)\ **Post date:** [April 26, 2024, 12:48pm UTC](https://community.make.com/t/detailed-assistance-for-setting-up-an-automated-workflow-with-make-google-sheets-content-ai-and-wordpress/35212/3 "2024-04-26T12:48:01Z")
Ok no problem, thanks you ! ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 27, 2024, 1:26am UTC](https://community.make.com/t/detailed-assistance-for-setting-up-an-automated-workflow-with-make-google-sheets-content-ai-and-wordpress/35212/4 "2024-06-27T01:26:53Z")
Welcome to the Make community! I would suggest completing the **Make Academy** before jumping into building a complete scenario. If you need **specific assistance** when you are **building a scenario** it’s easier to help you then. Otherwise, you can also **hire a professional** by posting in the #solution-exchange:professional-services category. Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too β€” ### General - [Help Center](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) - [Make Academy](https://academy.make.com) – learn Make and get your certificate - [Discord Server](https://samliew.com/make-discord-invite) – join us in a community-run live chat ### Help Center Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - [Tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [Tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [September 25, 2024, 1:36am UTC](https://community.make.com/t/detailed-assistance-for-setting-up-an-automated-workflow-with-make-google-sheets-content-ai-and-wordpress/35212/5 "2024-09-25T01:36:20Z")