Google drive integration

Integrator.io
, ,
1

Im trying to integrate NetSuite with Google drive. Export NetSuite invoices to Google drive. How should I start. Is there a documentation where I can look for Google connector help in Celigo?
Please advice.

2

I put together a quick walkthrough video showing how to integrate Google Drive with Celigo integrator.io to handle the exact use cases you mentioned:

In the video, I cover:

  • How to create files in Google Drive from records in another system (like an ERP or CRM)
  • How to move files from another system into a specific folder in Google Drive
  • Key setup details like working with folder paths and file IDs

Hope this gives you a solid starting point. Let me know if you have questions or run into anything—happy to help!

3

Tyler how can we purge the file from Google Drive? For Example I am trying to put saved search into Google Drive and I want each time flow runs to replace the existing file.

Making the file name static does not work because Google Drive accepts the file even though they are with same name.

4

That's somewhat possible now, but not as easy as we could make it with an enhancement. Google drive does allow updating of existing files, but we don't currently support this. The best thing to do now would be to make a flow that runs after you make a new file and have the second flow delete all files with the same name that aren't the one you just made.

1 Like
5

Understood - This would be great enhancement.

Would you able to give me an example of a flow that can delete the file?

6

Can you attempt this first and see if you hit a roadblock? Here is the api you need to delete a file:

The image shows a user interface for creating an import from Google Drive, with options to delete files via API endpoint and specify connection details. (Captioned by AI)
The image shows a user interface for creating an import from Google Drive, with options to delete files via API endpoint and specify connection details. (Captioned by AI)1784×1576 178 KB

You'll need an export similar to this. You would then flip to HTTP view and go to the grouping section to group by name. Then not delete the first in the group since it is the most recently created one.

The image shows a user interface for creating an export with options to select a connection, resource, API endpoint, and query parameters. (Captioned by AI)
The image shows a user interface for creating an export with options to select a connection, resource, API endpoint, and query parameters. (Captioned by AI)1656×1428 146 KB

The image shows a user interface for configuring API export options, including export type, paging, non-standard response patterns, and grouping records by fields. (Captioned by AI)
The image shows a user interface for configuring API export options, including export type, paging, non-standard response patterns, and grouping records by fields. (Captioned by AI)1668×1044 50.8 KB

8

I have managed the list all the items in specific folder but no luck with deleting it. Since google drive allows files with the same name by nature, I think Celigo should be able to delete the old file upon creating a new one by default. We shouldn`t have to do thru all of these steps.