Post to a Google Chat space when a new row is added to a Google Sheet spreadsheet
Start today
Other popular Google Chat workflows and automations
-
1 - Morning message1
- Email a message to a Google Chat space 11
- Post Discord messages to a Google Chat space 3
- Alert Slack When a New Member Joins Your Google Chat Space
- Create a quick summary of tasks after each chat
- Automatically post to a Google Chat space when a new file is added to Dropbox
- Post your new Facebook Lead Ads leads to a Google Chat space
- Post your Twitter/X mentions to a Google Chat space 1
Useful Google Chat and Lennox iComfort integrations
Triggers (If this)
Indoor temperature rises aboveThis Trigger fires every time the indoor temperature rises above a threshold that is specified.- New message in spaceThis trigger fires whenever there is a new message in the specified space.
- Away mode is enteredThis Trigger fires when my thermostat enters Away mode.
- New member in spaceThis trigger fires whenever a new member is added to the specified space.
- Away mode is cancelledThis Trigger fires when Away mode is canceled on my thermostat.
- New space addedThis trigger fires whenever a new space is added to a Google Workspace.
- Indoor Temperature drops belowThis Trigger fires every time the indoor temperature drops below a threshold that is specified.
Queries (With)
- History of when Indoor temperature rose above a thresholdThis query returns a list of when the indoor temperature rose above a threshold that was specified. Note: this query will only return future events after this Applet is created.
- History of when Away mode was enteredThis query returns a list of when my thermostat entered Away mode.
- History of temperature dropsThis query returns a list of instances when the indoor temperature drops below a threshold that was specified. Note: this query will only return future events after this Applet is created.
Actions (Then that)
- Set Fan to ONThis Action will set my thermostat's fan to On indefinitely. Note: does not work when the thermostat is in Away mode.
- Post to a spaceThis action will post a message to the space you choose in Google Chat.
- Set Fan to AUTOThis Action will set my thermostat's fan to AUTO indefinitely. Note: does not work when the thermostat is in Away mode.
- Add member to a spaceThis action will add a member to a space using their email address. Note: This action will only work if you have the permissions to modify the space members and settings. Also, the member should be a Google Workspace member.
- Set Fan to CIRCULATEThis Action will set my thermostat's fan to CIRCULATE indefinitely. Note: does not work when the thermostat is in Away mode.
- Create a private spaceThis action will create a private space in Google Chat.
- Turn the thermostat offThis Action will set the Thermostat to Off.
- Update space descriptionThis action will update the description of the space you select.
- Set home to AwayThis Action will set all Thermostats in a home to Away.
- Update space guidelinesThis action will update the guidelines of the space you select.
- Cancel AwayThis Action will cancel Away on Thermostats in a home.
- Increase Indoor TemperatureThis Action will attempt to increase the indoor temperature of an thermostat by the number of degrees specified.
- Decrease Indoor TemperatureThis Action will attempt to decrease the indoor temperature of an thermostat by the number of degrees specified.
IFTTT helps all your apps and devices work better together