Send customer visit notifications from Google Calendar to Slack and Sheets

Bby bhsoft· via n8n.io

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