Google Drive to OneDrive?

[mindc]

Folks:

Is it possible to create a Flow that syncs files from Google Drive to OneDrive and/or back and forth between the two?

-M.

[v-micsh-msft]

Hi @mindc,

For Sync files between OneDrive and Google Drive, we could take use of the following template:

OneDrive files to Google Drive Files

For OneDrive for Business to Google Dirve files:

OneDrive for Business to Google Dirve files

The Template above are using "When a file is created" Trigger, and then create the corresponding file under Google Drive.

Currently for Google Drive, there is no corresponding triggers under Microsoft Flow, which means currenlty we could just configure One way sync (Even Google Drive trigger added, I am afraid we could only configure one way sync, doing A->B and B->A might cause loop).

If file already exists in Google Drive and we want to update it, then we need to first list files in Google Drive, follow the steps below in screenshot:

Hope the information above is helpful.

Regards

[mindc]

So Flow will only work when Microsoft has created triggers?

Will OneDrive --> Google actually synchronize the files, or just copy files FROM OneDrive TO Google?  (Will it be bidirectional?)

[v-micsh-msft]

Hi @mindc,

Generally yes, if the connection has no triggers in Microsoft Flow, then it can't be used as a trigger in Microsoft Flow.

For the flow OneDrive ->Google Drive, the flow created here is not file synchronization. The flow created is more like copy files, for files which already exist, it will overwrite.

You shoud have noticed that when specify the file identifier, file content is selected as a whole.

And this is not bidirectional.

For example, if you have added a new file in Google Drive, this file won't be added into OneDrive, with this flow configured.

Regards

[Matt1]

What about if we want to copy a file from Google drive to Onedrive for buisness?  Specifically a Google Sheet that contains Google form response data.

[messageavinash]

@Matt1 It doesn't work i.e. from Google drive to one drive because google drive doesn't have any triggers to initiate. I don't know why we don't have to those, as I guess Microsoft doesn't support them (yet). I am looking for the same solution as yours but I guess I will have to fallback to manual