A client newsletter from one topic — with your approval

Set a topic in your таблица — the scenario writes the issue, saves it to your Keap and emails it to your Gmail for approval, then sends it out to the clients on the list.

  • An issue written from a single topic
  • Comes to you for approval before sending
  • Sent to the clients on the list by itself
  • Marks which issue went to whom
Google Sheets
Set it up for yourselfScriptera

How it works

To move data from Keap to Gmail automatically, use a ready-made scenario — no manual exports.

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

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

Similar scenarios