Quickbooks Profit and Loss to Google Sheets

How To
,
1

Hello,
I am trying to create transfer company Profit and Loss reports from QuickBooks to Google sheets. I can see from the output bundle that the data collected is correct (via and API call), but I can’t figure out how to map it to Google sheets. Any help on this would be great! Thanks!

3

Hey @Babs

Welcome to make community

This video will help you to map value in Google sheet

1 Like
4

Thanks @Abhishek. Yes I have used Google sheets successfully in Make for many other scenarios. My question is specifically to how the Profit and Loss data comes in from Quickbooks, which is less straightforward. If you have a template for this type of report that would be really useful.

5

The issue is that there are several data rows and columns (as its a report), not just 1 data row at a time