Creating Purchase Orders in Buildertrend from Google Sheets Data

I work as a Project Manager in residential Construction and I'm trying to create a workflow that would create a group of Purchase orders inside Buildertrend once we are ready to start a new project. The list of Purchase Orders would be created for each sub contractor we plan to use on the project and that information would be pulled from Google Sheets, content that is stored in Google Drive, and then populated in Buildertrend. I'm starting to get confused and wondering if this can be accomplished at this time, does anyone have any ideas how I can gain clarity on this issue? Am I thinking about this wrong or making it more difficult that it really is?