Google Sheets + Nerve

Find Rows

Find Rows. Look up rows in a worksheet based on a column value

Format Row(s)

Format Row(s). Apply colour and text styling to one or more rows

Get Row by Number

Get Row by Number. Retrieve one row by its row number

Get Next Rows

Get Next Rows. Read the next batch of rows from a worksheet, continuing where the last run left off

Get All Rows

Get All Rows. Read every row from a worksheet

Read Data Range

Read Data Range. Read cells from a range using A1 notation (e.g. A1:D10). Returns rows and the resolved range

Find Spreadsheet(s)

Find Spreadsheet(s). Find spreadsheet(s) by name

Find Worksheet(s)

Find Worksheet(s). Find worksheets in a spreadsheet by title

Export Worksheet

Export Worksheet. Download a worksheet as a CSV or TSV file

Export Worksheet (CSV/TSV)

Export Worksheet (CSV/TSV). Download a worksheet as a CSV or TSV file

Find Rows

Find Rows. Look up rows in a worksheet based on a column value

Find Worksheets

Find Worksheets. Find a worksheet(s) by title

Add Row

Add Row. Add a new row of data to a specific spreadsheet

Add Row at Top

Add Row at Top. Inserts a new row at the top of a worksheet, just below the header row

Add Multiple Rows

Add Multiple Rows. Add multiple rows of data at once to a specific spreadsheet

Update Row

Update Row. Update the data in an existing row

Update Multiple Rows

Update Multiple Rows. Updates multiple rows in a specific spreadsheet

Delete Row

Delete Row. Delete a specific row from the selected sheet

Delete Multiple Rows

Delete Multiple Rows. Deletes a contiguous range of rows, or a list of specific row numbers. Row numbers are 1-based

Find or Create Row

Find or Create Row. Look up a row by column value; if no match is found, create a new row with the provided values

Create Spreadsheet

Create Spreadsheet. Creates a blank spreadsheet

Create Worksheet

Create Worksheet. Create a new blank worksheet with a title

Find or Create Worksheet

Find or Create Worksheet. Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers

Clear Sheet

Clear Sheet. Clear every row on a worksheet, keeping the worksheet itself