Popular Button widget and Google Sheets workflows and automations
- Press a button to track work hours in Google Drive
- Check in to work SCS Button
- Keeping tally on anything
- Quickly keep a tally on anything
- Check out of work SCS Button
Useful Button widget and Google Sheets integrations
Triggers (If this)
- New spreadsheet added to folderThis 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.
- Button pressThis trigger fires every time you press the button.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
Queries (With)
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of spreadsheets added to folderThis 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 spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Add row to spreadsheetThis 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.
- Update cell in spreadsheetThis 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.
Button widget and Google Sheets resources
How to use Google Sheets (A 2024 Guide)
Click to learn how to use Google Sheets in 2024
Automate New Year’s resolutions
Most New Year’s resolutions fail by mid-January, after our first few weeks of trying to create new habits and completing tasks with gusto, we lose steam and life catches up. Strava data has demonstrated that there is a dramatic drop that...
Google Sheets vs Excel: A comprehensive comparison for 2024
Google Sheets vs Excel: A Comprehensive Comparison for 2024
What is Webflow?
Curious about the web's newest no-code website builder? Click to answer your what is Webflow question!
Best automation blogs of 2024
Check out our best and most read blog articles of 2021. A list of Applet collections and some round ups of our most-enabled services.
Automations for students 2024
Save yourself time that is often spent getting organized and managing your schedule by automating elements of the manual tasks you need to do. Out of the hundreds of services available on IFTTT, we integrate with many of the popular...