Google SheetsAbout this trigger
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 trigger fires when a new row is added to a spreadsheet you specify.
- API endpoint slug
- google_sheets.new_row_in_spreadsheet
Trigger fields
Path Text input > Other
- Label
- Enter the folder path...
- Helper text
- Format: folders separated by "/" like "Recipes/Vegetables"
- Slug
- path
- Required
- true
- Can have default value
- true
Filename Text input > Other
- Label
- and enter the filename
- Helper text
- E.g. Vegetable Recipes
- Slug
- filename
- Required
- true
- Can have default value
- true
Spreadsheet URL Text input > Other
- Label
- Or copy and paste the spreadsheet URL
- Helper text
- Must be a valid spreadsheet URL
- Slug
- spreadsheet_url
- Required
- true
- Can have default value
- true
Ingredients
FilenameThe name of the spreadsheet.
- Slug
- spreadsheet_name
- Filter code
- GoogleSheets.newRowInSpreadsheet.Filename
- Type
- String
- Example
- 2018 Trip ideas
PathPath of the new spreadsheet.
- Slug
- path
- Filter code
- GoogleSheets.newRowInSpreadsheet.Path
- Type
- String
- Example
- IFTTT/Faves
Spreadsheet URLThe URL to the spreadsheet on Google Sheets.
- Slug
- spreadsheet_url
- Filter code
- GoogleSheets.newRowInSpreadsheet.SpreadsheetUrl
- Type
- Web URL
- Example
- https://docs.google.com/spreadsheets/d/1va_bpHMbOIwbQb77orUzAQVs0ZGsyqHqgeyYXssa6Z0/edit#gid=0
Created atDate and time row was added.
- Slug
- created_at
- Filter code
- GoogleSheets.newRowInSpreadsheet.CreatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00
Row indexThe numerical value of the new row.
- Slug
- row_index
- Filter code
- GoogleSheets.newRowInSpreadsheet.RowIndex
- Type
- String
- Example
- 4
Column aValue in column A
- Slug
- column_a
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnA
- Type
- String
- Example
- 1234
Column bValue in column B
- Slug
- column_b
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnB
- Type
- String
- Example
- $99
Column cValue in column C
- Slug
- column_c
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnC
- Type
- String
- Example
- Towel
Column dValue in column D
- Slug
- column_d
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnD
- Type
- String
- Example
- Blue
Column eValue in column E
- Slug
- column_e
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnE
- Type
- String
- Example
- FREE SHIPPING
Column fValue in column F
- Slug
- column_f
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnF
- Type
- String
- Example
- FREE SHIPPING
Column gValue in column G
- Slug
- column_g
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnG
- Type
- String
- Example
- Delivery Date
Column hValue in column H
- Slug
- column_h
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnH
- Type
- String
- Example
- November 7th, 2017
Column iValue in column I
- Slug
- column_i
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnI
- Type
- String
- Example
- Delivery Address
Column jValue in column J
- Slug
- column_j
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnJ
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column kValue in column K
- Slug
- column_k
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnK
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column lValue in column L
- Slug
- column_l
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnL
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column mValue in column M
- Slug
- column_m
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnM
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column nValue in column N
- Slug
- column_n
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnN
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column oValue in column O
- Slug
- column_o
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnO
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column pValue in column P
- Slug
- column_p
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnP
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column qValue in column Q
- Slug
- column_q
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnQ
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column rValue in column R
- Slug
- column_r
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnR
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column sValue in column S
- Slug
- column_s
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnS
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column tValue in column T
- Slug
- column_t
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnT
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column uValue in column U
- Slug
- column_u
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnU
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column vValue in column V
- Slug
- column_v
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnV
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column wValue in column W
- Slug
- column_w
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnW
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column xValue in column X
- Slug
- column_x
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnX
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column yValue in column Y
- Slug
- column_y
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnY
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117
Column zValue in column Z
- Slug
- column_z
- Filter code
- GoogleSheets.newRowInSpreadsheet.ColumnZ
- Type
- String
- Example
- 923 Market St. San Francisco, CA 94117