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.

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