Skip to main content
Question

Connected table Pipelines or Zapier integration

  • December 28, 2023
  • 0 replies
  • 204 views

I have a connected table that I want to access the data in either pipelines or Zapier.  The table sources details on the products being purchased.  Ideally I would like to know the easiest way to export the table through a pipeline automation or into Zapier were it could add all the table data into a google template.  In the past I used Workato and created a loop that would hold all the data in a list and then I would source the entire list.  Looking to see if there is an easier solution to the problem.  



------------------------------
Scott Talarico
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • December 28, 2023

    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.  



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement