My scenario is supposed to pull data from Notion (Watch Database Items module) and use that data to generate one reimbursement report (Google Docs Create Document from Template module) for each person who submitted a reimbursement request.
Relevant Data
The data that are relevant in the Notion database are:
- Driver name (this is a relation property, and if you look in the scenario blueprint, you’ll see that I have this set up properly)
- Driver email
- Route description
- Date of the mileage expense
- Total miles for the trip
- Reimbursement amount for the trip
- Reason for the trip (event title)
My Goal
I want to group all of items 3-7 by item 1/2, sort items 3-7 by date (item 4), and display in the google doc:
- The driver name
- The driver email
- The current date
- The sum of all of the miles on the report
- The sum of all of the reimbursement on the report
- A formatted list of all of the routes, the dates, the miles driven, and the event
For example:
Driver: Jane Carman, jac@test.mail
Report date: October 6, 2025.
Total miles driven: 40
Total reimbursement: $28
Description:
- 2025-10-02, Meeting: Office to Partner (9 miles)
- 2025-10-03, Outreach: Office to LibraryOne (8 miles)
- 2025-10-05, Outreach: Office to LibraryTwo (23 miles)
Where I Am
I had everything working perfectly EXCEPT for the total miles and total reimbursement summary at the top of each report. This was using a text aggregator set up as follows:
Mileage reimbursement.blueprint.json (289.4 KB)
The problem here, of course, is that the reimbursement amount gets lost when the text aggregator runs.
What Else I Tried
I tried to address this problem by changing the set-up of the text aggregator module so that instead of creating the exact string I was looking for, I created a string that had more information and had a unique separator (date + route + miles + reimbursement), then after the iterator, used a Set Variables module to turn that string back into an array using a split() function. Then I set new variables by mapping the elements of the array in order, and used a sum() function to get the total miles and total reimbursement.
At least, that’s what I thought I was doing.
The set variables module for mapping the elements of the array looks like this, which concerns me because the white background generally means you’re referring back to something that is no longer there, so did I set that up wrong?
And then the output is totally wonky in a few ways, I think all related to this one problem: the fourth variable is pulling in the date for the second DB item, so instead of the variable routeReimburse being a number, it is a string, so the sum() function doesn’t work AND the data from the second DB item disappears from the report. (When I’m done testing, the limit for the Watch New Rows module will be higher than 2, but for now, 2 has been adequate for testing.)
The blueprint with these changes is:
Mileage reimbursement (copy for figuring out totals ).blueprint.json (292.7 KB)
Any help you can give will be very gratefully accepted.