About this query
Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.
Developer info
- Description
- This query returns a list of when a particular cell was updated within the spreadsheet you specify.
- API endpoint slug
- google_sheets.history_of_when_cell_was_updated_in_spreadsheet
- Runtime method
- performQuery("google_sheets.history_of_when_cell_was_updated_in_spreadsheet")
Query fields
Path Text input > Other
- Label
- Enter the folder path...
- Helper text
- Format: folders separated by "/" like "Recipes/Vegetables"
- Slug
- path
- Required
- false
- Can have default value
- true
Filename Text input > Other
- Label
- and enter the filename
- Helper text
- E.g. Vegetable Recipes
- Slug
- filename
- Required
- false
- Can have default value
- true
Spreadsheet URL Text input
- Label
- Or copy and paste the spreadsheet URL
- Helper text
- Must be a valid spreadsheet URL
- Slug
- spreadsheet_url
- Required
- false
- Can have default value
- true
Cell Text input > Other
- Label
- Which cell to monitor?
- Helper text
- E.g. "A17" (must be a valid single cell)
- Slug
- cell
- Required
- false
- Can have default value
- true
Ingredients
ValueThe new value of the cell.
- Slug
- value
- Filter code
- GoogleSheets.historyOfWhenCellWasUpdatedInSpreadsheet.Value
- Type
- String
- Example
- Red
PathPath of the Spreadsheet
- Slug
- path
- Filter code
- GoogleSheets.historyOfWhenCellWasUpdatedInSpreadsheet.Path
- Type
- String
- Example
- /IFTTT/FoodTracking
Spreadsheet nameName of the spreadsheet.
- Slug
- spreadsheet_name
- Filter code
- GoogleSheets.historyOfWhenCellWasUpdatedInSpreadsheet.SpreadsheetName
- Type
- String
- Example
- Vegetables
Spreadsheet URLThe URL to the spreadsheet.
- Slug
- spreadsheet_url
- Filter code
- GoogleSheets.historyOfWhenCellWasUpdatedInSpreadsheet.SpreadsheetUrl
- Type
- Web URL
- Example
- https://docs.google.com/spreadsheets/d/1cHROp05l1AvtsvKmfKhiyIl09FoxeZR2GGFtzI9fYcc/edit?usp=sharing
Updated atDate and time event the cell was updated.
- Slug
- updated_at
- Filter code
- GoogleSheets.historyOfWhenCellWasUpdatedInSpreadsheet.UpdatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00