We need you to add an action to the existing Google Drive integration:
“Find Folder By Name”
This would be incredibly helpful to access folders created in different automations, as right now it looks like only static folders can be accessed or those created in the current automation, but for use-case I need to copy files to a folder created in a different automation. And this folder is unique to each new row in my Google Sheet.
For posterity, found a workaround (requires a database, tested with Google Sheets):
Create a folder in Google Drive using your dynamic variables, then pass the unique folder ID to a column in Google Sheets (or Airtable, etc.) and use that unique Folder ID in future automations.
Should have thought of this sooner lol. Of course, a direct action is always better, but this works perfectly fine.
q= name = 'FOLDER NAME' and mimeType = 'application/vnd.google-apps.folder' and 'PARENT_FOLDER_ID_YOU_KNOW' in parents and trashed = false
fields=files(id,name)
spaces=drive
pageSize=10