Client visit reminders — from your calendar to the whole team

The scenario watches your calendar, spots client visits and warns everyone involved in advance — with a direct message and a company-wide notice on the day.

  • The team hears about the visit a day ahead, not five minutes before
  • Every attendee gets a personal reminder
  • A morning announcement means the room and the welcome are ready
  • A send log means nobody gets the same reminder twice
Google Sheets
Set it upScriptera

How it works

To get MISP notifications in Quick Base, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Step 1: Activation schedule: Every 1 hour, from 6 AM to 6 PM.
  2. Then: Step 2: Set Variables
  3. Then: Step 3: Get datetime
  4. Then: Step 4: Get the event information from Google Calendar for tomorrow.
  5. Check: Step 5: Check if there is a record or not?
  6. If yes: Step 6: Filter out events whose titles match the action of a customer visiting the company.
  7. Check: Step 7: Check if there is a record or not?
  8. If yes: Step 8: Read the Odoo Calendar Event notifications that have been sent.
  9. Then: Step 9: Read Google Sheets member slack
  10. Then: Step 10: Filter out records that have not been sent.
  11. Check: Step 11: Check if there is a record or not?
  12. If no: Step 12: Loop Over Items
  13. Check: Step 14: Loop Over Partners.
  14. Then: Step 17: Return output of step8
  15. Check: Step 18: Loop Over Items
  16. Then: Step 20: Get the event information from Google Calendar for today..
  17. Check: Step 21: Check if there is a record or not?
  18. If yes: Step 22: Filter out events whose titles match the action of a customer visiting the company.
  19. Check: Step 23: Check if there is a record or not?
  20. If yes: Step 24: Read the Odoo Calendar Event notifications that have been sent.
  21. Then: Step 25: Filter out records that have not been sent.
  22. Check: Step 26: Check if there is a record or not?
  23. If no: Step 27: Check if it is currently >= 8 AM?
  24. If yes: Step 28: Convert to text
  25. Then: Step 29: Download file image
  26. Then: Step 30: Convert KB → bytes
  27. Then: Step 31: Call Slack API's getUploadURLExternal API
  28. Check: Step 32: Choose branch 2
  29. Then: Step 33: POST upload_url Slack
  30. Then: Step 34: Call the completeUploadExternal Slack API to complete the file upload.
  31. Then: Step 35: Return output of step 25
  32. Check: Step 36: Loop Over Items
  33. Then: Step 37: Fill in the Calendar Event information in the Google Sheet.
  34. Then: Step 19: Fill in the Calendar Event information in the Google Sheet.
  35. Then: Step 15: Wait 1s
  36. Then: Step 16: Send a message to your Partners
  37. Then: Step 13: Extract the email and member ID of the partners.
  38. If no: Step 38: Get the event information from Google Calendar for today.
  39. Check: Step 39: Check if there is a record or not?
  40. If yes: Step 40: Filter out events whose titles match the action of a customer visiting the company.
  41. Check: Step 41: Check if there is a record or not?
  42. If yes: Step 42: Read the Odoo Calendar Event notifications that have been sent.
  43. Then: Step 43: Filter out records that have not been sent.
  44. Check: Step 44: Check if there is a record or not?
  45. If no: Step 45: Check if it is currently >= 8 AM?
  46. If yes: Step 46: Convert to text
  47. Then: Step 47: Download file image
  48. Then: Step 48: Convert KB → bytes
  49. Then: Step 49: Call Slack API's getUploadURLExternal API
  50. Check: Step 50: Choose branch 2
  51. Then: Step 51: POST upload_url Slack
  52. Then: Step 52: Call the completeUploadExternal Slack API to complete the file upload.
  53. Then: Step 53: Return output of step 43
  54. Check: Step 54: Loop Over Items
  55. Then: Step 55: Fill in the Calendar Event information in the Google Sheet.

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

Similar scenarios