Posts from fresh news — but only the ones you approved by email

The scenario emails you a shortlist of fresh stories, waits for your pick and writes the post in your voice — from examples of your past posts — then publishes it.

  • Only what you approved gets published
  • The post is written from examples of your own past posts
  • The shortlist arrives by email — reply from your phone
  • Every suggestion and decision is kept in a sheet
GmailGoogle SheetsEmbeddings OpenAIQdrant Vector Store
Connect Postgres PGVector Store and run itScriptera

How it works

To connect Postgres PGVector Store and Gmail, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Schedule Trigger
  2. Then: Set Input Data (Topic/Company/Tone)
  3. Then: News API
  4. Then: Split Articles
  5. Then: Send Email with News Articles
  6. Then: Log Email Activity
  7. Starts when: Gmail Trigger
  8. Then: Retrieve the message
  9. Then: Unread
  10. Then: Gmail1
  11. Then: Edit Fields1
  12. Then: ExtractLatestEmail2
  13. Check: Merge
  14. Check: If
  15. If yes: Generate Linkedin Posts
  16. Then: FormatLinkedInPayload
  17. Check: Merge1
  18. Then: Publish LinkedIn Post
  19. Then: confirmation
  20. Then: Capture Email Decision
  21. Then: OpenAI Chat Model
  22. Then: Structured Output Parser
  23. Then: Generate Vector Embeddings
  24. Then: RetrievePostExamples
  25. Then: Set Linkedin Id

You can launch this Postgres PGVector Store + Gmail integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios