Blog Writing Automation Agentic AI

​

🎥 Video walkthrough

​

Step-by-step guide

​

1. Configure Google Sheets

• Trigger: New Row
• Connection: google-sheets
• Spreadsheet: Select the sheet where you add content ideas.
• Include Team Drive Sheets: Choose whether to include Team Drives.
• Sheet: Select the specific sheet to monitor.
• Max Rows to Poll: Set to 10 (maximum) to avoid errors. Additional rows are processed in later runs.

​

2. Integrate OpenAI

• Action: Ask ChatGPT
• Connection: openai
• Model: gpt-3.5-turbo or similar

• Generate a title: “Write a blog title about this idea: ‘[Idea]’ and ensure it complies with these guidelines: ‘[Guidelines]’.”
• Generate a blog post: “Write a blog post about this idea: ‘[Idea]’ and ensure it complies with these guidelines: ‘[Guidelines]’.”
• Settings: Temperature: 0.9, Max Tokens: 2048, Presence Penalty: 0.6

​

3. Set up WordPress

• Action: Create Page
• Connection: Connect to your WordPress site.
• Title: Use the title generated by ChatGPT.
• Content: Use the blog content generated by ChatGPT.
• Status: Draft (recommended for review before publishing)
• Additional options: Add slug, excerpt, comments, or publish date as needed.

​

4. Send Gmail notifications

• Action: Send Email
• Connection: Gmail account
• Recipient: Content team’s email (e.g., blog@example.com)
• Subject: “Blog Post Ready for Review”
• Body: Notify the team about the draft post and provide review instructions.

​

Workflow summary

1. Trigger: Google Sheets monitors new rows for content ideas.
2. Generate content: OpenAI creates blog titles and posts.
3. Publish draft: WordPress creates a draft page with the generated content.
4. Notify team: Gmail sends a notification to the content team for review.