Expensify + Google Sheets

Create Spreadsheet

Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.

Delete Spreadsheet Row

Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

API Request (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Find Worksheet

Finds a worksheet by title.

Lookup Spreadsheet Row

Finds a row by a column and value. Returns the entire row if one is found.

Find or Create Row

Finds or creates a specific lookup row.

Create Expense Report

Export Report to PDF

Given a Report ID (from a trigger), export that report to a PDF document.

Find Report

Retrieves a specific expense report, using the report's number.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

Format Spreadsheet Row

Format a row in a specific spreadsheet.

Lookup Spreadsheet Rows (output as Line Items)

Finds many matched rows (500 max.) by a column and value.

Get Many Spreadsheet Rows (Advanced, output as Line Items)

Returns many rows (500 max.) as a single JSON value and flat rows (line items).

Find or Create Worksheet

Finds or creates a specific find worksheet.

New Report

Triggered when a new report is created.

Create Single Expense

Creates a single expense item.

API Request (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.