I have a flow where I need to import a file (csv, pdf, etc) into a Google Drive folder and am having issues with the files actually importing and not sure why it isn't working. The error I receive is always the same no matter how I try to reference the directory path. I believe (based on the error) that it must have something to do with the directory path I have in the import, but at this point I have tried every different syntax I can think of.
Any help is greatly appreciated.
Error on import:
General Import Setup (Note I hard-coded the last folder just to minimize variables, but this will need to flex when the flow runs:
Google Drive Setup:
Try:
Broker Application Program/Broker/Dave Test (NPN TestNPN)
@tylerlamparter - That worked! Thanks so much for the help on this.
That said, what is the solution for the placing the files in the dynamically in the folder structure being created?
Broker Application Program/Broker — These will be constant and will not change
Dave Test (NPN TestNPN)/2024-11-14T094555 – These will need to flex dependent on the broker name and the date the files will be placed in Google Drive.
I already have the API call to create the folders, but its just how do I reference the path in the directory. Do I need to be referencing the folder names instead of the folder id's when writing the directory path?
Yeah reference folder names, not folder ids. Then just use handlebar expressions in the field. Here is an example I have for syncing Zoom office hour recordings to google drive:
Thanks @tylerlamparter. That worked great!
