Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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:
 

 

My problem is… when I test the “retrieve poll” step, all the transactions come in as a list that looks like this:

 

Every single text block under “Activities” is a unique transaction that I want to add to my Google Sheet:
 



I want to use the parameters highlighted in yellow in step #2 of my Zap - here they are:
 



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

Hi ​@Kristoff 

Try using these Zap steps:

  1. Trigger: Schedule - Daily
    1. Help: https://zapier.com/apps/schedule/help
  2. Action: Formatter > Date & Time > Format
    1. Use to get yesterday’s date to use in the API request for filtering the data
  3. Action: Webhooks - GET
    1. Use this for the Wise API request
  4. Actions: GSheets - Add Rows
    1. This supports line items

Hi ​@Kristoff,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Hey ​@Troy Tessalone ​@JammerS
 

The 4 step workflow you recommended helped a ton, thanks a lot - I just added some formatting steps so the data comes in like I want.

Now my only obstacle is filtering the data that gets added to the sheet.

Here is an example of a row I don’t want to be in the sheet:



Since I want to keep track of expenses, I don’t want to add any income to the sheet.

The “Activities Primary Amount” field can be in the following format:

  • <positive>+ 9,999 USD </positive> (this is revenue - I don’t want it in the sheet)
  • <negative>+ 9,999 USD </negative> (this is an expense - I want it in the sheet)
  • 9,999 USD (this is an expense - I want it in the sheet)
     

Is there a way to only import these rows into the google sheet?


Thanks again for your help

​@Kristoff 

Ideally you are able to do the filtering in the API request.

 

OTHERWISE

If you want to filter data, then you will have to add these steps:

Reply


Terms & Conditions