Explore Plans
Mobile menu Close menu
Google SheetsGoogle Sheets

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