Export reports and card transactions to CSV, Excel, PDF, or XML, then receive a public download link that seamlessly feeds the next step in your workflow.
How to Use MCP Nodes
Authentication
To use the node, you will need to generate API credentials.- Create an Expensify account at https://www.expensify.com/
- Go to https://www.expensify.com/tools/integrations/
- A pair of credentials: partnerUserID and partnerUserSecret will be generated and shown on the page.
- Enter the credentials on the personal credentials page
What is Expensify MCP?
Expensify MCP creates an AI-generated node that understands the Expensify API. Provide a focused, single-action prompt, and the AI returns structured data for reports, card transactions, or bulk expense creation, making it easy to integrate Expensify into any Gumloop workflow.What Can It Do for You?
- Export expense reports for a custom date range and receive a downloadable link in your preferred file format
- Reconcile corporate card transactions by exporting transaction files for any period
- Create expenses in bulk with categories, tags, and custom fields to keep ledgers current
- Pass structured outputs directly into Google Sheets, BI tools, or other automations
Available Tools
Tool | What It Does | Example Use |
---|---|---|
Get Reports | Export Expensify reports in CSV, Excel, PDF, or XML and return a public download URL | ”Export reports from start date to end date in file format and return structured data with the public download_url ” |
Get Card Transactions | Export card transactions for reconciliation in multiple formats and return a public download URL | ”Export corporate card transactions for start date to end date in file format and return structured data with the public download_url ” |
Create Expenses | Create expenses in bulk in a user’s account with support for categories, tags, and custom fields | ”Using structured data list expenses list for user email that includes merchant , amount , currency , date , category , tags , and custom fields , create expenses and return structured data confirming creation” |
How to Use
1
Create Your Expensify MCP Node
Go to your node library, search for Expensify, and click “Create a node with AI”
2
Add Your Prompt
Drag the Expensify MCP node to your canvas and add your prompt in the text box.
3
Test Your Node
Run the node to see the results. If it works as expected, you’re all set! If you run into issues, check the troubleshooting tips below.
4
Save and Reuse
Once your Expensify MCP node is working, save it to your library. You can now use this customized node in any workflow.
Example Prompts
Here are some prompts that work well with Expensify MCP: Report Exports:Start with clear variables like
start date
, end date
, and file format
. Focus each prompt on a single action for fast, reliable results.Troubleshooting
If your Expensify MCP node isn’t working as expected, try these best practices:Keep Prompts Simple and Specific
- Good: “Export reports from
start date
toend date
infile format
and return the publicdownload_url
” - Bad: “Export reports, summarize totals by category, update a Google Sheet, and email finance”
While the second prompt might seem convenient, it can lead to timeouts or unexpected behavior. For best results, create separate nodes for exporting, summarizing, and emailing.
Match What Expensify Can Do
- Good: “Create expenses for
user email
fromexpenses list
and return structured data confirming creation” - Bad: “Create expenses and then post journal entries to my accounting system”
Expensify MCP excels at expense reporting and transaction data retrieval. For accounting system updates, connect the output to the relevant node within your workflow like the Call API or Google Sheets Writer nodes.
Break Complex Tasks Into Steps
Attempting everything at once might slow down processing:1
Step 1: Export Reports
Export reports from
start date
to end date
in file format
and return structured data with the public download_url
2
Step 2: Export Card Transactions
Export corporate card transactions from
start date
to end date
in file format
and return structured data with the public download_url
3
Step 3: Create Expenses
Using structured data list
expenses list
for user email
, create expenses with categories, tags, and custom fields and return structured data confirming creationConnect these nodes sequentially in your workflow. The download link from Step 1 can feed into Extract Data or Ask AI, while the expenses list for Step 3 comes from your prior processing step.
Focus on Data Retrieval
Expensify MCP is great at getting information from Expensify. For summaries or insights, link it to other nodes. Example:- Good prompt: “Export corporate card transactions for
start date
toend date
and return the publicdownload_url
” - Bad prompt: “Export card transactions and summarize top merchants by spend”
Use Ask AI for summaries and insights, or Extract Data to parse structured data from files after you download them.
Troubleshooting Node Creation
Empty Outputs
Empty Outputs
If you’re seeing empty outputs in the node creation window (or if you’ve already created the node, hover over it and click “Edit”), use the chat interface to prompt the AI to add debug logs and verify the API response. Specifically mention that you received empty outputs.
Incorrect Results
Incorrect Results
In the node creation window (or if you’ve already created the node, hover over it and click “Edit”), use the chat interface to describe in detail what you expected versus what you received.
Errors
Errors
First click “Fix with Gummie”. If multiple attempts fail, simplify your prompt or contact support.
Iterate Using the Chat
Iterate Using the Chat
MCP node creation often requires a few tweaks. Use the chat interface in the node creation window to refine filters, output fields, or pagination. The AI will adjust the node based on your feedback.
Need More Help?
- Watch What are MCP Nodes video tutorial
- Check out MCP Best Practices in Gumloop University
- Join the Gumloop Community for support
- View the Expensify MCP setup guide for Claude and Cursor
- Contact support at support@gumloop.com