In this blog, we learn how to create a family events reminder app and get a notification by WhatsApp message and Yeelight smart bulb. No single coding is required!
The notification will be triggered in 15 minutes before the due date and time. User shall be getting the WhatsApp message and the smart bulb will be turned on. User need to reply WhatsApp message saying "acknowledge" to turn off the light.
Download Yeelight app for iOS or Android.
Install the light and add it in your app. Make sure you can control the light from the app.
Create an account in IFTTT and setup two applets:
Navigate to Webhooks setting and take note the Maker Key below. We will use this information in the subsequent steps later on.
Create an account in Twilio and configure the WhatsApp sandbox.
Once you have done, take note the Account SID and Authorization Token We will use it when we configure SAP Open Connectors.
There is one more step we need to complete when we configure WAOffLight Zap step later on.
Create a connector to Twilio and set the account SID and authorization token.
On API Docs, configure and test the Post message to send the WhatsApp message.
Check the output from Curl command. We will need the following information to setup Zapier.
Create a form like this.
Test the form and check the response in Google Sheets.
Create three Zaps: Calendar, MyPhone and WAOffLight.
To create an event in Google Calendar from Google Forms entry.
Create:
Trigger: New or Updated Response in Spreadsheet
Watch for new entry from Google Forms.
Action: Create Detailed Event.
Create an event in Google Calendar.
To monitor events in Google Calendar and trigger payloads (sending WhatsApp message & turn on Yeelight smart bulb).
Create:
Trigger: Event Start
Check any events for 15 minutes before the due date & time.
Action: Post (To send WhatsApp message)
Send WhatsApp message.
Action: Get (To turn on Yeelight smart bulb)
Get the Maker Key from step IFTTT Setup and put it in the URL field (Step 3 - Set up Webhooks by Zapier GET).
To monitor incoming WhatsApp message and to turn off the light if the message reply is "acknowledge".
Create:
Trigger: Catch Hook
Wait for new post request from Twilio WhatsApp sandbox to Zapier webhook url.
On Step 3 - Connect Webhooks by Zapier take note the Zapier webhook URL:
Open Twilio console and navigate to Sandbox for WhatsApp, enter this URL information in "When a message comes in" and save it. Any incoming message from WhatsApp will be sent to Zapier webhook.
We only interested on the Body message content.
Filter: Only Continue If...
Only process if the reply is "acknowledge" from the message Body.
Action: Get
Send an event "light_off" to IFTTT.
That's all.
It is very easy to setup and I think is useful to have this platform for your family members. I hope you enjoy to setup and integrate multiple components.
The notification will be triggered in 15 minutes before the due date and time. User shall be getting the WhatsApp message and the smart bulb will be turned on. User need to reply WhatsApp message saying "acknowledge" to turn off the light.
Required Components
- SAP Cloud Platform Open Connectors
- Twilio
- Zapier
- Google Forms
- Google Sheets
- Google Calendars
- IFTTT
- Yeelight Smart LED Bulb
Yeelight Setup
Download Yeelight app for iOS or Android.
Install the light and add it in your app. Make sure you can control the light from the app.
IFTTT Setup
Create an account in IFTTT and setup two applets:
Navigate to Webhooks setting and take note the Maker Key below. We will use this information in the subsequent steps later on.
Twilio Setup
Create an account in Twilio and configure the WhatsApp sandbox.
Once you have done, take note the Account SID and Authorization Token We will use it when we configure SAP Open Connectors.
There is one more step we need to complete when we configure WAOffLight Zap step later on.
SAP Cloud Platform Open Connectors
Create a connector to Twilio and set the account SID and authorization token.
On API Docs, configure and test the Post message to send the WhatsApp message.
Check the output from Curl command. We will need the following information to setup Zapier.
"Authorization: User xxxxxxxxxx, Organization yyyyyyyyyy, Element zzzzzzzzzz"Google Forms
Create a form like this.
Test the form and check the response in Google Sheets.
Zapier Setup
Create three Zaps: Calendar, MyPhone and WAOffLight.
Calendar Zap
To create an event in Google Calendar from Google Forms entry.
Create:
- Trigger New or Updated Response in Spreadsheet
- Action Create Detailed Event.
Trigger: New or Updated Response in Spreadsheet
Watch for new entry from Google Forms.
Action: Create Detailed Event.
Create an event in Google Calendar.
MyPhone Zap
To monitor events in Google Calendar and trigger payloads (sending WhatsApp message & turn on Yeelight smart bulb).
Create:
- Trigger: Event Start
- Action: Post (to send WhatsApp message)
- Action: Get (to turn on the Yeelight)
Trigger: Event Start
Check any events for 15 minutes before the due date & time.
Action: Post (To send WhatsApp message)
Send WhatsApp message.
Action: Get (To turn on Yeelight smart bulb)
Get the Maker Key from step IFTTT Setup and put it in the URL field (Step 3 - Set up Webhooks by Zapier GET).
WAOffLight Zap
To monitor incoming WhatsApp message and to turn off the light if the message reply is "acknowledge".
Create:
- Trigger: Catch Hook
- Filter : Only Continue If...
- Action: Get (to turn off the Yeelight smart bulb)
Trigger: Catch Hook
Wait for new post request from Twilio WhatsApp sandbox to Zapier webhook url.
On Step 3 - Connect Webhooks by Zapier take note the Zapier webhook URL:
https://hooks.zapier.com/hooks/catch/xxxxxx/yyyyyy/Open Twilio console and navigate to Sandbox for WhatsApp, enter this URL information in "When a message comes in" and save it. Any incoming message from WhatsApp will be sent to Zapier webhook.
We only interested on the Body message content.
Filter: Only Continue If...
Only process if the reply is "acknowledge" from the message Body.
Action: Get
Send an event "light_off" to IFTTT.
That's all.
It is very easy to setup and I think is useful to have this platform for your family members. I hope you enjoy to setup and integrate multiple components.
- SAP Managed Tags:
2 Comments
