Hi everyone!
I’m extracting Quickbooks financial report data with a custom action, but the data is coming out as a JSON and I can’t figure out how to get that into Google Sheets in appropriate columns and rows. I’ve looked through previous posts and haven’t been able to figure out how to make this work. Can someone please suggest a solution for this?
Thank you so much!
Hi
For us to have full context, can you post screenshots of the DATA OUT from the QBO custom action step?
There should be a field for the raw JSON, along with fields for the parsed JSON data.
You are right, I looked below and there does seem to be parsed JSON. Screenshots attached. Is there a way to import all the columns and rows that are in the parsed JSON to the Google Sheet at once?
Each desired data point from QBO needs to be mapped to the desired GSheets column.
How might I do that? I’m trying the ‘Create Multiple Spreadsheet Rows’ zap for Google Sheets, and can’t find a way to isolate a certain cell to populate or populate a whole row. This is what it’s looking like:
The returned data is nested JSON which is more complex to parse.
That usually has to be handled with a custom Code step: https://zapier.com/apps/code/help
ChatGPT can be used to help configure the Code, or consider hiring a Certified Zapier Expert: https://zapier.com/experts
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.