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
-
-
Track work hours in a Google Spreadsheet
4.19K
-
-
Log People ringing door bell
1.24K
-
-
How strong is your currency in another country? Log the exchange rate every day
4.4K
-
-
Keep a simple spreadsheet of every Tweet you post
35.9K
-
-
Archive every time you're @mentioned to a Google spreadsheet
1.07K
-
-
Call Log, Missed call
3.87K
-
-
Back up new texts you receive on your Android device to a Google Spreadsheet
13.1K
-
-
Log your Facebook status updates in Google Drive spreadsheet
1.31K
-
Useful Google Sheets and WiZ integrations
Triggers (If this)
-
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.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
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.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
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.
-
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.
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 on / change light mode
This action will turn on the selected light(s). Optionally, a light mode or pre-defined color can be applied, as well as a level of dimming.
-
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 off the light
This action will turn off the selected light(s).
-
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.
-
Pulse the light
This action will make the selected light(s) pulse gently once.
-
Activate a scene
This action will apply the settings of the selected scene to your WiZ lights.
-
Dim / Brighten the light
This action will dim / brighten the selected light(s) by the step of your choice. Ideal for your smart remotes, connected buttons, widgets and much more!
-
Toggle your lights on/off
This action will turn your lights on if they are currently off – and vice versa. An easy way to toggle between on and off statuses!
Turn on / change light mode
This action will turn on the selected light(s). Optionally, a light mode or pre-defined color can be applied, as well as a level of dimming.
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 off the light
This action will turn off the selected light(s).
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.
Pulse the light
This action will make the selected light(s) pulse gently once.
Activate a scene
This action will apply the settings of the selected scene to your WiZ lights.
Dim / Brighten the light
This action will dim / brighten the selected light(s) by the step of your choice. Ideal for your smart remotes, connected buttons, widgets and much more!
Toggle your lights on/off
This action will turn your lights on if they are currently off – and vice versa. An easy way to toggle between on and off statuses!
Google Sheets and WiZ resources
What are Webhooks and How Should I Use Them?
Webhooks serve as the basis to many internet processes we know and love. Click to learn all about how to automate and integrate webhooks to improve your daily routines and business needs.
How to Add and Delete Rows in Google Sheets
Learning how to get started with Google Sheets is quick and easy. Click here to see how IFTTT can help automate your spreadsheet game.
How an IFTTTer automates their Twitch
Twitch is one of the most popular services on IFTTT. Automate your Twitch today!
IFTTT helps all your apps and devices work better together