History of rows added to spreadsheet

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

About this query

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 query returns a list of when a new row is added to a spreadsheet you specify.
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