Shipping quotes delivered right in the customer chat

The scenario runs the мессенджер chat, gathers parcel details, checks the contact in Affinity, computes multi-carrier rates and sends the best to the customer, logging everything to Microsoft SQL.

  • The customer gets a quote in seconds, in the same chat
  • Several carriers are compared at once
  • Your markup is added automatically
  • Every quote is saved to the sheet
Redis Chat MemoryWhatsApp Business CloudShipengine
Set it up for yourselfScriptera

How it works

To move data from Affinity to Microsoft SQL automatically, use a ready-made scenario — no manual exports.

  1. Starts when: When WhatsApp Message Received
  2. Check: Check Message Content
  3. If yes: Fetch HighLevel Contacts
  4. Check: If Not Do Not Disturb
  5. If yes: Lead Processing Agent
  6. Check: If Data Collected
  7. If yes: Set Commission Rate
  8. Then: Fetch Shipping Rates
  9. Then: Process and Rank Shipping Quotes
  10. Then: Append or update row in sheet
  11. Then: Send Shipping Quote Message
  12. If no: Send WhatsApp Message
  13. Then: Redis Chat Memory
  14. Then: Google Gemini Model
  15. Then: Offload Lead
  16. Then: Create Contact
  17. Then: Parse Structured Output

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

Similar scenarios