Back

New spreadsheet added to folder

This trigger fires 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.new_spreadsheet

Trigger fields

Path Text input > Other

Label: Drive folder path
Helper text: Use '/' to separate folders, e.g., 'Documents/Photos/Receipts'. Detailed guide <a href="https://ift.tt/drivefolderpath" target="_blank">here</a>
Slug: path
Required: true
Can have default value: true

Ingredients

Spreadsheet url The URL to the spreadsheet on Google Sheets.

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

Created at Date and time event was created.

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

Filename The name of the spreadsheet.

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

Path Path of the new spreadsheet.

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