Google Sheets
Add Google Sheets to your lifestyle analytics with Welltory
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
