Blog to Socials Repurposer Agent v1.0

By /

This page outlines the workflow of the Blog to Socials Repurposer Agent v1.0. It’s based on a configuration that uses Google Sheets, Bitly, Perplexity AI, OpenAI, Twitter, LinkedIn, Facebook, and Instagram.

Workflow Overview

  1. Filter Google Sheets Rows: Retrieves the first row from a Google Sheet (ID: 1pWYhKc2Z86mR8OUuiERUmn5YuaEKs6uRMhP-GENoZ84, Sheet: Sheet1) where the “Status” (Column C) is “Not Posted”. It includes headers, uses “A1:CZ1” as the table range, and sorts by row number in ascending order.
  2. Update Google Sheets Row: Updates the “Status” (Column C) of the retrieved row in the Google Sheet to “Posted”.
  3. Shorten URL with Bitly: Shortens the “Blog links” URL (Column A from the Google Sheet) using Bitly.
  4. Summarize Article with Perplexity AI: Summarizes the content of the article linked in the “Blog links” URL (Column A), considering any notes provided in the “My notes” column (Column B).
  5. Basic Router: Routes the flow based on the summarization from Perplexity AI to different social media platforms:
    • Twitter:
      • Create Tweet with ChatGPT: Generates a tweet summarizing the article (using OpenAI’s GPT-4o) and including the shortened Bitly link. The tweet is limited to 250 characters and uses a maximum of 2 hashtags.
      • Create a Tweet on Twitter: Posts the generated tweet to Twitter.
    • LinkedIn:
      • Create LinkedIn Post with ChatGPT: Generates a LinkedIn post summarizing the article (using OpenAI’s GPT-4o) and including the shortened Bitly link. Uses up to 2 hashtags.
      • Create Post on LinkedIn: Posts the generated post to LinkedIn.
    • Facebook:
      • Create Facebook Post with ChatGPT: Generates a Facebook post summarizing the article (using OpenAI’s GPT-4o) and including the shortened Bitly link. Uses up to 2 hashtags.
      • Create Post on Facebook Pages: Posts the generated post to a specified Facebook Page (ID: 349279311610622).
    • Instagram:
      • Create Instagram Post with ChatGPT: Generates an Instagram post summarizing the article (using OpenAI’s GPT-4o) and including the shortened Bitly link. Uses up to 2 hashtags.
      • Generate Image with ChatGPT: Generates an photorealistic image about the content of the article (using OpenAI’s Dall-E 3).
      • Create Post Photo on Instagram Business: Posts the generated image and the caption to Instagram (Account ID: 17841465902033856).

Connections

  • Google Sheets: Connected to robonuggets100@gmail.com
  • Bitly: Connected to o_565hm65q4p
  • Perplexity AI: Connected to Perplexity
  • OpenAI: Connected to OpenAI
  • Twitter: Connected to X – PaperBot (kofi77629532156)
  • LinkedIn: Connected to My LinkedIn connection
  • Facebook: Connected to My Facebook connection (Do Vernan)

Scroll to Top