Get Last N Table Rows

The Get Last N Table Rows action finds the end of a table and returns up to the requested number of final data rows as header-keyed objects.

Inputs

Input	Type	Required	Description
Third-party account	Google account	Yes	Account with Sheets write access, required to locate the table end.
Spreadsheet ID or URL	String	Yes	Spreadsheet containing the table.
Sheet Name	String	Yes	Sheet tab to read.
Number of Rows	Number	Yes	Maximum rows to return; must be at least `1`.
Header Row Number	Number	No	One-based header position. Defaults to `1`.
Return Formatted Values	Boolean	No	Return display text instead of raw values. Default `false`.

Outputs

Output	Type	Description
Rows	List of row objects	Final table rows keyed by header text.

The header row is excluded. If the table has fewer than N data rows, all available rows are returned.

The action determines the append position using column A. Tables should have consistent data in their first column for reliable end-of-table detection.

Get Spreadsheet DetailsRetrieve a Google Spreadsheet's title, URL, ID, and sheets.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Outputs

​Inputs

​Outputs

Inputs

Outputs