Automate the googlesheet filled for my blog daily plan

I need to populate the below columns in my google sheet automatically for 30 days blog plan. Please kindly help me hoe to achieve it. Thank you.



DateTitleImage PromptCatagorySEO Tags

This is my workflow url.

 

Preeti Paryani

Well-known member
Staff member
Hello @KanimaTraders,

Could you please provide more details about the specific issue you are facing with the workflow setup? From our initial review, it appears to be configured correctly, so additional clarification will help us identify the exact concern.

To assist you more effectively, we may need to access your Pabbly Connect account. If you are comfortable with this, kindly grant us permission by replying with the following statement:

"You have my permission to log into my Pabbly Connect account and edit the workflow, if required. Here is the registered email address associated with it."

We look forward to your response so we can proceed further.
 
You have my permission to log into my Pabbly Connect account and edit the workflow, if required. Here is the registered email address associated with it."
 

Preeti Paryani

Well-known member
Staff member
As of now, the data being returned from ChatGPT is only for a single day. You may need to improve your prompt strategy to ensure it returns data for 30 days in a structured format. This way, you can map it properly with the Google Sheets action to add multiple rows for all 30 days.
 

ifrajohn

Member
If you want to automate your Google Sheet for your daily blog plan, the easiest way is to use Google Apps Script. It can auto-fill your dates, topics, and task statuses without you doing everything manually.

I’ve seen teams like ClickTraces use this approach to streamline content planning, and even a basic script can save a lot of time. You can set a daily trigger that adds a new row or pulls data from your blog tools automatically.
 
Top