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