Without knowing exactly what you're doing in Google I can only provide a generic answer, so if you can expand on the Google piece my answer might change.
The difference between Pipelines versus Zapier probably just has to do with which one has the better connector to Google the achieves your end goal. Pipelines has channels for Google Drive, Docs and Sheets but if you need a specific action that Pipelines doesn't support then Zapier will be better. QB is the easy part so its the Google piece that you want to consider more.
As for getting data out of QB - again it depends on the the action you're wanting to perform that will determine the format and actions. Pipelines has has a table feature in the Bucket Channel somewhat like the Workato stored array but its more for looking up / referencing data and generating an output CSV. If you just wanted a CSV output from QB to load to Drive you can also just do an API_GenResultsTable in QB and load that to Drive.
Thanks for the note. Specifically what I'm doing is creating a google doc template. The goal is to merge in the data to the template. I have done this already where I can map in single data fields (Example: Name, company, date, etc) but when there is a connected table the challenge has been getting a storing the data. The hope was not to have to create a loop to get and store the data and then map that to a field in the google doc template. I can look into the API_GenResultsTable since I used this when I used to use exact forms. If you have any other suggests that would be great.
