Change Upodi charges from newly updated amounts in Corpay One and Google Sheets rows
Using Google Sheets, you can quickly skip many steps and avoid having identifying values directly in the feeding system. With this template, when an expense is updated in Corpay One, the usage is immediately updated to the subscription charge in Upodi, so the usage will be billed on next billing run.
Using Google Sheets, you can quickly skip many steps and avoid having identifying values directly in the feeding system. With this template, when an expense is updated in Corpay One, the usage is immediately updated to the subscription charge in Upodi, so the usage will be billed on next billing run.
- When this happens...Amount Updated
Triggers when amount is updated on expense.
- automatically do this...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.
- then do this...Update Spreadsheet Row
Update a row in a specific spreadsheet.
- then do this!Create a Change to a Charge
When the subscription is created all charges will have the default quantities and prices. If you want to change them make sure to update them before you activate the subscription or update them along the way if what the customer purchases changes. If the change incurs an invoice the invoice will be returned here.
- Free forever for core features
- 14 day trial for premium features & apps