Top Google Sheets automations
Explore Plans
Mobile menu Close menu
Google SheetsGoogle Sheets

History of worksheets in spreadsheet

This query returns a list of when a new worksheet is added to a 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 new worksheet is added to a spreadsheet you specify.
API endpoint slug
google_sheets.history_of_worksheets_in_spreadsheet
Runtime method
performQuery("google_sheets.history_of_worksheets_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
true
Can have default value
true

Filename Text input > Other

Label
and enter the filename
Helper text
E.g. Vegetable Recipes
Slug
filename
Required
true
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
true
Can have default value
true

Ingredients

Created atDate and time event was created.

Slug
created_at
Filter code
GoogleSheets.historyOfWorksheetsInSpreadsheet.CreatedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06.000+05:00

Worksheet URLUrl to the worksheet on Google Sheets.

Slug
worksheet_url
Filter code
GoogleSheets.historyOfWorksheetsInSpreadsheet.WorksheetUrl
Type
Web URL
Example
https://docs.google.com/spreadsheets/d/1QOibtN5msmiOBbLGAAgLixoz_gEdH8JDwxx-wTN0dSU/edit#gid=1003277314

Worksheet nameThe name of the worksheet.

Slug
worksheet_name
Filter code
GoogleSheets.historyOfWorksheetsInSpreadsheet.WorksheetName
Type
String
Example
Summer

PathPath of the spreadsheet

Slug
path
Filter code
GoogleSheets.historyOfWorksheetsInSpreadsheet.Path
Type
String
Example
IFTTT/FoodTracking

Spreadsheet nameThe name of the spreadsheet.

Slug
spreadsheet_name
Filter code
GoogleSheets.historyOfWorksheetsInSpreadsheet.SpreadsheetName
Type
String
Example
Vegetables