Explore Plans
Mobile menu Close menu
Google SheetsGoogle Sheets

History of spreadsheets added to folder

This 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.

Developer info

API endpoint slug
google_sheets.history_of_spreadsheets_added_to_folder
Runtime method
performQuery("google_sheets.history_of_spreadsheets_added_to_folder")

Query fields

Path Text input > Other

Label
Drive folder path
Helper text
Format: folders separated by "/" like "Recipes/Vegetables." If blank, will look for files added to "My Drive."
Slug
path
Required
true
Can have default value
true

Ingredients

Created atDate and time event was created.

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

Spreadsheet URLThe URL to the spreadsheet on Google Sheets.

Slug
spreadsheet_url
Filter code
GoogleSheets.historyOfSpreadsheetsAddedToFolder.SpreadsheetUrl
Type
Web URL
Example
https://docs.google.com/spreadsheets/d/1cHROp05l1AvtsvKmfKhiyIl09FoxeZR2GGFtzI9fYcc/edit?usp=sharing

FilenameThe name of the spreadsheet.

Slug
name
Filter code
GoogleSheets.historyOfSpreadsheetsAddedToFolder.Filename
Type
String
Example
2018 Trip ideas

PathPath of the new spreadsheet.

Slug
path
Filter code
GoogleSheets.historyOfSpreadsheetsAddedToFolder.Path
Type
String
Example
IFTTT/Faves