How to format transactions from Wise API to Google Sheets using Zapier

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:

• Action: Looping - Create Loop from Line Items
  • Map the line item data into the Looping step
  • Help: https://zapier.com/apps/looping/integrations#help
• Action: Filter
  • Map the data from the Looping step
  • Help: https://zapier.com/apps/filter/integrations#help
• Action: GSheet - Add Row
  • Map the data from the Looping step