LOW / CODEBlueprints
finance

Expense Report Collection & Tracking

Collect expense submissions through Typeform, log them automatically to Google Sheets, and notify finance managers via Slack when new reports arrive.

Beginner~15 minn8nMake.com 820 downloads 2209 views

Setup Instructions

1. Create a Typeform with fields: Employee Name, Department, Expense Category (dropdown), Amount, Date, Receipt Upload, Description. 2. In your automation platform, add a Typeform trigger node and connect it to your form. 3. Add a Set/Function node to format the data — convert the amount to a number and format the date. 4. Connect a Google Sheets node to a spreadsheet named "Expense Reports" with columns: Timestamp, Employee, Department, Category, Amount, Description, Receipt URL, Status. 5. Add a Slack node that posts to your #finance channel with the employee name, amount, and category. 6. Set the Status column default to "Pending Review" so finance knows which reports need attention. 7. Test by submitting a dummy expense through your Typeform and verify the sheet row and Slack message appear.
Troubleshooting
**Typeform webhook not firing:** Ensure the Typeform is published (not in draft). Check the Typeform Connect tab to verify the webhook URL is registered. **Receipt file URLs not captured:** Typeform file upload fields return a temporary URL. Download and re-upload to Google Drive within the workflow if you need permanent storage. **Slack message formatting broken:** Use Slack Block Kit format for rich messages. Plain text messages may not render amounts or links correctly.

Need a custom version?

We can build a tailored automation workflow for your specific needs.

New blueprints weekly

Get notified when we publish new automation workflows.