Automatically create Google Sheets rows for new Google Ads leads
Start today
Other popular Google Sheets workflows and automations
-
- Fleet Arrival Log
5 - bluetooth history442
- Add new leads from Facebook Lead Ads to rows on Google Sheets
42 - Log Tempest data to Google Sheets
355 - Persona entra
1 - Jacob Left Home
20 - Log motion from Ring into Google Drive
1.1k - Automatically log work hours in a spreadsheet 1.9k
Useful Google Sheets and TIS Control Limited 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.
- 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.
History of Switch being turned on or offThis query returns a list of when your TIS support switch was turned on or off- 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)
- Change thermostat mode to coolThis action will change your thermostat to cool
- 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 thermostatThis action will turn on your thermostat
- 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.
- Change thermostat mode to heatThis action will change your thermostat to heat
- Turn off switchThis action will turn off your switch
- Change thermostat mode to autoThis action will change your thermostat to auto
- Turn off floor heaterThis action will turn off your floor heater
- Turn on rgbThis action will turn on your rgb
- Turn off thermostatThis action will turn off your thermostat
- Turn off dimmerThis action will turn off your dimmer
- Turn on floor heaterThis action will turn on your floor heater
- Close relay to curtainThis action will close your TIS relay to curtain
- Set color for rgb lightThis action will set color for selected TIS support rgb light
- Turn on moodThis action will turn on your TIS mood
- Turn off rgbThis action will turn off your rgb
- Turn on fanThis action will turn on your fan
- Turn on switchThis action will turn on your switch
- Set brightness for dimmerThis action will set brightness for selected TIS support dimmer
- Turn off applianceThis action will turn off your appliance
- Open relay to curtainThis action will open your TIS relay to curtain
- Open curtain motorThis action will open your TIS curtain motor
- Close curtain motorThis action will close your TIS curtain motor
- Turn on applianceThis action will turn on your appliance
- Turn off fanThis action will turn off your fan
- Turn on dimmerThis action will turn on your dimmer
IFTTT helps all your apps and devices work better together