Expensify + Google Sheets

Add new Expensify reports to a Google Sheets spreadsheet

Make sure your expense reports are available to your whole team, anytime. Use this automation to add new Expensify reports to a Google Sheets spreadsheet. Your expense reporting will get an extra boost of visibility and everyone will stay in the know.

When this happens...
New Report
Triggered when a new report is created.
TriggerScheduled
automatically do this!
Update Spreadsheet Row
Update a row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Report
Triggered when a new report is created.
Trigger
Scheduled
Create Expense Report
Action
Write
Create Single Expense
Creates a single expense item.
Action
Write
Export Report to PDF
Given a Report ID (from a trigger), export that report to a PDF document.
Action
Write
Find Report
Retrieves a specific expense report, using the report's number.
Action
Search

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger
Instant

New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
Scheduled

Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action