Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Email Automation

Email Automation

Write and Send a Newsletter from a Topic Sheet

On a schedule or manual run, the workflow takes a topic from Google Sheets, has OpenAI write the newsletter, saves it to Drive and sends it by Gmail.

Import it free Sign in to open it

The steps

  1. When clicking 'Test workflow'
  2. Schedule Trigger
  3. Loop Over Items
  4. Get topic from newsletter sheet
  5. Validate Status as Pending
  6. Create HTML for Newsletter
  7. Prepare Data to create word doc
  8. Upload doc to google drive
  9. Send an email to admin
  10. Update Status as Generated
  11. Validate Status as Approved
  12. Pick records to send email to client
  13. Get Client email address
  14. Send email to client

15 steps in total.

Similar automations

Email AutomationSend an AI-Written Newsletter to Clients with OpenAI and Gmail17 stepsContent Writing & GenerationWrite a News Newsletter with Perplexity and OpenAI Agents31 stepsEmail AutomationDaily AI News Newsletter with Azure OpenAI and Gmail6 stepsEmail AutomationManage a Job Newsletter with Subscribers via Webhooks and OpenAI36 steps