Explore Plans
Mobile menu Close menu
Google SheetsGoogle Sheets

History of rows added to spreadsheet

This query returns a list of when a new row is added to a spreadsheet you specify.

Developer info

API endpoint slug
google_sheets.recent_rows_in_spreadsheet
Runtime method
performQuery("google_sheets.recent_rows_in_spreadsheet")

Query fields

Path Text input > Other

Label
Enter the folder path...
Helper text
Format: folders separated by "/" like "Recipes/Vegetables"
Slug
path
Required
false
Can have default value
true

Filename Text input > Other

Label
and enter the filename
Helper text
E.g. Vegetable Recipes
Slug
filename
Required
false
Can have default value
true

Spreadsheet URL Text input

Label
Or copy and paste the spreadsheet URL
Helper text
Must be a valid spreadsheet URL
Slug
spreadsheet_url
Required
false
Can have default value
true

Ingredients

FilenameThe name of the spreadsheet.

Slug
spreadsheet_name
Filter code
GoogleSheets.recentRowsInSpreadsheet.Filename
Type
String
Example
2018 Trip ideas

PathPath of the new spreadsheet.

Slug
path
Filter code
GoogleSheets.recentRowsInSpreadsheet.Path
Type
String
Example
IFTTT/Faves

Spreadsheet URLThe URL to the spreadsheet on Google Sheets.

Slug
spreadsheet_url
Filter code
GoogleSheets.recentRowsInSpreadsheet.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.recentRowsInSpreadsheet.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.recentRowsInSpreadsheet.RowIndex
Type
String
Example
4

Column aValue in column A

Slug
column_a
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnA
Type
String
Example
1234

Column bValue in Column B

Slug
column_b
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnB
Type
String
Example
$99

Column cValue in Column C

Slug
column_c
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnC
Type
String
Example
Towel

Column dValue in Column D

Slug
column_d
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnD
Type
String
Example
Blue

Column eValue in Column E

Slug
column_e
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnE
Type
String
Example
FREE SHIPPING

Column fValue in Column F

Slug
column_f
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnF
Type
String
Example
FREE SHIPPING

Column gValue in Column G

Slug
column_g
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnG
Type
String
Example
Delivery Date

Column hValue in Column H

Slug
column_h
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnH
Type
String
Example
November 7th, 2017

Column iValue in Column I

Slug
column_i
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnI
Type
String
Example
Delivery Address

Column jValue in Column J

Slug
column_j
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnJ
Type
String
Example
923 Market St. San Francisco, CA 94117

Column kValue in column K

Slug
column_k
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnK
Type
String
Example
923 Market St. San Francisco, CA 94117

Column lValue in column L

Slug
column_l
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnL
Type
String
Example
923 Market St. San Francisco, CA 94117

Column mValue in column M

Slug
column_m
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnM
Type
String
Example
923 Market St. San Francisco, CA 94117

Column nValue in column N

Slug
column_n
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnN
Type
String
Example
923 Market St. San Francisco, CA 94117

Column oValue in column O

Slug
column_o
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnO
Type
String
Example
923 Market St. San Francisco, CA 94117

Column pValue in column P

Slug
column_p
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnP
Type
String
Example
923 Market St. San Francisco, CA 94117

Column qValue in column Q

Slug
column_q
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnQ
Type
String
Example
923 Market St. San Francisco, CA 94117

Column rValue in column R

Slug
column_r
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnR
Type
String
Example
923 Market St. San Francisco, CA 94117

Column sValue in column S

Slug
column_s
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnS
Type
String
Example
923 Market St. San Francisco, CA 94117

Column tValue in column T

Slug
column_t
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnT
Type
String
Example
923 Market St. San Francisco, CA 94117

Column uValue in column U

Slug
column_u
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnU
Type
String
Example
923 Market St. San Francisco, CA 94117

Column vValue in column V

Slug
column_v
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnV
Type
String
Example
923 Market St. San Francisco, CA 94117

Column wValue in column W

Slug
column_w
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnW
Type
String
Example
923 Market St. San Francisco, CA 94117

Column xValue in column X

Slug
column_x
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnX
Type
String
Example
923 Market St. San Francisco, CA 94117

Column yValue in column Y

Slug
column_y
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnY
Type
String
Example
923 Market St. San Francisco, CA 94117

Column zValue in column Z

Slug
column_z
Filter code
GoogleSheets.recentRowsInSpreadsheet.ColumnZ
Type
String
Example
923 Market St. San Francisco, CA 94117