Log my card purchases to a spreadsheet
Start today
Other popular Google Sheets workflows and automations
-
929 - How strong is your currency in another country? Log the exchange rate every day4.4k
- Track work hours in a Google Spreadsheet
4.2k - Add new ClickUp tasks to a Google Sheets spreadsheet 2
- Create a spreadsheet of new laws, eliminating the need for countless Washington, DC interns
1.1k - Create a Google spreadsheet entry every time you charge your Android device 9.1k
- Add new Square payments to a spreadsheet2.5k
- Log People ringing door bell
1.2k - Keep a log of your recently played tracks
1.0k
Useful Google Sheets and HomeSeer 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.
A device is turned onThis Trigger fires when a device attached to your HomeSeer system is turned on.- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- A device is turned offThis Trigger fires when a device attached to your HomeSeer system is turned off.
- 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.
- History of a device is turned onThis query returns a list of when a device attached to your HomeSeer system was turned on.
- 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)
- Run a HomeSeer system eventThis Action will run a HomeSeer system event. HomeSeer events can be programmed to control just about any combination of home automation products installed in your home!
- 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.
- Turn on a deviceThis Action will turn on a device attached to your HomeSeer system. Devices may include light switches, receptacles, plug-in modules and much more!
- 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.
- Turn off a deviceThis Action will turn off a device attached to your HomeSeer system. Devices may include light switches, receptacles, plug-in modules and much more!
- Dim a deviceThis Action will dim a dimmable lighting device attached to your HomeSeer system.
- Lock a door lockThis Action will lock a door lock attached to your HomeSeer system.
- Unlock a door lockThis Action will unlock a door lock attached to your HomeSeer system.
- Change a thermostat's cool set-pointThis Action will change the cool set-point of a thermostat attached to your HomeSeer system.
- Change a thermostat's heat set-pointThis Action will change the heat set-point of a thermostat attached to your HomeSeer system.
- Change a thermostat's operating mode to autoThis Action will change the the operating mode of a thermostat attached to your HomeSeer system to auto.
- Change a thermostat's operating mode to offThis Action will change the the operating mode of a thermostat attached to your HomeSeer system to off.
- Change a thermostat's operating mode to coolThis Action will change the the operating mode of a thermostat attached to your HomeSeer system to cool.
- Change a thermostat's operating mode to heatThis Action will change the the operating mode of a thermostat attached to your HomeSeer system to heat.
- Send a text command to HomeSeerThis action will send a text command to your HomeSeer system.
IFTTT helps all your apps and devices work better together