Expensify + Google Sheets

Create Spreadsheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Clear Spreadsheet Row

Permanently deletes all data in a selected row. This action cannot be undone.

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

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match 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

Creates a new worksheet in a Google Sheet.

Format Spreadsheet Row

Format a row in a specific spreadsheet.

Lookup Spreadsheet Rows (Advanced)

Find up to 500 rows based on a column and value as line items.

Get Many Spreadsheet Rows (Advanced)

Return up to 500 rows as a single JSON value or as 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.