Hey everyone! I’m scratching my head over a Zapier setup. I want to sync GoCardless payment info to my Google Sheets, but I’m having trouble matching payments to customers.
The webhook I get from GoCardless looks like this:
{
"events": [{
"id": "EVT123ABC",
"resource_type": "payments",
"action": "confirmed",
"links": {
"payment": "PAY456DEF"
},
"details": {
"origin": "gocardless",
"cause": "payment_confirmed"
}
}]
}
I think I need to use one of these IDs to find the right customer through the API, but I’m not sure how to do this in Zapier. The docs aren’t much help (or maybe I’m just not getting it).
Has anyone cracked this puzzle before? Any tips or tricks would be awesome. Thanks!
hey mate, i’ve dealt with this before. you’re on the right track! in zapier, you’ll wanna use the payment ID (PAY456DEF) from the webhook to fetch customer details via gocardless api. set up a ‘find customer’ action after your trigger, using that payment id. it’ll grab the customer info you need for your sheet. hope this helps!
I’ve implemented a similar setup for a client recently. The key is indeed using the payment ID from the webhook to fetch additional details. In Zapier, you’ll want to add a ‘GoCardless’ action step after your webhook trigger. Choose ‘Find Payment’ and use the payment ID (PAY456DEF in your example) as the lookup value. This will give you access to the customer ID associated with that payment. From there, you can either use another GoCardless action to find the full customer details or, if you only need basic info, you might already have enough to populate your Google Sheet. Remember to test thoroughly, as API responses can sometimes be inconsistent.