Skip to content
FlowHub
FluxonLab
Google Calendar
Files & Cloud Storagefree

Customer Visit Notification

by BHSoftUpdated Aug 2026
RequiresGoogle CalendarGoogle CalendarGoogle SheetsGoogle SheetsGoogle DriveGoogle Drive
Share Post Share
ScStep 1: Activation schedule: Every 1 hour, from 6 AM to 6 PM.Step 1: Activat…Step 4: Get the event information from Google Calendar for tomorrow.Step 4: Get the…SeStep 2: Set VariablesStep 2: Set Var…CoStep 3: Get datetimeStep 3: Get dat…IfStep 5: Check if there is a record or not?Step 5: Check i…FiStep 6: Filter out events whose titles match the action of a customer visiting the company.Step 6: Filter …IfStep 7: Check if there is a record or not?Step 7: Check i…Step 8: Read the Odoo Calendar Event notifications that have been sent.Step 8: Read th…Step 9: Read Google Sheets member slackStep 9: Read Go…CoStep 10: Filter out records that have not been sent.Step 10: Filter…IfStep 11: Check if there is a record or not?Step 11: Check …SIStep 12: Loop Over ItemsStep 12: Loop O…CoStep 13: Extract the email and member ID of the partners.Step 13: Extrac…SIStep 14: Loop Over Partners.Step 14: Loop O…WaStep 15: Wait 1sHRStep 16: Send a message to your PartnersStep 16: Send a…CoStep 17: Return output of step8Step 17: Return…SIStep 18: Loop Over ItemsStep 18: Loop O…Step 19: Fill in the Calendar Event information in the Google Sheet.Step 19: Fill i…Step 20: Get the event information from Google Calendar for today..Step 20: Get th…IfStep 21: Check if there is a record or not?Step 21: Check …FiStep 22: Filter out events whose titles match the action of a customer visiting the company.Step 22: Filter…IfStep 23: Check if there is a record or not?Step 23: Check …Step 24: Read the Odoo Calendar Event notifications that have been sent.Step 24: Read t…CoStep 25: Filter out records that have not been sent.Step 25: Filter…IfStep 26: Check if there is a record or not?Step 26: Check …IfStep 27: Check if it is currently >= 8 AM?Step 27: Check …CoStep 28: Convert to textStep 28: Conver…Step 29: Download file imageStep 29: Downlo…CoStep 30: Convert KB → bytesStep 30: Conver…MeStep 32: Choose branch 2Step 32: Choose…HRStep 33: POST upload_url SlackStep 33: POST u…HRStep 31: Call Slack API's getUploadURLExternal APIStep 31: Call S…HRStep 34: Call the completeUploadExternal Slack API to complete the file upload.Step 34: Call t…CoStep 35: Return output of step 25Step 35: Return…SIStep 36: Loop Over ItemsStep 36: Loop O…Step 37: Fill in the Calendar Event information in the Google Sheet.Step 37: Fill i…Step 38: Get the event information from Google Calendar for today.Step 38: Get th…IfStep 39: Check if there is a record or not?Step 39: Check …FiStep 40: Filter out events whose titles match the action of a customer visiting the company.Step 40: Filter…IfStep 41: Check if there is a record or not?Step 41: Check …Step 42: Read the Odoo Calendar Event notifications that have been sent.Step 42: Read t…CoStep 43: Filter out records that have not been sent.Step 43: Filter…IfStep 44: Check if there is a record or not?Step 44: Check …IfStep 45: Check if it is currently >= 8 AM?Step 45: Check …CoStep 46: Convert to textStep 46: Conver…Step 47: Download file imageStep 47: Downlo…CoStep 48: Convert KB → bytesStep 48: Conver…HRStep 49: Call Slack API's getUploadURLExternal APIStep 49: Call S…MeStep 50: Choose branch 2Step 50: Choose…HRStep 51: POST upload_url SlackStep 51: POST u…HRStep 52: Call the completeUploadExternal Slack API to complete the file upload.Step 52: Call t…CoStep 53: Return output of step 43Step 53: Return…SIStep 54: Loop Over ItemsStep 54: Loop O…Step 55: Fill in the Calendar Event information in the Google Sheet.Step 55: Fill i…
1/5
STEPS · 61
Runs on a schedule

On a schedule, pulls Google Calendar events, filters visits into Google Sheets, then fetches and archives related files to Google Drive.

Tags

cronadvancedGoogle CalendarGoogle SheetsInternal Wikidiscoveredpending-review
Connects
googlecalendarGoogle CalendarsheetsGoogle SheetsgoogledriveGoogle Drive
CategoryFiles & Cloud Storage
Triggercron
Complexityadvanced
Nodes55
AddedJun 27, 2026