Explore Plans
Mobile menu Close menu
Google SheetsGoogle Sheets

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.

Developer info

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