What is IFTTT?
Explore Plans Developers
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.

About 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