Create a Powerful Gemini AI Agent for Content Creation

Hello everyone, welcome back to Pabi. In this video, I'm going to show you how I'm automatically generating the content and the blogs for a social media platform. Now I'm running a business which requires a lot of online presence and I cannot handle that manually.

So that's why I've created this automation workflow using Pably Connect. Now here I'm going to add a title. We are going to test this workflow once whether it is working fine or not.

So here I have added a title the future of AI automation in digital marketing. Then I have added the keyword target audience tone and I'm going to add the word count. As I add this word count, a post should be created on the same title in my WordPress and should be published.

So here I'm going to enter the word count as let's suppose 800 and here as soon as I have added this word count a post or a blog should be published. Let me open my WordPress and refresh this page once. So here it is.

As I have refreshed this page, I can see the future of AI automation in digital marketing. This is the same title. I'm going to click on this view and you will see that it is being published.

So the future of AI automation in digital marketing. The digital marketing landscape is in perpetual state of evolution. But no single force is shaping its future more profoundly than artificial intelligence.

Here is the introduction. Then beyond the basics, hyperpersonalization at scale. This means productive analytics for proactive strategy.

The evolving role of marketer with AI automation. Then I have received these other details also and it has been concluded with a very nice paragraph. You see that this is a very useful blog for the title which I have added here and I could not have been able to post such nice and factual and informative content daily and that's why this automation is very powerful tool for me.

Now if you also want to learn how you can create this automation workflow using public ed then let's start creating this from the scratch. So here in this video I'm going to show you how I'm going to generate content or blogs for my WordPress or any other social media using Google Gemini. And for this I'm simply going to build connection between my WordPress Google sheet spreadsheet and Google Gemini using Pabi connect.

Now this is the landing page of Pabi and you can visit this simply by typing pabyt. com in your browser. After browsing the website, we need to sign into a PABY account.

On the top right corner, you can see two options, sign in and sign up for free. If you are an existing user, click on the sign in. And if you are a new user, click on the sign up for free.

And this will give you 100 tasks free on monthly basis. You can use these 100 tasks and check whether it fits your business or not. And when you feel ready to upgrade, you can use this code shyt to get maximum benefits on your PB yearly and lifetime deal.

Once you pay for this lifetime deal, you get access to all the features that forever. Here as I'm an existing user, I'll click on this sign in. And here all Pabi apps page has appeared which is showing me all the PBY applications.

I'll click on this PB connect access. Now here I will be landed towards the app dashboard of Pab Connect. Now over here you can see all the workflows and all the folders which I have created here.

If you want to create a new folder, simply click on this plus icon and from here you can create a new folder. For now, I want to create a new workflow for which I need to click on this create workflow and I'll select the workflow builder. We have this new beta which is modern, faster and more flexible one.

And then we have this classic which is a stable and a familiar approach. I'll select this new beta and I'm going to name this workflow as create a powerful Gemini AI agent for content creation. And now I'm going to select the folder.

Now these are the folders which have been created. I'm going to select it as AI agent and then click on create. So here workflow created successfully.

As soon as I click on create, this box has appeared in front of me where I have to enter my trigger application. So trigger is basically an event which starts the automation of a workflow. There can be only one trigger step in a workflow but as many as action steps as you want.

Here in this workflow, I want that whenever I receive a new content idea or a title in my Google Sheet spreadsheet, the content should be automatically generated using Google Gemini and it should be automatically published on my WordPress. Which means whenever I'm going to add a new title in my Google sheet spreadsheet, this complete workflow here will get triggered because trigger basically activates or triggers any workflow. Here in my trigger application, I will be taking Google Sheets and following this trigger application.

In my action application, I will be taking Google Gemini and then WordPress. And if you want to add any other of your social media like the Facebook and the LinkedIn, you can do that. So for now, I'm going to click on this add trigger and in my trigger application I'm going to take Google Sheets.

In my trigger event, I'm going to select new or updated spreadsheet row and then click on connect. Now I need to make connection between public connect and Google sheets for which a webbook URL is provided to me and this webbook URL is going to act as a bridge to connect my Google sheets with public connect. I'm going to follow the help desk given below and build this connection.

For that I'm going to open my Google sheet spreadsheet. Now this is the sheet which I have created by the name content blog for WordPress and I have added all these fields here. Title, primary keyword, target, audience tone and word count.

Now here I'm going to fill in these details and send these details to my workflow. But for that I have to build the connection. Now over here I'm going to add the word count here as 1,000 let's suppose or 700 let's suppose 700 words.

So the title is how AI is transforming small business in 2026. The primary keyword is AI for small businesses target audiences startup founders and small business owners. The tone is professional and insightful and the word count is 700 words.

Now I'm going to send these details. For that I have to go towards the extensions, click on this add-ons and then click on this get add-ons. Here Google Workspace Marketplace will appear in front of me where I have to search for Pably Connect webbooks and you will see it will show me installed because I have already installed this.

But if you're doing this for the first time, please make sure that you install this following the same process. And after doing this you refresh your Google sheets. Once you refresh your Google sheets your public web books will start appearing over here.

From here you have to open this initial setup and a box will appear in front of me where I have to enter the webbook URL and the trigger column. So here I'll go back towards my workflow. Copy this webbook URL and paste it over here.

And then I have to enter the trigger column. So the trigger column will be a final data column on which if the data is added the whole of that two data will be sent to the webbook URL. Here my final data entry column is column E which means whenever I'm going to add the data in this particular column the complete row data will be sent to my workflow.

Here I'm going to enter column E and then I'm going to click on the send test. You will see the test data will be sent successfully. And now to make the setup I have to click on the submit also.

You will see setup configured successfully. Here we have successfully added the webbook URL which I was provided in my workflow to this Google sheet spreadsheet. And now whenever there will be new title added to this spreadsheet I will start capturing that response in my workflow.

But before that we have to follow a very important step we have to go towards this extensions click on this public books and then click on the send on event. So this step is going to make sure that whenever you add any future data it is sent to my workflow. Now I open my workflow and check whether I have received these details there or not.

And once again ago I have received the response. The word count which we entered was 700 words. The trigger column was E which we entered professional and insightful is the tone.

Then the title is how AI is transforming small businesses in 2026. Then we have the target audience here as the startup founders and small business owners. Then we have the spreadsheet name.

The name of the spreadsheet is this content blog for WordPress. The primary keyword AI for small businesses. Here as soon as I receive the response, we can say the connection setup is working fine.

And now whenever there will be new title added I will start capturing that response in this workflow. Moving on towards the next step. Whenever I receive a new title I want to generate a content or a blog or various the social media.

So for that I am going to select my AI agent or my action application. Here I'm going to select Google Gemini. You can take according to your choice and preference.

I'm going to select Google Gemini here. And then in my action event I'm going to select generate content and then click on connect. If you have an existing connection go with save.

If you don't have one click on this add new connection. And now to make this connection you have to enter the API key. Following the help desk given below you have to click on the hyperlink and it will take you towards this AI studio page.

Now over here on the left hand side you get this option of get API key. You have to open this and then you have to click on this create API key. You have to name this API key and then you have to select the default project and after this you have to click on this create key.

A new API token will be provided to you which you need to copy and paste that over here. Now I am on the paid account of Google Gemini. So I have already built this connection multiple times.

I'm going to save this old connection or the existing connection. And here connection created successfully. Now I have to enter the text model and the method.

Now in this text I'm going to enter the prompt that I want to generate the content on this topic. the topic which I have received from Google sheet spreadsheet. So first I'm going to enter.

So here I've entered the prompt. You're an expert SEO blog writer. Write a well structured blog using the title, primary keyword, target audience tone and word count.

Include the primary keyword naturally in the introduction headings and conclusion. Use clear H23 headings, short paragraphs and bullet points where helpful. And then end with 100 character meta description.

You can increase or decrease this according to your choice and preference. Now here I'm going to enter these details but I'm not going to enter these details manually. Instead I'm going to map it.

So to map this I have entered the slash. I'm going to click on this Google sheets and then I'm going to enter the title as this. Then I'm going to enter the keyword here.

So the keyword were AI for small business. And then we have the target audience here as this one startup founders and small business owners. Then we have the tone.

So the tone was this professional and insightful. And then we have the word count as 700 words. Now over here mapping is important so that every time you receive a new response it is taken into consideration in this field.

Manually entering the data will make this field static and the information will not change even when you receive the new response. Over here if I manually enter any details this field will become static and every time I receive a new response the result will not change. So as to keep this field dynamic we use this process mapping instead of manually entering the details.

Here after entering all these details I'm going to select my model. So I'm going to select my model according to my choice. You can do this according to your choice preference and requirement.

Then the methods will be generate content. After adding all these details, I'm simply going to click on the save and send test request and wait for the response. So here I have received the response.

In this content part, I have received this response. If I open this, you can see how AI is transforming small businesses into 2026. The last year is 2026.

The year is 2026 and the business landscape looks vastly different than it did just a few years ago. The driving force behind this rapid revolution is artificial intelligence. Here you see that it has provided me the points the new competitive edge.

Then the key areas then the hyperpersonalized customer experience with the conclusion. You can see that we have received a very detailed blog which we can directly posted to our WordPress. So using this Google Gemini we have generated a very detailed blog.

I'm going to cross this action step and in my action application I'm going to select WordPress. In my action event, I'm going to select create a post and then click on connect. If you have an existing connection, go with save.

If you don't have one, click on this add new connection. And now to make this connection, I need to enter these details. Now over here, I'm going to first enter the base URL.

It is written in the help desk that I have to enter the base URL, which is this one. So here it is written that I have to enter the base URL in this format. So I'm going to open my WordPress on the top where I can see this.

I'm going to copy this URL, paste it over here and then I have to keep it till. com. So I'm going to keep it till there and then I'm going to enter the email and the password which means the credentials of my WordPress and after adding all these details I'm simply going to save this.

You will see WordPress will be connected to PAB connect. And here it is connection created successfully. Now WordPress is connected.

Now I have to enter these details. Now over here again I'm going to map the details which I have received from my Google Gemini. So in the post type I'm going to select as post.

In the post title I'm going to map the title which was this Google Sheets title and then I'm going to map the content which I have generated from this Google Gemini. So if I scroll down I get this field of slug excerpt. I'm not going to enter anything.

The status will be published. You can select the status according to your requirement. Then we have this category ID and the tax where I'm not going to any enter anything.

I'm going to toggle on this feature media ID and then remove this ID. Then the format will be standard. The pink status will be open.

The comment status will be open. The sticky this is false. And then I have not received the response for these fields.

So I'm going to skip this. The custom field parent this is meta. I'm going to not change anything.

These values are going to be default values. So we have entered all the required details. We just want to post this the content which we have generated using Gemini.

We want to post it directly to WordPress. So we have mapped that. Now we are simply going to click on save and send test request and let's wait for the response here.

So we have received the response and we have received the ID of this post. This is a positive response. I'm going to open my WordPress on the left hand side where I can see all these options.

So I'm going to go towards the all posts and here it is. We have created this. So I'm going to click on this view.

It is published. And this is my blog. How AI is transforming small businesses in 2026.

And then we have received the rest of the content which we have generated using Gemini. And this is a very detailed content which we have generated and posted to our WordPress. So now to summarize with the Google Sheets as a trigger application where we made connection with public connect, we received the new title on which we want to generate the content.

After that we map that title to Google Gemini and then it generated a content for me and then I simply post that automatically to my WordPress. This is how this automation workflow is going to run. And here we have successfully created automation between Google Sheets, Google Gemini and WordPress using Pably Connect.

I have attached a link of this workflow in the description so that you can check this out and you can stay tuned to our channel for learning more such interesting automation. Before you go, if you plan to upgrade, do not forget to use the code shuyt to get maximum benefits on your PB yearly and lifetime deal. Thanks for watching.

Not only these applications, but you can integrate many more applications with the help of Pab Connect. Now, if you have any doubt, you can reach us at support ratep. com.

If you have any query, you can reach us at forum. paby. com.

And if you have any pricing related issue, you can visit the website given over here.