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