Add new Square payments to a spreadsheet
Start today
Triggers (If this)
Queries (With)
Actions (Then that)
Other popular Google Sheets workflows and automations
-
2.52K
-
-
Create a spreadsheet of new laws, eliminating the need for countless Washington, DC interns
1.06K
-
-
Automatically log work hours in a spreadsheet
1.48K
-
-
Record every time your phone's battery is low in a Google spreadsheet
3.04K
-
-
Automatically add your saved tracks in Spotify to a Google spreadsheet
13.4K
-
-
Back up new texts you receive on your Android device to a Google Spreadsheet
13.1K
-
-
Automatically add a new row to Google Sheets when you receive a new Google Business review
5
-
-
Track your daily Fitbit activity in a Google spreadsheet
26.4K
-
-
Add a new row to Google Sheets for all new files in Dropbox folder
31
-
Useful Google Sheets and Heatzy integrations
Triggers (If this)
-
Device is set to manual mode
This trigger fires when the specified device is set to manual mode
-
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.
-
Activate the child lock
This trigger fires when the specified device child lock is activated
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Deactivate the child lock
This trigger fires when the specified device child lock is deactivated
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Device is set to auto mode
This trigger fires when the specified device is set to auto mode
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Device is turned off
This trigger fires when the specified device is turned off
-
Device is set to eco mode
This trigger fires when the specified device is set to eco mode
-
Device is set to cool mode
This trigger fires when the specified device is set to cool mode
-
Device is turned on
This trigger fires when the specified device is turned on
-
Device is set to heat mode
This trigger fires when the specified device is set to heat mode
Device is set to manual mode
This trigger fires when the specified device is set to manual mode
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.
Activate the child lock
This trigger fires when the specified device child lock is activated
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Deactivate the child lock
This trigger fires when the specified device child lock is deactivated
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Device is set to auto mode
This trigger fires when the specified device is set to auto mode
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Device is turned off
This trigger fires when the specified device is turned off
Device is set to eco mode
This trigger fires when the specified device is set to eco mode
Device is set to cool mode
This trigger fires when the specified device is set to cool mode
Device is turned on
This trigger fires when the specified device is turned on
Device is set to heat mode
This trigger fires when the specified device is set to heat mode
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.
-
Device turn on history
Device turn on history
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
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 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.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Device turn on history
Device turn on history
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
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 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)
-
Turn off
This action will turn off a specific device
-
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.
-
Activate the child lock
This action will lock a specific device
-
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.
-
Set manual mode
This action will set a specific device on manual mode
-
Turn on
This action will turn on a specific device
-
Set heat mode
This action will set a specific device on heat mode
-
Set cool mode
This action will set a specific device on cool mode
-
Deactivate the child lock
This action will unlock a specific device
-
Set eco mode
This action will set a specific device on eco mode
-
Set auto mode
This action will set a specific device on auto mode
Turn off
This action will turn off a specific device
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.
Activate the child lock
This action will lock a specific device
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.
Set manual mode
This action will set a specific device on manual mode
Turn on
This action will turn on a specific device
Set heat mode
This action will set a specific device on heat mode
Set cool mode
This action will set a specific device on cool mode
Deactivate the child lock
This action will unlock a specific device
Set eco mode
This action will set a specific device on eco mode
Set auto mode
This action will set a specific device on auto mode
IFTTT helps all your apps and devices work better together