Hey guys, I’m trying to get all the new transactions from my Wise account (banking app) and add them to a google sheet every other day.
There is no native integration between Wise and Zapier so I had to use the Wise API (https://docs.wise.com/api-docs/api-reference/activity) & the webhook by Zapier feature.
Here is how my Zap looks like so far:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/50c3a1a5-a318-490f-a325-6d479896efef.png)
My problem is… when I test the “retrieve poll” step, all the transactions come in as a list that looks like this:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/614a8662-3bdd-4f0b-9c9c-c58346c13e33.png)
Every single text block under “Activities” is a unique transaction that I want to add to my Google Sheet:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a5370d59-4be4-4135-8fce-fa295063aa18.png)
I want to use the parameters highlighted in yellow in step #2 of my Zap - here they are:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/eb60a5d5-5d9c-4221-a229-e9c6c5b275da.png)
Is there any way to do so? (get the yellow fields into the right cells of my Google Sheet)
Would appreciate any help,
Thanks a lot