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.

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 spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
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