Published On Sep 22, 2024
Blueprint to this will be avalible soon.
Initial Data Retrieval:
Fetches a row from a Google Sheet containing article URLs and metadata.
The row must have "Pending" status and be in the "TLDR Marketing" category.
Web Scraping:
Sends an HTTP GET request to fetch the content of the article URL.
Converts the HTML content to plain text.
Content Validation:
Uses Anthropic's Claude AI to determine if the scraped content is suitable for rewriting.
If approved, the flow continues; if not, it's marked as an error in the Google Sheet.
Content Rewriting:
If approved, Claude AI rewrites the article in Swedish, optimized for SEO.
The rewritten content is formatted in HTML for WordPress.
Metadata Generation:
Another Claude AI call generates a title, meta description, Midjourney prompt, and LinkedIn post based on the rewritten content.
Image Generation:
Uses the Stability AI API to generate an image based on the Midjourney prompt.
Converts the image format and optimizes its quality using CloudConvert.
WordPress Publishing:
Uploads the generated image to WordPress as a media item.
Creates a new WordPress post with the rewritten content, generated title, and featured image.
LinkedIn Posting:
Creates a LinkedIn post with the generated content and image.
Update Google Sheet:
Updates the original row in the Google Sheet with the new status, URLs, and metadata.
Error Handling:
If the initial content validation fails, it attempts to use ScrapingBee API for JavaScript-rendered pages.
If still unsuccessful, it marks the row as an error in the Google Sheet.
Softwares used in video:
Make.com (formerly Integromat): https://www.make.com
TLDR Newsletter: https://tldr.tech/
Anthropic Claude AI: https://www.anthropic.com
Google Sheets: https://www.google.com/sheets/about/
Stability AI: https://stability.ai/
ScrapingBee: https://www.scrapingbee.com/
WordPress: https://wordpress.org/
#Automation #ContentCreation #MakeDotCom #SEO #NewsletterScraping #AIWriting #WordPressAutomation #LinkedInAutomation #WebScraping #DigitalMarketing
Check out our AI-automation lab -- https://www.alicelabs.ai/
Reach out to me on linked in-- / eric-lundberg-3530451bb
Get the blueprints here, if it gave you value, leave a like. (you don't have to, but it helps:)
: https://drive.google.com/drive/folder...