New row added to spreadsheet

This trigger fires when a new row is added to a spreadsheet you specify.

Developer info

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