Hi, I have a scenario which uses watch events trigger of stripe and when the there is payment made, then it updates google sheet to status ‘paid’.
But now, i want to make sure that the payment amount in google sheet (eg: 21.50) matches the stripe payment, then only the status gets changed to paid.
My problem is, I am unable to map the payment with decimals from stripe trigger. At present 21.50 comes as 2150. Could any one help with this issue.
Can you divide what you get from Stripe by 100?
That wouldnt work. Because a person could pay 2.500 or 25.00 or 250.0 which would output in stripe as 2500 (without decimals).
Please provide details about your Scenario and describe exactly how it works.
If you’re searching the Google Sheet for a specific amount, you need to properly convert what’s coming in from Stripe to what’s stored in the Google Sheet.
If you’re querying multiple rows from Google Sheets then filtering on the amounts, then there’s a different way to handle this.
When a invoice is send through jotform, the person name, email ID, invoice amount and payment status comes into the google sheet. Like wise I have almost 120 rows of invoices sent to different customers.
In some cases, person with same email ID might have been sent 2 invoices at different points of time in this single sheet.
Eg in this image:
Now, I have another automation setup in stripe to watch events - Payment intent trigger.
Due to this email duplication, I want only the invoice amount that is matching to the payment to be updated as paid and confirmed. Otherwise, automation will update both amounts as paid because it just reads the email ID to lookup.
Inorder to achieve this, I need the output from stripe trigger to be in decimals matching so that I can put the condition that if email Id and amount matches stripe payment output, then change status to paid. But please see the amount coming in without decimals, which dont allow me to action this:
Have you tried using Amount/100 in your Google Sheets search?
