Personal messages down a contact list — automatically

The scenario takes contacts from таблица, writes each a personal message and sends it carefully via botHelp, marking the status.

  • Each gets their own message, not a template
  • Written from the contact's data
  • Careful sending without abrupt blasts
  • Status marked in таблица
Google Sheets

How it works

To move data from botHelp to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Daily Schedule Trigger (5 PM)
  2. Then: Get Prospects from Sheet
  3. Check: Check if Message Exists
  4. If yes: Batch Process Prospects
  5. Then: Generate Personalized Message with AI
  6. Then: Save Generated Message to Sheet
  7. Then: Fetch Updated Prospect Data
  8. Check: Validate Message Not Empty
  9. If yes: Get LinkedIn Profile Data
  10. Then: Extract Profile URN and Identifiers
  11. Then: Send LinkedIn Message via ConnectSafely
  12. Then: Update Sheet with Send Status
  13. Then: Azure OpenAI GPT-4o-mini

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