IFTTT
IFTTT
Explore
Plans
Log in
Get started
Mobile menu
Close menu
Back
Share this using the options below:
Quickly connect Google Sheets to MyQ
Send this automation to anyone using the options below.
Copy
Or copy link
Copy
Share
Connect
Google Sheets
to
MyQ
and unlock powerful automations
Start today
Popular Google Sheets and MyQ workflows and automations
MyQ Close History
MyQ
104
MyQ open history
MyQ
190
Useful Google Sheets and MyQ integrations
Triggers (If this)
Door closed
This trigger fires when a door is closed.
New spreadsheet added to folder
This trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
Door opened
This trigger fires when a door is opened.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Light turned on
This trigger fires when a light is turned on.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Light turned off
This trigger fires when a light is turned off
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Queries (With)
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of Door closed
This query returns a list of times when a door was closed.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of Door openings
This query returns a list of events when a door was opened.
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
History of lights turned on
This query returns a list of instances when a light was turned on.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of spreadsheets added to folder
This query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
Close door
This action will close a garage door.
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Turn off light
This action will turn off a light
Update cell in spreadsheet
This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
Turn on light
This action will turn on a light
IFTTT helps all your apps and devices work better together
Start automating